kodus/sql-split

A simple facility to split SQL files into individual queries - supports MySQL and PostgreSQL

2.0.0 2022-08-11 13:50 UTC

This package is auto-updated.

Last update: 2024-10-11 18:26:30 UTC


README

A simple parser to split SQL (and/or DDL) files into individual SQL queries and strip comments.

PHP Version Build Status

Install via Composer

composer require kodus/sql-split

Features

I designed this for use with PDO and MySQL/PostgreSQL statements.

It uses a very simple recursive descent parser to minimally tokenize valid SQL - this approach ensures there is no ambiguity between quoted strings, keywords, comments, etc. but makes no attempt to validate SQL command structure or validity of the extracted statements.

It supports the following SQL/DDL features:

  • SQL and DDL Queries
  • Stored procedures, functions, views, triggers, etc.
  • PostgreSQL dollar-tags ($$ and $mytag$ delimiters)
  • The MySQL DELIMITER command

Usage

Just this:

$statements = Splitter::split(file_get_contents(...));

This will split to individual SQL statements and (by default) strip comments.

Then just loop over your $statements and run them via PDO.

That's all.