Class DbQueryParser
Description
Database query builder with SQL parser
This class is an extension to the query builder, which enables it to parse real SQL statements to fill the object's properties.
Note that the SQL statements are expected to use the syntax understood by FileDb. This sligthly differs from MySQL. No Limit clause is allowed. Use the method "DbQuery::setLimit()" instead. Ids do not need to be quoted. Values are quoted using double-quotes - not single-quotes.
For more details on this topic see the manual and the developer's cookbook.
Object | --DbQuery | --DbQueryParser
Method Summary
- DbQueryParser DbQueryParser (object $database)
- bool parseSQL (string $sqlStmt)
Methods
create a new instance
DbQueryParser
DbQueryParser
(
object $database
)
List of parameters:
| Name | Type | Description |
|---|---|---|
| $database | object |
Description:
This creates and initializes a new instance of this class.
parse SQL query into query object
bool
parseSQL
(
string $sqlStmt
)
List of parameters:
| Name | Type | Description |
|---|---|---|
| $sqlStmt | string |
Description:
Returns bool(true) if the input SQL statement is valid (in the sense of this parser) and bool(false) on failure.
inherited from base classes
Inherited From DbQuery
- DbQuery::DbQuery()
- DbQuery::getArrayAddress()
- DbQuery::getColumn()
- DbQuery::getColumns()
- DbQuery::getJoin()
- DbQuery::getLimit()
- DbQuery::getOffset()
- DbQuery::getOrderBy()
- DbQuery::getParent()
- DbQuery::getParentByColumn()
- DbQuery::getRow()
- DbQuery::getTable()
- DbQuery::getType()
- DbQuery::getValues()
- DbQuery::getWhere()
- DbQuery::isDescending()
- DbQuery::resetQuery()
- DbQuery::setColumn()
- DbQuery::setColumns()
- DbQuery::setJoin()
- DbQuery::setKey()
- DbQuery::setLimit()
- DbQuery::setOffset()
- DbQuery::setOrderBy()
- DbQuery::setRow()
- DbQuery::setTable()
- DbQuery::setType()
- DbQuery::setValues()
- DbQuery::setWhere()
- DbQuery::toString()
- DbQuery::useInheritance()
Inherited From Object
Documentation generated on Sat, 03 Jan 2009 22:22:19 +0100 by phpDocumentor 1.4.0
www.yanaframework.net