5.7.21. Bugzilla::DB::Mysql¶
5.7.21.1. NAME¶
Bugzilla::DB::Mysql - Bugzilla database compatibility layer for MySQL
5.7.21.2. DESCRIPTION¶
This module overrides methods of the Bugzilla::DB module with MySQL specific implementation. It is instantiated by the Bugzilla::DB module and should never be used directly.
For interface details see Bugzilla::DB and DBI.
5.7.21.3. MYSQL-SPECIFIC DATABASE-READING METHODS¶
These methods read information about the database from the disk, instead of from a Schema object. They are only reliable for MySQL (see bug 285111 for the reasons why not all DBs use/have functions like this), but that's OK because we only need them for backwards-compatibility anyway, for versions of Bugzilla before 2.20.
bz_column_info_real($table, $column)
Description: Returns an abstract column definition for a column as it actually exists on disk in the database. Params: $table - The name of the table the column is on. $column - The name of the column you want info about. Returns: An abstract column definition. If the column does not exist, returns undef.
bz_index_info_real($table, $index)
Description: Returns information about an index on a table in the database. Params: $table = name of table containing the index $index = name of an index Returns: An abstract index definition, always in hashref format. If the index does not exist, the function returns undef.
bz_index_list_real($table)
Description: Returns a list of index names on a table in the database, as it actually exists on disk. Params: $table - The name of the table you want info about. Returns: An array of index names.
5.7.21.4. MYSQL-SPECIFIC "SCHEMA BUILDER"¶
MySQL needs to be able to read in a legacy database (from before Schema existed) and create a Schema object out of it. That's what this code does.
5.7.21.5. Methods in need of POD¶
sql_date_format
bz_explain
bz_last_key
sql_position
sql_fulltext_search
sql_iposition
bz_enum_initial_values
sql_group_by
sql_limit
sql_not_regexp
sql_string_concat
sql_date_math
sql_to_days
bz_check_server_version
sql_from_days
sql_regexp
sql_istring
sql_group_concat
bz_setup_database
bz_db_is_utf8
This documentation undoubtedly has bugs; if you find some, please file them here.