README

SymfonySchemaBundle

安装

获取包

在您的composer.json中添加以下行

{
    "require": {
        "iliev/symfony-schema": "dev-master",
    }
}

初始化包

要开始使用此包，请在您的应用程序的kernel类中注册该包

// app/AppKernel.php
public function registerBundles()
{
    $bundles = array(
        // ...
        new Iliev\SymfonySchemaBundle\IlievSymfonySchemaBundle(),
    );
)

配置参考

以下是包的完整默认配置

# app/config/config.yml
iliev_symfony_schema:
    database:
        # A database connection name that is used to execute the SQL queries
        default_connection: default

        # doctrine or propel
        orm: doctrine

        # A database table name used to track the applied SQL files
        table_name: model_version

    # Path to the directory containing the sql files
    working_path: "%kernel.root_dir%/../schema/sql/updates"

用法

在包的working_path中创建您的更新脚本。建议遵循命名规范以确保增量更新。

示例

$ ls schema/sql/updates/ -l
total 24
-rw-r--r-- 1 user user 181 Jun  9 17:19 20130606-1.sql
-rw-r--r-- 1 user user 135 Jun  9 17:19 20130608-1.sql
-rw-r--r-- 1 user user 270 Jun  9 17:19 20130608-2.sql
-rw-r--r-- 1 user user 537 Jun  9 17:19 20130609-1.sql
-rw-r--r-- 1 user user 360 Jun  9 17:20 20130609-2.sql
-rw-r--r-- 1 user user 184 Jun  9 17:20 20130609-3.sql

每个文件都应该包含一个描述块。

多行示例

# schema/sql/updates/20130609-1.sql

#
# <description>
# Multi-line
# description
# of the update
# </description>
#

ALTER TABLE `accounts` ADD `username_normalized` VARCHAR(255) NOT NULL AFTER `username_canonical`;

单行示例

# schema/sql/updates/20130609-2.sql

#
# --> Single line description
#

ALTER TABLE `accounts` ADD `username_normalized` VARCHAR(255) NOT NULL AFTER `username_canonical`;