/** * @param array $fields * @param array|string|bool $order * @return ICmdSelect */ protected function createQuery(array $fields, $order = false) { $query = $this->connector->select()->from($this->tableName); $this->createFilter($query, $fields); if (is_string($order)) { $query->orderBy($order); } else { if (is_array($order)) { foreach ($order as $field => $type) { $query->orderBy($field, $type); } } } return $query; }
/** * @param string $key * @return string|null */ public function get($key) { return $this->connector->select()->columns('Data')->from($this->tableName)->byField('ID', $key)->queryScalar(null, false); }