Propel API
Class

MssqlDataSQLBuilder

class MssqlDataSQLBuilder extends DataSQLBuilder

MS SQL Server class for building data dump SQL.

Methods

static  reset()

Perform any reset between runs of this builder.

from DataSQLBuilder
static string getDatabaseStartSql()

Gets any SQL to place at the start of all the row inserts.

from DataSQLBuilder
static string getDatabaseEndSql()

Gets any SQL to place at the end of all the row inserts.

from DataSQLBuilder
string getTableStartSql()

Gets any SQL to place before row inserts for a new table.

from DataSQLBuilder
string getTableEndSql()

Gets any SQL to place at the end of row inserts for a table.

from DataSQLBuilder
string buildRowSql(DataRow $row)

The main method in this class, returns the SQL for INSERTing data into a row.

from DataSQLBuilder
string getTimestampSql(string $value)

Gets a representation of a timestamp value suitable for use in a SQL statement.

from DataSQLBuilder

Details

in DataSQLBuilder at line 28
static public reset()

Perform any reset between runs of this builder.

This can be used, for example, to clear any stored start/end SQL.

in DataSQLBuilder at line 38
static public string getDatabaseStartSql()

Gets any SQL to place at the start of all the row inserts.

Return Value

string

in DataSQLBuilder at line 48
static public string getDatabaseEndSql()

Gets any SQL to place at the end of all the row inserts.

Return Value

string

in DataSQLBuilder at line 58
public string getTableStartSql()

Gets any SQL to place before row inserts for a new table.

Return Value

string

in DataSQLBuilder at line 68
public string getTableEndSql()

Gets any SQL to place at the end of row inserts for a table.

Return Value

string

in DataSQLBuilder at line 78
public string buildRowSql(DataRow $row)

The main method in this class, returns the SQL for INSERTing data into a row.

Parameters

DataRow $row The row to process.

Return Value

string

in DataSQLBuilder at line 248
public string getTimestampSql(string $value)

Gets a representation of a timestamp value suitable for use in a SQL statement.

Parameters

string $value

Return Value

string