/** * Create table in databse * * @return void */ protected function createTable() { if (file_exists(__DIR__ . '/Sql/' . strtolower($this->sql->getDbType()) . '.sql')) { $sql = str_replace('[{table}]', $this->sql->getTable(), file_get_contents(__DIR__ . '/Sql/' . strtolower($this->sql->getDbType()) . '.sql')); $queries = explode(';', $sql); foreach ($queries as $query) { if (!empty($query) && $query != '') { $this->sql->db()->query($query); } } } }
public function testSetAndGetTable() { $s = new Sql(Db::factory('Sqlite', array('database' => __DIR__ . '/../tmp/test.sqlite')), 'users'); $s->setTable('user_data'); $this->assertEquals('user_data', $s->getTable()); }