forked from pool/perl-SQL-SplitStatement
Accepting request 898663 from devel:languages:perl:autoupdate
- updated to 1.00023
see /usr/share/doc/packages/perl-SQL-SplitStatement/Changes
1.00023 2021-06-05 22:10:21 IDT
1.00022 2021-06-05 21:53:11 IDT (TRIAL RELEASE)
* support REPLACE as an INSERT alternative (gh #5)
* allow { and } to pass through in PL/Perl functions (gh #2)
1.00021 2021-06-04 15:21:30 IDT (TRIAL RELEASE)
* fix POD issues
* fix issues with options in bin/sql-split (breaking, but wasn't working anyways)
OBS-URL: https://build.opensuse.org/request/show/898663
OBS-URL: https://build.opensuse.org/package/show/devel:languages:perl/perl-SQL-SplitStatement?expand=0&rev=5
This commit is contained in:
Andrey Karepin
committed by
Git OBS Bridge
Git OBS Bridge
parent
fe8abcef07
commit
d5afaf26b6
@@ -1,7 +1,7 @@
|
||||
#
|
||||
# spec file for package perl-SQL-SplitStatement
|
||||
#
|
||||
# Copyright (c) 2015 SUSE LINUX GmbH, Nuernberg, Germany.
|
||||
# Copyright (c) 2021 SUSE LLC
|
||||
#
|
||||
# All modifications and additions to the file contributed by third parties
|
||||
# remain the property of their copyright owners, unless otherwise agreed
|
||||
@@ -12,39 +12,37 @@
|
||||
# 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-SplitStatement
|
||||
Version: 1.00020
|
||||
Release: 0
|
||||
%define cpan_name SQL-SplitStatement
|
||||
Name: perl-SQL-SplitStatement
|
||||
Version: 1.00023
|
||||
Release: 0
|
||||
Summary: Split any SQL code into atomic statements
|
||||
License: Artistic-1.0 or GPL-1.0+
|
||||
Group: Development/Libraries/Perl
|
||||
Url: http://search.cpan.org/dist/SQL-SplitStatement/
|
||||
Source: http://www.cpan.org/authors/id/E/EM/EMAZEP/%{cpan_name}-%{version}.tar.gz
|
||||
License: Artistic-1.0 OR GPL-1.0-or-later
|
||||
URL: https://metacpan.org/release/%{cpan_name}
|
||||
Source0: https://cpan.metacpan.org/authors/id/V/VE/VEESH/%{cpan_name}-%{version}.tar.gz
|
||||
Source1: cpanspec.yml
|
||||
BuildArch: noarch
|
||||
BuildRoot: %{_tmppath}/%{name}-%{version}-build
|
||||
BuildRequires: perl
|
||||
BuildRequires: perl-macros
|
||||
BuildRequires: perl(Class::Accessor::Fast)
|
||||
BuildRequires: perl(List::MoreUtils)
|
||||
BuildRequires: perl(Regexp::Common)
|
||||
BuildRequires: perl(SQL::Tokenizer) >= 0.22
|
||||
BuildRequires: perl(Test::Exception) >= 0.27
|
||||
BuildRequires: perl(Test::Differences) >= 0.68
|
||||
BuildRequires: perl(Test::Exception) >= 0.270000
|
||||
BuildRequires: perl(Test::More) >= 0.7
|
||||
Requires: perl(Class::Accessor::Fast)
|
||||
Requires: perl(List::MoreUtils)
|
||||
Requires: perl(Regexp::Common)
|
||||
Requires: perl(SQL::Tokenizer) >= 0.22
|
||||
%{perl_requires}
|
||||
|
||||
%description
|
||||
This is a simple module which tries to split any SQL code, even including
|
||||
non-standard extensions (for the details see the the /SUPPORTED DBMSs
|
||||
manpage section below), into the atomic statements it is composed of.
|
||||
non-standard extensions (for the details see the SUPPORTED DBMSs section
|
||||
below), into the atomic statements it is composed of.
|
||||
|
||||
The logic used to split the SQL code is more sophisticated than a raw
|
||||
'split' on the ';' (semicolon) character: first, various different
|
||||
@@ -52,34 +50,34 @@ statement terminator _tokens_ are recognized (see below for the list), then
|
||||
this module is able to correctly handle the presence of said tokens inside
|
||||
identifiers, values, comments, 'BEGIN ... END' blocks (even nested),
|
||||
_dollar-quoted_ strings, MySQL custom 'DELIMITER's, procedural code etc.,
|
||||
as (partially) exemplified in the the /SYNOPSIS manpage above.
|
||||
as (partially) exemplified in the SYNOPSIS above.
|
||||
|
||||
Consider however that this is by no means a validating parser (technically
|
||||
speaking, it's just a _context-sensitive tokenizer_). It should rather be
|
||||
seen as an in-progress _heuristic_ approach, which will gradually improve
|
||||
as test cases will be reported. This also means that, except for the the
|
||||
/LIMITATIONS manpage detailed below, there is no known (to the author) SQL
|
||||
code the most current release of this module can't correctly split.
|
||||
as test cases will be reported. This also means that, except for the
|
||||
LIMITATIONS detailed below, there is no known (to the author) SQL code the
|
||||
most current release of this module can't correctly split.
|
||||
|
||||
The test suite bundled with the distribution (which now includes the
|
||||
popular _Sakila_ and _Pagila_ sample db schemata, as detailed in the the
|
||||
/SHOWCASE manpage section below) should give you an idea of the
|
||||
capabilities of this module
|
||||
popular _Sakila_ and _Pagila_ sample db schemata, as detailed in the
|
||||
SHOWCASE section below) should give you an idea of the capabilities of this
|
||||
module
|
||||
|
||||
If your atomic statements are to be fed to a DBMS, you are encouraged to
|
||||
use the DBIx::MultiStatementDo manpage instead, which uses this module and
|
||||
also (optionally) offers automatic transactions support, so that you'll
|
||||
have the _all-or-nothing_ behavior you would probably want.
|
||||
use DBIx::MultiStatementDo instead, which uses this module and also
|
||||
(optionally) offers automatic transactions support, so that you'll have the
|
||||
_all-or-nothing_ behavior you would probably want.
|
||||
|
||||
%prep
|
||||
%setup -q -n %{cpan_name}-%{version}
|
||||
%autosetup -n %{cpan_name}-%{version}
|
||||
|
||||
%build
|
||||
%{__perl} Makefile.PL INSTALLDIRS=vendor
|
||||
%{__make} %{?_smp_mflags}
|
||||
perl Makefile.PL INSTALLDIRS=vendor
|
||||
%make_build
|
||||
|
||||
%check
|
||||
%{__make} test
|
||||
make test
|
||||
|
||||
%install
|
||||
%perl_make_install
|
||||
@@ -87,7 +85,7 @@ have the _all-or-nothing_ behavior you would probably want.
|
||||
%perl_gen_filelist
|
||||
|
||||
%files -f %{name}.files
|
||||
%defattr(-,root,root,755)
|
||||
%doc Changes LICENSE README
|
||||
%doc Changes README
|
||||
%license LICENSE
|
||||
|
||||
%changelog
|
||||
|
||||
Reference in New Issue
Block a user