Hi have just taken over a project another programmer started which is online. This project runs on symfony 1.2.11
In order to develop it further I need to perform changes on the Database tables by adding columns and make new tables.
I have understood by reading the jobeet tutorial what is the process of creating a database and adding data to it using symfony.
This process consists basically of six steps:
1. Write down the structure on config/schema.yml
2. Generate the sql statements
php symfony propel:Build --sql
3. Create the tables into the DB
php symfony propel:insert-sql
4. Generate the model
php symfony propel:build --model
php symfony propel:build -all
5. Create data files at /data/fixtures.
php symfony propel:data load
This process is very good to start a project but what is much more scary is to perform a change on the data base, build or update the models and be able to retrieve data after that model has been created.
The database has grown so much that even if we make backups we pretend to make such changes and make sure everything goes all right avoiding as much as we can to delete the data or regenerate it.
I want to ask if this process would be the correct one.
1. Go to the database and add a column on the desired table
2. Run php symfony propel:build --model and php symfony propel:build --forms in order to update the model and form files related to the table where the change has been performed
I do not want to run any order that would change or alter the data that is already inside the database.
Is my strategy appropriate? Am I missing something?
Thanks so much for your help in advance.