コード例 #1
0
 public function setUp()
 {
     parent::setUp();
     if (self::$generated === false) {
         /* @var $sm \Doctrine\DBAL\Schema\AbstractSchemaManager */
         $table = new \Doctrine\DBAL\Schema\Table("fetch_table");
         $table->addColumn('test_int', 'integer');
         $table->addColumn('test_string', 'string');
         $table->addColumn('test_datetime', 'datetime', array('notnull' => false));
         $table->setPrimaryKey(array('test_int'));
         $sm = $this->_conn->getSchemaManager();
         $sm->createTable($table);
         $this->_conn->insert('fetch_table', array('test_int' => 1, 'test_string' => 'foo', 'test_datetime' => '2010-01-01 10:10:10'));
         self::$generated = true;
     }
 }
コード例 #2
0
 public function setUp()
 {
     parent::setUp();
     try {
         /* @var $sm \Doctrine\DBAL\Schema\AbstractSchemaManager */
         $table = new \Doctrine\DBAL\Schema\Table("write_table");
         $table->addColumn('id', 'integer', array('autoincrement' => true));
         $table->addColumn('test_int', 'integer');
         $table->addColumn('test_string', 'string', array('notnull' => false));
         $table->setPrimaryKey(array('id'));
         foreach ($this->_conn->getDatabasePlatform()->getCreateTableSQL($table) as $sql) {
             $this->_conn->executeQuery($sql);
         }
     } catch (\Exception $e) {
     }
     $this->_conn->executeUpdate('DELETE FROM write_table');
 }