Hello community,
here is the log from the commit of package perl-Mojo-SQLite for
openSUSE:Factory checked in at 2019-10-08 19:59:35
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Comparing /work/SRC/openSUSE:Factory/perl-Mojo-SQLite (Old)
and /work/SRC/openSUSE:Factory/.perl-Mojo-SQLite.new.2352 (New)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "perl-Mojo-SQLite"
Tue Oct 8 19:59:35 2019 rev:9 rq:736049 version:3.003
Changes:
--------
--- /work/SRC/openSUSE:Factory/perl-Mojo-SQLite/perl-Mojo-SQLite.changes
2019-06-24 21:53:48.788126871 +0200
+++
/work/SRC/openSUSE:Factory/.perl-Mojo-SQLite.new.2352/perl-Mojo-SQLite.changes
2019-10-08 19:59:37.303893563 +0200
@@ -1,0 +2,13 @@
+Fri Oct 4 09:25:08 UTC 2019 - <timueller+p...@suse.de>
+
+- updated to 3.003
+ see /usr/share/doc/packages/perl-Mojo-SQLite/Changes
+
+ 3.003 2019-10-01 15:49:43 EDT
+ - Increase DBD::SQLite dependency to 1.64 to support configuring
+ double-quoted string literals.
+ - Disable double-quoted string literals for all connections.
+
https://www.sqlite.org/quirks.html#double_quoted_string_literals_are_accepted
+ - Change default SQL::Abstract identifier back to double quote.
+
+-------------------------------------------------------------------
Old:
----
Mojo-SQLite-3.002.tar.gz
New:
----
Mojo-SQLite-3.003.tar.gz
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Other differences:
------------------
++++++ perl-Mojo-SQLite.spec ++++++
--- /var/tmp/diff_new_pack.W1HH8N/_old 2019-10-08 19:59:38.339890460 +0200
+++ /var/tmp/diff_new_pack.W1HH8N/_new 2019-10-08 19:59:38.343890448 +0200
@@ -17,7 +17,7 @@
Name: perl-Mojo-SQLite
-Version: 3.002
+Version: 3.003
Release: 0
%define cpan_name Mojo-SQLite
Summary: Tiny Mojolicious wrapper for SQLite
@@ -30,7 +30,7 @@
BuildRoot: %{_tmppath}/%{name}-%{version}-build
BuildRequires: perl
BuildRequires: perl-macros
-BuildRequires: perl(DBD::SQLite) >= 1.54
+BuildRequires: perl(DBD::SQLite) >= 1.64
BuildRequires: perl(DBI) >= 1.627
BuildRequires: perl(Module::Build::Tiny) >= 0.034
BuildRequires: perl(Module::Metadata)
@@ -40,7 +40,7 @@
BuildRequires: perl(URI) >= 1.69
BuildRequires: perl(URI::db) >= 0.15
BuildRequires: perl(URI::file) >= 4.21
-Requires: perl(DBD::SQLite) >= 1.54
+Requires: perl(DBD::SQLite) >= 1.64
Requires: perl(DBI) >= 1.627
Requires: perl(Mojolicious) >= 7.32
Requires: perl(SQL::Abstract) >= 1.81
++++++ Mojo-SQLite-3.002.tar.gz -> Mojo-SQLite-3.003.tar.gz ++++++
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.002/Build.PL
new/Mojo-SQLite-3.003/Build.PL
--- old/Mojo-SQLite-3.002/Build.PL 2019-06-21 23:41:37.000000000 +0200
+++ new/Mojo-SQLite-3.003/Build.PL 2019-10-01 21:49:45.000000000 +0200
@@ -84,13 +84,13 @@
"Dan Book <dbook\@cpan.org>"
],
"dist_name" => "Mojo-SQLite",
- "dist_version" => "3.002",
+ "dist_version" => "3.003",
"license" => "artistic_2",
"module_name" => "Mojo::SQLite",
"recursive_test_files" => 1,
"requires" => {
"Carp" => 0,
- "DBD::SQLite" => "1.54",
+ "DBD::SQLite" => "1.64",
"DBI" => "1.627",
"File::Spec::Functions" => 0,
"File::Temp" => 0,
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.002/Changes
new/Mojo-SQLite-3.003/Changes
--- old/Mojo-SQLite-3.002/Changes 2019-06-21 23:41:37.000000000 +0200
+++ new/Mojo-SQLite-3.003/Changes 2019-10-01 21:49:45.000000000 +0200
@@ -1,3 +1,10 @@
+3.003 2019-10-01 15:49:43 EDT
+ - Increase DBD::SQLite dependency to 1.64 to support configuring
+ double-quoted string literals.
+ - Disable double-quoted string literals for all connections.
+
https://www.sqlite.org/quirks.html#double_quoted_string_literals_are_accepted
+ - Change default SQL::Abstract identifier back to double quote.
+
3.002 2019-06-21 17:41:35 EDT
- Changed default SQL::Abstract identifier quoting character to `, as double
quoted identifiers may be interpreted as string literals if they are not
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.002/META.json
new/Mojo-SQLite-3.003/META.json
--- old/Mojo-SQLite-3.002/META.json 2019-06-21 23:41:37.000000000 +0200
+++ new/Mojo-SQLite-3.003/META.json 2019-10-01 21:49:45.000000000 +0200
@@ -39,7 +39,7 @@
"runtime" : {
"requires" : {
"Carp" : "0",
- "DBD::SQLite" : "1.54",
+ "DBD::SQLite" : "1.64",
"DBI" : "1.627",
"File::Spec::Functions" : "0",
"File::Temp" : "0",
@@ -66,28 +66,28 @@
"provides" : {
"Mojo::SQLite" : {
"file" : "lib/Mojo/SQLite.pm",
- "version" : "3.002"
+ "version" : "3.003"
},
"Mojo::SQLite::Database" : {
"file" : "lib/Mojo/SQLite/Database.pm",
- "version" : "3.002"
+ "version" : "3.003"
},
"Mojo::SQLite::Migrations" : {
"file" : "lib/Mojo/SQLite/Migrations.pm",
- "version" : "3.002"
+ "version" : "3.003"
},
"Mojo::SQLite::PubSub" : {
"file" : "lib/Mojo/SQLite/PubSub.pm",
- "version" : "3.002",
+ "version" : "3.003",
"x_deprecated" : 1
},
"Mojo::SQLite::Results" : {
"file" : "lib/Mojo/SQLite/Results.pm",
- "version" : "3.002"
+ "version" : "3.003"
},
"Mojo::SQLite::Transaction" : {
"file" : "lib/Mojo/SQLite/Transaction.pm",
- "version" : "3.002"
+ "version" : "3.003"
}
},
"release_status" : "stable",
@@ -103,7 +103,7 @@
},
"x_IRC" : "irc://irc.freenode.net/#mojo"
},
- "version" : "3.002",
+ "version" : "3.003",
"x_Dist_Zilla" : {
"perl" : {
"version" : "5.030000"
@@ -154,7 +154,7 @@
"meta_noindex" : 1
},
"Dist::Zilla::Role::ModuleMetadata" : {
- "Module::Metadata" : "1.000036",
+ "Module::Metadata" : "1.000037",
"version" : "0.006"
}
},
@@ -297,7 +297,7 @@
"branch" : null,
"changelog" : "Changes",
"signed" : 0,
- "tag" : "3.002",
+ "tag" : "3.003",
"tag_format" : "%v",
"tag_message" : "%v"
},
@@ -529,7 +529,7 @@
"class" : "Dist::Zilla::Plugin::InstallGuide",
"config" : {
"Dist::Zilla::Role::ModuleMetadata" : {
- "Module::Metadata" : "1.000036",
+ "Module::Metadata" : "1.000037",
"version" : "0.006"
}
},
@@ -638,6 +638,6 @@
"Dan Book <gri...@grinnz.com>"
],
"x_generated_by_perl" : "v5.30.0",
- "x_serialization_backend" : "Cpanel::JSON::XS version 4.11"
+ "x_serialization_backend" : "Cpanel::JSON::XS version 4.12"
}
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.002/META.yml
new/Mojo-SQLite-3.003/META.yml
--- old/Mojo-SQLite-3.002/META.yml 2019-06-21 23:41:37.000000000 +0200
+++ new/Mojo-SQLite-3.003/META.yml 2019-10-01 21:49:45.000000000 +0200
@@ -26,26 +26,26 @@
provides:
Mojo::SQLite:
file: lib/Mojo/SQLite.pm
- version: '3.002'
+ version: '3.003'
Mojo::SQLite::Database:
file: lib/Mojo/SQLite/Database.pm
- version: '3.002'
+ version: '3.003'
Mojo::SQLite::Migrations:
file: lib/Mojo/SQLite/Migrations.pm
- version: '3.002'
+ version: '3.003'
Mojo::SQLite::PubSub:
file: lib/Mojo/SQLite/PubSub.pm
- version: '3.002'
+ version: '3.003'
x_deprecated: 1
Mojo::SQLite::Results:
file: lib/Mojo/SQLite/Results.pm
- version: '3.002'
+ version: '3.003'
Mojo::SQLite::Transaction:
file: lib/Mojo/SQLite/Transaction.pm
- version: '3.002'
+ version: '3.003'
requires:
Carp: '0'
- DBD::SQLite: '1.54'
+ DBD::SQLite: '1.64'
DBI: '1.627'
File::Spec::Functions: '0'
File::Temp: '0'
@@ -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.002'
+version: '3.003'
x_Dist_Zilla:
perl:
version: '5.030000'
@@ -101,7 +101,7 @@
inherit_version: '1'
meta_noindex: '1'
Dist::Zilla::Role::ModuleMetadata:
- Module::Metadata: '1.000036'
+ Module::Metadata: '1.000037'
version: '0.006'
name: '@Author::DBOOK/MetaProvides::Package'
version: '2.004003'
@@ -211,7 +211,7 @@
branch: ~
changelog: Changes
signed: 0
- tag: '3.002'
+ tag: '3.003'
tag_format: '%v'
tag_message: '%v'
Dist::Zilla::Role::Git::Repo:
@@ -383,7 +383,7 @@
class: Dist::Zilla::Plugin::InstallGuide
config:
Dist::Zilla::Role::ModuleMetadata:
- Module::Metadata: '1.000036'
+ Module::Metadata: '1.000037'
version: '0.006'
name: '@Author::DBOOK/InstallGuide'
version: '1.200013'
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.002/cpanfile
new/Mojo-SQLite-3.003/cpanfile
--- old/Mojo-SQLite-3.002/cpanfile 2019-06-21 23:41:37.000000000 +0200
+++ new/Mojo-SQLite-3.003/cpanfile 2019-10-01 21:49:45.000000000 +0200
@@ -1,7 +1,7 @@
requires 'perl' => '5.010001';
requires 'Carp';
requires 'DBI' => '1.627';
-requires 'DBD::SQLite' => '1.54'; # for JSON1 and FTS5 support
+requires 'DBD::SQLite' => '1.64'; # for JSON1, FTS5, DQS
requires 'File::Spec::Functions';
requires 'File::Temp';
requires 'Mojolicious' => '7.32';
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.002/lib/Mojo/SQLite/Database.pm
new/Mojo-SQLite-3.003/lib/Mojo/SQLite/Database.pm
--- old/Mojo-SQLite-3.002/lib/Mojo/SQLite/Database.pm 2019-06-21
23:41:37.000000000 +0200
+++ new/Mojo-SQLite-3.003/lib/Mojo/SQLite/Database.pm 2019-10-01
21:49:45.000000000 +0200
@@ -10,7 +10,7 @@
use Mojo::Util 'monkey_patch';
use Scalar::Util 'weaken';
-our $VERSION = '3.002';
+our $VERSION = '3.003';
our @CARP_NOT = qw(Mojo::SQLite::Migrations);
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.002/lib/Mojo/SQLite/Migrations.pm
new/Mojo-SQLite-3.003/lib/Mojo/SQLite/Migrations.pm
--- old/Mojo-SQLite-3.002/lib/Mojo/SQLite/Migrations.pm 2019-06-21
23:41:37.000000000 +0200
+++ new/Mojo-SQLite-3.003/lib/Mojo/SQLite/Migrations.pm 2019-10-01
21:49:45.000000000 +0200
@@ -8,7 +8,7 @@
use constant DEBUG => $ENV{MOJO_MIGRATIONS_DEBUG} || 0;
-our $VERSION = '3.002';
+our $VERSION = '3.003';
has name => 'migrations';
has 'sqlite';
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.002/lib/Mojo/SQLite/PubSub.pm
new/Mojo-SQLite-3.003/lib/Mojo/SQLite/PubSub.pm
--- old/Mojo-SQLite-3.002/lib/Mojo/SQLite/PubSub.pm 2019-06-21
23:41:37.000000000 +0200
+++ new/Mojo-SQLite-3.003/lib/Mojo/SQLite/PubSub.pm 2019-10-01
21:49:45.000000000 +0200
@@ -3,7 +3,7 @@
use Mojo::Util 'deprecated';
-our $VERSION = '3.002';
+our $VERSION = '3.003';
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.002/lib/Mojo/SQLite/Results.pm
new/Mojo-SQLite-3.003/lib/Mojo/SQLite/Results.pm
--- old/Mojo-SQLite-3.002/lib/Mojo/SQLite/Results.pm 2019-06-21
23:41:37.000000000 +0200
+++ new/Mojo-SQLite-3.003/lib/Mojo/SQLite/Results.pm 2019-10-01
21:49:45.000000000 +0200
@@ -5,7 +5,7 @@
use Mojo::JSON 'from_json';
use Mojo::Util 'tablify';
-our $VERSION = '3.002';
+our $VERSION = '3.003';
has [qw(db sth)];
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.002/lib/Mojo/SQLite/Transaction.pm
new/Mojo-SQLite-3.003/lib/Mojo/SQLite/Transaction.pm
--- old/Mojo-SQLite-3.002/lib/Mojo/SQLite/Transaction.pm 2019-06-21
23:41:37.000000000 +0200
+++ new/Mojo-SQLite-3.003/lib/Mojo/SQLite/Transaction.pm 2019-10-01
21:49:45.000000000 +0200
@@ -3,7 +3,7 @@
use Carp 'croak';
-our $VERSION = '3.002';
+our $VERSION = '3.003';
has 'db';
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.002/lib/Mojo/SQLite.pm
new/Mojo-SQLite-3.003/lib/Mojo/SQLite.pm
--- old/Mojo-SQLite-3.002/lib/Mojo/SQLite.pm 2019-06-21 23:41:37.000000000
+0200
+++ new/Mojo-SQLite-3.003/lib/Mojo/SQLite.pm 2019-10-01 21:49:45.000000000
+0200
@@ -4,6 +4,7 @@
use Carp 'croak';
use DBI;
use DBD::SQLite;
+use DBD::SQLite::Constants ':database_connection_configuration_options';
use File::Spec::Functions 'catfile';
use File::Temp;
use Mojo::SQLite::Database;
@@ -13,9 +14,9 @@
use URI;
use URI::db;
-our $VERSION = '3.002';
+our $VERSION = '3.003';
-has abstract => sub { SQL::Abstract->new(name_sep => '.', quote_char => '`') };
+has abstract => sub { SQL::Abstract->new(name_sep => '.', quote_char => '"') };
has 'auto_migrate';
has database_class => 'Mojo::SQLite::Database';
has dsn => sub { _url_from_file(shift->_tempfile)->dbi_dsn };
@@ -82,6 +83,8 @@
my $dbh = DBI->connect($self->dsn, undef, undef, $self->options)
// croak "DBI connection to @{[$self->dsn]} failed: $DBI::errstr"; #
RaiseError disabled
+ $dbh->sqlite_db_config(SQLITE_DBCONFIG_DQS_DDL, 0);
+ $dbh->sqlite_db_config(SQLITE_DBCONFIG_DQS_DML, 0);
unless ($self->options->{no_wal}) {
$dbh->do('pragma journal_mode=WAL');
$dbh->do('pragma synchronous=NORMAL');
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.002/t/00-report-prereqs.dd
new/Mojo-SQLite-3.003/t/00-report-prereqs.dd
--- old/Mojo-SQLite-3.002/t/00-report-prereqs.dd 2019-06-21
23:41:37.000000000 +0200
+++ new/Mojo-SQLite-3.003/t/00-report-prereqs.dd 2019-10-01
21:49:45.000000000 +0200
@@ -14,7 +14,7 @@
'runtime' => {
'requires' => {
'Carp' => '0',
- 'DBD::SQLite' => '1.54',
+ 'DBD::SQLite' => '1.64',
'DBI' => '1.627',
'File::Spec::Functions' => '0',
'File::Temp' => '0',
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/Mojo-SQLite-3.002/t/database.t
new/Mojo-SQLite-3.003/t/database.t
--- old/Mojo-SQLite-3.002/t/database.t 2019-06-21 23:41:37.000000000 +0200
+++ new/Mojo-SQLite-3.003/t/database.t 2019-10-01 21:49:45.000000000 +0200
@@ -258,6 +258,9 @@
eval { $sql->db->query('select * from table_does_not_exist') };
like $@, qr/database\.t/, 'right error';
+# Double-quoted literal
+ok !eval { $sql->db->query('select "does_not_exist"') }, 'no double-quoted
string literals';
+
# WAL mode option
{
my $journal_mode = $sql->db->query('pragma
journal_mode')->arrays->first->[0];
