public function up() { $t = new STable(); $t->addColumn('content', 'text'); $t->addColumn('remind_at', 'datetime'); $this->createTable('reminders', $t); }
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) { } }