Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package perl-Mojo-SQLite for 
openSUSE:Factory checked in at 2021-06-29 22:43:28
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Comparing /work/SRC/openSUSE:Factory/perl-Mojo-SQLite (Old)
 and      /work/SRC/openSUSE:Factory/.perl-Mojo-SQLite.new.2625 (New)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Package is "perl-Mojo-SQLite"

Tue Jun 29 22:43:28 2021 rev:12 rq:903026 version:3.006

Changes:
--------
--- /work/SRC/openSUSE:Factory/perl-Mojo-SQLite/perl-Mojo-SQLite.changes        
2021-02-17 18:13:31.654038166 +0100
+++ 
/work/SRC/openSUSE:Factory/.perl-Mojo-SQLite.new.2625/perl-Mojo-SQLite.changes  
    2021-06-29 22:44:07.822942586 +0200
@@ -1,0 +2,10 @@
+Thu Jun 17 03:07:48 UTC 2021 - Tina M??ller <[email protected]>
+
+- updated to 3.006
+   see /usr/share/doc/packages/perl-Mojo-SQLite/Changes
+
+  3.006     2021-06-16 00:30:47 EDT
+    - Set default abstract generator to an SQL::Abstract::Pg object, enabling 
additional features.
+    - Update IRC metadata to libera.chat
+
+-------------------------------------------------------------------

Old:
----
  Mojo-SQLite-3.005.tar.gz

New:
----
  Mojo-SQLite-3.006.tar.gz

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Other differences:
------------------
++++++ perl-Mojo-SQLite.spec ++++++
--- /var/tmp/diff_new_pack.tKPu5G/_old  2021-06-29 22:44:08.242943140 +0200
+++ /var/tmp/diff_new_pack.tKPu5G/_new  2021-06-29 22:44:08.242943140 +0200
@@ -18,7 +18,7 @@
 
 %define cpan_name Mojo-SQLite
 Name:           perl-Mojo-SQLite
-Version:        3.005
+Version:        3.006
 Release:        0
 Summary:        Tiny Mojolicious wrapper for SQLite
 License:        Artistic-2.0
@@ -33,7 +33,7 @@
 BuildRequires:  perl(Module::Build::Tiny) >= 0.034
 BuildRequires:  perl(Module::Metadata)
 BuildRequires:  perl(Mojolicious) >= 8.03
-BuildRequires:  perl(SQL::Abstract) >= 1.81
+BuildRequires:  perl(SQL::Abstract::Pg) >= 1.0
 BuildRequires:  perl(Test::More) >= 0.96
 BuildRequires:  perl(URI) >= 1.69
 BuildRequires:  perl(URI::db) >= 0.15
@@ -41,7 +41,7 @@
 Requires:       perl(DBD::SQLite) >= 1.64
 Requires:       perl(DBI) >= 1.627
 Requires:       perl(Mojolicious) >= 8.03
-Requires:       perl(SQL::Abstract) >= 1.81
+Requires:       perl(SQL::Abstract::Pg) >= 1.0
 Requires:       perl(URI) >= 1.69
 Requires:       perl(URI::db) >= 0.15
 Requires:       perl(URI::file) >= 4.21

++++++ Mojo-SQLite-3.005.tar.gz -> Mojo-SQLite-3.006.tar.gz ++++++
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Mojo-SQLite-3.005/Build.PL 
new/Mojo-SQLite-3.006/Build.PL
--- old/Mojo-SQLite-3.005/Build.PL      2021-02-16 03:48:01.000000000 +0100
+++ new/Mojo-SQLite-3.006/Build.PL      2021-06-16 06:30:50.000000000 +0200
@@ -84,7 +84,7 @@
         "Dan Book <dbook\@cpan.org>"
       ],
       "dist_name" => "Mojo-SQLite",
-      "dist_version" => "3.005",
+      "dist_version" => "3.006",
       "license" => "artistic_2",
       "module_name" => "Mojo::SQLite",
       "recursive_test_files" => 1,
@@ -95,7 +95,7 @@
         "File::Spec::Functions" => 0,
         "File::Temp" => 0,
         "Mojolicious" => "8.03",
-        "SQL::Abstract" => "1.81",
+        "SQL::Abstract::Pg" => "1.0",
         "Scalar::Util" => 0,
         "URI" => "1.69",
         "URI::db" => "0.15",
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Mojo-SQLite-3.005/Changes 
new/Mojo-SQLite-3.006/Changes
--- old/Mojo-SQLite-3.005/Changes       2021-02-16 03:48:01.000000000 +0100
+++ new/Mojo-SQLite-3.006/Changes       2021-06-16 06:30:50.000000000 +0200
@@ -1,3 +1,7 @@
+3.006     2021-06-16 00:30:47 EDT
+  - Set default abstract generator to an SQL::Abstract::Pg object, enabling 
additional features.
+  - Update IRC metadata to libera.chat
+
 3.005     2021-02-15 21:47:59 EST
   - Add query_p, select_p, insert_p, update_p, delete_p 
Mojo::Promise-returning methods to Mojo::SQLite::Database.
     These are for API compatibility with Mojo::Pg and do not provide 
non-blocking query functionality. (#20, Stefan Adams)
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Mojo-SQLite-3.005/INSTALL 
new/Mojo-SQLite-3.006/INSTALL
--- old/Mojo-SQLite-3.005/INSTALL       2021-02-16 03:48:01.000000000 +0100
+++ new/Mojo-SQLite-3.006/INSTALL       2021-06-16 06:30:50.000000000 +0200
@@ -21,8 +21,11 @@
 
 ## Manual installation
 
-As a last resort, you can manually install it. Download the tarball, untar it,
-install configure prerequisites (see below), then build it:
+As a last resort, you can manually install it. If you have not already
+downloaded the release tarball, you can find the download link on the module's
+MetaCPAN page: https://metacpan.org/pod/Mojo::SQLite
+
+Untar the tarball, install configure prerequisites (see below), then build it:
 
     % perl Build.PL
     % ./Build && ./Build test
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Mojo-SQLite-3.005/META.json 
new/Mojo-SQLite-3.006/META.json
--- old/Mojo-SQLite-3.005/META.json     2021-02-16 03:48:01.000000000 +0100
+++ new/Mojo-SQLite-3.006/META.json     2021-06-16 06:30:50.000000000 +0200
@@ -44,7 +44,7 @@
             "File::Spec::Functions" : "0",
             "File::Temp" : "0",
             "Mojolicious" : "8.03",
-            "SQL::Abstract" : "1.81",
+            "SQL::Abstract::Pg" : "1.0",
             "Scalar::Util" : "0",
             "URI" : "1.69",
             "URI::db" : "0.15",
@@ -66,28 +66,28 @@
    "provides" : {
       "Mojo::SQLite" : {
          "file" : "lib/Mojo/SQLite.pm",
-         "version" : "3.005"
+         "version" : "3.006"
       },
       "Mojo::SQLite::Database" : {
          "file" : "lib/Mojo/SQLite/Database.pm",
-         "version" : "3.005"
+         "version" : "3.006"
       },
       "Mojo::SQLite::Migrations" : {
          "file" : "lib/Mojo/SQLite/Migrations.pm",
-         "version" : "3.005"
+         "version" : "3.006"
       },
       "Mojo::SQLite::PubSub" : {
          "file" : "lib/Mojo/SQLite/PubSub.pm",
-         "version" : "3.005",
+         "version" : "3.006",
          "x_deprecated" : 1
       },
       "Mojo::SQLite::Results" : {
          "file" : "lib/Mojo/SQLite/Results.pm",
-         "version" : "3.005"
+         "version" : "3.006"
       },
       "Mojo::SQLite::Transaction" : {
          "file" : "lib/Mojo/SQLite/Transaction.pm",
-         "version" : "3.005"
+         "version" : "3.006"
       }
    },
    "release_status" : "stable",
@@ -101,16 +101,16 @@
          "url" : "https://github.com/Grinnz/Mojo-SQLite.git";,
          "web" : "https://github.com/Grinnz/Mojo-SQLite";
       },
-      "x_IRC" : "irc://irc.freenode.net/#mojo"
+      "x_IRC" : "ircs://irc.libera.chat/#mojo"
    },
-   "version" : "3.005",
+   "version" : "3.006",
    "x_contributors" : [
       "Dan Book <[email protected]>",
       "Dan Book <[email protected]>",
       "Stefan Adams <[email protected]>"
    ],
-   "x_generated_by_perl" : "v5.32.0",
-   "x_serialization_backend" : "Cpanel::JSON::XS version 4.25",
+   "x_generated_by_perl" : "v5.34.0",
+   "x_serialization_backend" : "Cpanel::JSON::XS version 4.26",
    "x_spdx_expression" : "Artistic-2.0"
 }
 
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Mojo-SQLite-3.005/META.yml 
new/Mojo-SQLite-3.006/META.yml
--- old/Mojo-SQLite-3.005/META.yml      2021-02-16 03:48:01.000000000 +0100
+++ new/Mojo-SQLite-3.006/META.yml      2021-06-16 06:30:50.000000000 +0200
@@ -26,23 +26,23 @@
 provides:
   Mojo::SQLite:
     file: lib/Mojo/SQLite.pm
-    version: '3.005'
+    version: '3.006'
   Mojo::SQLite::Database:
     file: lib/Mojo/SQLite/Database.pm
-    version: '3.005'
+    version: '3.006'
   Mojo::SQLite::Migrations:
     file: lib/Mojo/SQLite/Migrations.pm
-    version: '3.005'
+    version: '3.006'
   Mojo::SQLite::PubSub:
     file: lib/Mojo/SQLite/PubSub.pm
-    version: '3.005'
+    version: '3.006'
     x_deprecated: 1
   Mojo::SQLite::Results:
     file: lib/Mojo/SQLite/Results.pm
-    version: '3.005'
+    version: '3.006'
   Mojo::SQLite::Transaction:
     file: lib/Mojo/SQLite/Transaction.pm
-    version: '3.005'
+    version: '3.006'
 requires:
   Carp: '0'
   DBD::SQLite: '1.64'
@@ -50,22 +50,22 @@
   File::Spec::Functions: '0'
   File::Temp: '0'
   Mojolicious: '8.03'
-  SQL::Abstract: '1.81'
+  SQL::Abstract::Pg: '1.0'
   Scalar::Util: '0'
   URI: '1.69'
   URI::db: '0.15'
   URI::file: '4.21'
   perl: '5.010001'
 resources:
-  IRC: irc://irc.freenode.net/#mojo
+  IRC: ircs://irc.libera.chat/#mojo
   bugtracker: https://github.com/Grinnz/Mojo-SQLite/issues
   homepage: https://github.com/Grinnz/Mojo-SQLite
   repository: https://github.com/Grinnz/Mojo-SQLite.git
-version: '3.005'
+version: '3.006'
 x_contributors:
   - 'Dan Book <[email protected]>'
   - 'Dan Book <[email protected]>'
   - 'Stefan Adams <[email protected]>'
-x_generated_by_perl: v5.32.0
+x_generated_by_perl: v5.34.0
 x_serialization_backend: 'YAML::Tiny version 1.73'
 x_spdx_expression: Artistic-2.0
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Mojo-SQLite-3.005/README new/Mojo-SQLite-3.006/README
--- old/Mojo-SQLite-3.005/README        2021-02-16 03:48:01.000000000 +0100
+++ new/Mojo-SQLite-3.006/README        2021-06-16 06:30:50.000000000 +0200
@@ -139,17 +139,6 @@
       my $tempfile = catfile $tempdir, 'test.db';
       my $sql = Mojo::SQLite->new->from_filename($tempfile);
 
-    SQL::Abstract::Pg can provide additional features to the SQL::Abstract
-    query methods in Mojo::SQLite::Database. The on_conflict and for
-    features are not applicable to SQLite queries.
-
-      use SQL::Abstract::Pg;
-      my $sql = Mojo::SQLite->new->abstract(SQL::Abstract::Pg->new(name_sep => 
'.', quote_char => '"'));
-      $sql->db->select(['some_table', ['other_table', foo_id => 'id']],
-        ['foo', [bar => 'baz'], \q{datetime('now') as dt}],
-        {foo => 'value'},
-        {order_by => 'foo', limit => 10, offset => 5, group_by => ['foo'], 
having => {baz => 'value'}});
-
 EXAMPLES
 
     This distribution also contains a well-structured example blog
@@ -181,13 +170,21 @@
       $sql         = $sql->abstract(SQL::Abstract->new);
 
     SQL::Abstract object used to generate CRUD queries for
-    Mojo::SQLite::Database, defaults to setting name_sep to . and
-    quote_char to ". SQL::Abstract::Pg may be used to provide additional
-    features.
+    Mojo::SQLite::Database, defaults to a SQL::Abstract::Pg object with
+    name_sep set to . and quote_char set to ".
 
       # Generate WHERE clause and bind values
       my($stmt, @bind) = $sql->abstract->where({foo => 'bar', baz => 'yada'});
 
+    SQL::Abstract::Pg provides additional features to the SQL::Abstract
+    query methods in Mojo::SQLite::Database such as -json and limit/offset.
+    The on_conflict and for features are not applicable to SQLite queries.
+
+      $sql->db->select(['some_table', ['other_table', foo_id => 'id']],
+        ['foo', [bar => 'baz'], \q{datetime('now') as dt}],
+        {foo => 'value'},
+        {order_by => 'foo', limit => 10, offset => 5, group_by => ['foo'], 
having => {baz => 'value'}});
+
  auto_migrate
 
       my $bool = $sql->auto_migrate;
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Mojo-SQLite-3.005/dist.ini 
new/Mojo-SQLite-3.006/dist.ini
--- old/Mojo-SQLite-3.005/dist.ini      2021-02-16 03:48:01.000000000 +0100
+++ new/Mojo-SQLite-3.006/dist.ini      2021-06-16 06:30:50.000000000 +0200
@@ -7,7 +7,7 @@
 [@Author::DBOOK]
 :version = v1.0.3
 installer = ModuleBuildTiny::Fallback
-irc = irc://irc.freenode.net/#mojo
+irc = ircs://irc.libera.chat/#mojo
 pod_tests = 1
 
 [Deprecated]
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Mojo-SQLite-3.005/lib/Mojo/SQLite/Database.pm 
new/Mojo-SQLite-3.006/lib/Mojo/SQLite/Database.pm
--- old/Mojo-SQLite-3.005/lib/Mojo/SQLite/Database.pm   2021-02-16 
03:48:01.000000000 +0100
+++ new/Mojo-SQLite-3.006/lib/Mojo/SQLite/Database.pm   2021-06-16 
06:30:50.000000000 +0200
@@ -9,7 +9,7 @@
 use Mojo::SQLite::Transaction;
 use Mojo::Util 'monkey_patch';
 
-our $VERSION = '3.005';
+our $VERSION = '3.006';
 
 our @CARP_NOT = qw(Mojo::SQLite::Migrations);
 
@@ -209,9 +209,9 @@
   my $results = $db->delete($table, \%where);
 
 Generate a C<DELETE> statement with L<Mojo::SQLite/"abstract"> (usually an
-L<SQL::Abstract> object) and execute it with L</"query">. You can also append a
-callback for API compatibility with L<Mojo::Pg>; the query is still executed in
-a blocking manner.
+L<SQL::Abstract::Pg> object) and execute it with L</"query">. You can also
+append a callback for API compatibility with L<Mojo::Pg>; the query is still
+executed in a blocking manner.
 
   $db->delete(some_table => sub ($db, $err, $results) {
     ...
@@ -255,9 +255,9 @@
   my $results = $db->insert($table, \@values || \%fieldvals, \%options);
 
 Generate an C<INSERT> statement with L<Mojo::SQLite/"abstract"> (usually an
-L<SQL::Abstract> object) and execute it with L</"query">. You can also append a
-callback for API compatibility with L<Mojo::Pg>; the query is still executed in
-a blocking manner.
+L<SQL::Abstract::Pg> object) and execute it with L</"query">. You can also
+append a callback for API compatibility with L<Mojo::Pg>; the query is still
+executed in a blocking manner.
 
   $db->insert(some_table => {foo => 'bar'} => sub ($db, $err, $results) {
     ...
@@ -343,9 +343,9 @@
   my $results = $db->select($source, $fields, $where, $order);
 
 Generate a C<SELECT> statement with L<Mojo::SQLite/"abstract"> (usually an
-L<SQL::Abstract> object) and execute it with L</"query">. You can also append a
-callback for API compatibility with L<Mojo::Pg>; the query is still executed in
-a blocking manner.
+L<SQL::Abstract::Pg> object) and execute it with L</"query">. You can also
+append a callback for API compatibility with L<Mojo::Pg>; the query is still
+executed in a blocking manner.
 
   $db->select(some_table => ['foo'] => {bar => 'yada'} => sub ($db, $err, 
$results) {
     ...
@@ -402,9 +402,9 @@
   my $results = $db->update($table, \%fieldvals, \%where);
 
 Generate an C<UPDATE> statement with L<Mojo::SQLite/"abstract"> (usually an
-L<SQL::Abstract> object) and execute it with L</"query">. You can also append a
-callback for API compatibility with L<Mojo::Pg>; the query is still executed in
-a blocking manner.
+L<SQL::Abstract::Pg> object) and execute it with L</"query">. You can also
+append a callback for API compatibility with L<Mojo::Pg>; the query is still
+executed in a blocking manner.
 
   $db->update(some_table => {foo => 'baz'} => {foo => 'bar'} => sub ($db, 
$err, $results) {
     ...
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Mojo-SQLite-3.005/lib/Mojo/SQLite/Migrations.pm 
new/Mojo-SQLite-3.006/lib/Mojo/SQLite/Migrations.pm
--- old/Mojo-SQLite-3.005/lib/Mojo/SQLite/Migrations.pm 2021-02-16 
03:48:01.000000000 +0100
+++ new/Mojo-SQLite-3.006/lib/Mojo/SQLite/Migrations.pm 2021-06-16 
06:30:50.000000000 +0200
@@ -8,7 +8,7 @@
 
 use constant DEBUG => $ENV{MOJO_MIGRATIONS_DEBUG} || 0;
 
-our $VERSION = '3.005';
+our $VERSION = '3.006';
 
 has name => 'migrations';
 has sqlite => undef, weak => 1;
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Mojo-SQLite-3.005/lib/Mojo/SQLite/PubSub.pm 
new/Mojo-SQLite-3.006/lib/Mojo/SQLite/PubSub.pm
--- old/Mojo-SQLite-3.005/lib/Mojo/SQLite/PubSub.pm     2021-02-16 
03:48:01.000000000 +0100
+++ new/Mojo-SQLite-3.006/lib/Mojo/SQLite/PubSub.pm     2021-06-16 
06:30:50.000000000 +0200
@@ -3,7 +3,7 @@
 
 use Mojo::Util 'deprecated';
 
-our $VERSION = '3.005';
+our $VERSION = '3.006';
 
 deprecated 'Mojo::SQLite::PubSub is deprecated and should no longer be used';
 
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Mojo-SQLite-3.005/lib/Mojo/SQLite/Results.pm 
new/Mojo-SQLite-3.006/lib/Mojo/SQLite/Results.pm
--- old/Mojo-SQLite-3.005/lib/Mojo/SQLite/Results.pm    2021-02-16 
03:48:01.000000000 +0100
+++ new/Mojo-SQLite-3.006/lib/Mojo/SQLite/Results.pm    2021-06-16 
06:30:50.000000000 +0200
@@ -5,7 +5,7 @@
 use Mojo::JSON 'from_json';
 use Mojo::Util 'tablify';
 
-our $VERSION = '3.005';
+our $VERSION = '3.006';
 
 has [qw(db sth)];
 
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Mojo-SQLite-3.005/lib/Mojo/SQLite/Transaction.pm 
new/Mojo-SQLite-3.006/lib/Mojo/SQLite/Transaction.pm
--- old/Mojo-SQLite-3.005/lib/Mojo/SQLite/Transaction.pm        2021-02-16 
03:48:01.000000000 +0100
+++ new/Mojo-SQLite-3.006/lib/Mojo/SQLite/Transaction.pm        2021-06-16 
06:30:50.000000000 +0200
@@ -3,7 +3,7 @@
 
 use Carp 'croak';
 
-our $VERSION = '3.005';
+our $VERSION = '3.006';
 
 has db => undef, weak => 1;
 
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Mojo-SQLite-3.005/lib/Mojo/SQLite.pm 
new/Mojo-SQLite-3.006/lib/Mojo/SQLite.pm
--- old/Mojo-SQLite-3.005/lib/Mojo/SQLite.pm    2021-02-16 03:48:01.000000000 
+0100
+++ new/Mojo-SQLite-3.006/lib/Mojo/SQLite.pm    2021-06-16 06:30:50.000000000 
+0200
@@ -10,13 +10,13 @@
 use Mojo::SQLite::Database;
 use Mojo::SQLite::Migrations;
 use Scalar::Util qw(blessed weaken);
-use SQL::Abstract;
+use SQL::Abstract::Pg;
 use URI;
 use URI::db;
 
-our $VERSION = '3.005';
+our $VERSION = '3.006';
 
-has abstract => sub { SQL::Abstract->new(name_sep => '.', quote_char => '"') };
+has abstract => sub { SQL::Abstract::Pg->new(name_sep => '.', quote_char => 
'"') };
 has 'auto_migrate';
 has database_class  => 'Mojo::SQLite::Database';
 has dsn             => sub { _url_from_file(shift->_tempfile)->dbi_dsn };
@@ -265,17 +265,6 @@
   my $tempfile = catfile $tempdir, 'test.db';
   my $sql = Mojo::SQLite->new->from_filename($tempfile);
 
-L<SQL::Abstract::Pg> can provide additional features to the L<SQL::Abstract>
-query methods in L<Mojo::SQLite::Database>. The C<on_conflict> and C<for>
-features are not applicable to SQLite queries.
-
-  use SQL::Abstract::Pg;
-  my $sql = Mojo::SQLite->new->abstract(SQL::Abstract::Pg->new(name_sep => 
'.', quote_char => '"'));
-  $sql->db->select(['some_table', ['other_table', foo_id => 'id']],
-    ['foo', [bar => 'baz'], \q{datetime('now') as dt}],
-    {foo => 'value'},
-    {order_by => 'foo', limit => 10, offset => 5, group_by => ['foo'], having 
=> {baz => 'value'}});
-
 =head1 EXAMPLES
 
 This distribution also contains a well-structured example
@@ -306,13 +295,22 @@
   $sql         = $sql->abstract(SQL::Abstract->new);
 
 L<SQL::Abstract> object used to generate CRUD queries for
-L<Mojo::SQLite::Database>, defaults to setting C<name_sep> to C<.> and
-C<quote_char> to C<">. L<SQL::Abstract::Pg> may be used to provide additional
-features.
+L<Mojo::SQLite::Database>, defaults to a L<SQL::Abstract::Pg> object with
+C<name_sep> set to C<.> and C<quote_char> set to C<">.
 
   # Generate WHERE clause and bind values
   my($stmt, @bind) = $sql->abstract->where({foo => 'bar', baz => 'yada'});
 
+L<SQL::Abstract::Pg> provides additional features to the L<SQL::Abstract>
+query methods in L<Mojo::SQLite::Database> such as C<-json> and
+C<limit>/C<offset>. The C<on_conflict> and C<for> features are not applicable
+to SQLite queries.
+
+  $sql->db->select(['some_table', ['other_table', foo_id => 'id']],
+    ['foo', [bar => 'baz'], \q{datetime('now') as dt}],
+    {foo => 'value'},
+    {order_by => 'foo', limit => 10, offset => 5, group_by => ['foo'], having 
=> {baz => 'value'}});
+
 =head2 auto_migrate
 
   my $bool = $sql->auto_migrate;
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Mojo-SQLite-3.005/prereqs.yml 
new/Mojo-SQLite-3.006/prereqs.yml
--- old/Mojo-SQLite-3.005/prereqs.yml   2021-02-16 03:48:01.000000000 +0100
+++ new/Mojo-SQLite-3.006/prereqs.yml   2021-06-16 06:30:50.000000000 +0200
@@ -8,7 +8,7 @@
     File::Temp: 0
     Mojolicious: '8.03'
     Scalar::Util: 0
-    SQL::Abstract: '1.81'
+    SQL::Abstract::Pg: '1.0'
     URI: '1.69'
     URI::db: '0.15'
     URI::file: '4.21'
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Mojo-SQLite-3.005/t/00-report-prereqs.dd 
new/Mojo-SQLite-3.006/t/00-report-prereqs.dd
--- old/Mojo-SQLite-3.005/t/00-report-prereqs.dd        2021-02-16 
03:48:01.000000000 +0100
+++ new/Mojo-SQLite-3.006/t/00-report-prereqs.dd        2021-06-16 
06:30:50.000000000 +0200
@@ -19,7 +19,7 @@
                                       'File::Spec::Functions' => '0',
                                       'File::Temp' => '0',
                                       'Mojolicious' => '8.03',
-                                      'SQL::Abstract' => '1.81',
+                                      'SQL::Abstract::Pg' => '1.0',
                                       'Scalar::Util' => '0',
                                       'URI' => '1.69',
                                       'URI::db' => '0.15',

Reply via email to