SEARCH
NEW RPMS
DIRECTORIES
ABOUT
FAQ
VARIOUS
BLOG
DONATE


YUM REPOSITORY

 
 

perl-SQL-SplitStatement rpm build for : openSUSE Tumbleweed. For other distributions click perl-SQL-SplitStatement.

Name : perl-SQL-SplitStatement
Version : 1.00020 Vendor : obs://build_opensuse_org/devel:languages:perl
Release : 5.22 Date : 2018-11-30 15:33:53
Group : Development/Libraries/Perl Source RPM : perl-SQL-SplitStatement-1.00020-5.22.src.rpm
Size : 0.10 MB
Packager : (none)
Summary : Split any SQL code into atomic statements
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.

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 the /SYNOPSIS manpage 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.

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

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.

RPM found in directory: /mirror/ftp5.gwdg.de/pub/opensuse/repositories/devel:/languages:/perl/openSUSE_Tumbleweed/noarch

Content of RPM  Changelog  Provides Requires

Download
ftp.pbone.net  perl-SQL-SplitStatement-1.00020-5.22.noarch.rpm
     

Provides :
perl(SQL::SplitStatement)
perl-SQL-SplitStatement

Requires :
/usr/bin/env
perl(:MODULE_COMPAT_5.28.1)
perl(Class::Accessor::Fast)
perl(List::MoreUtils)
perl(Regexp::Common)
perl(SQL::Tokenizer) >= 0.22
rpmlib(CompressedFileNames) <= 3.0.4-1
rpmlib(FileDigests) <= 4.6.0-1
rpmlib(PayloadFilesHavePrefix) <= 4.0-1
rpmlib(PayloadIsXz) <= 5.2-1


Content of RPM :
/usr/bin/sql-split
/usr/lib/perl5/vendor_perl/5.28.1/SQL
/usr/lib/perl5/vendor_perl/5.28.1/SQL/SplitStatement.pm
/usr/share/doc/packages/perl-SQL-SplitStatement
/usr/share/doc/packages/perl-SQL-SplitStatement/Changes
/usr/share/doc/packages/perl-SQL-SplitStatement/LICENSE
/usr/share/doc/packages/perl-SQL-SplitStatement/README
/usr/share/man/man1/sql-split.1.gz
/usr/share/man/man3/SQL::SplitStatement.3pm.gz