commit perl-SQL-Abstract for openSUSE:Factory

2020-06-03 Thread root
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:
 
@@ 

commit perl-SQL-Abstract for openSUSE:Factory

2018-07-28 Thread root
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

commit perl-SQL-Abstract for openSUSE:Factory

2018-02-02 Thread root
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

2017-04-11 Thread root
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

2017-03-23 Thread root
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 

commit perl-SQL-Abstract for openSUSE:Factory

2014-11-13 Thread h_root
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: 2.00
   perl: 5.6.0
 

commit perl-SQL-Abstract for openSUSE:Factory

2014-09-17 Thread h_root
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
   Test::Warn: 0
 

commit perl-SQL-Abstract for openSUSE:Factory

2014-02-28 Thread h_root
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 function 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

2013-07-30 Thread h_root
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.0 

commit perl-SQL-Abstract for openSUSE:Factory

2013-06-06 Thread h_root
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)
+VALUES (?, ?, ?, 

commit perl-SQL-Abstract for openSUSE:Factory

2012-01-26 Thread h_root
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