File perl-SQL-SplitStatement.spec of Package perl-SQL-SplitStatement

# spec file for package perl-SQL-SplitStatement
# 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
# 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

%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-or-later
URL:  {cpan_name}
Source1:        cpanspec.yml
BuildArch:      noarch
BuildRequires:  perl
BuildRequires:  perl-macros
BuildRequires:  perl(Class::Accessor::Fast)
BuildRequires:  perl(List::MoreUtils)
BuildRequires:  perl(Regexp::Common)
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)

This is a simple module which tries to split any SQL code, even including
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
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 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
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
SHOWCASE section below) should give you an idea of the capabilities of this

If your atomic statements are to be fed to a DBMS, you are encouraged to
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.

%autosetup  -n %{cpan_name}-%{version}

perl Makefile.PL INSTALLDIRS=vendor

make test


%files -f %{name}.files
%doc Changes README
%license LICENSE

openSUSE Build Service is sponsored by