Nette\Database\Drivers\SqliteDriver::getForeignKeys PHP Method

getForeignKeys() public method

Returns metadata for all foreign keys in a table.
public getForeignKeys ( $table )
    public function getForeignKeys($table)
    {
        $keys = [];
        foreach ($this->connection->query("PRAGMA foreign_key_list({$this->delimite($table)})") as $row) {
            $keys[$row['id']]['name'] = $row['id'];
            // foreign key name
            $keys[$row['id']]['local'] = $row['from'];
            // local columns
            $keys[$row['id']]['table'] = $row['table'];
            // referenced table
            $keys[$row['id']]['foreign'] = $row['to'];
            // referenced columns
            $keys[$row['id']]['onDelete'] = $row['on_delete'];
            $keys[$row['id']]['onUpdate'] = $row['on_update'];
            if ($keys[$row['id']]['foreign'][0] == NULL) {
                $keys[$row['id']]['foreign'] = NULL;
            }
        }
        return array_values($keys);
    }