Method |
Description |
|
__construct ( Db $db, mixed $table = null, string $alias = null ) : Sql |
Constructor |
|
__toString ( ) : string |
Method to return the SQL as a string |
|
adapter ( ) : AbstractAdapter |
Get the current database object's adapter. |
|
delete ( ) : Update |
Create a delete statement |
|
factory ( Db $db, mixed $table = null, string $alias = null ) : Sql |
Static method to instantiate the SQL object and return itself
to facilitate chaining methods together. |
|
getAlias ( ) : string |
Get the alias name. |
|
getDb ( ) : Db |
Get the current database object. |
|
getDbType ( ) : integer |
Get the current database type. |
|
getQuoteId ( ) : integer |
Get the quote ID type |
|
getSql ( ) : string |
Get the current SQL statement string. |
|
getTable ( ) : string |
Get the current table. |
|
hasAlias ( ) : boolean |
Determine if the Sql object has an alias name |
|
hasTable ( ) : boolean |
Determine if the Sql object has a table set |
|
insert ( array $columns = null ) : Insert |
Create a insert statement |
|
quote ( string $value ) : string |
Quote the value with single quotes |
|
quoteId ( string $id ) : string |
Quote the value with the quoted identifier |
|
render ( boolean $ret = false ) : mixed |
Render SQL string |
|
select ( mixed $columns = null ) : Select |
Create a select statement |
|
setAlias ( string $alias = null ) : Sql |
Set alias name |
|
setDb ( Db $db ) : Sql |
Set the database object |
|
setQuoteId ( integer $type = Pop\Db\Sql::NO_QUOTE ) : Sql |
Set the quote ID type |
|
setTable ( mixed $table = null ) : Sql |
Set current table to operate on. |
|
update ( array $columns = null ) : Update |
Create a update statement |
|