Ruckusing_Adapter_Sqlite3_Base::primary_keys PHP Méthode

primary_keys() public méthode

public primary_keys ( $table ) : array
$table
Résultat array
    public function primary_keys($table)
    {
        $result = $this->query('pragma table_info(' . $table . ')');
        $primary_keys = array();
        foreach ($result as $row) {
            if ($row['pk']) {
                $primary_keys[] = array('name' => $row['name'], 'type' => $row['type']);
            }
        }
        return $primary_keys;
    }

Usage Example

 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);
 }