public function test_generate_table_without_primary_key()
{
$tableDefinition = new Ruckusing_Adapter_Sqlite3_TableDefinition($this->adapter, "users", array('id' => false));
$tableDefinition->column("first_name", "string");
$tableDefinition->column("last_name", "string", array('limit' => 32));
$tableDefinition->finish();
$column = $this->adapter->column_info("users", "id");
$this->assertEquals(array(), $column);
$primary_keys = $this->adapter->primary_keys('users');
$this->assertEquals(array(), $primary_keys);
}
/**
* @return string
*/
private function keys()
{
if (count($this->_primary_keys) > 0) {
$lead = ' PRIMARY KEY (';
$quoted = array();
foreach ($this->_primary_keys as $key) {
$quoted[] = sprintf("%s", $this->_adapter->identifier($key));
}
$primary_key_sql = ",\n" . $lead . implode(",", $quoted) . ")";
return $primary_key_sql;
} else {
return '';
}
}
/**
* Quote a string
*
* @param string $str the string to quote
*
* @return string
*/
public function quote_string($str)
{
return $this->_adapter->quote_string($str);
}
