Propel - propel:build-sql - Ability to add CREATE DATABASE .. IF NOT EXISTS

Question

I'm customizing a phpUnderControl build file to use the symfony propel:build-sql functionality to generate .sql files to be loaded for every build (not every test). What I am running into is that the resulting .sql files expect the databases to exist, but as part of the build process, I would like to drop and recreate every database found in the schema.yml file to ensure a clean testing environment.

My question is, is it possible to configure propel:build-sql to behave as though I passed the --add-drop-database mysqldump flag?

propel:build --sql adds `drop table if exists` statements for every tables in the DB. — originof, Jun 19 '12 at 12:03
Looking for the `drop database if exists`. As you stated the `drop table if exists` statements are already present. — Mike Purcell, Jun 19 '12 at 16:38

score 2 · Accepted Answer · answered Aug 08 '12 at 12:27

2

No it's not possible. It's your job to drop/create the database before you run symfony/propel commands.

answered Aug 08 '12 at 12:27

William Durand

5,439
1
26
37

I'm afraid your right. Had to create a bash script to drop/create databases based on the names of the data/sql/*.sql files after doing a `symfony propel:build-sql` command. – Mike Purcell Aug 08 '12 at 19:39

Propel - propel:build-sql - Ability to add CREATE DATABASE .. IF NOT EXISTS

1 Answers1