migration.sql

CREATE EXTENSION IF NOT EXISTS dblink;

CREATE OR REPLACE FUNCTION remote_exec(suffix text, query text) RETURNS void AS $$
BEGIN
    PERFORM dblink_exec('dbname=' || current_database() || suffix || ' password=MYPASSWORD user=' || current_user, query);
END;
$$
LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION create_lsif_db() RETURNS void AS $$
BEGIN
    IF NOT EXISTS (SELECT FROM pg_catalog.pg_database WHERE datname = current_database() || '_lsif') THEN
        PERFORM remote_exec('', 'CREATE DATABASE "' || current_database() || '_lsif" OWNER DEFAULT TEMPLATE template0 ENCODING ''UTF8''');
    END IF;
END;
$$ LANGUAGE plpgsql;

SELECT create_lsif_db();
DROP FUNCTION create_lsif_db();

SELECT remote_exec('_lsif', 'CREATE EXTENSION IF NOT EXISTS dblink;');

UPDATE schema_migrations SET version='1528395595', dirty='f';