kodus / sql-splitter
A simple facility to split SQL files into individual queries - supports MySQL, PostgreSQL and Microsoft SQL Server
Installs: 20 904
Dependents: 0
Suggesters: 0
Security: 0
Stars: 2
Watchers: 1
Forks: 5
Open Issues: 2
Requires
- php: ^7.0
Requires (Dev)
- mindplay/testies: ^0.3.0
This package is auto-updated.
Last update: 2021-03-15 20:43:27 UTC
README
A simple parser to split SQL (and/or DDL) files into individual SQL queries.
This is an unofficial PHP port of SQL-Statement-Parser by TeamSQL.
Install via Composer
composer require kodus/sql-splitter
Features
Supported SQL File Formats:
- MySQL
- PostgreSQL
- Microsoft SQL Server
Specifically with support for the following SQL/DDL features:
- SQL and DDL Queries
- Stored procedures, functions, views, etc.
- PostgreSQL's dollar-tags (e.g.
$$
and$mytag$
, etc.) - MySQL's
DELIMITER
Usage
Pick one of the platform-specific methods:
$statements = SQLSplitter::splitMySQL(file_get_contents(...)); $statements = SQLSplitter::splitMSSQL(file_get_contents(...)); $statements = SQLSplitter::splitPostgreSQL(file_get_contents(...));
Or dynamically pick one based on the PDO driver-name:
$driver = $pdo->getAttribute(PDO::ATTR_DRIVER_NAME); $statements = SQLSplitter::split($driver, file_get_contents(...));
Driver-names are also available as SQLSplitter
class-constants, e.g. DB_MYSQL
, DB_MSSQL
and DB_PGSQL
.