public function up()
 {
     $t = new STable();
     $t->addColumn('content', 'text');
     $t->addColumn('remind_at', 'datetime');
     $this->createTable('reminders', $t);
 }
예제 #2
0
 public function testRenameTable()
 {
     $t = new STable();
     $t->addColumn('url', 'string');
     SActiveRecord::connection()->createTable('bookmarks', $t);
     SActiveRecord::connection()->renameTable('bookmarks', 'favoris');
     $this->assertNothingThrown();
     SActiveRecord::connection()->execute("INSERT INTO favoris (url) VALUES ('http://www.rubyonrails.org')");
     $row = SActiveRecord::connection()->selectOne('SELECT url FROM favoris WHERE id=1');
     $this->assertEqual('http://www.rubyonrails.org', $row['url']);
     try {
         SActiveRecord::connection()->dropTable('bookmarks');
     } catch (Exception $e) {
     }
     try {
         SActiveRecord::connection()->dropTable('favoris');
     } catch (Exception $e) {
     }
 }