/**
* @author "Lionel Lecaque, <*****@*****.**>"
*/
public function destroyTaoDatabase()
{
$platform = $this->connection->getDatabasePlatform();
$queries = $this->schema->toDropSql($platform);
foreach ($queries as $query) {
$this->connection->executeUpdate($query);
}
//drop sequence
$sm = $this->getSchemaManager();
$sequences = $sm->listSequences();
foreach ($sequences as $name) {
$sm->dropSequence($name);
}
}
$name_table->addColumn("lname", "string", array("length" => 32));
$name_table->setPrimaryKey(array("id"));
$cities_table = $schema->createTable('world_cities');
$cities_table->addColumn("geonameid", "integer", array("unsigned" => true));
$cities_table->addColumn("name", 'string', array('length' => 200));
$cities_table->addColumn("latitude", "decimal", array());
$cities_table->addColumn("longitude", "decimal", array());
$cities_table->addColumn("country_code", "string", array('length' => 3));
$cities_table->addColumn("time_zone", "string", array('length' => 40));
$country_codes = $schema->createTable('countries');
$country_codes->addColumn("name", "string", array("length" => 200));
$country_codes->addColumn("code", 'string', array('length' => 3));
# get queries to apply
$create_schema = $schema->toSql($connection->getDatabasePlatform());
// get queries to create this schema.
$drop_schema = $schema->toDropSql($connection->getDatabasePlatform());
// get queries to safely delete this schema.
$connection->executeQuery($drop_schema[0]);
$connection->executeQuery($drop_schema[1]);
$connection->executeQuery($drop_schema[2]);
$connection->executeQuery($create_schema[0]);
$connection->executeQuery($create_schema[1]);
$connection->executeQuery($create_schema[2]);
$output->writeLn('Finished Running <info>Database Setup</info>');
});
//---------------------------------------------------------------------
// Build pear
//
//--------------------------------------------------------------------
$pear_task = new Command('pear');
$pear_task->setDescription('Run pear package manager');
public function testLuckymallDB()
{
$conn = db::connection();
$myPlatform = $conn->getDatabasePlatform();
$schema = new \Doctrine\DBAL\Schema\Schema();
$myTable = $schema->createTable("my_table");
$myTable->addColumn("id", "integer", array("unsigned" => true));
$myTable->addColumn("username", "string", array("length" => 32));
$myTable->addColumn("booltest", "array");
$myTable->addColumn("xx", "object");
$myTable->setPrimaryKey(array("id"));
$myTable->addUniqueIndex(array("username"));
$myTable->addColumn("money", 'decimal', ['precision' => 10, 'scale' => 3]);
// $schema->createSequence("my_table_seq");
$myForeign = $schema->createTable("my_foreign");
$myForeign->addColumn("id", "integer");
$myForeign->addColumn("user_id", "integer");
$myForeign->addColumn("money", 'decimal', ['precision' => 10, 'scale' => 3]);
$myForeign->addForeignKeyConstraint($myTable, array("user_id"), array("id"), array("onUpdate" => "CASCADE"));
$queries = $schema->toSql($myPlatform);
// get queries to create this schema.
$dropSchema = $schema->toDropSql($myPlatform);
//var_dump($queries);
}
