A small wrapper around the pdo object which allows late/on demand initialization of the database connection.
The Schema class imports or updates SQL database schemata. Schemata are described by common SQL files with update instructions in comments. SQL files can also be templates to allow for prefixing/replacement of table identifiers.
- @@version
- mandatory, labels the following code with a version identifier
- @@tablename
- mandatory, declares database tablename to be updated
- marks table identifier for replacement function
- @@connection
- marks table identifiers for replacement function
SQL schema file (schema.sql)
# @tablename example
# @version 0.1
CREATE TABLE example (
uid int(10) unsigned NOT NULL DEFAULT '0',
pid int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
# @version 0.2
ALTER TABLE example
ADD COLUMN did int(10) unsigned NOT NULL DEFAULT '0' AFTER pid;$schema = new Schema($pdo);
$schema->setReplace(
function ($tableName) {
return 'prefix_' . $tableName;
}
);
$schema->loadFile('schema.sql');