Package : perl-SQL-SplitStatement > RPM : perl-SQL-SplitStatement-1.0.200-3.mga7.noarch.rpm

Basic items

Install
Name perl-SQL-SplitStatement
Version 1.0.200
Release 3.mga7
URL http://search.cpan.org/dist/SQL-SplitStatement
Group Development/Perl
Summary Split any SQL code into atomic statements
Size 108KB
Arch noarch
License GPL+ or Artistic

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.

Media information

Distribution release Mageia 7
Media name core-release
Media arch i586

Advanced items

Source RPM perl-SQL-SplitStatement-1.0.200-3.mga7.src.rpm
Build time 2018-09-19 13:04:49
Changelog View in Sophie
Files View in Sophie
Dependencies View in Sophie