Index | index by Group | index by Distribution | index by Vendor | index by creation date | index by Name | Mirrors | Help | Search |
Name: perl-SQL-SplitStatement | Distribution: openSUSE:Factory:zSystems |
Version: 1.00023 | Vendor: openSUSE |
Release: 1.13 | Build date: Sun Jun 6 05:08:46 2021 |
Group: Unspecified | Build host: reproducible |
Size: 111017 | Source RPM: perl-SQL-SplitStatement-1.00023-1.13.src.rpm |
Packager: https://bugs.opensuse.org | |
Url: https://metacpan.org/release/SQL-SplitStatement | |
Summary: Split any SQL code into atomic statements |
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 module 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.
Artistic-1.0 OR GPL-1.0-or-later
* Sun Jun 06 2021 Tina Müller <timueller+perl@suse.de> - 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) * Tue Jan 27 2015 coolo@suse.com - regenerate spec to install LICENSE * Sat Aug 31 2013 egdfree@opensuse.org - add BuildRoot line in spec for correctly compile on SLE * Sun Aug 25 2013 egdfree@opensuse.org - initial
/usr/bin/sql-split /usr/lib/perl5/vendor_perl/5.40.0/SQL /usr/lib/perl5/vendor_perl/5.40.0/SQL/SplitStatement /usr/lib/perl5/vendor_perl/5.40.0/SQL/SplitStatement.pm /usr/lib/perl5/vendor_perl/5.40.0/SQL/SplitStatement/Tokenizer.pm /usr/share/doc/packages/perl-SQL-SplitStatement /usr/share/doc/packages/perl-SQL-SplitStatement/Changes /usr/share/doc/packages/perl-SQL-SplitStatement/README /usr/share/licenses/perl-SQL-SplitStatement /usr/share/licenses/perl-SQL-SplitStatement/LICENSE /usr/share/man/man1/sql-split.1.gz /usr/share/man/man3/SQL::SplitStatement.3pm.gz /usr/share/man/man3/SQL::SplitStatement::Tokenizer.3pm.gz
Generated by rpm2html 1.8.1
Fabrice Bellet, Tue Sep 10 00:47:10 2024