I just discovered SQL::Abstract because it's used by Mojo::PG
In SQL::Abstract you can write an insert command like this:
my $sql= new SQL::Abstract( array_datatypes => 1 );
my $required = { a => [1, 3, 5], b => [2, 4, 6],};
my($stmt, @bind)= $sql->insert( testtable => $required );
This will be created:
stmt: "INSERT INTO testtable ( a, b) VALUES ( ?, ? )"
@bind: (
[
1,
3,
5
],
[
2,
4,
6
]
);
I receive JSON data in my script and so my data is like this:
my $data = [
{a => 1, b => 2},
{a => 3, b => 4},
{a => 5, b => 6},
];
I'm wondering whether or not there is something which would give me the required hash of arrays from my existing array of hashes.
My lengthy attempt is like this:
# %columns will become the hash of arrays
my %columns;
# Foreach row of data collect its keys and create an empty array in %c
+olumns
$columns{$_} //= [] foreach map { keys %$_ } @$data;
# Then, for each row
foreach my $row ( @$data ) {
# push the value foreach column
push @{$columns{$_}}, $row->{$_} foreach keys %columns;
}
Is there a better way to achieve this transposition?
s$$([},&%#}/&/]+}%&{})*;#$&&s&&$^X.($'^"%]=\&(|?*{%
+.+=%;.#_}\&"^"-+%*).}%:##%}={~=~:.")&e&&s""`$''`"e
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.