Description sfPropelSqlDiff plugin generate diff.sql file, which contains difference beetween schema.yml and current database structure. Categories Behavior

Leads

Name	Email
Sergey Smirnov	ur.kb <<ta>> gresms

Releases for sf 1.1

Releases for sf 1.0

Copyright (c) 2008 Smirnov Sergey

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Join this plugin team

Other releases

Release 0.1.4 - 22/04/2008

Release 0.1.3 - 11/04/2008

Installation for sf 1.1

php symfony plugin:install sfPropelSqlDiffPlugin --release=0.1.4 

Installation for sf 1.0

php symfony plugin-install http://plugins.symfony-project.org/sfPropelSqlDiffPlugin 

PEAR

Download the PEAR package

Repository

Go to the repository: http://svn.symfony-project.com/plugins/sfPropelSqlDiffPlugin

sfPropelSqlDiffPlugin

sfPropelSqlDiff plugin generate diff.sql file, which contains difference beetween schema.yml and current database structure.

Description

It provides new symfony task - propel-build-sql-diff which will create file diff.sql with ALTER TABLE statements, whitch will make current database structure exactly as it described schema.yml without deleting data in tables as it does propel-build-sql task.

Currently it handles:

• creation and deletion of tables/fields/indexes/foreign keys

• changing fields/indexes/foreign keys

Plugin is in beta state now. It is tested only for mysql. You can discuss it at thread in symfony forum

Installation

  symfony plugin-install http://plugins.symfony-project.com/sfPropelSqlDiffPlugin
  symfony cc

Usage

After making changes in schema.yml

  symfony propel-build-sql-diff frontend

(first parameter is application name, second, if not ommited, environment)

Then you can find sql file at data/sql/diff.sql

To execute diff.sql

  symfony propel-insert-sql-diff frontend

To run model rebuild and apply database changes to database

  symfony propel-update-all frontend

Changelog

0.1.3

• symfony 1.1 compatible

0.1.2

• added task propel-update-all
• fixed problem with short open tags
• fixed problem with "foreign key constraint fails" error during diff.sql execution

0.1.1

• added task propel-insert-sql-diff
• fixed php notices
• fixed problem with default values like ''