public function schemaTemplate($schemaName)
    {
        return [
            'exists' => (new Query())
                ->select('nspname')
                ->from('pg_namespace')
                ->where('nspname = :value', [':value' => $schemaName])
                ->exists($this->db),
            'up' => "CREATE SCHEMA $schemaName",
            'down' => "DROP SCHEMA $schemaName",
        ];
    }
public function schemaTemplate($schemaName)
    {
        return [
            'exists' => (new Query())
                ->select('nspname')
                ->from('pg_namespace')
                ->where('nspname = :value', [':value' => $schemaName])
                ->exists($this->db),
            'up' => "CREATE SCHEMA $schemaName",
            'down' => "DROP SCHEMA $schemaName",
        ];
    }
public function schemaTemplate ( $ schemaName ) { return [ 'exists' => ( new Query ( ) ) -> select ( 'nspname' ) -> from ( 'pg_namespace' ) -> where ( 'nspname = :value' , [ ':value' => $ schemaName ] ) -> exists ( $ this -> db ) , 'up' => "CREATE SCHEMA $schemaName" , 'down' => "DROP SCHEMA $schemaName" , ] ; }
Returns two queries, to create and destroy the audits schema.
@param string $schemaName
@return array with three keys: exists(boolean), up(string) and down(string)
Returns two queries to create and destroy the audits schema .