notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
Port details
p5-SQL-SplitStatement Split any SQL code into atomic statements
1.00023 databases on this many watch lists=2 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout Package not present on quarterly.This port was created during this quarter. It will be in the next quarterly branch but not the current one.
Maintainer: sunpoet@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2024-07-18 16:51:09
Last Update: 2024-07-18 16:44:41
Commit Hash: 7fc5c97
People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py39-PyOpenGL, p5-Sane
Also Listed In: perl5
License: ART10 GPLv1+
WWW:
https://metacpan.org/dist/SQL-SplitStatement
Description:
SQL::SplitStatement is a simple module which tries to split any SQL code, even including non-standard extensions, 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 DELIMITERs, 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.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (13 items)
Collapse this list.
  1. /usr/local/share/licenses/p5-SQL-SplitStatement-1.00023/catalog.mk
  2. /usr/local/share/licenses/p5-SQL-SplitStatement-1.00023/LICENSE
  3. /usr/local/share/licenses/p5-SQL-SplitStatement-1.00023/ART10
  4. /usr/local/share/licenses/p5-SQL-SplitStatement-1.00023/GPLv1+
  5. bin/sql-split
  6. lib/perl5/site_perl/SQL/SplitStatement.pm
  7. lib/perl5/site_perl/SQL/SplitStatement/Tokenizer.pm
  8. lib/perl5/site_perl/man/man1/sql-split.1.gz
  9. lib/perl5/site_perl/man/man3/SQL::SplitStatement.3.gz
  10. lib/perl5/site_perl/man/man3/SQL::SplitStatement::Tokenizer.3.gz
  11. @owner
  12. @group
  13. @mode
Collapse this list.
Dependency lines:
  • p5-SQL-SplitStatement>0:databases/p5-SQL-SplitStatement
To install the port:
cd /usr/ports/databases/p5-SQL-SplitStatement/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/p5-SQL-SplitStatement
  • pkg install p5-SQL-SplitStatement
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: p5-SQL-SplitStatement
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1721280200 SHA256 (SQL-SplitStatement-1.00023.tar.gz) = 1a748420cd2ad341c2524ef1185b76ef7172969f17a9e4bab6f4376f0de9f35e SIZE (SQL-SplitStatement-1.00023.tar.gz) = 63709

Packages (timestamps in pop-ups are UTC):
p5-SQL-SplitStatement
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest1.000231.00023-1.000231.00023---
FreeBSD:13:quarterly-1.00023--1.00023---
FreeBSD:14:latest1.000231.00023-1.000231.00023---
FreeBSD:14:quarterly-1.00023--1.00023---
FreeBSD:15:latest1.000231.00023n/a1.00023n/a---
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. p5-Class-Accessor>=0 : devel/p5-Class-Accessor
  2. p5-List-MoreUtils>=0 : lang/p5-List-MoreUtils
  3. p5-Regexp-Common>=0 : textproc/p5-Regexp-Common
  4. perl5>=5.36<5.37 : lang/perl5.36
  5. perl5>=5.36<5.37 : lang/perl5.36
Test dependencies:
  1. p5-Test-Differences>=0.680 : devel/p5-Test-Differences
  2. p5-Test-Exception>=0.27 : devel/p5-Test-Exception
Runtime dependencies:
  1. p5-Class-Accessor>=0 : devel/p5-Class-Accessor
  2. p5-List-MoreUtils>=0 : lang/p5-List-MoreUtils
  3. p5-Regexp-Common>=0 : textproc/p5-Regexp-Common
  4. perl5>=5.36<5.37 : lang/perl5.36
This port is required by:
for Build
  1. databases/p5-DBIx-Class-DeploymentHandler
for Run
  1. databases/p5-DBIx-Class-DeploymentHandler

Configuration Options:
No options to configure
Options name:
databases_p5-SQL-SplitStatement
USES:
perl5
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (12 items)
Collapse this list.
  1. ftp://ftp.auckland.ac.nz/pub/perl/CPAN/modules/by-module/SQL/
  2. ftp://ftp.cpan.org/pub/CPAN/modules/by-module/
  3. ftp://ftp.cpan.org/pub/CPAN/modules/by-module/SQL/
  4. ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module/SQL/
  5. ftp://ftp.kddlabs.co.jp/lang/perl/CPAN/modules/by-module/SQL/
  6. ftp://ftp.mirrorservice.org/sites/cpan.perl.org/CPAN/modules/by-module/SQL/
  7. http://backpan.perl.org/modules/by-module/SQL/
  8. http://ftp.jaist.ac.jp/pub/CPAN/modules/by-module/SQL/
  9. http://ftp.twaren.net/Unix/Lang/CPAN/modules/by-module/SQL/
  10. https://cpan.metacpan.org/modules/by-module/
  11. https://cpan.metacpan.org/modules/by-module/SQL/
  12. https://www.cpan.org/modules/by-module/SQL/
Collapse this list.

Number of commits found: 1

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
1.00023
18 Jul 2024 16:44:41
commit hash: 7fc5c9713a63e0ab4da05ae240d1c2baebd73f96commit hash: 7fc5c9713a63e0ab4da05ae240d1c2baebd73f96commit hash: 7fc5c9713a63e0ab4da05ae240d1c2baebd73f96commit hash: 7fc5c9713a63e0ab4da05ae240d1c2baebd73f96 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
databases/p5-SQL-SplitStatement: Add p5-SQL-SplitStatement 1.00023

SQL::SplitStatement is a simple module which tries to split any SQL code, even
including non-standard extensions, 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 DELIMITERs, 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.

Number of commits found: 1