php-extended/php-db-schema-mysql

A library to abstract the mysql database schema rules

9.5.6 2024-07-31 13:55 UTC

Requires

• php: >=8.0
• php-extended/php-charset-object: ^7
• php-extended/php-db-schema-core: ^9.5

Requires (Dev)

• php-extended/placeholder-phpunit: ^9

MIT

• Anastaszor

• database
• php
• db
• mysql
• schema

README

A library to abstract the mysql database schema rules

Installation

The installation of this library is made via composer and the autoloading of all classes of this library is made through their autoloader.

• Download composer.phar from their website.
• Then run the following command to install this library as dependency :
• php composer.phar php-extended/php-db-schema-mysql ^9

Basic Usage

This library can generate CREATE DATABASE statements.

use PhpExtended\DbSchema\MysqlTableFactory;
use PhpExtended\DbSchema\MysqlDialect;
use PhpExtended\DbSchema\MysqlTypeNumber;
use PhpExtended\DbSchema\MysqlTypeString;

$factory = new MysqlTableFactory();
$dialect = new MysqlDialect();

$factory->setName('<tableName>');

// <tableColumnId> INT(11) NOT NULL AUTO_INCREMENT COMMENT 'The primary key'
$factory->addColumn('<tableColumnId>', MysqlTypeNumber::INT(), 11, null, null, false, true, 'The primary key');
// <nameColumn> VARCHAR(255) NOT NULL COMMENT 'The name of the <xxx>'
$factory->addColumn('<nameColumn>', MysqlTypeString::VARCHAR(), 255, null, null, false, false, 'The name of the <xxx>');
$factory->addsToPrimaryKey('<tableColumnId>');

$sql = $dialect->showCreateTable($factory->getTable());	// CREATE TABLE ...

License

MIT (See license file).