DBIx::UpdateTable::FromHoH - Update database table from hash-of-hash
This document describes version 0.002 of DBIx::UpdateTable::FromHoH (from Perl distribution DBIx-UpdateTable-FromHoH), released on 2020-05-06.
Currently only tested on SQLite.
Usage:
update_table_from_hoh(%args) -> [status, msg, payload, meta]
Update database table from hash-of-hash.
Given a table t1 like this:
t1
id col1 col2 col3 -- ---- ---- ---- 1 a b foo 2 c c bar 3 g h qux
this code:
my $res = update_table_from_hoh( dbh => $dbh, table => 't1', key_column => 'id', hoh => { 1 => {col1=>'a', col2=>'b'}, 2 => {col1=>'c', col2=>'d'}, 4 => {col1=>'e', col2=>'f'}, }, );
will perform these SQL queries:
UPDATE TABLE t1 SET col2='d' WHERE id='2'; INSERT INTO t1 (id,col1,col2) VALUES (4,'e','f'); DELETE FROM t1 WHERE id='3';
to make table t1 become like this:
id col1 col2 col3 -- ---- ---- ---- 1 a b foo 2 c d bar 4 e f qux
This function is not exported by default, but exportable.
Arguments ('*' denotes required arguments):
data_columns => array[str]
dbh* => obj
extra_insert_columns => hos
extra_update_columns => hos
hoh* => hoh
key_column* => str
table* => str
use_tx => bool (default: 1)
Returns an enveloped result (an array).
First element (status) is an integer containing HTTP status code (200 means OK, 4xx caller error, 5xx function error). Second element (msg) is a string containing error message, or 'OK' if status is 200. Third element (payload) is optional, the actual result. Fourth element (meta) is called result metadata and is optional, a hash that contains extra information.
Return value: (any)
Please visit the project's homepage at https://metacpan.org/release/DBIx-UpdateTable-FromHoH.
Source repository is at https://github.com/perlancar/perl-DBIx-UpdateTable-FromHoH.
Please report any bugs or feature requests on the bugtracker website https://rt.cpan.org/Public/Dist/Display.html?Name=DBIx-UpdateTable-FromHoH
When submitting a bug or request, please include a test-file or a patch to an existing test-file that illustrates the bug or desired feature.
DBIx::UpdateHoH::FromTable
DBIx::Compare to compare database contents.
diffdb from App::diffdb which can compare two database (schema as well as content) and display the result as the familiar colored unified-style diff.
DBIx::Diff::Schema
perlancar <perlancar@cpan.org>
This software is copyright (c) 2020 by perlancar@cpan.org.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
To install DBIx::UpdateTable::FromHoH, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::UpdateTable::FromHoH
CPAN shell
perl -MCPAN -e shell install DBIx::UpdateTable::FromHoH
For more information on module installation, please visit the detailed CPAN module installation guide.