Class Mysql

Constants summary

• int|null
  MAX_ALIAS_LENGTH ¶
  256

Properties summary

• $_autoQuoting protected
  bool

  Indicates whether or not the driver is doing automatic identifier quoting for all queries

• $_baseConfig protected
  array

  Base configuration settings for MySQL driver

• $_config protected
  array

  Configuration data.

• $_connection protected
  \PDO

  Instance of PDO.

• $_endQuote protected
  string

  String used to end a database identifier quoting to make it safe

• $_schemaDialect protected
  \Cake\Database\Schema\MysqlSchema

  The schema dialect class for this driver

• $_startQuote protected
  string

  String used to start a database identifier quoting to make it safe

• $_supportsNativeJson protected
  bool

  Whether or not the server supports native JSON

• $_version protected
  string

  The server version

Method Summary

• __construct() public

  Constructor

• __debugInfo() public

  Returns an array that can be used to describe the internal state of this object.

• __destruct() public

  Destructor

• _connect() protected

  Establishes a connection to the database server

• _deleteQueryTranslator() protected

  Apply translation steps to delete queries.

• _expressionTranslators() protected

  Returns an associative array of methods that will transform Expression objects to conform with the specific SQL dialect. Keys are class names and values a method in this class.

• _insertQueryTranslator() protected

  Apply translation steps to insert queries.

• _removeAliasesFromConditions() protected

  Removes aliases from the WHERE clause of a query.

• _selectQueryTranslator() protected

  Apply translation steps to select queries.

• _transformDistinct() protected

  Returns the passed query after rewriting the DISTINCT clause, so that drivers that do not support the "ON" part can provide the actual way it should be done

• _updateQueryTranslator() protected

  Apply translation steps to update queries.

• beginTransaction() public

  Starts a transaction.

• commitTransaction() public

  Commits a transaction.

• compileQuery() public

  Transforms the passed query to this Driver's dialect and returns an instance of the transformed query and the full compiled SQL string.

• connect() public

  Establishes a connection to the database server

• disableAutoQuoting() public

  Disable auto quoting of identifiers in queries.

• disableForeignKeySQL() public

  Get the SQL for disabling foreign keys.

• disconnect() public

  Disconnects from database server.

• enableAutoQuoting() public

  Sets whether or not this driver should automatically quote identifiers in queries.

• enableForeignKeySQL() public

  Get the SQL for enabling foreign keys.

• enabled() public

  Returns whether php is able to use this driver for connecting to database

• getConnection() public

  Get the internal PDO connection instance.

• getMaxAliasLength() public

  Returns the maximum alias length allowed.

• isAutoQuotingEnabled() public

  Returns whether or not this driver should automatically quote identifiers in queries.

• isConnected() public

  Checks whether or not the driver is connected.

• lastInsertId() public

  Returns last id generated for a table or sequence in database.

• newCompiler() public

  Returns an instance of a QueryCompiler.

• newTableSchema() public

  Constructs new TableSchema.

• prepare() public

  Prepares a sql statement to be executed

• queryTranslator() public

  Returns a callable function that will be used to transform a passed Query object.

• quote() public

  Returns a value in a safe representation to be used in a query string

• quoteIdentifier() public

  Quotes a database identifier (a column name, table name, etc..) to be used safely in queries without the risk of using reserved words

• releaseSavePointSQL() public

  Returns a SQL snippet for releasing a previously created save point

• rollbackSavePointSQL() public

  Returns a SQL snippet for rollbacking a previously created save point

• rollbackTransaction() public

  Rollbacks a transaction.

• savePointSQL() public

  Returns a SQL snippet for creating a new transaction savepoint

• schema() public

  Returns the schema name that's being used.

• schemaDialect() public

  Get the schema dialect.

• schemaValue() public

  Escapes values for use in schema definitions.

• setConnection() public

  Set the internal PDO connection instance.

• supportsDynamicConstraints() public

  Returns whether the driver supports adding or dropping constraints to already created tables.

• supportsNativeJson() public

  Returns true if the server supports native JSON columns

• supportsQuoting() public

  Checks if the driver supports quoting, as PDO_ODBC does not support it.

• supportsSavePoints() public

  Returns whether this driver supports save points for nested transactions.

Method Detail

Property Detail