function toSQL()
{
$db = \Radical\DB::getInstance();
//Build Query
$sql = 'UPDATE `' . $this->table . '` ';
$sql .= $this->set . ' ';
$sql .= $this->where;
return $sql;
}
function toSQL()
{
$db = \Radical\DB::getInstance();
$sql = 'MATCH (' . implode(',', $this->fields) . ') ';
$sql .= 'AGAINST (' . $db->Escape($this->text);
if ($this->boolean) {
$sql .= ' IN BOOLEAN MODE';
}
$sql .= ')';
return $sql;
}
static function transaction($function, ...$updating)
{
foreach ($updating as $k => $v) {
if ($v instanceof Table) {
$updating[$k] = $v->refreshTableData(true);
}
}
$instance = \Radical\DB::getInstance();
return $instance->transaction(function () use($updating, $function) {
return $function(...$updating);
});
}
function toSQL($where = false)
{
if (is_string($this->parts)) {
$sql = '';
if ($where && count($this->parts)) {
$sql = 'WHERE ';
}
$sql .= $this->parts;
return $sql;
}
//Do for array
$db = \Radical\DB::getInstance();
$ret = array();
foreach ($this->parts as $alias => $p) {
$rr = '';
if ($alias) {
$rr = '`' . $alias . '`.';
}
foreach ($p as $k => $v) {
$rri = $rr . '`' . $k . '`';
if ($v instanceof IToSQL) {
$rri .= $v->toSQL();
} else {
$rri .= '=' . $db->Escape($v);
}
$ret[] = $rri;
}
}
//Build SQL
$sql = '';
if ($where) {
$sql = 'WHERE ';
}
$sql .= implode(' ' . static::SEPPERATOR . ' ', $ret);
return $sql;
}
function toSQL()
{
$db = \Radical\DB::getInstance();
return ' BETWEEN ' . $this->E($db, $this->a) . ' AND ' . $this->E($db, $this->b);
}
