Docs For Class atkDb2Query

Inherited Properties	Inherited Methods
Inherited From atkQuery atkQuery::$m_aliases atkQuery::$m_conditions atkQuery::$m_db atkQuery::$m_distinct atkQuery::$m_expressions atkQuery::$m_fieldaliases atkQuery::$m_fields atkQuery::$m_generatedAlias atkQuery::$m_groupbys atkQuery::$m_joinaliases atkQuery::$m_joins atkQuery::$m_limit atkQuery::$m_offset atkQuery::$m_orderbys atkQuery::$m_quotedfields atkQuery::$m_reservedNames atkQuery::$m_searchconditions atkQuery::$m_searchmethod atkQuery::$m_tables	Inherited From atkQuery 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 atkQuery::atkquery() Initialize all variables atkQuery::betweenCondition() Get the between condition atkQuery::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. atkQuery::buildDelete() Builds the SQL Delete query atkQuery::buildInsert() Builds the SQL Insert query atkQuery::buildSelect() Builds the SQL Select query atkQuery::buildUpdate() Builds the SQL Update query atkQuery::clearExpressions() Clear expression list. atkQuery::clearFields() Clear field list. atkQuery::create() Static factory method. This method returns a new instance of a query object for the current database. atkQuery::deAlias() Search Alias in alias array atkQuery::exactCondition() Generate a searchcondition that checks whether $value matches $field exactly. atkQuery::exactNumberCondition() Generate a searchcondition that check number/decimal literal values atkQuery::executeDelete() Wrapper function to execute a delete query atkQuery::executeInsert() Wrapper function to execute an insert query atkQuery::executeSelect() Wrapper function to execute a select query. atkQuery::executeUpdate() Wrapper function to execute an update query atkQuery::getDb() Returns the database instance. atkQuery::greaterthanCondition() Generate searchcondition with greater than atkQuery::greaterthanequalCondition() Generate searchcondition with greater than atkQuery::lessthanCondition() Generate searchcondition with less than atkQuery::lessthanequalCondition() Generate searchcondition with less than atkQuery::notNullCondition() Generate a searchcondition that checks if the field is not null. atkQuery::nullCondition() Generate a searchcondition that checks if the field is null. atkQuery::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. atkQuery::quoteFields() Quote an array of fields if m_fieldquote is set. atkQuery::setDb() Sets the database instance. atkQuery::setDistinct() Set the 'distinct' mode for the query. atkQuery::setLimit() Set a limit to the number of results. atkQuery::setSearchMethod() Sets this queries search method. atkQuery::substringCondition() Generate a searchcondition that checks whether $field contains $value . atkQuery::wildcardCondition() Generate a searchcondition that accepts '' as wildcard character. atkQuery::_addFrom() Add FROM clause to query. atkQuery::_addLimiter() Add limiting clauses to the query. atkQuery::_addOrderBy() Add the ORDER BY clause

Inherited Properties

Inherited Methods

Inherited From atkQuery

atkQuery::$m_aliases

atkQuery::$m_conditions

atkQuery::$m_db

atkQuery::$m_distinct

atkQuery::$m_expressions

atkQuery::$m_fieldaliases

atkQuery::$m_fields

atkQuery::$m_generatedAlias

atkQuery::$m_groupbys

atkQuery::$m_joinaliases

atkQuery::$m_joins

atkQuery::$m_limit

atkQuery::$m_offset

atkQuery::$m_orderbys

atkQuery::$m_quotedfields

atkQuery::$m_reservedNames

atkQuery::$m_searchconditions

atkQuery::$m_searchmethod

atkQuery::$m_tables

Inherited From atkQuery

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

atkQuery::atkquery()

Initialize all variables

atkQuery::betweenCondition()

Get the between condition

atkQuery::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.

atkQuery::buildDelete()

Builds the SQL Delete query

atkQuery::buildInsert()

Builds the SQL Insert query

atkQuery::buildSelect()

Builds the SQL Select query

atkQuery::buildUpdate()

Builds the SQL Update query

atkQuery::clearExpressions()

Clear expression list.

atkQuery::clearFields()

Clear field list.

atkQuery::create()

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

atkQuery::deAlias()

Search Alias in alias array

atkQuery::exactCondition()

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

atkQuery::exactNumberCondition()

Generate a searchcondition that check number/decimal literal values

atkQuery::executeDelete()

Wrapper function to execute a delete query

atkQuery::executeInsert()

Wrapper function to execute an insert query

atkQuery::executeSelect()

Wrapper function to execute a select query.

atkQuery::executeUpdate()

Wrapper function to execute an update query

atkQuery::getDb()

Returns the database instance.

atkQuery::greaterthanCondition()

Generate searchcondition with greater than

atkQuery::greaterthanequalCondition()

Generate searchcondition with greater than

atkQuery::lessthanCondition()

Generate searchcondition with less than

atkQuery::lessthanequalCondition()

Generate searchcondition with less than

atkQuery::notNullCondition()

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

atkQuery::nullCondition()

Generate a searchcondition that checks if the field is null.

atkQuery::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.

atkQuery::quoteFields()

Quote an array of fields if m_fieldquote is set.

atkQuery::setDb()

Sets the database instance.

atkQuery::setDistinct()

Set the 'distinct' mode for the query.

atkQuery::setLimit()

Set a limit to the number of results.

atkQuery::setSearchMethod()

Sets this queries search method.

atkQuery::substringCondition()

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

atkQuery::wildcardCondition()

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

atkQuery::_addFrom()

Add FROM clause to query.

atkQuery::_addLimiter()

Add limiting clauses to the query.

atkQuery::_addOrderBy()

Add the ORDER BY clause

[ Top ]

Property Summary

mixed

$m_fieldquote

[ Top ]

Method Summary

void	&addField()
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	regexpCondition()	Generate an SQL searchcondition for a regular expression match.
String	soundexCondition()	Generate an SQL searchcondition for a soundex match.
void	_addLimiter()	Prepare the query for a limit.

[ Top ]

Properties

mixed $m_fieldquote = '' [line 34]

Redefinition of:

atkQuery::$m_fieldquote: The quote char to put around fields, for example `

[ Top ]

Methods

addField [line 164]

void &addField(

$name, [
$value = ""], [
$table = ""], [
$fieldaliasprefix = ""], [
$quote = true], [
$mode = ""], [
$fieldType = ""] 
)

Parameters:

	$name:
	$value:
	$table:
	$fieldaliasprefix:
	$quote:
	$mode:
	$fieldType:

Redefinition of:

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

[ Top ]

buildCount [line 113]

String buildCount(
[boolean
$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:

boolean

$distinct:

distinct rows?

API Tags:

Return:

a SQL Select COUNT(*) Query

Redefinition of:

atkQuery::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 ]

regexpCondition [line 49]

String regexpCondition(
String
$field, String
$value, [boolean
$inverse = false] 
)

Generate an SQL searchcondition for a regular expression match.

Parameters:

String	$field:	The fieldname on which the regular expression match will be performed.
String	$value:	The regular expression to search for.
boolean	$inverse:	Set to false (default) to perform a normal match. Set to true to generate a SQL string that searches for values dat do not match.

API Tags:

Return:

A SQL regexp expression.

Information Tags:

Todo:

convert to db2

[ Top ]

soundexCondition [line 74]

String soundexCondition(
String
$field, String
$value, [boolean
$inverse = false] 
)

Generate an SQL searchcondition for a soundex match.

Parameters:

String	$field:	The fieldname on which the soundex match will be performed.
String	$value:	The value to search for.
boolean	$inverse:	Set to false (default) to perform a normal match. Set to true to generate a SQL string that searches for values dat do not match.

API Tags:

Return:

A SQL soundex expression.

Information Tags:

Todo:

convert to db2 (is this ever used anyway???)

[ Top ]

_addLimiter [line 93]

void _addLimiter(

&$query, String
$query 
)

Prepare the query for a limit.

Parameters:

String	$query:	The SQL query that is being constructed.
	&$query:

API Tags:

Access:

private

Information Tags:

Todo:

add limit statement in db2 style (limit 10,5 will not work)

Redefinition of:

atkQuery::_addLimiter(): Add limiting clauses to the query.

[ Top ]