PHP Context::getConnection方法代码示例

 /** Funkcia v poli vrati zakladne info. o pripojeni.
  * @return array
  */
 public function getDBInfo()
 {
     $pom = explode(":", $this->connection->getConnection()->getDsn());
     $out = array();
     foreach (explode(";", $pom[1]) as $v) {
         $t = explode("=", $v);
         $out[$t[0]] = $t[1];
     }
     return $out;
 }

 protected function execute(InputInterface $input, OutputInterface $output)
 {
     $connection = $this->database->getConnection();
     Nette\Database\Helpers::loadFromFile($connection, $this->getFile(static::FILE_USERS_TABLE));
     Nette\Database\Helpers::loadFromFile($connection, $this->getFile(static::FILE_ROLES_TABLE));
     Nette\Database\Helpers::loadFromFile($connection, $this->getFile(static::FILE_RESOURCES_TABLE));
     Nette\Database\Helpers::loadFromFile($connection, $this->getFile(static::FILE_USER_ROLE_TABLE));
     Nette\Database\Helpers::loadFromFile($connection, $this->getFile(static::FILE_USER_REQUEST_TABLE));
     Nette\Database\Helpers::loadFromFile($connection, $this->getFile(static::FILE_ROLES_DATA_TABLE));
     Nette\Database\Helpers::loadFromFile($connection, $this->getFile(static::FILE_IDENTITY_HASH_TABLE));
 }

 /**
  * Import taken from Adminer, slightly modified
  *
  * @param    string path to imported file
  * @param    DibiConnection
  * @returns  int number of executed queries
  *
  * @author   Jakub Vrána
  * @author   Jan Tvrdík
  * @author   Michael Moravec
  * @author   Jan Skrasek
  * @license  Apache License
  */
 protected function loadFile($file)
 {
     $query = @file_get_contents($file);
     if (!$query) {
         throw new IOException("Cannot open file '{$file}'.");
     }
     $delimiter = ';';
     $offset = $queries = 0;
     $space = "(?:\\s|/\\*.*\\*/|(?:#|-- )[^\\n]*\\n|--\\n)";
     $driver = $this->context->getConnection()->getSupplementalDriver();
     if ($driver instanceof MsSqlDriver) {
         $parse = '[\'"[]|/\\*|-- |$';
     } elseif ($driver instanceof SqliteDriver) {
         $parse = '[\'"`[]|/\\*|-- |$';
     } elseif ($driver instanceof PgSqlDriver) {
         $parse = '[\'"]|/\\*|-- |$|\\$[^$]*\\$';
     } else {
         $parse = '[\'"`#]|/\\*|-- |$';
     }
     while ($query != '') {
         if (!$offset && preg_match("~^{$space}*DELIMITER\\s+(\\S+)~i", $query, $match)) {
             $delimiter = $match[1];
             $query = substr($query, strlen($match[0]));
         } else {
             preg_match('(' . preg_quote($delimiter) . "\\s*|{$parse})", $query, $match, PREG_OFFSET_CAPTURE, $offset);
             // should always match
             $found = $match[0][0];
             $offset = $match[0][1] + strlen($found);
             if (!$found && rtrim($query) === '') {
                 break;
             }
             if (!$found || rtrim($found) == $delimiter) {
                 // end of a query
                 $q = substr($query, 0, $match[0][1]);
                 $queries++;
                 $this->context->query($q);
                 $query = substr($query, $offset);
                 $offset = 0;
             } else {
                 // find matching quote or comment end
                 while (preg_match('(' . ($found == '/*' ? '\\*/' : ($found == '[' ? ']' : (preg_match('~^-- |^#~', $found) ? "\n" : preg_quote($found) . "|\\\\."))) . '|$)s', $query, $match, PREG_OFFSET_CAPTURE, $offset)) {
                     //! respect sql_mode NO_BACKSLASH_ESCAPES
                     $s = $match[0][0];
                     $offset = $match[0][1] + strlen($s);
                     if ($s[0] !== '\\') {
                         break;
                     }
                 }
             }
         }
     }
     return $queries;
 }

 private function processViews()
 {
     $tables = $this->db->getConnection()->getSupplementalDriver()->getTables();
     foreach ($tables as $table) {
         if ($table['view'] == TRUE) {
             $viewName = $table['name'];
             // Fetch SHOW CREATE VIEW string
             $row = $this->db->query("SHOW CREATE VIEW `{$viewName}`")->fetch();
             $createView = $row["Create View"];
             // Remove Auto increment value
             $createView = Strings::replace($createView, '#SQL SECURITY DEFINER\\s?#i');
             $createView = Strings::replace($createView, '#ALGORITHM=UNDEFINED\\s?#i');
             $createView = Strings::replace($createView, '/DEFINER=`.+?`\\@`.+?`\\s?/');
             // Add ;
             $createView .= ";";
             $dropTable = "DROP VIEW IF EXISTS `{$viewName}`;\n";
             $data = Data::header() . $dropTable . $createView . "\n" . Data::footer();
             $dump = new Dump($viewName, Dump::TYPE_VIEW, $this->dumpDir);
             $dump->saveIfChanged($data, function ($fromFile) use($createView) {
                 $createViewFromFile = Strings::match($fromFile, "/CREATE.*;/s")[0];
                 return Strings::normalize($createViewFromFile) == Strings::normalize($createView);
             });
         }
     }
 }

 public function __construct($tableName, Context $context)
 {
     $this->tableName = $tableName;
     $this->driver = $context->getConnection()->getSupplementalDriver();
     $this->conventions = $context->getConventions();
     $this->structure = $context->getStructure();
     $this->delimitedTable = implode('.', array_map([$this->driver, 'delimite'], explode('.', $tableName)));
 }

 /**
  * Helper for findBy, countBy
  *
  * @param array   $values
  * @param array   $order Order => column=>ASC/DESC
  * @param integer $limit Limit count
  * @param integer $offset Limit offset
  *
  * @return Nette\Database\Table\Selection
  */
 protected function selectionBy(array $values, $order = null, $limit = null, $offset = null)
 {
     $selection = $this->getTable();
     // compose Where
     foreach ($values as $key => $value) {
         // translate property name to SQL column name
         $keyTranslate = $this->translatePropertyToColumnSQL($key);
         if (is_int($key) and is_array($value)) {
             // multiple parameters in array must be first condition like (col = ? OR col = ? OR col2 = ?) and next is parameters
             $value[0] = $this->translatePropertyToColumnSQL($value[0]);
             call_user_func_array([$selection, "where"], $value);
         } else {
             $selection->where($keyTranslate, $value);
         }
     }
     // compose permanently filter
     foreach ($this->getPermanentlyFilter() as $key => $value) {
         // translate property name to SQL column name
         $keyTranslate = $this->translatePropertyToColumnSQL($key);
         if (is_int($key) and is_array($value)) {
             // multiple parameters in array must be first condition like (col = ? OR col = ? OR col2 = ?) and next is parameters
             $value[0] = $this->translatePropertyToColumnSQL($value[0]);
             call_user_func_array([$selection, "where"], $value);
         } else {
             $selection->where($keyTranslate, $value);
         }
     }
     // compose Order
     if ($order !== null) {
         $orderString = "";
         foreach ($order as $column => $ascdesc) {
             // translate properties to SQL column name
             $columnTranslate = $this->translatePropertyToColumnSQL($column);
             $orderString .= ($orderString ? "," : "") . $columnTranslate . (strtolower($ascdesc) == "desc" ? " DESC" : "");
         }
         if ($orderString) {
             $selection->order($orderString);
         } else {
         }
     }
     // compose Limit
     if ($limit !== null) {
         if ($offset !== null) {
             $selection->limit((int) $limit, (int) $offset);
         } else {
             $selection->limit((int) $limit);
         }
     }
     if ($limit !== null and !$order) {
         // is MS SQL? need order for OFFSET
         if ($this->database->getConnection()->getSupplementalDriver() instanceof Nette\Database\Drivers\SqlsrvDriver) {
             $selection->order($selection->getPrimary());
         }
     }
     return $selection;
 }

 public function __construct(Nette\Database\Context $context)
 {
     trigger_error(sprintf('Class %s is deprecated, use class SqlHandler instead.', __CLASS__), E_USER_DEPRECATED);
     $connection = $context->getConnection();
     $driver = $connection->getSupplementalDriver();
     $dbal = new NetteAdapter($connection);
     if ($driver instanceof Nette\Database\Drivers\PgSqlDriver) {
         parent::__construct(new PgSqlDriver($dbal, 'migrations'));
     } elseif ($driver instanceof Nette\Database\Drivers\MySqlDriver) {
         parent::__construct(new MySqlDriver($dbal, 'migrations'));
     } else {
         throw new \LogicException();
     }
 }

 /**
  * Inserts row in a table.
  * @param  array|\Traversable|Selection array($column => $value)|\Traversable|Selection for INSERT ... SELECT
  * @return IRow|int|bool Returns IRow or number of affected rows for Selection or table without primary key
  */
 public function insert($data)
 {
     if ($data instanceof self) {
         $return = $this->context->queryArgs($this->sqlBuilder->buildInsertQuery() . ' ' . $data->getSql(), $data->getSqlBuilder()->getParameters());
     } else {
         if ($data instanceof \Traversable) {
             $data = iterator_to_array($data);
         }
         $return = $this->context->query($this->sqlBuilder->buildInsertQuery() . ' ?values', $data);
     }
     $this->loadRefCache();
     if ($data instanceof self || $this->primary === NULL) {
         unset($this->refCache['referencing'][$this->getGeneralCacheKey()][$this->getSpecificCacheKey()]);
         return $return->getRowCount();
     }
     $primarySequenceName = $this->getPrimarySequence();
     $primaryKey = $this->context->getInsertId(!empty($primarySequenceName) ? $this->context->getConnection()->getSupplementalDriver()->delimite($primarySequenceName) : $primarySequenceName);
     if ($primaryKey === FALSE) {
         unset($this->refCache['referencing'][$this->getGeneralCacheKey()][$this->getSpecificCacheKey()]);
         return $return->getRowCount();
     }
     if (is_array($this->getPrimary())) {
         $primaryKey = array();
         foreach ((array) $this->getPrimary() as $key) {
             if (!isset($data[$key])) {
                 return $data;
             }
             $primaryKey[$key] = $data[$key];
         }
         if (count($primaryKey) === 1) {
             $primaryKey = reset($primaryKey);
         }
     }
     $row = $this->createSelectionInstance()->select('*')->wherePrimary($primaryKey)->fetch();
     if ($this->rows !== NULL) {
         if ($signature = $row->getSignature(FALSE)) {
             $this->rows[$signature] = $row;
             $this->data[$signature] = $row;
         } else {
             $this->rows[] = $row;
             $this->data[] = $row;
         }
     }
     return $row;
 }

 protected function execute(InputInterface $input, OutputInterface $output)
 {
     $connection = $this->database->getConnection();
     $driverName = $connection->getPdo()->getAttribute(\PDO::ATTR_DRIVER_NAME);
     Nette\Database\Helpers::loadFromFile($connection, $this->getFileName($driverName . '.' . static::FILE_LABELS_TABLE));
 }

 /** @param  NdbContext $database */
 public function __construct(NdbContext $database)
 {
     $this->database = $database;
     $this->transaction = new Transaction($database->getConnection());
 }

 public function getPdo()
 {
     return $this->context->getConnection()->getPdo();
 }

 public function __construct(Nette\Database\Context $context, $tableName)
 {
     trigger_error(sprintf('Class %s is deprecated, use class MySqlDriver instead.', __CLASS__), E_USER_DEPRECATED);
     parent::__construct(new NetteAdapter($context->getConnection()), $tableName);
 }

 public function __construct(Context $context, $tableName)
 {
     $this->context = $context;
     $this->delimitedTableName = $context->getConnection()->getSupplementalDriver()->delimite($tableName);
     $this->delimitedLockTableName = $context->getConnection()->getSupplementalDriver()->delimite($tableName . '_lock');
 }

 public function renderFilter($categoryId = null, $manufacturerId = null)
 {
     $this->template->goodsRecommended = array();
     $this->template->goodsOther = array();
     $this->template->selectedCategoryId = $categoryId;
     $this->template->selectedSubcategoryId = $categoryId;
     $this->template->selectedManufacturerId = $manufacturerId;
     if ($categoryId && $manufacturerId) {
         $category = $this->category->createSelectionInstance()->get($categoryId);
         $manufacturer = $this->manufacturer->get($manufacturerId);
         if (!$category || !$manufacturer) {
             $this->flashMessage('Kategorie nebo výrobce nebyl nalezen.', 'warning');
         } else {
             $parentCategory = $category->parent ? $this->category->createSelectionInstance()->get($category->parent) : null;
             $this->template->filterName = ($parentCategory ? $parentCategory->name . ' - ' : '') . $category->name . " od " . $manufacturer->name;
             $this->template->og = ['title' => $this->template->filterName . ' - alena.cz', 'description' => strip_tags($category->description)];
             $in = $category . ',';
             $subcategories = $category->related('category.parent');
             foreach ($subcategories as $subcategory) {
                 $in .= $subcategory . ',';
             }
             $in = rtrim($in, ',');
             $sql = "SELECT g.id\n\t\t\t\t\t\tFROM category_goods cg\n\t\t\t\t\t\tJOIN goods g ON cg.`goods_id` = g.id\n\t\t\t\t\t\tJOIN category c ON cg.`category_id` = c.id\n\t\t\t\t\t\tWHERE cg.`category_id` IN ({$in}) AND g.`manufacturer_id` = {$manufacturerId} AND g.recommended = ";
             $this->template->goodsRecommended = $this->good->createSelectionInstance()->where('id', $this->database->getConnection()->query($sql . "1 GROUP BY id")->fetchPairs());
             $this->template->goodsOther = $this->good->createSelectionInstance()->where('id', $this->database->getConnection()->query($sql . "0 GROUP BY id")->fetchPairs());
             if ($category->parent) {
                 $this->template->selectedCategoryId = $category->parent;
                 $this->template->selectedSubCategoryId = $categoryId;
             } else {
                 $this->template->selectedCategoryId = $categoryId;
             }
         }
     } elseif ($categoryId) {
         $category = $this->category->createSelectionInstance()->get($categoryId);
         if (!$category) {
             $this->flashMessage('Kategorie nebyla nalezena.', 'warning');
         } else {
             $parentCategory = $category->parent ? $this->category->createSelectionInstance()->get($category->parent) : null;
             $this->template->filterName = ($parentCategory ? $parentCategory->name . ' - ' : '') . $category->name;
             $this->template->og = ['title' => $this->template->filterName . ' - alena.cz', 'description' => strip_tags($category->description)];
             $in = $category . ',';
             $subcategories = $category->related('category.parent');
             foreach ($subcategories as $subcategory) {
                 $in .= $subcategory . ',';
             }
             $in = rtrim($in, ',');
             $sql = "SELECT g.id\n\t\t\t\t\t\tFROM category_goods cg\n\t\t\t\t\t\tJOIN goods g ON cg.`goods_id` = g.id\n\t\t\t\t\t\tJOIN category c ON cg.`category_id` = c.id\n\t\t\t\t\t\tWHERE cg.`category_id` IN ({$in}) AND g.recommended = ";
             $this->template->goodsRecommended = $this->good->createSelectionInstance()->where('id', $this->database->getConnection()->query($sql . "1 GROUP BY id")->fetchPairs());
             $this->template->goodsOther = $this->good->createSelectionInstance()->where('id', $this->database->getConnection()->query($sql . "0 GROUP BY id")->fetchPairs());
             if ($category->parent) {
                 $this->template->selectedCategoryId = $category->parent;
                 $this->template->selectedSubCategoryId = $categoryId;
             } else {
                 $this->template->selectedCategoryId = $categoryId;
             }
         }
     } elseif ($manufacturerId) {
         $manufacturer = $this->manufacturer->get($manufacturerId);
         if (!$manufacturer) {
             $this->flashMessage('Výrobce nebyl nalezen.', 'warning');
         } else {
             $this->template->filterName = $manufacturer->name;
             $this->template->goodsRecommended = $this->good->where('manufacturer_id = ? AND recommended != 0', $manufacturerId)->order('id DESC');
             $this->template->goodsOther = $this->good->createSelectionInstance()->where('manufacturer_id = ? AND recommended = 0', $manufacturerId)->order('id DESC');
             $this->template->selectedManufacturer = $manufacturerId;
             $this->template->og = ['title' => $this->template->filterName . ' - alena.cz', 'description' => strip_tags($manufacturer->description)];
         }
     } else {
         $this->redirect("default");
     }
 }

 public function __construct($table, Nette\Database\Context $context)
 {
     parent::__construct($context->getConnection(), $table, $context->getDatabaseReflection());
 }