Docs For Class atkPgsqlQuery

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_fieldquote 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::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::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_fieldquote

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

Method Summary

atkQuery	&addJoin()	Makes a join SQL query for PostgreSQL
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.
void	_addLimiter()	Add limiting clauses to the query.

[ Top ]

Properties

Methods

addJoin [line 42]

atkQuery &addJoin(
string
$table, string
$alias, string
$condition, bool
$outer 
)

Makes a join SQL query for PostgreSQL

Parameters:

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

API Tags:

Return:

The query object (for fluent usage)

Redefinition of:

atkQuery::addJoin(): Add join to Join Array

[ Top ]

buildCount [line 78]

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

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 ]

_addLimiter [line 61]

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:

Redefinition of:

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

[ Top ]