002-runner.sql

begin;
set search_path=meta_meta;

CREATE FUNCTION exec(text) RETURNS text AS $$
    BEGIN
    -- raise notice 'exec: %', $1;
    EXECUTE $1;
    RETURN $1;
    END
$$ LANGUAGE plpgsql;

-- all components except downcasts for every entity
select exec(component_statement(e.name, c.name))
from pg_entity e, pg_entity_component c
where c.position < 30
order by e.name, c.position;

-- downcasts to schema_id for everything that has a schema_name
select exec(component_statement(e.name, c.name))
from pg_entity e, pg_entity_component c
where c.position in (30,31) and 'schema_name' = any(constructor_arg_names)
order by e.name, c.position;

-- downcasts to relation_id for everything that has a relation_name
select exec(component_statement(e.name, c.name))
from pg_entity e, pg_entity_component c
where c.position in(32,33) and 'relation_name' = any(constructor_arg_names)
order by e.name, c.position;

-- downcasts to column_id for everything that has a column_name
select exec(component_statement(e.name, c.name))
from pg_entity e, pg_entity_component c
where c.position in(34,35) and 'column_name' = any(constructor_arg_names)
order by e.name, c.position;

/*
field_id cast to row_id

select e.name as entity_name, c.name as component_name, exec(component_statement(e.name, c.name))
from pg_entity e, pg_entity_component c
where c.position in(26,27) and 'column_name' = any(constructor_arg_names)
order by e.name, c.position;
*/

commit;