public function test_generate_table_without_primary_key() { $t1 = new Ruckusing_MySQLTableDefinition($this->adapter, "users", array('id' => false, 'options' => 'Engine=InnoDB')); $t1->column("first_name", "string"); $t1->column("last_name", "string", array('limit' => 32)); $actual = $t1->finish(); $col = $this->adapter->column_info("users", "id"); $this->assertEquals(null, $col); }
public function test_ensure_table_does_exist() { //first make sure the table does not exist $users = $this->adapter->has_table('users', true); $this->assertEquals(false, $users); //create it //$this->adapter->execute_ddl("CREATE TABLE `users` ( name varchar(20) );"); $t1 = new Ruckusing_MySQLTableDefinition($this->adapter, "users", array('options' => 'Engine=InnoDB')); $t1->column("name", "string", array('limit' => 20)); $sql = $t1->finish(); //now make sure it does exist $users = $this->adapter->table_exists('users', true); $this->assertEquals(true, $users); }
public function test_custom_primary_key_1() { $t1 = new Ruckusing_MySQLTableDefinition($this->adapter, "users", array('id' => true, 'options' => 'Engine=InnoDB')); $t1->column("user_id", "integer", array("primary_key" => true)); $actual = $t1->finish(true); $this->remove_table('users'); }
public function test_custom_primary_with_auto_increment() { $t1 = new Ruckusing_MySQLTableDefinition($this->adapter, "users", array('id' => false, 'options' => 'Engine=InnoDB')); $t1->column("user_id", "integer", array('primary_key' => true, 'increment' => true)); $t1->finish(); $col = $this->adapter->column_info("users", "user_id"); $this->assertEquals('auto_increment', $col['extra']); }
public function test_generate_table_with_forced_primary_key_and_with_user_specified_key() { $t1 = new Ruckusing_MySQLTableDefinition($this->adapter, "users", array('options' => 'Engine=InnoDB')); $t1->column("guid", "string", array('primary_key' => true)); $t1->finish(); }