depage/db

depage-pdo is a small wrapper around the pdo object which allows late/on demand initializition of the database connection.

Maintainers

Details

github.com/depage/depage-db

Source

Issues

Installs: 705

Dependents: 6

Suggesters: 0

Security: 0

Stars: 1

Watchers: 3

Forks: 1

Open Issues: 0

1.4.0 2014-02-24 00:00 UTC

Requires

  • php: >= 5.3

MIT, GPL-2.0 a1beb850d1b80cb6bb3f6d638c14f1b697f604a2

databasedbpdo

This package is auto-updated.

Last update: 2024-11-19 16:33:57 UTC

README

PDO Wrapper

A small wrapper around the pdo object which allows late/on demand initialization of the database connection.

Schema

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.

Instruction tags

  • @@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

Example

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;

Import/update in PHP

$schema = new Schema($pdo);
$schema->setReplace(
    function ($tableName) {
        return 'prefix_' . $tableName;
    }
);
$schema->loadFile('schema.sql');

License (dual)