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); }