commit perl-SQL-Abstract for openSUSE:Factory
Hello community, here is the log from the commit of package perl-SQL-Abstract for openSUSE:Factory checked in at 2020-06-03 20:36:21 Comparing /work/SRC/openSUSE:Factory/perl-SQL-Abstract (Old) and /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new.3606 (New) Package is "perl-SQL-Abstract" Wed Jun 3 20:36:21 2020 rev:15 rq:811175 version:1.87 Changes: --- /work/SRC/openSUSE:Factory/perl-SQL-Abstract/perl-SQL-Abstract.changes 2018-07-28 12:39:27.780317462 +0200 +++ /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new.3606/perl-SQL-Abstract.changes 2020-06-03 20:36:52.525991252 +0200 @@ -1,0 +2,11 @@ +Tue Jun 2 15:36:46 UTC 2020 - Tina Müller + +- updated to 1.87 + see /usr/share/doc/packages/perl-SQL-Abstract/Changes + + 1.87 - 2020-06-02 + - Add runtime dependency on Test::Deep and Test::Builder::Module for +SQL::Abstract::Test (RT#131623) + + +--- Old: SQL-Abstract-1.86.tar.gz New: SQL-Abstract-1.87.tar.gz Other differences: -- ++ perl-SQL-Abstract.spec ++ --- /var/tmp/diff_new_pack.ykg4cI/_old 2020-06-03 20:36:53.105993070 +0200 +++ /var/tmp/diff_new_pack.ykg4cI/_new 2020-06-03 20:36:53.109993083 +0200 @@ -1,7 +1,7 @@ # # spec file for package perl-SQL-Abstract # -# Copyright (c) 2018 SUSE LINUX GmbH, Nuernberg, Germany. +# Copyright (c) 2020 SUSE LLC # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed @@ -12,18 +12,18 @@ # license that conforms to the Open Source Definition (Version 1.9) # published by the Open Source Initiative. -# Please submit bugfixes or comments via http://bugs.opensuse.org/ +# Please submit bugfixes or comments via https://bugs.opensuse.org/ # Name: perl-SQL-Abstract -Version:1.86 +Version:1.87 Release:0 %define cpan_name SQL-Abstract Summary:Generate SQL from Perl data structures License:Artistic-1.0 OR GPL-1.0-or-later Group: Development/Libraries/Perl -Url:http://search.cpan.org/dist/SQL-Abstract/ +URL:https://metacpan.org/release/%{cpan_name} Source0: https://cpan.metacpan.org/authors/id/I/IL/ILMARI/%{cpan_name}-%{version}.tar.gz Source1:cpanspec.yml BuildArch: noarch @@ -34,6 +34,7 @@ BuildRequires: perl(MRO::Compat) >= 0.12 BuildRequires: perl(Moo) >= 2.01 BuildRequires: perl(Sub::Quote) >= 2.01 +BuildRequires: perl(Test::Builder::Module) >= 0.84 BuildRequires: perl(Test::Deep) >= 0.101 BuildRequires: perl(Test::Exception) >= 0.31 BuildRequires: perl(Test::More) >= 0.88 @@ -43,6 +44,8 @@ Requires: perl(MRO::Compat) >= 0.12 Requires: perl(Moo) >= 2.01 Requires: perl(Sub::Quote) >= 2.01 +Requires: perl(Test::Builder::Module) >= 0.84 +Requires: perl(Test::Deep) >= 0.101 Requires: perl(Text::Balanced) >= 2.00 %{perl_requires} @@ -90,14 +93,14 @@ %prep %setup -q -n %{cpan_name}-%{version} -find . -type f ! -name \*.pl -print0 | xargs -0 chmod 644 +find . -type f ! -path "*/t/*" ! -name "*.pl" ! -path "*/bin/*" ! -path "*/script/*" ! -name "configure" -print0 | xargs -0 chmod 644 %build -%{__perl} Makefile.PL INSTALLDIRS=vendor -%{__make} %{?_smp_mflags} +perl Makefile.PL INSTALLDIRS=vendor +make %{?_smp_mflags} %check -%{__make} test +make test %install %perl_make_install ++ SQL-Abstract-1.86.tar.gz -> SQL-Abstract-1.87.tar.gz ++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.86/Changes new/SQL-Abstract-1.87/Changes --- old/SQL-Abstract-1.86/Changes 2018-07-09 18:24:23.0 +0200 +++ new/SQL-Abstract-1.87/Changes 2020-06-02 12:33:58.0 +0200 @@ -1,5 +1,9 @@ Revision history for SQL::Abstract +1.87 - 2020-06-02 +- Add runtime dependency on Test::Deep and Test::Builder::Module for + SQL::Abstract::Test (RT#131623) + 1.86 - 2018-07-09 - Remove obsolete documentation about arrayrefref as the $source argument for ->select (removed in version 1.74) diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.86/LICENSE new/SQL-Abstract-1.87/LICENSE --- old/SQL-Abstract-1.86/LICENSE 2018-07-09 18:28:58.0 +0200 +++ new/SQL-Abstract-1.87/LICENSE 2020-06-02 12:36:30.0 +0200 @@ -7,7 +7,7 @@ --- The GNU General Public License, Version 1, February 1989 --- -This software is Copyright (c) 2018 by Nathan Wiger . +This software is Copyright (c) 2020 by Nathan Wiger . This is free software, licensed under: @@ -267
commit perl-SQL-Abstract for openSUSE:Factory
Hello community, here is the log from the commit of package perl-SQL-Abstract for openSUSE:Factory checked in at 2018-07-28 12:39:26 Comparing /work/SRC/openSUSE:Factory/perl-SQL-Abstract (Old) and /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new (New) Package is "perl-SQL-Abstract" Sat Jul 28 12:39:26 2018 rev:14 rq:623037 version:1.86 Changes: --- /work/SRC/openSUSE:Factory/perl-SQL-Abstract/perl-SQL-Abstract.changes 2018-02-02 22:23:32.802333710 +0100 +++ /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new/perl-SQL-Abstract.changes 2018-07-28 12:39:27.780317462 +0200 @@ -1,0 +2,12 @@ +Tue Jul 10 06:00:40 UTC 2018 - co...@suse.com + +- updated to 1.86 + see /usr/share/doc/packages/perl-SQL-Abstract/Changes + + 1.86 - 2018-07-09 + - Remove obsolete documentation about arrayrefref as the $source +argument for ->select (removed in version 1.74) + - Factor out the field list part of SELECT for subclassability (GH#13) + - Do not replace literal '0' with empty string in WHERE clauses (GH#14) + +--- Old: SQL-Abstract-1.85.tar.gz New: SQL-Abstract-1.86.tar.gz Other differences: -- ++ perl-SQL-Abstract.spec ++ --- /var/tmp/diff_new_pack.totzWY/_old 2018-07-28 12:39:28.704319238 +0200 +++ /var/tmp/diff_new_pack.totzWY/_new 2018-07-28 12:39:28.704319238 +0200 @@ -17,11 +17,11 @@ Name: perl-SQL-Abstract -Version:1.85 +Version:1.86 Release:0 %define cpan_name SQL-Abstract Summary:Generate SQL from Perl data structures -License:Artistic-1.0 or GPL-1.0+ +License:Artistic-1.0 OR GPL-1.0-or-later Group: Development/Libraries/Perl Url:http://search.cpan.org/dist/SQL-Abstract/ Source0: https://cpan.metacpan.org/authors/id/I/IL/ILMARI/%{cpan_name}-%{version}.tar.gz @@ -107,5 +107,6 @@ %files -f %{name}.files %defattr(-,root,root,755) %doc Changes examples README +%license LICENSE %changelog ++ SQL-Abstract-1.85.tar.gz -> SQL-Abstract-1.86.tar.gz ++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.85/Changes new/SQL-Abstract-1.86/Changes --- old/SQL-Abstract-1.85/Changes 2018-01-27 12:10:35.0 +0100 +++ new/SQL-Abstract-1.86/Changes 2018-07-09 18:24:23.0 +0200 @@ -1,5 +1,11 @@ Revision history for SQL::Abstract +1.86 - 2018-07-09 +- Remove obsolete documentation about arrayrefref as the $source + argument for ->select (removed in version 1.74) +- Factor out the field list part of SELECT for subclassability (GH#13) +- Do not replace literal '0' with empty string in WHERE clauses (GH#14) + 1.85 - 2018-01-27 - Restore perl version requirement missed in the Distar port - Factor out the SET ... part of UPDATE for subclassability (GH#12) diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.85/LICENSE new/SQL-Abstract-1.86/LICENSE --- old/SQL-Abstract-1.85/LICENSE 1970-01-01 01:00:00.0 +0100 +++ new/SQL-Abstract-1.86/LICENSE 2018-07-09 18:28:58.0 +0200 @@ -0,0 +1,374 @@ +Terms of the Perl programming language system itself + +a) the GNU General Public License as published by the Free + Software Foundation; either version 1, or (at your option) any + later version, or +b) the "Artistic License" + +--- The GNU General Public License, Version 1, February 1989 --- + +This software is Copyright (c) 2018 by Nathan Wiger . + +This is free software, licensed under: + + The GNU General Public License, Version 1, February 1989 + +GNU GENERAL PUBLIC LICENSE + Version 1, February 1989 + + Copyright (C) 1989 Free Software Foundation, Inc. + 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA + + Everyone is permitted to copy and distribute verbatim copies + of this license document, but changing it is not allowed. + +Preamble + + The license agreements of most software companies try to keep users +at the mercy of those companies. By contrast, our General Public +License is intended to guarantee your freedom to share and change free +software--to make sure the software is free for all its users. The +General Public License applies to the Free Software Foundation's +software and to any other program whose authors commit to using it. +You can use it for your programs, too. + + When we speak of free software, we are referring to freedom, not +price. Specifically, the General Public License is designed to make +sure that you have the freedom to give away or sell copies of free +softwar
commit perl-SQL-Abstract for openSUSE:Factory
Hello community, here is the log from the commit of package perl-SQL-Abstract for openSUSE:Factory checked in at 2018-02-02 22:23:13 Comparing /work/SRC/openSUSE:Factory/perl-SQL-Abstract (Old) and /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new (New) Package is "perl-SQL-Abstract" Fri Feb 2 22:23:13 2018 rev:13 rq:572022 version:1.85 Changes: --- /work/SRC/openSUSE:Factory/perl-SQL-Abstract/perl-SQL-Abstract.changes 2017-04-11 12:43:49.421949659 +0200 +++ /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new/perl-SQL-Abstract.changes 2018-02-02 22:23:32.802333710 +0100 @@ -1,0 +2,10 @@ +Wed Jan 31 12:46:25 UTC 2018 - co...@suse.com + +- updated to 1.85 + see /usr/share/doc/packages/perl-SQL-Abstract/Changes + + 1.85 - 2018-01-27 + - Restore perl version requirement missed in the Distar port + - Factor out the SET ... part of UPDATE for subclassability (GH#12) + +--- Old: SQL-Abstract-1.84.tar.gz New: SQL-Abstract-1.85.tar.gz Other differences: -- ++ perl-SQL-Abstract.spec ++ --- /var/tmp/diff_new_pack.PySH80/_old 2018-02-02 22:23:33.530299729 +0100 +++ /var/tmp/diff_new_pack.PySH80/_new 2018-02-02 22:23:33.534299541 +0100 @@ -1,7 +1,7 @@ # # spec file for package perl-SQL-Abstract # -# Copyright (c) 2017 SUSE LINUX GmbH, Nuernberg, Germany. +# Copyright (c) 2018 SUSE LINUX GmbH, Nuernberg, Germany. # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed @@ -17,7 +17,7 @@ Name: perl-SQL-Abstract -Version:1.84 +Version:1.85 Release:0 %define cpan_name SQL-Abstract Summary:Generate SQL from Perl data structures ++ SQL-Abstract-1.84.tar.gz -> SQL-Abstract-1.85.tar.gz ++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.84/Changes new/SQL-Abstract-1.85/Changes --- old/SQL-Abstract-1.84/Changes 2017-04-03 17:28:06.0 +0200 +++ new/SQL-Abstract-1.85/Changes 2018-01-27 12:10:35.0 +0100 @@ -1,5 +1,9 @@ Revision history for SQL::Abstract +1.85 - 2018-01-27 +- Restore perl version requirement missed in the Distar port +- Factor out the SET ... part of UPDATE for subclassability (GH#12) + 1.84 - 2017-04-03 - Restore 'dynamic_config => 0' missed in the Distar port diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.84/META.json new/SQL-Abstract-1.85/META.json --- old/SQL-Abstract-1.84/META.json 2017-04-03 17:29:18.0 +0200 +++ new/SQL-Abstract-1.85/META.json 2018-01-27 12:15:01.0 +0100 @@ -33,7 +33,13 @@ } }, "develop" : { - "requires" : {} + "requires" : { +"Pod::Coverage" : "0.19", +"Test::EOL" : "1.0", +"Test::NoTabs" : "0.9", +"Test::Pod" : "1.14", +"Test::Pod::Coverage" : "1.04" + } }, "runtime" : { "requires" : { @@ -44,7 +50,8 @@ "Moo" : "2.01", "Scalar::Util" : "0", "Sub::Quote" : "2.01", -"Text::Balanced" : "2.00" +"Text::Balanced" : "2.00", +"perl" : "5.006" } }, "test" : { @@ -73,6 +80,6 @@ }, "x_IRC" : "irc://irc.perl.org/#dbix-class" }, - "version" : "1.84", - "x_serialization_backend" : "JSON::PP version 2.27400" + "version" : "1.85", + "x_serialization_backend" : "JSON::PP version 2.27400_02" } diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.84/META.yml new/SQL-Abstract-1.85/META.yml --- old/SQL-Abstract-1.84/META.yml 2017-04-03 17:29:18.0 +0200 +++ new/SQL-Abstract-1.85/META.yml 2018-01-27 12:15:01.0 +0100 @@ -33,10 +33,11 @@ Scalar::Util: '0' Sub::Quote: '2.01' Text::Balanced: '2.00' + perl: '5.006' resources: IRC: irc://irc.perl.org/#dbix-class bugtracker: https://rt.cpan.org/Public/Dist/Display.html?Name=SQL-Abstract license: http://dev.perl.org/licenses/ repository: https://github.com/dbsrgits/sql-abstract.git -version: '1.84' +version: '1.85' x_serialization_backend: 'CPAN::Meta::YAML version 0.018' diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.84/Makefile.PL new/SQL-Abstract-1.85/Makefile.PL --- old/SQL-Abstract-1.84/Makefile.PL 2017-04-03 17:26:38.0 +0200 +++ new/SQL-Abstract-1.85/Makefile.PL 2017-04-14 15:36:07.0 +0200 @@ -34,10 +34,17 @@
commit perl-SQL-Abstract for openSUSE:Factory
Hello community, here is the log from the commit of package perl-SQL-Abstract for openSUSE:Factory checked in at 2017-04-11 12:43:48 Comparing /work/SRC/openSUSE:Factory/perl-SQL-Abstract (Old) and /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new (New) Package is "perl-SQL-Abstract" Tue Apr 11 12:43:48 2017 rev:12 rq:486136 version:1.84 Changes: --- /work/SRC/openSUSE:Factory/perl-SQL-Abstract/perl-SQL-Abstract.changes 2017-03-24 02:23:27.436760214 +0100 +++ /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new/perl-SQL-Abstract.changes 2017-04-11 12:43:49.421949659 +0200 @@ -1,0 +2,13 @@ +Tue Apr 4 06:42:58 UTC 2017 - co...@suse.com + +- updated to 1.84 + see /usr/share/doc/packages/perl-SQL-Abstract/Changes + + 1.84 - 2017-04-03 + - Restore 'dynamic_config => 0' missed in the Distar port + + 1.83 - 2017-04-03 + - Support for DELETE ... RETURNING (GH#9) + - Port to Distar + +--- Old: SQL-Abstract-1.82.tar.gz New: SQL-Abstract-1.84.tar.gz Other differences: -- ++ perl-SQL-Abstract.spec ++ --- /var/tmp/diff_new_pack.t8NU8s/_old 2017-04-11 12:43:50.197840028 +0200 +++ /var/tmp/diff_new_pack.t8NU8s/_new 2017-04-11 12:43:50.201839462 +0200 @@ -17,7 +17,7 @@ Name: perl-SQL-Abstract -Version:1.82 +Version:1.84 Release:0 %define cpan_name SQL-Abstract Summary:Generate SQL from Perl data structures @@ -106,6 +106,6 @@ %files -f %{name}.files %defattr(-,root,root,755) -%doc Changes examples +%doc Changes examples README %changelog ++ SQL-Abstract-1.82.tar.gz -> SQL-Abstract-1.84.tar.gz ++ 5212 lines of diff (skipped)
commit perl-SQL-Abstract for openSUSE:Factory
Hello community, here is the log from the commit of package perl-SQL-Abstract for openSUSE:Factory checked in at 2017-03-24 02:23:27 Comparing /work/SRC/openSUSE:Factory/perl-SQL-Abstract (Old) and /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new (New) Package is "perl-SQL-Abstract" Fri Mar 24 02:23:27 2017 rev:11 rq:482158 version:1.82 Changes: --- /work/SRC/openSUSE:Factory/perl-SQL-Abstract/perl-SQL-Abstract.changes 2014-11-13 09:18:16.0 +0100 +++ /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new/perl-SQL-Abstract.changes 2017-03-24 02:23:27.436760214 +0100 @@ -1,0 +2,19 @@ +Tue Mar 21 07:45:31 UTC 2017 - co...@suse.com + +- updated to 1.82 + see /usr/share/doc/packages/perl-SQL-Abstract/Changes + + revision 1.82 2017-03-20 + - + - Add explicit dependency on Sub::Quote (GH#8) + - Fix syntax errors in ORDER BY docs (GH#7) + + revision 1.81_01 2017-02-28 + + - Fix order clauses with bind parameters in ->where + - Fix ->insert($table, \@values) with >26 values (RT#112684) + - Teach ::Tree that ILIKE (PostgreSQL) and REGEXP (MySQL) are binary ops + - Support for UPDATE ... RETURNING + - Documentation improvements for ORDER BY + +--- Old: SQL-Abstract-1.81.tar.gz New: SQL-Abstract-1.82.tar.gz cpanspec.yml Other differences: -- ++ perl-SQL-Abstract.spec ++ --- /var/tmp/diff_new_pack.GDMKX7/_old 2017-03-24 02:23:27.972684384 +0100 +++ /var/tmp/diff_new_pack.GDMKX7/_new 2017-03-24 02:23:27.976683818 +0100 @@ -1,7 +1,7 @@ # # spec file for package perl-SQL-Abstract # -# Copyright (c) 2014 SUSE LINUX Products GmbH, Nuernberg, Germany. +# Copyright (c) 2017 SUSE LINUX GmbH, Nuernberg, Germany. # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed @@ -17,45 +17,47 @@ Name: perl-SQL-Abstract -Version:1.81 +Version:1.82 Release:0 %define cpan_name SQL-Abstract Summary:Generate SQL from Perl data structures License:Artistic-1.0 or GPL-1.0+ Group: Development/Libraries/Perl Url:http://search.cpan.org/dist/SQL-Abstract/ -Source: http://www.cpan.org/authors/id/R/RI/RIBASUSHI/%{cpan_name}-%{version}.tar.gz +Source0: https://cpan.metacpan.org/authors/id/I/IL/ILMARI/%{cpan_name}-%{version}.tar.gz +Source1:cpanspec.yml BuildArch: noarch BuildRoot: %{_tmppath}/%{name}-%{version}-build BuildRequires: perl BuildRequires: perl-macros BuildRequires: perl(Hash::Merge) >= 0.12 BuildRequires: perl(MRO::Compat) >= 0.12 -BuildRequires: perl(Moo) >= 1.004002 +BuildRequires: perl(Moo) >= 2.01 +BuildRequires: perl(Sub::Quote) >= 2.01 BuildRequires: perl(Test::Deep) >= 0.101 -BuildRequires: perl(Test::Exception) >= 0.31 +BuildRequires: perl(Test::Exception) >= 0.31 BuildRequires: perl(Test::More) >= 0.88 BuildRequires: perl(Test::Warn) BuildRequires: perl(Text::Balanced) >= 2.00 Requires: perl(Hash::Merge) >= 0.12 Requires: perl(MRO::Compat) >= 0.12 -Requires: perl(Moo) >= 1.004002 +Requires: perl(Moo) >= 2.01 +Requires: perl(Sub::Quote) >= 2.01 Requires: perl(Text::Balanced) >= 2.00 %{perl_requires} %description -This module was inspired by the excellent the DBIx::Abstract manpage. -However, in using that module I found that what I really wanted to do was -generate SQL, but still retain complete control over my statement handles -and use the DBI interface. So, I set out to create an abstract SQL -generation module. - -While based on the concepts used by the DBIx::Abstract manpage, there are -several important differences, especially when it comes to WHERE clauses. I -have modified the concepts used to make the SQL easier to generate from -Perl data structures and, IMO, more intuitive. The underlying idea is for -this module to do what you mean, based on the data structures you provide -it. The big advantage is that you don't have to modify your code every time +This module was inspired by the excellent DBIx::Abstract. However, in using +that module I found that what I really wanted to do was generate SQL, but +still retain complete control over my statement handles and use the DBI +interface. So, I set out to create an abstract SQL generation module. + +While based on the concepts used by DBIx::Abstract, there are several +important differences, especially when it comes to WHERE clauses. I have +modified the concepts used to make the SQL easier to generate from Perl +data structures a
commit perl-SQL-Abstract for openSUSE:Factory
Hello community, here is the log from the commit of package perl-SQL-Abstract for openSUSE:Factory checked in at 2014-11-13 09:17:57 Comparing /work/SRC/openSUSE:Factory/perl-SQL-Abstract (Old) and /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new (New) Package is "perl-SQL-Abstract" Changes: --- /work/SRC/openSUSE:Factory/perl-SQL-Abstract/perl-SQL-Abstract.changes 2014-09-17 17:26:23.0 +0200 +++ /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new/perl-SQL-Abstract.changes 2014-11-13 09:18:16.0 +0100 @@ -1,0 +2,20 @@ +Wed Nov 12 09:41:09 UTC 2014 - co...@suse.com + +- updated to 1.81 + - Fix overly-enthusiastic parenthesis unroller (RT#99503) + + revision 1.80 2014-10-05 + + - Fix erroneous behavior of is_literal_value($) wrt { -ident => ... } + - Explicitly croak on top-level special ops (they didn't work anyway) + + revision 1.79 2014-09-25 + + - New exportable functions: is_literal_value($) and is_plain_value($) + - New attribute 'escape_char' allowing for proper escape of quote_chars + present in an identifier + - Deprecate { "" => \... } constructs + - Treat { -value => undef } as plain undef in all cases + - Explicitly throw on { -ident => undef } + +--- Old: SQL-Abstract-1.78.tar.gz New: SQL-Abstract-1.81.tar.gz Other differences: -- ++ perl-SQL-Abstract.spec ++ --- /var/tmp/diff_new_pack.GHCROj/_old 2014-11-13 09:18:17.0 +0100 +++ /var/tmp/diff_new_pack.GHCROj/_new 2014-11-13 09:18:17.0 +0100 @@ -17,7 +17,7 @@ Name: perl-SQL-Abstract -Version:1.78 +Version:1.81 Release:0 %define cpan_name SQL-Abstract Summary:Generate SQL from Perl data structures @@ -30,13 +30,17 @@ BuildRequires: perl BuildRequires: perl-macros BuildRequires: perl(Hash::Merge) >= 0.12 +BuildRequires: perl(MRO::Compat) >= 0.12 BuildRequires: perl(Moo) >= 1.004002 BuildRequires: perl(Test::Deep) >= 0.101 BuildRequires: perl(Test::Exception) >= 0.31 BuildRequires: perl(Test::More) >= 0.88 BuildRequires: perl(Test::Warn) +BuildRequires: perl(Text::Balanced) >= 2.00 Requires: perl(Hash::Merge) >= 0.12 +Requires: perl(MRO::Compat) >= 0.12 Requires: perl(Moo) >= 1.004002 +Requires: perl(Text::Balanced) >= 2.00 %{perl_requires} %description ++ SQL-Abstract-1.78.tar.gz -> SQL-Abstract-1.81.tar.gz ++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.78/Changes new/SQL-Abstract-1.81/Changes --- old/SQL-Abstract-1.78/Changes 2014-05-28 12:11:40.0 +0200 +++ new/SQL-Abstract-1.81/Changes 2014-10-25 13:30:00.0 +0200 @@ -1,5 +1,23 @@ Revision history for SQL::Abstract +revision 1.81 2014-10-25 + +- Fix overly-enthusiastic parenthesis unroller (RT#99503) + +revision 1.80 2014-10-05 + +- Fix erroneous behavior of is_literal_value($) wrt { -ident => ... } +- Explicitly croak on top-level special ops (they didn't work anyway) + +revision 1.79 2014-09-25 + +- New exportable functions: is_literal_value($) and is_plain_value($) +- New attribute 'escape_char' allowing for proper escape of quote_chars + present in an identifier +- Deprecate { "" => \... } constructs +- Treat { -value => undef } as plain undef in all cases +- Explicitly throw on { -ident => undef } + revision 1.78 2014-05-28 - Fix parsing of binary ops to correctly take up only a single LHS diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.78/MANIFEST new/SQL-Abstract-1.81/MANIFEST --- old/SQL-Abstract-1.78/MANIFEST 2014-05-28 12:14:07.0 +0200 +++ new/SQL-Abstract-1.81/MANIFEST 2014-10-25 13:31:05.0 +0200 @@ -41,6 +41,7 @@ t/20injection_guard.t t/21op_ident.t t/22op_value.t +t/23_is_X_value.t t/dbic/bulk-insert.t t/dbic/no-repeats.t t/dbic/show-progress.t diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.78/META.yml new/SQL-Abstract-1.81/META.yml --- old/SQL-Abstract-1.78/META.yml 2014-05-28 12:13:59.0 +0200 +++ new/SQL-Abstract-1.81/META.yml 2014-10-25 13:30:57.0 +0200 @@ -28,13 +28,17 @@ package: - DBIx::Class::Storage::Debug::PrettyPrint requires: + Exporter: 5.57 Hash::Merge: 0.12 List::Util: 0 + MRO::Compat: 0.12 Moo: 1.004002 Scalar::Util: 0 + Text::Balanced
commit perl-SQL-Abstract for openSUSE:Factory
Hello community, here is the log from the commit of package perl-SQL-Abstract for openSUSE:Factory checked in at 2014-09-17 17:26:01 Comparing /work/SRC/openSUSE:Factory/perl-SQL-Abstract (Old) and /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new (New) Package is "perl-SQL-Abstract" Changes: --- /work/SRC/openSUSE:Factory/perl-SQL-Abstract/perl-SQL-Abstract.changes 2014-02-28 19:16:02.0 +0100 +++ /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new/perl-SQL-Abstract.changes 2014-09-17 17:26:23.0 +0200 @@ -1,0 +2,11 @@ +Mon Sep 15 15:44:40 UTC 2014 - co...@suse.com + +- updated to 1.78 + - Fix parsing of binary ops to correctly take up only a single LHS + element, instead of gobbling up the entire parse-to-date + - Explicitly handle ROW_NUMBER() OVER as the snowflake-operator it is + - Improve signatures/documentation of is_same_sql_bind / eq_sql_bind + - Retire script/format-sql - the utility needs more work to be truly + end-user convenient + +--- Old: SQL-Abstract-1.77.tar.gz New: SQL-Abstract-1.78.tar.gz Other differences: -- ++ perl-SQL-Abstract.spec ++ --- /var/tmp/diff_new_pack.Mb4uvV/_old 2014-09-17 17:26:24.0 +0200 +++ /var/tmp/diff_new_pack.Mb4uvV/_new 2014-09-17 17:26:24.0 +0200 @@ -17,7 +17,7 @@ Name: perl-SQL-Abstract -Version:1.77 +Version:1.78 Release:0 %define cpan_name SQL-Abstract Summary:Generate SQL from Perl data structures @@ -29,16 +29,14 @@ BuildRoot: %{_tmppath}/%{name}-%{version}-build BuildRequires: perl BuildRequires: perl-macros -BuildRequires: perl(Class::Accessor::Grouped) >= 0.10005 -BuildRequires: perl(Getopt::Long::Descriptive) >= 0.091 BuildRequires: perl(Hash::Merge) >= 0.12 +BuildRequires: perl(Moo) >= 1.004002 BuildRequires: perl(Test::Deep) >= 0.101 -BuildRequires: perl(Test::Exception) -BuildRequires: perl(Test::More) >= 0.92 +BuildRequires: perl(Test::Exception) >= 0.31 +BuildRequires: perl(Test::More) >= 0.88 BuildRequires: perl(Test::Warn) -Requires: perl(Class::Accessor::Grouped) >= 0.10005 -Requires: perl(Getopt::Long::Descriptive) >= 0.091 Requires: perl(Hash::Merge) >= 0.12 +Requires: perl(Moo) >= 1.004002 %{perl_requires} %description ++ SQL-Abstract-1.77.tar.gz -> SQL-Abstract-1.78.tar.gz ++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.77/Changes new/SQL-Abstract-1.78/Changes --- old/SQL-Abstract-1.77/Changes 2014-01-17 02:04:54.0 +0100 +++ new/SQL-Abstract-1.78/Changes 2014-05-28 12:11:40.0 +0200 @@ -1,5 +1,14 @@ Revision history for SQL::Abstract +revision 1.78 2014-05-28 + +- Fix parsing of binary ops to correctly take up only a single LHS + element, instead of gobbling up the entire parse-to-date +- Explicitly handle ROW_NUMBER() OVER as the snowflake-operator it is +- Improve signatures/documentation of is_same_sql_bind / eq_sql_bind +- Retire script/format-sql - the utility needs more work to be truly + end-user convenient + revision 1.77 2014-01-17 - Reintroduce { -not => undef } column operator (regression from 1.75) diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.77/MANIFEST new/SQL-Abstract-1.78/MANIFEST --- old/SQL-Abstract-1.77/MANIFEST 2014-01-17 02:06:19.0 +0100 +++ new/SQL-Abstract-1.78/MANIFEST 2014-05-28 12:14:07.0 +0200 @@ -1,6 +1,7 @@ Changes examples/console.pl examples/dbic-console.pl +examples/sqla-format inc/Module/AutoInstall.pm inc/Module/Install.pm inc/Module/Install/AutoInstall.pm @@ -10,7 +11,6 @@ inc/Module/Install/Include.pm inc/Module/Install/Makefile.pm inc/Module/Install/Metadata.pm -inc/Module/Install/Scripts.pm inc/Module/Install/Win32.pm inc/Module/Install/WriteAll.pm lib/DBIx/Class/Storage/Debug/PrettyPrint.pm @@ -20,7 +20,6 @@ Makefile.PL MANIFEST This list of files META.yml -script/format-sql t/00new.t t/01generate.t t/02where.t diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.77/META.yml new/SQL-Abstract-1.78/META.yml --- old/SQL-Abstract-1.77/META.yml 2014-01-17 02:06:14.0 +0100 +++ new/SQL-Abstract-1.78/META.yml 2014-05-28 12:13:59.0 +0200 @@ -6,8 +6,8 @@ ExtUtils::MakeMaker: 6.59 Storable: 0 Test::Deep: 0.101 - Test::Exception: 0 - Test::More: 0.92 + Test::Exception: 0.31 + Test::More: 0.88 Tes
commit perl-SQL-Abstract for openSUSE:Factory
Hello community, here is the log from the commit of package perl-SQL-Abstract for openSUSE:Factory checked in at 2014-02-28 19:16:01 Comparing /work/SRC/openSUSE:Factory/perl-SQL-Abstract (Old) and /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new (New) Package is "perl-SQL-Abstract" Changes: --- /work/SRC/openSUSE:Factory/perl-SQL-Abstract/perl-SQL-Abstract.changes 2013-07-30 14:04:23.0 +0200 +++ /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new/perl-SQL-Abstract.changes 2014-02-28 19:16:02.0 +0100 @@ -1,0 +2,21 @@ +Mon Feb 24 06:12:15 UTC 2014 - co...@suse.com + +- updated to 1.77 +- Reintroduce { -not => undef } column operator (regression from 1.75) +- *UPCOMING INCOMPATIBLE BUGFIX*: SQLA used to generate incorrect SQL + on undef-containing lists fed to -in and -not_in. An exception will + be raised for a while before properly fixing this, to avoid quiet + but subtle changes to query results in production +- Deprecate and warn when supplying an empty arrayref to like/not_like + operators (likely to be removed before 2.0) + +- Warn when using an inequality operator with a multi-value array to + arrive at what amounts to a 1=1 condition (no pre-2.0 plans to fix + this behavior due to backwards comp concerns) +- Fix false negative comparison of ORDER BY ASC +- More improvements of incorrect parsing (placeholder at end of list + element) +- Fix typos in POD and comments (RT#87776) +- Augment -not_bool example with nesting (RT#89601) + +--- Old: SQL-Abstract-1.74.tar.gz New: SQL-Abstract-1.77.tar.gz Other differences: -- ++ perl-SQL-Abstract.spec ++ --- /var/tmp/diff_new_pack.kUUSlj/_old 2014-02-28 19:16:02.0 +0100 +++ /var/tmp/diff_new_pack.kUUSlj/_new 2014-02-28 19:16:02.0 +0100 @@ -1,7 +1,7 @@ # # spec file for package perl-SQL-Abstract # -# Copyright (c) 2013 SUSE LINUX Products GmbH, Nuernberg, Germany. +# Copyright (c) 2014 SUSE LINUX Products GmbH, Nuernberg, Germany. # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed @@ -17,7 +17,7 @@ Name: perl-SQL-Abstract -Version:1.74 +Version:1.77 Release:0 %define cpan_name SQL-Abstract Summary:Generate SQL from Perl data structures @@ -36,20 +36,6 @@ BuildRequires: perl(Test::Exception) BuildRequires: perl(Test::More) >= 0.92 BuildRequires: perl(Test::Warn) -#BuildRequires: perl(CPANPLUS::Backend) -#BuildRequires: perl(DBIx::Class::Storage::Debug::PrettyPrint) -#BuildRequires: perl(DBIx::Class::Storage::Statistics) -#BuildRequires: perl(inc::Module::Install) >= 1.06 -#BuildRequires: perl(JSON) -#BuildRequires: perl(LWP::Simple) -#BuildRequires: perl(Module::AutoInstall) -#BuildRequires: perl(Module::Build) -#BuildRequires: perl(Module::Install::Base) -#BuildRequires: perl(Parse::CPAN::Meta) -#BuildRequires: perl(SQL::Abstract) -#BuildRequires: perl(SQL::Abstract::Test) -#BuildRequires: perl(SQL::Abstract::Tree) -#BuildRequires: perl(YAML::Tiny) Requires: perl(Class::Accessor::Grouped) >= 0.10005 Requires: perl(Getopt::Long::Descriptive) >= 0.091 Requires: perl(Hash::Merge) >= 0.12 ++ SQL-Abstract-1.74.tar.gz -> SQL-Abstract-1.77.tar.gz ++ 2361 lines of diff (skipped) -- To unsubscribe, e-mail: opensuse-commit+unsubscr...@opensuse.org For additional commands, e-mail: opensuse-commit+h...@opensuse.org
commit perl-SQL-Abstract for openSUSE:Factory
Hello community, here is the log from the commit of package perl-SQL-Abstract for openSUSE:Factory checked in at 2013-07-30 14:04:22 Comparing /work/SRC/openSUSE:Factory/perl-SQL-Abstract (Old) and /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new (New) Package is "perl-SQL-Abstract" Changes: --- /work/SRC/openSUSE:Factory/perl-SQL-Abstract/perl-SQL-Abstract.changes 2013-06-06 13:27:46.0 +0200 +++ /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new/perl-SQL-Abstract.changes 2013-07-30 14:04:23.0 +0200 @@ -1,0 +2,9 @@ +Sat Jul 27 11:58:57 UTC 2013 - co...@suse.com + +- updated to 1.74 +- Fix insufficient parenthesis unroll during operator comparison +- 'ORDER BY foo' and 'ORDER BY foo ASC' are now considered equal + by default (with a switch to reenable old behavior when necessary) +- Change parser to not eagerly slurp RHS expressions it doesn't recognize + +--- Old: SQL-Abstract-1.73.tar.gz New: SQL-Abstract-1.74.tar.gz Other differences: -- ++ perl-SQL-Abstract.spec ++ --- /var/tmp/diff_new_pack.0HRWR5/_old 2013-07-30 14:04:24.0 +0200 +++ /var/tmp/diff_new_pack.0HRWR5/_new 2013-07-30 14:04:24.0 +0200 @@ -17,14 +17,14 @@ Name: perl-SQL-Abstract -Version:1.73 +Version:1.74 Release:0 %define cpan_name SQL-Abstract Summary:Generate SQL from Perl data structures License:Artistic-1.0 or GPL-1.0+ Group: Development/Libraries/Perl Url:http://search.cpan.org/dist/SQL-Abstract/ -Source: http://www.cpan.org/authors/id/F/FR/FREW/%{cpan_name}-%{version}.tar.gz +Source: http://www.cpan.org/authors/id/R/RI/RIBASUSHI/%{cpan_name}-%{version}.tar.gz BuildArch: noarch BuildRoot: %{_tmppath}/%{name}-%{version}-build BuildRequires: perl @@ -32,6 +32,7 @@ BuildRequires: perl(Class::Accessor::Grouped) >= 0.10005 BuildRequires: perl(Getopt::Long::Descriptive) >= 0.091 BuildRequires: perl(Hash::Merge) >= 0.12 +BuildRequires: perl(Test::Deep) >= 0.101 BuildRequires: perl(Test::Exception) BuildRequires: perl(Test::More) >= 0.92 BuildRequires: perl(Test::Warn) ++ SQL-Abstract-1.73.tar.gz -> SQL-Abstract-1.74.tar.gz ++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.73/Changes new/SQL-Abstract-1.74/Changes --- old/SQL-Abstract-1.73/Changes 2012-07-10 23:19:39.0 +0200 +++ new/SQL-Abstract-1.74/Changes 2013-06-05 15:25:39.0 +0200 @@ -1,5 +1,12 @@ Revision history for SQL::Abstract +revision 1.74 2013-06-04 + +- Fix insufficient parenthesis unroll during operator comparison +- 'ORDER BY foo' and 'ORDER BY foo ASC' are now considered equal + by default (with a switch to reenable old behavior when necessary) +- Change parser to not eagerly slurp RHS expressions it doesn't recognize + revision 1.73 2012-07-10 - Fix parsing of ORDER BY foo + ? diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.73/MANIFEST new/SQL-Abstract-1.74/MANIFEST --- old/SQL-Abstract-1.73/MANIFEST 2012-07-10 23:22:19.0 +0200 +++ new/SQL-Abstract-1.74/MANIFEST 2013-06-05 15:25:54.0 +0200 @@ -42,7 +42,6 @@ t/20injection_guard.t t/21op_ident.t t/22op_value.t -t/23reassembly-bugs.t t/90pod.t t/91podcoverage.t t/dbic/bulk-insert.t diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.73/META.yml new/SQL-Abstract-1.74/META.yml --- old/SQL-Abstract-1.73/META.yml 2012-07-10 23:22:17.0 +0200 +++ new/SQL-Abstract-1.74/META.yml 2013-06-05 15:25:52.0 +0200 @@ -5,13 +5,14 @@ build_requires: ExtUtils::MakeMaker: 6.59 Storable: 0 + Test::Deep: 0.101 Test::Exception: 0 Test::More: 0.92 Test::Warn: 0 configure_requires: ExtUtils::MakeMaker: 6.59 distribution_type: module -dynamic_config: 1 +dynamic_config: 0 generated_by: 'Module::Install version 1.06' license: perl meta-spec: @@ -36,4 +37,4 @@ bugtracker: http://rt.cpan.org/NoAuth/Bugs.html?Dist=SQL-Abstract license: http://dev.perl.org/licenses/ repository: git://git.shadowcat.co.uk/dbsrgits/SQL-Abstract.git -version: 1.73 +version: 1.74 diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-Abstract-1.73/Makefile.PL new/SQL-Abstract-1.74/Makefile.PL --- old/SQL-Abstract-1.73/Makefile.PL 2012-06-15 03:07:59.0 +0200 +++ new/SQL-Abstract-1.74/Makefile.PL 2013-06-05 15:25:39.
commit perl-SQL-Abstract for openSUSE:Factory
Hello community, here is the log from the commit of package perl-SQL-Abstract for openSUSE:Factory checked in at 2013-06-06 13:27:44 Comparing /work/SRC/openSUSE:Factory/perl-SQL-Abstract (Old) and /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new (New) Package is "perl-SQL-Abstract" Changes: --- /work/SRC/openSUSE:Factory/perl-SQL-Abstract/perl-SQL-Abstract.changes 2012-01-26 14:07:08.0 +0100 +++ /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new/perl-SQL-Abstract.changes 2013-06-06 13:27:46.0 +0200 @@ -1,0 +2,15 @@ +Tue Jun 4 17:21:42 UTC 2013 - co...@suse.com + +- updated to 1.73 +- Fix parsing of ORDER BY foo + ? +- Stop filling in placeholders in `format-sql` since it does not support + passing values for them anyway +- Fix parsing of NOT EXISTS +- Fix over-eager parenthesis unrolling +- Fix deep recursion warnings while parsing obnoxiously long sql statements +- Fix incorrect comparison of malformed lists +- Fix incorrect reporting of mismatch-members in SQLA::Test +- Migrate the -ident operator from DBIC into SQLA +- Migrate the -value operator from DBIC into SQLA + +--- Old: SQL-Abstract-1.72.tar.gz New: SQL-Abstract-1.73.tar.gz Other differences: -- ++ perl-SQL-Abstract.spec ++ --- /var/tmp/diff_new_pack.265d8d/_old 2013-06-06 13:27:47.0 +0200 +++ /var/tmp/diff_new_pack.265d8d/_new 2013-06-06 13:27:47.0 +0200 @@ -1,7 +1,7 @@ # # spec file for package perl-SQL-Abstract # -# Copyright (c) 2012 SUSE LINUX Products GmbH, Nuernberg, Germany. +# Copyright (c) 2013 SUSE LINUX Products GmbH, Nuernberg, Germany. # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed @@ -17,31 +17,41 @@ Name: perl-SQL-Abstract -Version:1.72 +Version:1.73 Release:0 %define cpan_name SQL-Abstract Summary:Generate SQL from Perl data structures -License:GPL-1.0+ or Artistic-1.0 +License:Artistic-1.0 or GPL-1.0+ Group: Development/Libraries/Perl Url:http://search.cpan.org/dist/SQL-Abstract/ -Source: http://www.cpan.org/authors/id/F/FR/FREW/SQL-Abstract-%{version}.tar.gz +Source: http://www.cpan.org/authors/id/F/FR/FREW/%{cpan_name}-%{version}.tar.gz BuildArch: noarch BuildRoot: %{_tmppath}/%{name}-%{version}-build BuildRequires: perl BuildRequires: perl-macros -BuildRequires: perl(Class::Accessor::Grouped) >= 0.10002 -BuildRequires: perl(Getopt::Long::Descriptive) >= 0.086 +BuildRequires: perl(Class::Accessor::Grouped) >= 0.10005 +BuildRequires: perl(Getopt::Long::Descriptive) >= 0.091 BuildRequires: perl(Hash::Merge) >= 0.12 -BuildRequires: perl(List::Util) -BuildRequires: perl(Scalar::Util) -BuildRequires: perl(Test::Deep) >= 0.106 BuildRequires: perl(Test::Exception) +BuildRequires: perl(Test::More) >= 0.92 BuildRequires: perl(Test::Warn) -Requires: perl(Class::Accessor::Grouped) >= 0.10002 -Requires: perl(Getopt::Long::Descriptive) >= 0.086 +#BuildRequires: perl(CPANPLUS::Backend) +#BuildRequires: perl(DBIx::Class::Storage::Debug::PrettyPrint) +#BuildRequires: perl(DBIx::Class::Storage::Statistics) +#BuildRequires: perl(inc::Module::Install) >= 1.06 +#BuildRequires: perl(JSON) +#BuildRequires: perl(LWP::Simple) +#BuildRequires: perl(Module::AutoInstall) +#BuildRequires: perl(Module::Build) +#BuildRequires: perl(Module::Install::Base) +#BuildRequires: perl(Parse::CPAN::Meta) +#BuildRequires: perl(SQL::Abstract) +#BuildRequires: perl(SQL::Abstract::Test) +#BuildRequires: perl(SQL::Abstract::Tree) +#BuildRequires: perl(YAML::Tiny) +Requires: perl(Class::Accessor::Grouped) >= 0.10005 +Requires: perl(Getopt::Long::Descriptive) >= 0.091 Requires: perl(Hash::Merge) >= 0.12 -Requires: perl(List::Util) -Requires: perl(Scalar::Util) %{perl_requires} %description @@ -59,8 +69,37 @@ it. The big advantage is that you don't have to modify your code every time your data changes, as this module figures it out. +To begin with, an SQL INSERT is as easy as just specifying a hash of +'key=value' pairs: + +my %data = ( +name => 'Jimbo Bobson', +phone => '123-456-7890', +address => '42 Sister Lane', +city => 'St. Louis', +state => 'Louisiana', +); + +The SQL can then be generated with this: + +my($stmt, @bind) = $sql->insert('people', \%data); + +Which would give you something like this: + +$stmt = "INSERT INTO people +(address, city, name, phone, state) +
commit perl-SQL-Abstract for openSUSE:Factory
Hello community, here is the log from the commit of package perl-SQL-Abstract for openSUSE:Factory checked in at 2012-01-26 14:07:06 Comparing /work/SRC/openSUSE:Factory/perl-SQL-Abstract (Old) and /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new (New) Package is "perl-SQL-Abstract", Maintainer is "" Changes: New Changes file: --- /dev/null 2010-08-26 16:28:41.0 +0200 +++ /work/SRC/openSUSE:Factory/.perl-SQL-Abstract.new/perl-SQL-Abstract.changes 2012-01-26 14:07:08.0 +0100 @@ -0,0 +1,30 @@ +--- +Thu Mar 31 08:30:28 UTC 2011 - co...@novell.com + +- update to 1.72 + * lots of changes, see Changes + +--- +Wed Dec 1 10:23:00 UTC 2010 - co...@novell.com + +- switch to perl_requires macro + +--- +Fri Dec 11 14:47:44 UTC 2009 - ch...@computersalat.de + +- update to version 1.60 + * lot of changes, see Changes +- cleanup spec + * added header + * sorted Tags + * fixed build-/deps + * added author + * moved changelog to .changes +- added perl-macros + * perl_gen_filelist + +--- +Sun Oct 26 08:12:19 CET 2008 - gerrit.be...@gmx.de + +- first release 1.24 + New: SQL-Abstract-1.72.tar.gz perl-SQL-Abstract.changes perl-SQL-Abstract.spec Other differences: -- ++ perl-SQL-Abstract.spec ++ # # spec file for package perl-SQL-Abstract # # Copyright (c) 2012 SUSE LINUX Products GmbH, Nuernberg, Germany. # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed # upon. The license for this file, and modifications and additions to the # file, is the same license as for the pristine package itself (unless the # license for the pristine package is not an Open Source License, in which # case the license is the MIT License). An "Open Source License" is a # license that conforms to the Open Source Definition (Version 1.9) # published by the Open Source Initiative. # Please submit bugfixes or comments via http://bugs.opensuse.org/ # Name: perl-SQL-Abstract Version:1.72 Release:0 %define cpan_name SQL-Abstract Summary:Generate SQL from Perl data structures License:GPL-1.0+ or Artistic-1.0 Group: Development/Libraries/Perl Url:http://search.cpan.org/dist/SQL-Abstract/ Source: http://www.cpan.org/authors/id/F/FR/FREW/SQL-Abstract-%{version}.tar.gz BuildArch: noarch BuildRoot: %{_tmppath}/%{name}-%{version}-build BuildRequires: perl BuildRequires: perl-macros BuildRequires: perl(Class::Accessor::Grouped) >= 0.10002 BuildRequires: perl(Getopt::Long::Descriptive) >= 0.086 BuildRequires: perl(Hash::Merge) >= 0.12 BuildRequires: perl(List::Util) BuildRequires: perl(Scalar::Util) BuildRequires: perl(Test::Deep) >= 0.106 BuildRequires: perl(Test::Exception) BuildRequires: perl(Test::Warn) Requires: perl(Class::Accessor::Grouped) >= 0.10002 Requires: perl(Getopt::Long::Descriptive) >= 0.086 Requires: perl(Hash::Merge) >= 0.12 Requires: perl(List::Util) Requires: perl(Scalar::Util) %{perl_requires} %description This module was inspired by the excellent the DBIx::Abstract manpage. However, in using that module I found that what I really wanted to do was generate SQL, but still retain complete control over my statement handles and use the DBI interface. So, I set out to create an abstract SQL generation module. While based on the concepts used by the DBIx::Abstract manpage, there are several important differences, especially when it comes to WHERE clauses. I have modified the concepts used to make the SQL easier to generate from Perl data structures and, IMO, more intuitive. The underlying idea is for this module to do what you mean, based on the data structures you provide it. The big advantage is that you don't have to modify your code every time your data changes, as this module figures it out. %prep %setup -q -n %{cpan_name}-%{version} %build %{__perl} Makefile.PL INSTALLDIRS=vendor %{__make} %{?_smp_mflags} %check %{__make} test %install %perl_make_install %perl_process_packlist %perl_gen_filelist %files -f %{name}.files %defattr(644,root,root,755) %doc Changes %changelog -- To unsubscribe, e-mail: opensuse-commit+unsubscr...@opensuse.org For additional commands, e-mail: opensuse-commit+h...@opensuse.org