dotProject 2.1 RC1 : Vue détaillée de query.class.php

Classe: DBQuery - X-Ref

DBQuery($prefix = null) X-Ref

Pas de description

clear() X-Ref

Pas de description

clearQuery() X-Ref

Pas de description

addMap($varname, $name, $id) X-Ref

Add a hash item to an array.

param: string    $varname    Name of variable to add/create
param: mixed    $name    Data to add
param: string     $id    Index to use in array.

addTable($name, $id = null) X-Ref

Adds a table to the query.  A table is normally addressed by an
alias.  If you don't supply the alias chances are your code will
break.  You can add as many tables as are needed for the query.
E.g. addTable('something', 'a') will result in an SQL statement
of {PREFIX}table as a.
Where {PREFIX} is the system defined table prefix.

param: string    $name    Name of table, without prefix.

addClause($clause, $value, $check_array = true) X-Ref

Add a clause to an array. Checks to see variable exists first.
then pushes the new data onto the end of the array.

addQuery($query) X-Ref

Add the actual select part of the query.  E.g. '*', or 'a.*'
or 'a.field, b.field', etc.  You can call this multiple times
and it will correctly format a combined query.

param: string    $query    Query string to use.

addInsert($field, $value, $set = false, $func = false) X-Ref

Pas de description

addReplace($field, $value, $set = false, $func = false) X-Ref

Pas de description

addUpdate($field, $value, $set = false) X-Ref

Pas de description

createTable($table) X-Ref

Pas de description

createTemp($table) X-Ref

Pas de description

dropTable($table) X-Ref

Pas de description

dropTemp($table) X-Ref

Pas de description

alterTable($table) X-Ref

Pas de description

addField($name, $type) X-Ref

Pas de description

dropField($name) X-Ref

Pas de description

addIndex($name, $type) X-Ref

Pas de description

dropIndex($name) X-Ref

Pas de description

dropPrimary() X-Ref

Pas de description

createDefinition($def) X-Ref

Pas de description

setDelete($table) X-Ref

Pas de description

addWhere($query) X-Ref

Add where sub-clauses. The where clause can be built up one
part at a time and the resultant query will put in the 'and'
between each component.

Make sure you use table aliases.

param: string $query Where subclause to use

addJoin($table, $alias, $join, $type = 'left') X-Ref

Add a join condition to the query.  This only implements
left join, however most other joins are either synonymns or
can be emulated with where clauses.

param: string    $table    Name of table (without prefix)
param: string    $alias    Alias to use instead of table name (required).
param: mixed    $join    Join condition (e.g. 'a.id = b.other_id')

leftJoin($table, $alias, $join) X-Ref

Pas de description

rightJoin($table, $alias, $join) X-Ref

Pas de description

innerJoin($table, $alias, $join) X-Ref

Pas de description

addOrder($order) X-Ref

Add an order by clause. Again, only the fieldname is required, and
it should include an alias if a table has been added.
May be called multiple times.

param: string $order Order by field.

addGroup($group) X-Ref

Add a group by clause.  Only the fieldname is required.
May be called multiple times.  Use table aliases as required.

param: string    $group    Field name to group by.

setLimit($limit, $start = -1) X-Ref

Set a limit on the query.  This is done in a database-independent
fashion.

param: integer    $limit    Number of rows to limit.
param: integer    $start    First row to start extraction.

prepare($clear = false) X-Ref

Prepare a query for execution via db_exec.

prepareSelect() X-Ref

Pas de description

prepareUpdate() X-Ref

Pas de description

prepareInsert() X-Ref

Pas de description

prepareReplace() X-Ref

Pas de description

prepareDelete() X-Ref

Pas de description