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-12-06 23:59:54
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Comparing /work/SRC/openSUSE:Factory/perl-Mojo-SQLite (Old)
and /work/SRC/openSUSE:Factory/.perl-Mojo-SQLite.new.31177 (New)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "perl-Mojo-SQLite"
Mon Dec 6 23:59:54 2021 rev:14 rq:935943 version:3.008
Changes:
--------
--- /work/SRC/openSUSE:Factory/perl-Mojo-SQLite/perl-Mojo-SQLite.changes
2021-08-03 22:49:21.628452019 +0200
+++
/work/SRC/openSUSE:Factory/.perl-Mojo-SQLite.new.31177/perl-Mojo-SQLite.changes
2021-12-07 00:01:07.524194506 +0100
@@ -1,0 +2,9 @@
+Mon Nov 29 03:07:55 UTC 2021 - Tina M??ller <[email protected]>
+
+- updated to 3.008
+ see /usr/share/doc/packages/perl-Mojo-SQLite/Changes
+
+ 3.008 2021-11-28 11:10:24 EST
+ - Update documentation to indicate that upsert operations are now
supported via SQL::Abstract::Pg.
+
+-------------------------------------------------------------------
Old:
----
Mojo-SQLite-3.007.tar.gz
New:
----
Mojo-SQLite-3.008.tar.gz
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Other differences:
------------------
++++++ perl-Mojo-SQLite.spec ++++++
--- /var/tmp/diff_new_pack.cwsVML/_old 2021-12-07 00:01:08.292191790 +0100
+++ /var/tmp/diff_new_pack.cwsVML/_new 2021-12-07 00:01:08.304191747 +0100
@@ -18,7 +18,7 @@
%define cpan_name Mojo-SQLite
Name: perl-Mojo-SQLite
-Version: 3.007
+Version: 3.008
Release: 0
Summary: Tiny Mojolicious wrapper for SQLite
License: Artistic-2.0
++++++ Mojo-SQLite-3.007.tar.gz -> Mojo-SQLite-3.008.tar.gz ++++++
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.007/Build.PL
new/Mojo-SQLite-3.008/Build.PL
--- old/Mojo-SQLite-3.007/Build.PL 2021-08-02 02:17:44.000000000 +0200
+++ new/Mojo-SQLite-3.008/Build.PL 2021-11-28 17:10:26.000000000 +0100
@@ -84,7 +84,7 @@
"Dan Book <dbook\@cpan.org>"
],
"dist_name" => "Mojo-SQLite",
- "dist_version" => "3.007",
+ "dist_version" => "3.008",
"license" => "artistic_2",
"module_name" => "Mojo::SQLite",
"recursive_test_files" => 1,
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.007/Changes
new/Mojo-SQLite-3.008/Changes
--- old/Mojo-SQLite-3.007/Changes 2021-08-02 02:17:44.000000000 +0200
+++ new/Mojo-SQLite-3.008/Changes 2021-11-28 17:10:26.000000000 +0100
@@ -1,3 +1,6 @@
+3.008 2021-11-28 11:10:24 EST
+ - Update documentation to indicate that upsert operations are now supported
via SQL::Abstract::Pg.
+
3.007 2021-08-01 20:17:42 EDT
- Increase DBD::SQLite dependency to 1.68 to support and use
sqlite_string_mode over sqlite_unicode (#22, Adam Williamson)
- The default options now set sqlite_string_mode to
DBD_SQLITE_STRING_MODE_UNICODE_FALLBACK,
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.007/META.json
new/Mojo-SQLite-3.008/META.json
--- old/Mojo-SQLite-3.007/META.json 2021-08-02 02:17:44.000000000 +0200
+++ new/Mojo-SQLite-3.008/META.json 2021-11-28 17:10:26.000000000 +0100
@@ -66,28 +66,28 @@
"provides" : {
"Mojo::SQLite" : {
"file" : "lib/Mojo/SQLite.pm",
- "version" : "3.007"
+ "version" : "3.008"
},
"Mojo::SQLite::Database" : {
"file" : "lib/Mojo/SQLite/Database.pm",
- "version" : "3.007"
+ "version" : "3.008"
},
"Mojo::SQLite::Migrations" : {
"file" : "lib/Mojo/SQLite/Migrations.pm",
- "version" : "3.007"
+ "version" : "3.008"
},
"Mojo::SQLite::PubSub" : {
"file" : "lib/Mojo/SQLite/PubSub.pm",
- "version" : "3.007",
+ "version" : "3.008",
"x_deprecated" : 1
},
"Mojo::SQLite::Results" : {
"file" : "lib/Mojo/SQLite/Results.pm",
- "version" : "3.007"
+ "version" : "3.008"
},
"Mojo::SQLite::Transaction" : {
"file" : "lib/Mojo/SQLite/Transaction.pm",
- "version" : "3.007"
+ "version" : "3.008"
}
},
"release_status" : "stable",
@@ -103,7 +103,7 @@
},
"x_IRC" : "ircs://irc.libera.chat/#mojo"
},
- "version" : "3.007",
+ "version" : "3.008",
"x_contributors" : [
"Adam Williamson <[email protected]>",
"Dan Book <[email protected]>",
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.007/META.yml
new/Mojo-SQLite-3.008/META.yml
--- old/Mojo-SQLite-3.007/META.yml 2021-08-02 02:17:44.000000000 +0200
+++ new/Mojo-SQLite-3.008/META.yml 2021-11-28 17:10:26.000000000 +0100
@@ -26,23 +26,23 @@
provides:
Mojo::SQLite:
file: lib/Mojo/SQLite.pm
- version: '3.007'
+ version: '3.008'
Mojo::SQLite::Database:
file: lib/Mojo/SQLite/Database.pm
- version: '3.007'
+ version: '3.008'
Mojo::SQLite::Migrations:
file: lib/Mojo/SQLite/Migrations.pm
- version: '3.007'
+ version: '3.008'
Mojo::SQLite::PubSub:
file: lib/Mojo/SQLite/PubSub.pm
- version: '3.007'
+ version: '3.008'
x_deprecated: 1
Mojo::SQLite::Results:
file: lib/Mojo/SQLite/Results.pm
- version: '3.007'
+ version: '3.008'
Mojo::SQLite::Transaction:
file: lib/Mojo/SQLite/Transaction.pm
- version: '3.007'
+ version: '3.008'
requires:
Carp: '0'
DBD::SQLite: '1.68'
@@ -61,7 +61,7 @@
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.007'
+version: '3.008'
x_contributors:
- 'Adam Williamson <[email protected]>'
- 'Dan Book <[email protected]>'
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.007/README new/Mojo-SQLite-3.008/README
--- old/Mojo-SQLite-3.007/README 2021-08-02 02:17:44.000000000 +0200
+++ new/Mojo-SQLite-3.008/README 2021-11-28 17:10:26.000000000 +0100
@@ -183,12 +183,16 @@
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.
+ The for feature is 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'}});
+
+ # Upsert supported since SQLite 3.24.0
+ $sql->db->insert('some_table', {name => $name, value => $value},
+ {on_conflict => [name => {value => \'"excluded"."value"'}]});
auto_migrate
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.007/lib/Mojo/SQLite/Database.pm
new/Mojo-SQLite-3.008/lib/Mojo/SQLite/Database.pm
--- old/Mojo-SQLite-3.007/lib/Mojo/SQLite/Database.pm 2021-08-02
02:17:44.000000000 +0200
+++ new/Mojo-SQLite-3.008/lib/Mojo/SQLite/Database.pm 2021-11-28
17:10:26.000000000 +0100
@@ -9,7 +9,7 @@
use Mojo::SQLite::Transaction;
use Mojo::Util 'monkey_patch';
-our $VERSION = '3.007';
+our $VERSION = '3.008';
our @CARP_NOT = qw(Mojo::SQLite::Migrations);
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.007/lib/Mojo/SQLite/Migrations.pm
new/Mojo-SQLite-3.008/lib/Mojo/SQLite/Migrations.pm
--- old/Mojo-SQLite-3.007/lib/Mojo/SQLite/Migrations.pm 2021-08-02
02:17:44.000000000 +0200
+++ new/Mojo-SQLite-3.008/lib/Mojo/SQLite/Migrations.pm 2021-11-28
17:10:26.000000000 +0100
@@ -8,7 +8,7 @@
use constant DEBUG => $ENV{MOJO_MIGRATIONS_DEBUG} || 0;
-our $VERSION = '3.007';
+our $VERSION = '3.008';
has name => 'migrations';
has sqlite => undef, weak => 1;
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.007/lib/Mojo/SQLite/PubSub.pm
new/Mojo-SQLite-3.008/lib/Mojo/SQLite/PubSub.pm
--- old/Mojo-SQLite-3.007/lib/Mojo/SQLite/PubSub.pm 2021-08-02
02:17:44.000000000 +0200
+++ new/Mojo-SQLite-3.008/lib/Mojo/SQLite/PubSub.pm 2021-11-28
17:10:26.000000000 +0100
@@ -3,7 +3,7 @@
use Mojo::Util 'deprecated';
-our $VERSION = '3.007';
+our $VERSION = '3.008';
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.007/lib/Mojo/SQLite/Results.pm
new/Mojo-SQLite-3.008/lib/Mojo/SQLite/Results.pm
--- old/Mojo-SQLite-3.007/lib/Mojo/SQLite/Results.pm 2021-08-02
02:17:44.000000000 +0200
+++ new/Mojo-SQLite-3.008/lib/Mojo/SQLite/Results.pm 2021-11-28
17:10:26.000000000 +0100
@@ -5,7 +5,7 @@
use Mojo::JSON 'from_json';
use Mojo::Util 'tablify';
-our $VERSION = '3.007';
+our $VERSION = '3.008';
has [qw(db sth)];
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.007/lib/Mojo/SQLite/Transaction.pm
new/Mojo-SQLite-3.008/lib/Mojo/SQLite/Transaction.pm
--- old/Mojo-SQLite-3.007/lib/Mojo/SQLite/Transaction.pm 2021-08-02
02:17:44.000000000 +0200
+++ new/Mojo-SQLite-3.008/lib/Mojo/SQLite/Transaction.pm 2021-11-28
17:10:26.000000000 +0100
@@ -3,7 +3,7 @@
use Carp 'croak';
-our $VERSION = '3.007';
+our $VERSION = '3.008';
has db => undef, weak => 1;
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.007/lib/Mojo/SQLite.pm
new/Mojo-SQLite-3.008/lib/Mojo/SQLite.pm
--- old/Mojo-SQLite-3.007/lib/Mojo/SQLite.pm 2021-08-02 02:17:44.000000000
+0200
+++ new/Mojo-SQLite-3.008/lib/Mojo/SQLite.pm 2021-11-28 17:10:26.000000000
+0100
@@ -14,7 +14,7 @@
use URI;
use URI::db;
-our $VERSION = '3.007';
+our $VERSION = '3.008';
has abstract => sub { SQL::Abstract::Pg->new(name_sep => '.', quote_char =>
'"') };
has 'auto_migrate';
@@ -311,14 +311,17 @@
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.
+C<limit>/C<offset>. The C<for> feature is 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'}});
+ # Upsert supported since SQLite 3.24.0
+ $sql->db->insert('some_table', {name => $name, value => $value},
+ {on_conflict => [name => {value => \'"excluded"."value"'}]});
+
=head2 auto_migrate
my $bool = $sql->auto_migrate;
