Docs For Class SGL

Description

Provides SQL schema and data parsing/executing methods.

author: Demian Turner <demian@phpkitchen.com>
version: $Revision: 1.23 $

Located in /SGL/Sql.php (line 48)

Method Summary

static void parse (string $filename, [ $errorReporting = E_ALL], [ $executerCallback = null])

string addTablePrefix (string $tableName)

void buildDbCreateStatement ( $driver, $dbname)

void buildDbDropStatement ( $driver, $dbname)

void execute ( $sql)

string extractTableNameFromCreateStatement (string $str)

void extractTableNameFromInsertStatement ( $str)

void extractTableNamesFromSchema ( $data)

void getDbShortnameFromType ( $dbType)

void getNextId ( $tableName)

string prefixTableNameInStatement (string $str, string $type)

void rewriteWithAutoIncrement ( $str, $nextId)

Methods

static parse (line 60)

Simple function that opens a file with sql statements and executes them using DB

author: Gerry Lachac <glachac@tethermedia.com>
access: public

void parse (string $filename, [ $errorReporting = E_ALL], [ $executerCallback = null])

string $filename: File with SQL statements to execute
$errorReporting
$executerCallback

addTablePrefix (line 287)

Prefix given table name.

string addTablePrefix (string $tableName)

string $tableName: table name

buildDbCreateStatement (line 371)

void buildDbCreateStatement ( $driver, $dbname)

$driver
$dbname

buildDbDropStatement (line 387)

void buildDbDropStatement ( $driver, $dbname)

$driver
$dbname

execute (line 187)

void execute ( $sql)

$sql

extractTableNameFromCreateStatement (line 227)

Given a CREATE TABLE string, will extract the table name.

todo: consider using SQL_Parser, 19kb lib

string extractTableNameFromCreateStatement (string $str)

string $str

extractTableNameFromInsertStatement (line 212)

void extractTableNameFromInsertStatement ( $str)

$str

extractTableNamesFromSchema (line 242)

void extractTableNamesFromSchema ( $data)

$data

getDbShortnameFromType (line 260)

void getDbShortnameFromType ( $dbType)

$dbType

getNextId (line 200)

void getNextId ( $tableName)

$tableName

prefixTableNameInStatement (line 301)

Prefix table name in SQL statement.

string prefixTableNameInStatement (string $str, string $type)

string $str: initial string (statement)
string $type: query type

rewriteWithAutoIncrement (line 236)

void rewriteWithAutoIncrement ( $str, $nextId)

$str
$nextId

SGL_Sql