/** * @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); }