db.zep

/*
 +------------------------------------------------------------------------+
 | Phalcon Framework                                                      |
 +------------------------------------------------------------------------+
 | Copyright (c) 2011-2015 Phalcon Team (http://www.phalconphp.com)       |
 +------------------------------------------------------------------------+
 | This source file is subject to the New BSD License that is bundled     |
 | with this package in the file docs/LICENSE.txt.                        |
 |                                                                        |
 | If you did not receive a copy of the license and are unable to         |
 | obtain it through the world-wide-web, please send an email             |
 | to license@phalconphp.com so we can send you a copy immediately.       |
 +------------------------------------------------------------------------+
 | Authors: Andres Gutierrez <andres@phalconphp.com>                      |
 |          Eduar Carvajal <eduar@phalconphp.com>                         |
 +------------------------------------------------------------------------+
 */

namespace Phalcon;

use \PDO as Pdo;

/**
 * Phalcon\Db
 *
 * Phalcon\Db and its related classes provide a simple SQL database interface for Phalcon Framework.
 * The Phalcon\Db is the basic class you use to connect your PHP application to an RDBMS.
 * There is a different adapter class for each brand of RDBMS.
 *
 * This component is intended to lower level database operations. If you want to interact with databases using
 * higher level of abstraction use Phalcon\Mvc\Model.
 *
 * Phalcon\Db is an abstract class. You only can use it with a database adapter like Phalcon\Db\Adapter\Pdo
 *
 *<code>
 *use Phalcon\Db;
 *use Phalcon\Db\Exception;
 *use Phalcon\Db\Adapter\Pdo\Mysql as MysqlConnection;
 *
 *try {
 *
 *  $connection = new MysqlConnection(array(
 *     'host' => '192.168.0.11',
 *     'username' => 'sigma',
 *     'password' => 'secret',
 *     'dbname' => 'blog',
 *     'port' => '3306',
 *  ));
 *
 *  $result = $connection->query("SELECT * FROM robots LIMIT 5");
 *  $result->setFetchMode(Db::FETCH_NUM);
 *  while ($robot = $result->fetch()) {
 *    print_r($robot);
 *  }
 *
 *} catch (Exception $e) {
 *	echo $e->getMessage(), PHP_EOL;
 *} 
 * </code>
 */
abstract class Db
{

	const FETCH_LAZY = \Pdo::FETCH_LAZY;

	const FETCH_ASSOC = \Pdo::FETCH_ASSOC;

	const FETCH_NAMED = \Pdo::FETCH_NAMED;

	const FETCH_NUM = \Pdo::FETCH_NUM;

	const FETCH_BOTH = \Pdo::FETCH_BOTH;

	const FETCH_OBJ = \Pdo::FETCH_OBJ;

	const FETCH_BOUND = \Pdo::FETCH_BOUND;

	const FETCH_COLUMN = \Pdo::FETCH_COLUMN;

	const FETCH_CLASS = \Pdo::FETCH_CLASS;

	const FETCH_INTO = \Pdo::FETCH_INTO;

	const FETCH_FUNC = \Pdo::FETCH_FUNC;

	const FETCH_GROUP = \Pdo::FETCH_GROUP;

	const FETCH_UNIQUE = \Pdo::FETCH_UNIQUE;

	const FETCH_KEY_PAIR = \Pdo::FETCH_KEY_PAIR;

	const FETCH_CLASSTYPE = \Pdo::FETCH_CLASSTYPE;

	const FETCH_SERIALIZE = \Pdo::FETCH_SERIALIZE;

	const FETCH_PROPS_LATE = \Pdo::FETCH_PROPS_LATE;

	/**
	 * Enables/disables options in the Database component
	 */
	public static function setup(array! options) -> void
	{
		var escapeIdentifiers, forceCasting;

		/**
		 * Enables/Disables globally the escaping of SQL identifiers
		 */
		if fetch escapeIdentifiers, options["escapeSqlIdentifiers"] {
			globals_set("db.escape_identifiers", escapeIdentifiers);
		}

		/**
		 * Force cast bound values in the PHP userland
		 */
		if fetch forceCasting, options["forceCasting"] {
			globals_set("db.force_casting", forceCasting);
		}
	}
}