Docs For Class SQLUtils

Description

This is a static class that provides functions for the running of arbitrary SQL strings and files.

Method Summary

void multiQuery (string $queryString, integer $dbIndex)

string parseSQLFile (string $file)

string parseSQLString (string $queryString)

void runSQLdir (string $dir, integer $dbIndex, [optional $extn = 'sql'])

void runSQLfile (string $file, integer $dbIndex)

Methods

multiQuery (line 79)

Break up a SQL string with multiple queries (separated by ';') and run each query

void multiQuery (string $queryString, integer $dbIndex)

parseSQLFile (line 36)

Parse SQL textfile to remove comments and line returns.

string parseSQLFile (string $file)

parseSQLString (line 53)

Parse SQL string to remove comments and line returns.

string parseSQLString (string $queryString)

runSQLdir (line 122)

Run all of the files with a given extention in a directory as SQL files.

void runSQLdir (string $dir, integer $dbIndex, [optional $extn = 'sql'])

runSQLfile (line 107)

Run all of the queries in a text file. Comments must start with '#' and queries must be separated by ';'.

void runSQLfile (string $file, integer $dbIndex)