public function execute(QueryContext $context) { $query = $this->toQueryString($context); if (true === $this->insertGetId) { if (true === DB::insert($query, $context->getParams())) { return DB::table($this->schema->getName())->orderBy($this->schema->getAutoIncrementField(), 'DESC')->pluck($this->schema->getAutoIncrementField())->execute(); } } return DB::insert($query, $context->getParams()); }
public function test_error() { $query = \Xaircraft\DB::table('user')->whereIn('id', function (\Xaircraft\Database\WhereQuery $whereQuery) { $whereQuery->from('user')->select('id'); }); $query1 = $query; $list = $query->select()->execute(); $list = $query1->select()->execute(); var_dump($list); var_dump(\Xaircraft\DB::getQueryLog()); }
private static function getParent($id, array &$traces, TableQuery $query = null) { /** @var Model $model */ $model = DI::get(__CLASS__); if (!isset($query)) { $realQuery = DB::table($model->getSchema()->getName()); } else { $realQuery = clone $query; } $current = $realQuery->where('id', $id)->select()->detail()->execute(); if (!isset($traces)) { $traces = array(); } $traces[] = $current['name']; $parentID = $current[$model->getParentIDField()]; if ($parentID > 0) { self::getParent($parentID, $traces, $query); } }
public function test_order() { $query = DB::table('user')->orderBy('id', \Xaircraft\Database\OrderInfo::SORT_ASC)->select(array("id", "name", "project_id" => function (WhereQuery $whereQuery) { $whereQuery->from('project')->select('id')->top(); }))->execute(); }
private function setField($field, $value) { if (!$this->schema->existsField($field)) { throw new EntityException("Can't find field [{$field}] in table [" . $this->schema->getName()); } if ($value != $this->shadows[$field]) { if ($this->autoIncrementField === $field) { if (!$this->exists) { if (DB::table($this->schema->getName())->where($field, $value)->count()->execute() > 0) { $this->exists = true; } $this->query = DB::table($this->schema->getName())->where($field, $value); } } $this->fields[$field] = $value; if ($this->autoIncrementField !== $field) { $this->updates[$field] = $value; } $this->shadows[$field] = $value; } }
public static function find($arg) { $model = self::model(); if ($arg instanceof TableQuery) { if ($arg->getTableSchema()->getName() !== $model->schema->getName()) { throw new ModelException("TableQuery must be table [" . $model->schema->getName() . "]'s query."); } $query = $arg; } else { if (is_numeric($arg)) { $query = DB::table($model->schema->getName())->where($model->schema->getAutoIncrementField(), $arg)->select(); } else { throw new ModelException("What do you want to find?"); } } $model->loadData($query); if (is_numeric($arg) && !$model->isExists()) { throw new ModelException("Record not exists."); } return $model; }