`relstorage.adapters.mysql.schema` – Database schema installers#

Database schema installers

class MySQLSchemaInstaller(driver=None, version_detector=None, **kwargs)[source]#

Bases: AbstractSchemaInstaller

create_procedures(cursor)[source]#: Subclasses should override

COLTYPE_BINARY_STRING = 'BLOB'#: The type of the column used to hold binary strings. Our default is appropriate for PostgreSQL.

COLTYPE_BLOB_CHUNK = 'LONGBLOB'#: The type of the column used to store blob chunks.

COLTYPE_MD5 = 'CHAR(32) CHARACTER SET ascii'#: The type of the column used to store MD5 hash strings.

TRANSACTIONAL_TABLE_SUFFIX = 'ENGINE = InnoDB'#: The suffix needed (after the closing ‘)’) to make sure a table behaves in a transactional manner. Our default is appropriate for PostgreSQL.