1. class
  2. ActiveRecord
  3. \
  4. SQLBuilder

SQLBuilder

class SQLBuilder (View source)

Helper class for building sql statements progmatically.

Methods

SQLBuilder
__construct(Connection $connection, string $table)

Constructor.

string
__toString()

Returns the SQL string.

string
to_s()

Returns the SQL string.

array
bind_values()

Returns the bind values.

get_where_values()

No description

where()

No description

order($order)

No description

group($group)

No description

having($having)

No description

limit($limit)

No description

offset($offset)

No description

select($select)

No description

joins($joins)

No description

insert($hash, $pk = null, $sequence_name = null)

No description

update($mixed)

No description

delete()

No description

static 
reverse_order($order)

Reverses an order clause.

static A
create_conditions_from_underscored_string(Connection $connection, $name, $values = array(), $map = null)

Converts a string like "id_and_name_or_z" into a conditions value like array("id=? AND name=? OR z=?", values, .

static array
create_hash_from_underscored_string($name, $values = array(), $map = null)

Like create_conditions_from_underscored_string but returns a hash of name => value array instead.

Details

at line 42
SQLBuilder __construct(Connection $connection, string $table)

Constructor.

Parameters

Connection $connection A database connection object
string $table Name of a table

Return Value

SQLBuilder

Exceptions

ActiveRecordException if connection was invalid

at line 56
string __toString()

Returns the SQL string.

Return Value

string

at line 67
string to_s()

Returns the SQL string.

Return Value

string

See also

__toString

at line 78
array bind_values()

Returns the bind values.

Return Value

array

at line 91
get_where_values()

at line 96
where()

at line 102
order($order)

Parameters

$order

at line 108
group($group)

Parameters

$group

at line 114
having($having)

Parameters

$having

at line 120
limit($limit)

Parameters

$limit

at line 126
offset($offset)

Parameters

$offset

at line 132
select($select)

Parameters

$select

at line 139
joins($joins)

Parameters

$joins

at line 145
insert($hash, $pk = null, $sequence_name = null)

Parameters

$hash
$pk
$sequence_name

at line 159
update($mixed)

Parameters

$mixed

at line 173
delete()

at line 183
static reverse_order($order)

Reverses an order clause.

Parameters

$order

at line 214
static A create_conditions_from_underscored_string(Connection $connection, $name, $values = array(), $map = null)

Converts a string like "id_and_name_or_z" into a conditions value like array("id=? AND name=? OR z=?", values, .

..).

Parameters

Connection $connection
$name Underscored string
$values Array of values for the field names. This is used to determine what kind of bind marker to use: =?, IN(?), IS NULL
$map A hash of "mapped_column_name" => "real_column_name"

Return Value

A conditions array in the form array(sql_string, value1, value2,...)

at line 257
static array create_hash_from_underscored_string($name, $values = array(), $map = null)

Like create_conditions_from_underscored_string but returns a hash of name => value array instead.

Parameters

$name
$values
$map

Return Value

array A hash of array(name => value, ...)