Docs For Class atkQuery

Child Class	Description
atkMockQuery	A mock query abstraction.
atkMysqlQuery	SQL Builder for MySQL databases.
atkOci8Query	Query build for Oracle 8i databases.
atkPgsqlQuery	SQL query builder for PostgreSQL.

[ Top ]

Property Summary

mixed	$m_aliases	Array with aliases
mixed	$m_conditions	Array with conditions
mixed	$m_db	The database that this query does it's thing on
mixed	$m_distinct	Do we need to perform a DISTINCT query?
mixed	$m_expressions	Array with expressions.
mixed	$m_fieldaliases	Array with field aliases
String	$m_fieldquote	The quote char to put around fields, for example `
mixed	$m_fields	Array with Fieldnames
mixed	$m_generatedAlias	Array with generated aliasses
mixed	$m_groupbys	Array with group by statements
mixed	$m_joinaliases	Array with aliases from joins
mixed	$m_joins	Array with Joins
mixed	$m_limit
mixed	$m_offset	Do we need to fetch only a specific set of records?
mixed	$m_orderbys	Array with order by statements
Array	$m_quotedfields	Wether or not a field should be quoted in a query
Array	$m_reservedNames	Names reserved by the database, if any of these are used ATK MUST quote the fieldname or the database engine will not be able to make any sense of the queries.
mixed	$m_searchconditions
mixed	$m_searchmethod	Var with AND or OR method
mixed	$m_tables	Array with tables

[ Top ]

Method Summary

static string	exactNumberCondition()	Generate a searchcondition that check number/decimal literal values
atkQuery	&addCondition()	Add a query condition (conditions are where-expressions that are AND-ed)
atkQuery	&addExpression()	Add's an expression to the select query
atkQuery	&addField()	Add's a field to the query
atkQuery	addFields()	Add multiple fields at once
atkQuery	&addGroupBy()	Add a group-by statement
atkQuery	&addJoin()	Add join to Join Array
atkQuery	&addOrderBy()	Add order-by statement
atkQuery	&addSearchCondition()	Add search condition to the query. Basically similar to addCondition, but searchconditions make use of the searchmode setting to determine whether the different searchconditions should be and'ed or or'ed.
atkQuery	addSequenceField()	Add's a sequence field to the query.
atkQuery	&addTable()	Add table to Tables array
void	atkquery()	Initialize all variables
unknown	betweenCondition()	Get the between condition
String	buildCount()	Builds the SQL Select COUNT(*) query. This is different from select, because we do joins, like in a select, but we don't really select the fields.
String	buildDelete()	Builds the SQL Delete query
String	buildInsert()	Builds the SQL Insert query
String	buildSelect()	Builds the SQL Select query
String	buildUpdate()	Builds the SQL Update query
atkQuery	&create()	Static factory method. This method returns a new instance of a query object for the current database.
void	deAlias()	Search Alias in alias array
string	exactCondition()	Generate a searchcondition that checks whether $value matches $field exactly.
void	executeDelete()	Wrapper function to execute a delete query
void	executeInsert()	Wrapper function to execute an insert query
array	executeSelect()	Wrapper function to execute a select query.
void	executeUpdate()	Wrapper function to execute an update query
atkDb	getDb()	Returns the database instance.
void	greaterthanCondition()	Generate searchcondition with greater than
void	greaterthanequalCondition()	Generate searchcondition with greater than
void	lessthanCondition()	Generate searchcondition with less than
void	lessthanequalCondition()	Generate searchcondition with less than
void	notNullCondition()	Generate a searchcondition that checks if the field is not null.
void	nullCondition()	Generate a searchcondition that checks if the field is null.
The	quoteField()	If we set a m_fieldquote you can pass a field to this function and it will quote all the identifiers (db, table, column, etc...) in the field.
Array	quoteFields()	Quote an array of fields if m_fieldquote is set.
void	setDb()	Sets the database instance.
atkQuery	&setDistinct()	Set the 'distinct' mode for the query.
atkQuery	&setLimit()	Set a limit to the number of results.
String	substringCondition()	Generate a searchcondition that checks whether $field contains $value .
void	wildcardCondition()	Generate a searchcondition that accepts '*' as wildcard character.
void	_addFrom()	Add FROM clause to query.
void	_addLimiter()	Add limiting clauses to the query.
void	_addOrderBy()	Add the ORDER BY clause

[ Top ]

Properties

mixed $m_aliases [line 62]

Array with aliases

[ Top ]

mixed $m_conditions [line 51]

Array with conditions

[ Top ]

mixed $m_db [line 110]

The database that this query does it's thing on

[ Top ]

mixed $m_distinct = false [line 93]

Do we need to perform a DISTINCT query?

[ Top ]

mixed $m_expressions [line 41]

Array with expressions.

[ Top ]

mixed $m_fieldaliases [line 67]

Array with field aliases

[ Top ]

String $m_fieldquote [line 117]

The quote char to put around fields, for example `

API Tags:

Access:

private

Redefined in descendants as:

atkMysqlQuery::$m_fieldquote

[ Top ]

mixed $m_fields [line 36]

Array with Fieldnames

[ Top ]

mixed $m_generatedAlias [line 105]

Array with generated aliasses

Oracle has a problem when aliases are too long

[ Top ]

mixed $m_groupbys [line 83]

Array with group by statements

[ Top ]

mixed $m_joinaliases [line 72]

Array with aliases from joins

[ Top ]

mixed $m_joins [line 78]

Array with Joins

[ Top ]

mixed $m_limit [line 99]

[ Top ]

mixed $m_offset [line 98]

Do we need to fetch only a specific set of records?

[ Top ]

mixed $m_orderbys [line 88]

Array with order by statements

[ Top ]

Array $m_quotedfields = array() [line 125]

Wether or not a field should be quoted in a query

API Tags:

Access:

private

[ Top ]

Array $m_reservedNames = array('from','select','order','group','release') [line 135]

Names reserved by the database, if any of these are used ATK MUST quote the fieldname or the database engine will not be able to make any sense of the queries.

API Tags:

Access:

private

[ Top ]

mixed $m_searchconditions [line 52]

[ Top ]

mixed $m_searchmethod [line 57]

Var with AND or OR method

[ Top ]

mixed $m_tables [line 46]

Array with tables

[ Top ]

Methods

static method exactNumberCondition [line 740]

static string exactNumberCondition(
string
$field, mixed
$value 
)

Generate a searchcondition that check number/decimal literal values

Parameters:

string	$field:	full qualified table column
mixed	$value:	integer/float/double etc.

API Tags:

Return:	piece of where clause to use in your SQL statement
Access:	public

[ Top ]

addCondition [line 345]

atkQuery &addCondition(
string
$condition 
)

Add a query condition (conditions are where-expressions that are AND-ed)

Parameters:

string

$condition:

Condition

API Tags:

Return:

The query object itself (for fluent usage)

[ Top ]

addExpression [line 270]

atkQuery &addExpression(
string
$fieldName, string
$expression, [string
$fieldAliasPrefix = ""], [bool
$quoteFieldName = false] 
)

Add's an expression to the select query

Parameters:

string	$fieldName:	expression field name
string	$expression:	expression value
string	$fieldAliasPrefix:	field alias prefix
bool	$quoteFieldName:	wether or not to quote the expression field name

API Tags:

Return:

The query object itself (for fluent usage)

[ Top ]

addField [line 199]

atkQuery &addField(
string
$name, [string
$value = ""], [string
$table = ""], [string
$fieldaliasprefix = ""], [bool
$quote = true], [bool
$quotefield = false] 
)

Add's a field to the query

Parameters:

string	$name:	Field name
string	$value:	Field value
string	$table:	Table name
string	$fieldaliasprefix:	Field alias prefix
bool	$quote:	If this parameter is true, stuff is inserted into the db using quotes, e.g. SET name = 'piet'. If it is false, it's done without quotes, e.d. SET number = 4.
bool	$quotefield:	Wether or not to quote the fieldname

API Tags:

Return:

The query object itself (for fluent usage)

Redefined in descendants as:

atkMssqlQuery::addField() : Add's a field to the query
atkOci9Query::addField() : Add's a field to the query

[ Top ]

addFields [line 252]

atkQuery addFields(

$fields, [string
$table = ""], [string
$fieldaliasprefix = ""], [bool
$quote = true], [bool
$quotefield = false] 
)

Add multiple fields at once

Parameters:

array	$fields:	array with field value pairs
string	$table:	Table name
string	$fieldaliasprefix:	Field alias prefix
bool	$quote:	If this parameter is true, stuff is inserted into the db using quotes, e.g. SET name = 'piet'. If it is false, it's done without quotes, e.d. SET number = 4.
bool	$quotefield:	Wether or not to quote the fieldname

API Tags:

Return:

The query object itself (for fluent usage)

[ Top ]

addGroupBy [line 321]

atkQuery &addGroupBy(
String
$element 
)

Add a group-by statement

Parameters:

String

$element:

Group by expression

API Tags:

Return:

The query object itself (for fluent usage)

[ Top ]

addJoin [line 308]

atkQuery &addJoin(
string
$table, string
$alias, string
$condition, [bool
$outer = false] 
)

Add join to Join Array

Parameters:

string	$table:	Table name
string	$alias:	Alias of table
string	$condition:	Condition for the Join
bool	$outer:	Wether to use an outer (left) join or an inner join

API Tags:

Return:

The query object itself (for fluent usage)

Redefined in descendants as:

atkOci8Query::addJoin() : Makes a Join SQL query for Oracle
atkOci9Query::addJoin() : Makes a Join SQL query for Oracle
atkPgsqlQuery::addJoin() : Makes a join SQL query for PostgreSQL

[ Top ]

addOrderBy [line 333]

atkQuery &addOrderBy(
String
$element 
)

Add order-by statement

Parameters:

String

$element:

Order by expression

API Tags:

Return:

The query object itself (for fluent usage)

[ Top ]

addSearchCondition [line 360]

atkQuery &addSearchCondition(
string
$condition 
)

Add search condition to the query. Basically similar to addCondition, but searchconditions make use of the searchmode setting to determine whether the different searchconditions should be and'ed or or'ed.

Parameters:

string

$condition:

Condition

API Tags:

Return:

The query object itself (for fluent usage)

[ Top ]

addSequenceField [line 233]

atkQuery addSequenceField(
string
$fieldName, 
&$value, [string
$seqName = null], int
$value 
)

Add's a sequence field to the query.

Parameters:

string	$fieldName:	field name
int	$value:	field to store the new sequence value in, note certain drivers might populate this field only after the insert query has been executed
string	$seqName:	sequence name (optional for certain drivers)
	&$value:

API Tags:

Access:

public

Redefined in descendants as:

atkMysqliQuery::addSequenceField() : Add's a sequence field to the query.

[ Top ]

addTable [line 293]

atkQuery &addTable(
string
$name, [string
$alias = ""] 
)

Add table to Tables array

Parameters:

string	$name:	Table name
string	$alias:	Alias of table

API Tags:

Return:

The query object itself (for fluent usage)

[ Top ]

atkquery [line 140]

void atkquery(
)

Initialize all variables

[ Top ]

betweenCondition [line 863]

unknown betweenCondition(
String
$field, Mixed
$value1, Mixed
$value2, [Bool
$quote = true] 
)

Get the between condition

Parameters:

String	$field:	The database field
Mixed	$value1:	The first value
Mixed	$value2:	The second value
Bool	$quote:	Add quotes?

[ Top ]

buildCount [line 528]

String buildCount(
[bool
$distinct = FALSE] 
)

Builds the SQL Select COUNT(*) query. This is different from select, because we do joins, like in a select, but we don't really select the fields.

Parameters:

bool

$distinct:

distinct rows?

API Tags:

Return:

a SQL Select COUNT(*) Query

Redefined in descendants as:

atkMysqlQuery::buildCount() : Builds the SQL Select COUNT(*) query. This is different from select, because we do joins, like in a select, but we don't really select the fields.
atkOci9Query::buildCount() : Builds the SQL Select COUNT(*) query. This is different from select, because we do joins, like in a select, but we don't really select the fields.
atkPgsqlQuery::buildCount() : Builds the SQL Select COUNT(*) query. This is different from select, because we do joins, like in a select, but we don't really select the fields.

[ Top ]

buildDelete [line 647]

String buildDelete(
)

Builds the SQL Delete query

API Tags:

Return:

a SQL Delete Query

[ Top ]

buildInsert [line 619]

String buildInsert(
)

Builds the SQL Insert query

API Tags:

Return:

a SQL Insert Query

Redefined in descendants as:

atkMysqliQuery::buildInsert() : Builds the SQL Insert query

[ Top ]

buildSelect [line 400]

String buildSelect(
[bool
$distinct = FALSE] 
)

Builds the SQL Select query

Parameters:

bool

$distinct:

distinct records?

API Tags:

Return:

a SQL Select Query

Redefined in descendants as:

atkOci9Query::buildSelect() : Builds the SQL Select query

[ Top ]

buildUpdate [line 581]

String buildUpdate(
)

Builds the SQL Update query

API Tags:

Return:

a SQL Update Query

[ Top ]

create [line 877]

atkQuery &create(
[string
$basepath = "atk.db."] 
)

Static factory method. This method returns a new instance of a query object for the current database.

Parameters:

string

$basepath:

The basepath for the database object (defaults to 'atk.db')

API Tags:

Return:

A Query object for the appropriate database

[ Top ]

deAlias [line 672]

void deAlias(

&$record, array
$record 
)

Search Alias in alias array

Parameters:

array	$record:	Array with fields
	&$record:

[ Top ]

exactCondition [line 719]

string exactCondition(
string
$field, mixed
$value, [string
$dbFieldType = null] 
)

Generate a searchcondition that checks whether $value matches $field exactly.

Parameters:

string	$field:	full qualified table column
mixed	$value:	string/number/decimal expected column value
string	$dbFieldType:	help determine exact search method

API Tags:

Return:

piece of where clause to use in your SQL statement

[ Top ]

executeDelete [line 662]

void executeDelete(
)

Wrapper function to execute a delete query

[ Top ]

executeInsert [line 609]

void executeInsert(
)

Wrapper function to execute an insert query

Redefined in descendants as:

atkMysqliQuery::executeInsert() : Wrapper function to execute an insert query
atkOci9Query::executeInsert() : Wrapper function to execute a query

[ Top ]

executeSelect [line 489]

array executeSelect(
[boolean
$distinct = FALSE] 
)

Wrapper function to execute a select query.

Parameters:

boolean

$distinct:

Set to true to perform a distinct select, false for a regular select.

API Tags:

Return:

The set of records returned by the database.

[ Top ]

executeUpdate [line 600]

void executeUpdate(
)

Wrapper function to execute an update query

Redefined in descendants as:

atkOci9Query::executeUpdate() : Wrapper function to execute a query

[ Top ]

getDb [line 177]

atkDb getDb(
)

Returns the database instance.

API Tags:

Return:	database instance
Access:	public

[ Top ]

greaterthanCondition [line 788]

void greaterthanCondition(
String
$field, String
$value 
)

Generate searchcondition with greater than

Parameters:

String	$field:	The database field
String	$value:	The value

[ Top ]

greaterthanequalCondition [line 806]

void greaterthanequalCondition(
String
$field, String
$value 
)

Generate searchcondition with greater than

Parameters:

String	$field:	The database field
String	$value:	The value

[ Top ]

lessthanCondition [line 824]

void lessthanCondition(
String
$field, String
$value 
)

Generate searchcondition with less than

Parameters:

String	$field:	The database field
String	$value:	The value

[ Top ]

lessthanequalCondition [line 842]

void lessthanequalCondition(
String
$field, String
$value 
)

Generate searchcondition with less than

Parameters:

String	$field:	The database field
String	$value:	The value

[ Top ]

notNullCondition [line 704]

void notNullCondition(
String
$field, [Bool
$emptyStringIsNull = false] 
)

Generate a searchcondition that checks if the field is not null.

Parameters:

String	$field:
Bool	$emptyStringIsNull:

[ Top ]

nullCondition [line 690]

void nullCondition(
String
$field, [Bool
$emptyStringIsNull = false] 
)

Generate a searchcondition that checks if the field is null.

Parameters:

String	$field:
Bool	$emptyStringIsNull:

[ Top ]

quoteField [line 891]

The quoteField(
String
$field 
)

If we set a m_fieldquote you can pass a field to this function and it will quote all the identifiers (db, table, column, etc...) in the field.

Parameters:

String

$field:

The field to add quotes too

API Tags:

Return:

quoted field, if we have a fieldquote

[ Top ]

quoteFields [line 920]

Array quoteFields(
Array
$fields 
)

Quote an array of fields if m_fieldquote is set.

Uses $this->quoteField($field)

Parameters:

Array

$fields:

The fields to add quotes to

API Tags:

Return:

The quoted fields

[ Top ]

setDb [line 167]

void setDb(

$db 
)

Sets the database instance.

Parameters:

$db:

API Tags:

Access:

public

[ Top ]

setDistinct [line 375]

atkQuery &setDistinct(
Bool
$distinct 
)

Set the 'distinct' mode for the query.

If set to true, a 'SELECT DISTINCT' will be performed. If set to false, a regular 'SELECT' will be performed.

Parameters:

Bool

$distinct:

Set to true to perform a distinct select, false for a regular select.

API Tags:

Return:

The query object itself (for fluent usage)

[ Top ]

setLimit [line 388]

atkQuery &setLimit(
int
$offset, int
$limit 
)

Set a limit to the number of results.

Parameters:

int	$offset:	Retrieve records starting with record ...
int	$limit:	Retrieve only this many records.

API Tags:

Return:

The query object itself (for fluent usage)

[ Top ]

substringCondition [line 752]

String substringCondition(
String
$field, String
$value 
)

Generate a searchcondition that checks whether $field contains $value .

Parameters:

String	$field:	The field
String	$value:	The value

API Tags:

Return:

The substring condition

Redefined in descendants as:

atkOci8Query::substringCondition() : Generate a searchcondition that checks whether $field contains $value .

[ Top ]

wildcardCondition [line 770]

void wildcardCondition(
String
$field, String
$value 
)

Generate a searchcondition that accepts '*' as wildcard character.

Parameters:

String	$field:
String	$value:

[ Top ]

_addFrom [line 471]

void _addFrom(

&$query, String
$query 
)

Add FROM clause to query.

Parameters:

String	$query:	The query
	&$query:

Redefined in descendants as:

atkMysqliQuery::_addFrom() : Overriding the _addFrom function to support a change that was made in MySQL 5.0.15 to make MySQL more compliant with the standard.

[ Top ]

_addLimiter [line 501]

void _addLimiter(

&$query, string
$query 
)

Add limiting clauses to the query.

Default implementation: no limit supported. Derived classes should implement this.

Parameters:

string	$query:	The query to add the limiter to
	&$query:

Redefined in descendants as:

atkMysqlQuery::_addLimiter() : Prepare the query for a limit.
atkMssqlQuery::_addLimiter() : Prepare the query for a limit.
atkOci8Query::_addLimiter() : Add limiting clauses to the query.
atkPgsqlQuery::_addLimiter() : Add limiting clauses to the query.

[ Top ]

_addOrderBy [line 511]

void _addOrderBy(

&$query, String
$query 
)

Add the ORDER BY clause

Parameters:

String	$query:	The query
	&$query:

Redefined in descendants as:

atkOci805Query::_addOrderBy() : Add the list of order by fields to the SQL query.

[ Top ]