DBIx::InsertHash - insert/update a database record from a hash
version 0.011
use DBIx::InsertHash; # insert DBIx::InsertHash->insert({USERNAME => 'foo', PASSWORD => 'bar', }, 'table', $dbh); # update DBIx::InsertHash->update({PASSWORD => 'foobar'}, [12],'USERID = ?', 'table', $dbh); # constructor usage my $dbix = DBIx::InsertHash->new(quote => 1, dbh => $dbh, table => 'table', where => 'USERID = ?', ); $dbix->insert($hash); $dbix->update($hash, [12]);
If you have data in a hash (which keys are matching the column names) and want to insert it in a database, then this is the right module for you. It frees you from having to construct the SQL statement.
It really only does a simple insert (or update) from a hash into a single table. For anything beyond I suggest a ORM (object-relational mapper), like Rose::DB::Object or DBIx::Class.
Constructor (optional). Only needed to store default values or set quoting options.
Turn quoting of column names on (off by default). This switch affects all column names (see quote_func below to only quote specific names).
If you use MySQL, quoting is recommended. It is needed when column names clash with reserved words.
Quoting character/string (default is backtick).
This function is given the column name as first (and only) parameter. It has to return a boolean, indicating if the column has to be quoted.
The following example uses SQL::ReservedWords:
my $quote = sub { SQL::ReservedWords->is_reserved($_[0]) }; my $dbix = DBIx::InsertHash->new(quote_func => $quote); $dbix->insert(...);
Insert hash in database. Returns last_insert_id.
Row data. The keys have to match with the column names of your table. This parameter is mandatory. If an empty hashref is given, no record is inserted and a warning is given.
Table name. If this parameter is missing, the object default (see new is used). Otherwise it dies.
DBI database handle (you have to connect yourself). If this parameter is missing, the object default (see new) is used). Otherwise it dies.
Update record from hash. Returns do.
Bind values for the WHERE clause. If you do not use or need them, just pass a false value (undef or empty string) or an empty arrayref. This parameter is optional and has no object defaults.
undef
Where clause (with optional placeholders ?). If this parameter is missing, the object default (see new) is used. Otherwise it dies.
?
http://github.com/uwe/dbix-inserthash/tree/master
Uwe Voelker, <uwe.voelker@gmx.de>
To install DBIx::InsertHash, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::InsertHash
CPAN shell
perl -MCPAN -e shell install DBIx::InsertHash
For more information on module installation, please visit the detailed CPAN module installation guide.