Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package perl-Mojo-Pg for openSUSE:Factory checked in at 2026-11-08 19:22:31 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/perl-Mojo-Pg (Old) and /work/SRC/openSUSE:Factory/.perl-Mojo-Pg.new.3759290 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "perl-Mojo-Pg" Sun Nov 8 19:22:31 2026 rev:34 rq:1396148 version:5.10.0 Changes: -------- --- /work/SRC/openSUSE:Factory/perl-Mojo-Pg/perl-Mojo-Pg.changes 2026-05-24 19:38:07.245342986 +0200 +++ /work/SRC/openSUSE:Factory/.perl-Mojo-Pg.new.3759290/perl-Mojo-Pg.changes 2026-11-08 19:23:03.058524883 +0100 @@ -1,0 +2,9 @@ +Sun Oct 25 09:51:31 UTC 2026 - Tina Müller <[email protected]> + +- updated to 5.10.0 (5.01) + see /usr/share/doc/packages/perl-Mojo-Pg/Changes + + 5.01 2026-10-25 + - Added support for bulk inserts to insert and insert_p methods in Mojo::Pg::Database. + +------------------------------------------------------------------- Old: ---- Mojo-Pg-5.0.tar.gz New: ---- Mojo-Pg-5.01.tar.gz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ perl-Mojo-Pg.spec ++++++ --- /var/tmp/diff_new_pack.HLoXId/_old 2026-11-08 19:23:03.693551153 +0100 +++ /var/tmp/diff_new_pack.HLoXId/_new 2026-11-08 19:23:03.695551235 +0100 @@ -18,10 +18,10 @@ %define cpan_name Mojo-Pg Name: perl-Mojo-Pg -Version: 5.0.0 +Version: 5.10.0 Release: 0 -# 5.0 -> normalize -> 5.0.0 -%define cpan_version 5.0 +# 5.01 -> normalize -> 5.10.0 +%define cpan_version 5.01 License: Artistic-2.0 Summary: Wrapper around DBD::Pg for using PostgreSql with Mojolicious URL: https://metacpan.org/release/%{cpan_name} @@ -34,11 +34,11 @@ BuildRequires: perl(DBD::Pg) >= 3.7.4 BuildRequires: perl(Mojo::SQL) >= 0.10 BuildRequires: perl(Mojolicious) >= 8.500 -BuildRequires: perl(SQL::Abstract::Pg) >= 1.0 +BuildRequires: perl(SQL::Abstract::Pg) >= 1.10 Requires: perl(DBD::Pg) >= 3.7.4 Requires: perl(Mojo::SQL) >= 0.10 Requires: perl(Mojolicious) >= 8.500 -Requires: perl(SQL::Abstract::Pg) >= 1.0 +Requires: perl(SQL::Abstract::Pg) >= 1.10 Provides: perl(Mojo::Pg) = %{version} Provides: perl(Mojo::Pg::Database) Provides: perl(Mojo::Pg::Migrations) ++++++ Mojo-Pg-5.0.tar.gz -> Mojo-Pg-5.01.tar.gz ++++++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/Mojo-Pg-5.0/Changes new/Mojo-Pg-5.01/Changes --- old/Mojo-Pg-5.0/Changes 2026-05-11 17:52:29.000000000 +0200 +++ new/Mojo-Pg-5.01/Changes 2026-10-25 02:03:07.000000000 +0200 @@ -1,4 +1,7 @@ +5.01 2026-10-25 + - Added support for bulk inserts to insert and insert_p methods in Mojo::Pg::Database. + 5.0 2026-05-11 - Added support for passing Mojo::SQL statements directly to query and query_p methods in Mojo::Pg::Database. - Updated Perl requirement to 5.20. diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/Mojo-Pg-5.0/META.json new/Mojo-Pg-5.01/META.json --- old/Mojo-Pg-5.0/META.json 2026-05-12 12:04:29.000000000 +0200 +++ new/Mojo-Pg-5.01/META.json 2026-10-25 02:04:27.000000000 +0200 @@ -37,7 +37,7 @@ "DBD::Pg" : "3.007004", "Mojo::SQL" : "0.01", "Mojolicious" : "8.50", - "SQL::Abstract::Pg" : "1.0", + "SQL::Abstract::Pg" : "1.01", "perl" : "5.020" } } @@ -61,6 +61,6 @@ "web" : "https://web.libera.chat/#mojo"; } }, - "version" : "5.0", + "version" : "5.01", "x_serialization_backend" : "JSON::PP version 4.16" } diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/Mojo-Pg-5.0/META.yml new/Mojo-Pg-5.01/META.yml --- old/Mojo-Pg-5.0/META.yml 2026-05-12 12:04:29.000000000 +0200 +++ new/Mojo-Pg-5.01/META.yml 2026-10-25 02:04:27.000000000 +0200 @@ -23,7 +23,7 @@ DBD::Pg: '3.007004' Mojo::SQL: '0.01' Mojolicious: '8.50' - SQL::Abstract::Pg: '1.0' + SQL::Abstract::Pg: '1.01' perl: '5.020' resources: IRC: @@ -33,5 +33,5 @@ homepage: https://mojolicious.org license: http://www.opensource.org/licenses/artistic-license-2.0 repository: https://github.com/mojolicious/mojo-pg.git -version: '5.0' +version: '5.01' x_serialization_backend: 'CPAN::Meta::YAML version 0.020' diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/Mojo-Pg-5.0/Makefile.PL new/Mojo-Pg-5.01/Makefile.PL --- old/Mojo-Pg-5.0/Makefile.PL 2026-05-11 17:52:29.000000000 +0200 +++ new/Mojo-Pg-5.01/Makefile.PL 2026-10-25 01:53:24.000000000 +0200 @@ -29,6 +29,6 @@ x_IRC => {url => 'irc://irc.libera.chat/#mojo', web => 'https://web.libera.chat/#mojo'} }, }, - PREREQ_PM => {'DBD::Pg' => 3.007004, Mojolicious => '8.50', 'Mojo::SQL' => '0.01', 'SQL::Abstract::Pg' => '1.0'}, + PREREQ_PM => {'DBD::Pg' => 3.007004, Mojolicious => '8.50', 'Mojo::SQL' => '0.01', 'SQL::Abstract::Pg' => '1.01'}, test => {TESTS => 't/*.t t/*/*.t'} ); diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/Mojo-Pg-5.0/lib/Mojo/Pg/Database.pm new/Mojo-Pg-5.01/lib/Mojo/Pg/Database.pm --- old/Mojo-Pg-5.0/lib/Mojo/Pg/Database.pm 2026-05-11 17:52:29.000000000 +0200 +++ new/Mojo-Pg-5.01/lib/Mojo/Pg/Database.pm 2026-10-25 01:55:30.000000000 +0200 @@ -339,7 +339,7 @@ =head2 insert - my $results = $db->insert($table, \@values || \%fieldvals, \%options); + my $results = $db->insert($table, \@values || \%fieldvals || \@fieldvals, \%options); Generate an C<INSERT> statement with L<Mojo::Pg/"abstract"> (usually an L<SQL::Abstract::Pg> object) and execute it with L</"query">. You can also append a callback to perform operations non-blocking. @@ -379,9 +379,14 @@ # "INSERT INTO t (a, b) VALUES ('c', 'd') ON CONFLICT (a, b) DO UPDATE SET a = 'e'" $db->insert('t', {a => 'c', b => 'd'}, {on_conflict => [['a', 'b'] => {a => 'e'}]}); +And bulk inserts with multiple rows. + + # "INSERT INTO t (a, b) VALUES ('c', 'd'), ('e', DEFAULT) RETURNING id" + $db->insert('t', [{a => 'c', b => 'd'}, {a => 'e'}], {returning => 'id'}); + =head2 insert_p - my $promise = $db->insert_p($table, \@values || \%fieldvals, \%options); + my $promise = $db->insert_p($table, \@values || \%fieldvals || \@fieldvals, \%options); Same as L</"insert">, but performs all operations non-blocking and returns a L<Mojo::Promise> object instead of accepting a callback. diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/Mojo-Pg-5.0/lib/Mojo/Pg.pm new/Mojo-Pg-5.01/lib/Mojo/Pg.pm --- old/Mojo-Pg-5.0/lib/Mojo/Pg.pm 2026-05-11 17:52:29.000000000 +0200 +++ new/Mojo-Pg-5.01/lib/Mojo/Pg.pm 2026-05-12 12:05:28.000000000 +0200 @@ -22,7 +22,7 @@ has [qw(password username)] => ''; has pubsub => sub { Mojo::Pg::PubSub->new(pg => shift) }; -our $VERSION = '5.0'; +our $VERSION = '5.01'; sub db { $_[0]->database_class->new(dbh => $_[0]->_prepare, pg => $_[0]) } diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/Mojo-Pg-5.0/t/crud.t new/Mojo-Pg-5.01/t/crud.t --- old/Mojo-Pg-5.0/t/crud.t 2026-03-23 11:25:14.000000000 +0100 +++ new/Mojo-Pg-5.01/t/crud.t 2026-10-25 01:56:32.000000000 +0200 @@ -185,6 +185,25 @@ [{id => 1, test1 => 'hello', test2 => 'world', test3 => 'hello'}], 'right structure'; }; +subtest 'Bulk insert' => sub { + $db->query( + "CREATE TABLE IF NOT EXISTS crud_test6 ( + id SERIAL PRIMARY KEY, + name TEXT UNIQUE, + tag TEXT DEFAULT 'none' + )" + ); + my $results = $db->insert('crud_test6', [{name => 'foo', tag => 'a'}, {name => 'bar'}], {returning => '*'}); + is_deeply $results->hashes->to_array, + [{id => 1, name => 'foo', tag => 'a'}, {id => 2, name => 'bar', tag => 'none'}], 'right structure'; + $results = $db->insert('crud_test6', [{name => 'foo'}, {name => 'baz'}], {on_conflict => undef, returning => 'name'}); + is_deeply $results->hashes->to_array, [{name => 'baz'}], 'right structure'; + + my $result; + $db->insert_p('crud_test6', [{name => 'yada'}, {name => 'test'}])->then(sub { $result = shift->rows })->wait; + is $result, 2, 'right result'; +}; + # Clean up once we are done $pg->db->query('DROP SCHEMA mojo_crud_test CASCADE'); diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/Mojo-Pg-5.0/t/database.t new/Mojo-Pg-5.01/t/database.t --- old/Mojo-Pg-5.0/t/database.t 2026-05-11 17:52:29.000000000 +0200 +++ new/Mojo-Pg-5.01/t/database.t 2026-10-25 02:02:36.000000000 +0200 @@ -10,7 +10,7 @@ use Mojo::JSON qw(true); use Mojo::Pg; use Mojo::Promise; -use Mojo::SQL qw(sql); +use Mojo::SQL qw(sql); use Scalar::Util qw(refaddr); my $pg = Mojo::Pg->new($ENV{TEST_ONLINE}); ++++++ _scmsync.obsinfo ++++++ --- /var/tmp/diff_new_pack.HLoXId/_old 2026-11-08 19:23:03.805555786 +0100 +++ /var/tmp/diff_new_pack.HLoXId/_new 2026-11-08 19:23:03.812556076 +0100 @@ -1,6 +1,6 @@ -mtime: 1778669246 -commit: e25ada31ef063e47e4148b5d92341a88bb54595e4de0364cee9da603afa141f5 +mtime: 1792921892 +commit: d67e05d7da235caa3114a6ecc647407db710753da2864497882503a9ddf0cd50 url: https://src.opensuse.org/perl/perl-Mojo-Pg -revision: e25ada31ef063e47e4148b5d92341a88bb54595e4de0364cee9da603afa141f5 +revision: d67e05d7da235caa3114a6ecc647407db710753da2864497882503a9ddf0cd50 projectscmsync: https://src.opensuse.org/perl/_ObsPrj ++++++ build.specials.obscpio ++++++ ++++++ build.specials.obscpio ++++++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/.gitignore new/.gitignore --- old/.gitignore 1970-01-01 01:00:00.000000000 +0100 +++ new/.gitignore 2026-10-25 10:51:32.000000000 +0100 @@ -0,0 +1 @@ +.osc
