- update to 1.33

[Bug fixes]
* Move test dependencies to (unreleased) Bundle::Test::SQL::Statement
  to avoid circular dependencies
* Fixed invalid check for escaped single quotes
* Fixed unpermitted modification of array source for table creation
  (CREATE TABLE AS IMPORT(?),[[..],[..]])
* Fixing alias used in ORDER BY (RT#61384, thanks jvm)
* Fixing ORDER BY behavior for multiple sort columns
  (slower, but guaranteed correct)
[Improvements]
* renamed fetch-method into fetch_row (keep fetch() as alias) and
  add a fetch_rows() to fetch all rows at once
* Different accessors for direction of ORDER BY clause query part
  and it's boolean equivalent "desc" (0 or 1, respectively)
* Add a lot of Pure-Perl DBD's as build dependency for testing
  (skip DBD::AnyData for now, because it seems to be broken - check
  for next release)
[Misc]
* Bump requirement of DBI to 1.616
* switch for fully external DBD tests from DBD::XBase to DBD::SQLite
* Document another limitation (lacking implicit creating temp table
  during processing a query using the same table with different aliases
  twice)

OBS-URL: https://build.opensuse.org/package/show/devel:languages:perl/perl-SQL-Statement?expand=0&rev=22

SQL-Statement-1.31.tar.bz2

@@ -1,3 +0,0 @@
-version https://git-lfs.github.com/spec/v1
-oid sha256:be5c9766508ff30cc30510701da38fb715531268c12c0148a0d37bbd2110bbb2
-size 98416

SQL-Statement-1.33.tar.gz

@@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:a71c6fdbc3883b5164232bf441a34cd7c6a6f5a8753c3d12e50396b1e83c0e96
+size 123572

perl-SQL-Statement.changes

@@ -1,3 +1,33 @@
+-------------------------------------------------------------------
+Thu Mar 31 12:07:05 UTC 2011 - coolo@novell.com
+
+- update to 1.33
+[Bug fixes]
+* Move test dependencies to (unreleased) Bundle::Test::SQL::Statement
+  to avoid circular dependencies
+* Fixed invalid check for escaped single quotes
+* Fixed unpermitted modification of array source for table creation
+  (CREATE TABLE AS IMPORT(?),[[..],[..]])
+* Fixing alias used in ORDER BY (RT#61384, thanks jvm)
+* Fixing ORDER BY behavior for multiple sort columns
+  (slower, but guaranteed correct)
+
+[Improvements]
+* renamed fetch-method into fetch_row (keep fetch() as alias) and
+  add a fetch_rows() to fetch all rows at once
+* Different accessors for direction of ORDER BY clause query part
+  and it's boolean equivalent "desc" (0 or 1, respectively)
+* Add a lot of Pure-Perl DBD's as build dependency for testing
+  (skip DBD::AnyData for now, because it seems to be broken - check
+  for next release)
+
+[Misc]
+* Bump requirement of DBI to 1.616
+* switch for fully external DBD tests from DBD::XBase to DBD::SQLite
+* Document another limitation (lacking implicit creating temp table
+  during processing a query using the same table with different aliases
+  twice)
+
 -------------------------------------------------------------------
 Wed Dec  1 13:35:18 UTC 2010 - coolo@novell.com
 

perl-SQL-Statement.spec

@@ -1,5 +1,5 @@
 #
-# spec file for package perl-SQL-Statement (Version 1.31)
+# spec file for package perl-SQL-Statement (Version 1.33)
 #
 # Copyright (c) 2010 SUSE LINUX Products GmbH, Nuernberg, Germany.
 #
@@ -15,51 +15,31 @@
 # Please submit bugfixes or comments via http://bugs.opensuse.org/
 #
 
-# norootforbuild
-
-%bcond_with opt
-
 Name:           perl-SQL-Statement
-%define cpan_name SQL-Statement
+Version:        1.33
-Summary:        SQL parsing and processing engine
-Version:        1.31
 Release:        1
 License:        GPL+ or Artistic
-Group:          Development/Libraries/Perl
+%define cpan_name SQL-Statement
+Summary:        SQL parsing and processing engine
 Url:            http://search.cpan.org/dist/SQL-Statement/
-#Source:         http://www.cpan.org/modules/by-module/SQL/SQL-Statement-%{version}.tar.gz
+Group:          Development/Libraries/Perl
-Source:         %{cpan_name}-%{version}.tar.bz2
+#Source:         http://www.cpan.org/authors/id/R/RE/REHSACK/SQL-Statement-%{version}.tar.gz
+Source:         %{cpan_name}-%{version}.tar.gz
 BuildArch:      noarch
 BuildRoot:      %{_tmppath}/%{name}-%{version}-build
-%{perl_requires}
 BuildRequires:  perl
 BuildRequires:  perl-macros
 BuildRequires:  perl(Carp)
 BuildRequires:  perl(Clone) >= 0.30
 BuildRequires:  perl(Data::Dumper)
-# means perl-DBI >= 1.612
-BuildRequires:  perl(DBD::File) >= 0.39
-BuildRequires:  perl(DBI::DBD::SqlEngine) >= 0.01
 BuildRequires:  perl(Params::Util) >= 1.00
 BuildRequires:  perl(Scalar::Util) >= 1.0
-BuildRequires:  perl(Test::Simple) >= 0.90
-# optional for build
-%if %{with opt}
-BuildRequires:  perl(Test::Pod) >= 1.00
-BuildRequires:  perl(Test::Pod::Coverage) >= 1.00
-BuildRequires:  perl(DBD::CSV)
-%endif
-#
 Requires:       perl(Carp)
 Requires:       perl(Clone) >= 0.30
 Requires:       perl(Data::Dumper)
 Requires:       perl(Params::Util) >= 1.00
 Requires:       perl(Scalar::Util) >= 1.0
-#
+%{perl_requires}
-Recommends:     perl(DBD::CSV)
-# means perl-DBI >= 1.612
-Recommends:     perl(DBD::File) >= 0.39
-Recommends:     perl(DBI::DBD::SqlEngine) >= 0.01
 
 %description
 The SQL::Statement module implements a pure Perl SQL parsing and execution
@@ -68,20 +48,20 @@ many features including column and table aliases, built-in and user-defined
 functions, implicit and explicit joins, complex nested search conditions,
 and other features.
 
-Authors:
+SQL::Statement is a small embeddable Database Management System (DBMS).
---------
+This means that it provides all of the services of a simple DBMS except
-    Jochen Wiedmann (original module as an XS (C) extension in 1998)
+that instead of a persistent storage mechanism, it has two things: 1) an
-    Jeff Zucker (since 2001)
+in-memory storage mechanism that allows you to prepare, execute, and fetch
-    Jens Rehsack (since 2008) <rehsackATcpan.org>
+from SQL statements using temporary tables and 2) a set of software sockets
+where any author can plug in any storage mechanism.
+
+There are three main uses for SQL::Statement. One or another (hopefully not
+all) may be irrelevant for your needs: 1) to access and manipulate data in
+CSV, XML, and other formats 2) to build your own DBD for a new data source
+3) to parse and examine the structure of SQL statements.
 
 %prep
 %setup -q -n %{cpan_name}-%{version}
-# rpmlint wrong-file-end-of-line-encoding
-%{__perl} -p -i -e "s|\r\n|\n|" README
-# rpmlint: spurious-executable-perm
-%{__chmod} a-x Changes README
-# rpmlint: script-without-shebang
-find -name "*.pm" -exec %{__chmod} 0644 {} \;
 
 %build
 %{__perl} Makefile.PL INSTALLDIRS=vendor
@@ -92,18 +72,14 @@ find -name "*.pm" -exec %{__chmod} 0644 {} \;
 
 %install
 %perl_make_install
-# do not perl_process_packlist (noarch)
+%perl_process_packlist
-# remove .packlist file
-%{__rm} -rf $RPM_BUILD_ROOT%perl_vendorarch
-# remove perllocal.pod file
-%{__rm} -rf $RPM_BUILD_ROOT%perl_archlib
 %perl_gen_filelist
 
 %clean
-%{__rm} -rf $RPM_BUILD_ROOT
+%{__rm} -rf %{buildroot}
 
 %files -f %{name}.files
-%defattr(-,root,root,-)
+%defattr(644,root,root,755)
-%doc Changes README
+%doc Changes README xt
 
 %changelog