Aquameta just ate itself

gistfile1.txt

eric@phoenix:~/aquameta$ dropdb aquameta; createdb aquameta ; cat extension-to-bundle.sql | psql -a aquameta
create extension if not exists plpythonu;
CREATE EXTENSION
create extension if not exists multicorn schema public;
CREATE EXTENSION
create extension if not exists hstore schema public;
CREATE EXTENSION
create extension if not exists hstore_plpythonu schema public;
CREATE EXTENSION
create extension if not exists dblink schema public;
CREATE EXTENSION
create extension if not exists "uuid-ossp";
CREATE EXTENSION
create extension if not exists pgcrypto schema public;
CREATE EXTENSION
create extension if not exists pg_catalog_get_defs schema pg_catalog;
CREATE EXTENSION
create extension if not exists plv8;
CREATE EXTENSION
create extension meta;
CREATE EXTENSION
create extension bundle;
CREATE EXTENSION
------------------------------------------------------------------------
-- bundle
------------------------------------------------------------------------
set search_path=bundle;
SET
-- bundle internal tables
insert into bundle.ignored_relation(relation_id) values (meta.relation_id('bundle','bundle'));
INSERT 0 1
insert into bundle.ignored_relation(relation_id) values (meta.relation_id('bundle','commit'));
INSERT 0 1
insert into bundle.ignored_relation(relation_id) values (meta.relation_id('bundle','rowset'));
INSERT 0 1
insert into bundle.ignored_relation(relation_id) values (meta.relation_id('bundle','rowset_row'));
INSERT 0 1
insert into bundle.ignored_relation(relation_id) values (meta.relation_id('bundle','rowset_row_field'));
INSERT 0 1
insert into bundle.ignored_relation(relation_id) values (meta.relation_id('bundle','blob'));
INSERT 0 1
insert into bundle.ignored_relation(relation_id) values (meta.relation_id('bundle','tracked_row_added'));
INSERT 0 1
insert into bundle.bundle (name) values ('org.aquameta.core.bundle');
INSERT 0 1
-- TODO: track the ignored_rows
-- track bundle entities
select bundle.tracked_row_add('org.aquameta.core.bundle', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='schema' and (((row_id).pk_value)::meta.schema_id).name = 'bundle';
                 tracked_row_add                 
-------------------------------------------------
 org.aquameta.core.bundle - meta.schema.(bundle)
(1 row)

select bundle.tracked_row_add('org.aquameta.core.bundle', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='table' and ((((row_id).pk_value)::meta.relation_id)::meta.schema_id).name = 'bundle';
                             tracked_row_add                              
--------------------------------------------------------------------------
 org.aquameta.core.bundle - meta.table.bundle/ignored_row
 org.aquameta.core.bundle - meta.table.bundle/ignored_schema
 org.aquameta.core.bundle - meta.table.bundle/ignored_relation
 org.aquameta.core.bundle - meta.table.bundle/ignored_column
 org.aquameta.core.bundle - meta.table.bundle/stage_row_added
 org.aquameta.core.bundle - meta.table.bundle/stage_row_deleted
 org.aquameta.core.bundle - meta.table.bundle/stage_field_changed
 org.aquameta.core.bundle - meta.table.bundle/trackable_nontable_relation
 org.aquameta.core.bundle - meta.table.bundle/remote_database
(9 rows)

select bundle.tracked_row_add('org.aquameta.core.bundle', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='column' and ((((row_id).pk_value)::meta.column_id)::meta.schema_id).name = 'bundle';
                                          tracked_row_add                                           
----------------------------------------------------------------------------------------------------
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",ignored_row)",row_id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",ignored_row)",id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",ignored_schema)",id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",ignored_schema)",schema_id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",ignored_relation)",id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",ignored_relation)",relation_id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",ignored_column)",id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",ignored_column)",column_id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_row_added)",row_id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_row_added)",bundle_id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_row_added)",id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_row_deleted)",id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_row_deleted)",bundle_id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_row_deleted)",rowset_row_id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_field_changed)",bundle_id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_field_changed)",field_id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_field_changed)",new_value)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_field_changed)",id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",trackable_nontable_relation)",id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",trackable_nontable_relation)",pk_column_id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",remote_database)",dbname)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",remote_database)",port)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",remote_database)",id)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",remote_database)",username)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",remote_database)",password)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",remote_database)",foreign_server_name)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",remote_database)",schema_name)
 org.aquameta.core.bundle - meta.column.("(""(bundle)"",remote_database)",host)
(28 rows)

-- TODO: stage and commit
------------------------------------------------------------------------
-- email
------------------------------------------------------------------------
create extension email;
CREATE EXTENSION
-- track meta entities
insert into bundle.bundle (name) values ('org.aquameta.core.email');
INSERT 0 1
-- schema
select bundle.tracked_row_add('org.aquameta.core.email', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='schema' and (((row_id).pk_value)::meta.schema_id).name = 'email';
                tracked_row_add                
-----------------------------------------------
 org.aquameta.core.email - meta.schema.(email)
(1 row)

-- type_definition
select bundle.tracked_row_add('org.aquameta.core.email', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='type_definition' and ((((row_id).pk_value)::meta.type_id).schema_id).name = 'email';
 tracked_row_add 
-----------------
(0 rows)

-- table
select bundle.tracked_row_add('org.aquameta.core.email', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='table' and ((((row_id).pk_value)::meta.relation_id)::meta.schema_id).name = 'email';
                    tracked_row_add                     
--------------------------------------------------------
 org.aquameta.core.email - meta.table.email/smtp_server
 org.aquameta.core.email - meta.table.email/template
(2 rows)

-- view
select bundle.tracked_row_add('org.aquameta.core.email', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='view' and ((((row_id).pk_value)::meta.relation_id)::meta.schema_id).name = 'email';
 tracked_row_add 
-----------------
(0 rows)

-- column
select bundle.tracked_row_add('org.aquameta.core.email', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='column' and ((((row_id).pk_value)::meta.column_id)::meta.schema_id).name = 'email';
                                 tracked_row_add                                  
----------------------------------------------------------------------------------
 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",ttl_username)
 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",id)
 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",use_ttls)
 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",ttl_password)
 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",port)
 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",hostname)
 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",name)
 org.aquameta.core.email - meta.column.("(""(email)"",template)",subject)
 org.aquameta.core.email - meta.column.("(""(email)"",template)",body_text)
 org.aquameta.core.email - meta.column.("(""(email)"",template)",body_html)
 org.aquameta.core.email - meta.column.("(""(email)"",template)",id)
(11 rows)

-- constraint_check
select bundle.tracked_row_add('org.aquameta.core.email', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='constraint_check' and (((((row_id).pk_value)::meta.constraint_id).table_id)::meta.schema_id).name = 'email';
                                           tracked_row_add                                            
------------------------------------------------------------------------------------------------------
 org.aquameta.core.email - meta.constraint_check.("(""(email)"",smtp_server)",77664_77666_1_not_null)
 org.aquameta.core.email - meta.constraint_check.("(""(email)"",template)",77664_77681_3_not_null)
 org.aquameta.core.email - meta.constraint_check.("(""(email)"",template)",77664_77681_1_not_null)
 org.aquameta.core.email - meta.constraint_check.("(""(email)"",template)",77664_77681_2_not_null)
(4 rows)

-- foreign_key
select bundle.tracked_row_add('org.aquameta.core.email', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='foreign_key' and (((((row_id).pk_value)::meta.constraint_id).table_id)::meta.schema_id).name = 'email';
 tracked_row_add 
-----------------
(0 rows)

-- function_definition
select bundle.tracked_row_add('org.aquameta.core.email', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='function_definition' and ((((row_id).pk_value)::meta.function_id).schema_id).name = 'email';
                                                                              tracked_row_add                                                                               
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 org.aquameta.core.email - meta.function_definition.email/send/{"smtp_server_id uuid","from_email text","to_email text[]","subject text","body text"}
 org.aquameta.core.email - meta.function_definition.email/template_render/{"template text","vars public.hstore"}
 org.aquameta.core.email - meta.function_definition.email/template_send/{"smtp_server_id uuid","from_email text","to_email text[]","template_id uuid","template_args json"}
(3 rows)

select bundle.stage_row_add('org.aquameta.core.email', (row_id::meta.schema_id).name, (row_id::meta.relation_id).name, 'id', (row_id).pk_value) from bundle.tracked_row_added where bundle_id=(select id from bundle.bundle where name='org.aquameta.core.email');
                                                                               stage_row_add                                                                                
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 org.aquameta.core.email - meta.schema.(email)
 org.aquameta.core.email - meta.table.email/smtp_server
 org.aquameta.core.email - meta.table.email/template
 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",ttl_username)
 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",id)
 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",use_ttls)
 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",ttl_password)
 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",port)
 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",hostname)
 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",name)
 org.aquameta.core.email - meta.column.("(""(email)"",template)",subject)
 org.aquameta.core.email - meta.column.("(""(email)"",template)",body_text)
 org.aquameta.core.email - meta.column.("(""(email)"",template)",body_html)
 org.aquameta.core.email - meta.column.("(""(email)"",template)",id)
 org.aquameta.core.email - meta.constraint_check.("(""(email)"",smtp_server)",77664_77666_1_not_null)
 org.aquameta.core.email - meta.constraint_check.("(""(email)"",template)",77664_77681_3_not_null)
 org.aquameta.core.email - meta.constraint_check.("(""(email)"",template)",77664_77681_1_not_null)
 org.aquameta.core.email - meta.constraint_check.("(""(email)"",template)",77664_77681_2_not_null)
 org.aquameta.core.email - meta.function_definition.email/send/{"smtp_server_id uuid","from_email text","to_email text[]","subject text","body text"}
 org.aquameta.core.email - meta.function_definition.email/template_render/{"template text","vars public.hstore"}
 org.aquameta.core.email - meta.function_definition.email/template_send/{"smtp_server_id uuid","from_email text","to_email text[]","template_id uuid","template_args json"}
(21 rows)

select bundle.commit('org.aquameta.core.email','initial import');
NOTICE:  bundle: Committing to org.aquameta.core.email
NOTICE:  bundle: Committing rowset_rows...
NOTICE:  bundle: Committing blobs...
NOTICE:  bundle: Committing stage_row_fields...
NOTICE:  bundle: Creating the commit...
NOTICE:  bundle: Updating bundle.head_commit_id...
NOTICE:  bundle: Cleaning up after commit...
 commit 
--------
 
(1 row)

drop extension email;
DROP EXTENSION
drop schema email;
DROP SCHEMA
select bundle.checkout((select head_commit_id from bundle.bundle where name='org.aquameta.core.email'));
NOTICE:  bundle.checkout(): org.aquameta.core.email / 999f3323-96eb-4b2b-8c70-375c4440e8fb @ 2019-02-08 10:13:19.08106 by <NULL>: "initial import"
 checkout 
----------
 
(1 row)

------------------------------------------------------------------------
-- endpoint
------------------------------------------------------------------------
create extension endpoint;
CREATE EXTENSION
-- track meta entities
insert into bundle.bundle (name) values ('org.aquameta.core.endpoint');
INSERT 0 1
select bundle.tracked_row_add('org.aquameta.core.endpoint', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='schema' and (((row_id).pk_value)::meta.schema_id).name = 'endpoint';
                   tracked_row_add                   
-----------------------------------------------------
 org.aquameta.core.endpoint - meta.schema.(endpoint)
(1 row)

select bundle.tracked_row_add('org.aquameta.core.endpoint', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='type_definition' and ((((row_id).pk_value)::meta.type_id).schema_id).name = 'endpoint';
                                 tracked_row_add                                 
---------------------------------------------------------------------------------
 org.aquameta.core.endpoint - meta.type_definition.("(endpoint)",resource_bin)
 org.aquameta.core.endpoint - meta.type_definition.("(endpoint)",resource_txt)
 org.aquameta.core.endpoint - meta.type_definition.("(endpoint)",column_type)
 org.aquameta.core.endpoint - meta.type_definition.("(endpoint)",join_graph_row)
(4 rows)

select bundle.tracked_row_add('org.aquameta.core.endpoint', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='table' and ((((row_id).pk_value)::meta.relation_id)::meta.schema_id).name = 'endpoint';
                             tracked_row_add                              
--------------------------------------------------------------------------
 org.aquameta.core.endpoint - meta.table.endpoint/mimetype_extension
 org.aquameta.core.endpoint - meta.table.endpoint/column_mimetype
 org.aquameta.core.endpoint - meta.table.endpoint/function_field_mimetype
 org.aquameta.core.endpoint - meta.table.endpoint/resource_binary
 org.aquameta.core.endpoint - meta.table.endpoint/resource_text
 org.aquameta.core.endpoint - meta.table.endpoint/resource_file
 org.aquameta.core.endpoint - meta.table.endpoint/resource_directory
 org.aquameta.core.endpoint - meta.table.endpoint/resource
 org.aquameta.core.endpoint - meta.table.endpoint/mimetype
 org.aquameta.core.endpoint - meta.table.endpoint/template
 org.aquameta.core.endpoint - meta.table.endpoint/template_route
 org.aquameta.core.endpoint - meta.table.endpoint/site_settings
 org.aquameta.core.endpoint - meta.table.endpoint/user
 org.aquameta.core.endpoint - meta.table.endpoint/session
(14 rows)

select bundle.tracked_row_add('org.aquameta.core.endpoint', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='view' and ((((row_id).pk_value)::meta.relation_id)::meta.schema_id).name = 'endpoint';
                       tracked_row_add                        
--------------------------------------------------------------
 org.aquameta.core.endpoint - meta.view.endpoint/current_user
(1 row)

select bundle.tracked_row_add('org.aquameta.core.endpoint', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='column' and ((((row_id).pk_value)::meta.column_id)::meta.schema_id).name = 'endpoint';
                                           tracked_row_add                                           
-----------------------------------------------------------------------------------------------------
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype_extension)",mimetype_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype_extension)",extension)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype_extension)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",column_mimetype)",column_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",column_mimetype)",mimetype_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",column_mimetype)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",schema_name)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",function_name)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",field_name)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",mimetype_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",path)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",mimetype_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",content)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",active)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",path)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",mimetype_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",content)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",active)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_file)",file_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_file)",path)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_file)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_file)",active)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_directory)",directory_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_directory)",path)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_directory)",indexes)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_directory)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",path)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",mimetype_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",active)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",content)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype)",mimetype)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template)",mimetype_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template)",content)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template_route)",template_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template_route)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template_route)",url_pattern)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template_route)",args)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",name)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",site_title)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",site_url)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",smtp_server_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",auth_from_email)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",active)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",email)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",role_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",name)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",active)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",activation_code)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",created_at)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",session)",role_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",session)",user_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",session)",id)
(60 rows)

select bundle.tracked_row_add('org.aquameta.core.endpoint', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='constraint_check' and (((((row_id).pk_value)::meta.constraint_id).table_id)::meta.schema_id).name = 'endpoint';
                                                    tracked_row_add                                                     
------------------------------------------------------------------------------------------------------------------------
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",session)",77769_78005_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",session)",77769_78005_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",function_field_mimetype)",77769_77822_5_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_3_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",mimetype)",77769_77781_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template_route)",77769_77916_4_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_file)",77769_77866_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template_route)",77769_77916_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",column_mimetype)",77769_77808_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_7_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_5_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource)",77769_77885_5_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template)",77769_77901_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",function_field_mimetype)",77769_77822_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_directory)",77769_77876_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_binary)",77769_77836_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template)",77769_77901_3_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_file)",77769_77866_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",column_mimetype)",77769_77808_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_binary)",77769_77836_3_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_file)",77769_77866_4_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template_route)",77769_77916_3_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",mimetype_extension)",77769_77792_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",mimetype)",77769_77781_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",site_settings)",77769_77932_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",mimetype_extension)",77769_77792_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource)",77769_77885_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_text)",77769_77851_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_4_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_text)",77769_77851_5_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template_route)",77769_77916_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",column_mimetype)",77769_77808_3_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_text)",77769_77851_3_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template)",77769_77901_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource)",77769_77885_3_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",site_settings)",77769_77932_6_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_binary)",77769_77836_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource)",77769_77885_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_binary)",77769_77836_5_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_text)",77769_77851_1_not_null)
(42 rows)

select bundle.tracked_row_add('org.aquameta.core.endpoint', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='foreign_key' and (((((row_id).pk_value)::meta.constraint_id).table_id)::meta.schema_id).name = 'endpoint';
                                                           tracked_row_add                                                           
-------------------------------------------------------------------------------------------------------------------------------------
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",column_mimetype)",column_mimetype_mimetype_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",function_field_mimetype)",function_field_mimetype_mimetype_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",mimetype_extension)",mimetype_extension_mimetype_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",resource)",resource_mimetype_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",resource_binary)",resource_binary_mimetype_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",resource_text)",resource_text_mimetype_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",session)",session_user_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",site_settings)",site_settings_smtp_server_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",template)",template_mimetype_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",template_route)",template_route_template_id_fkey)
(10 rows)

select bundle.tracked_row_add('org.aquameta.core.endpoint', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='function_definition' and ((((row_id).pk_value)::meta.function_id).schema_id).name = 'endpoint';
                                                                                                            tracked_row_add                                                                                                             
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 org.aquameta.core.endpoint - meta.function_definition.endpoint/resource_bin/{"value json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/resource_txt/{"value json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/is_indexed/{"_path text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/set_mimetype/{"_schema name","_table name","_column name","_mimetype text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/columns_json/{"_schema_name text","_relation_name text","exclude text[]","include text[]","OUT json json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/pk/{"_schema_name name","_relation_name name","OUT pk_name text","OUT pk_type text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/pk_name/{"_schema_name name","_relation_name name"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/construct_join_graph/{"temp_table_name text","start_rowset json","subrowsets json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/multiple_row_insert/{"relation_id meta.relation_id","args json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/suffix_clause/{"args json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_insert/{"args json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/row_insert/{"relation_id meta.relation_id","args json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/is_json_object/{"value text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/is_json_array/{"value text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/row_update/{"row_id meta.row_id","args json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/row_select/{"row_id meta.row_id","args json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/field_select/{"field_id meta.field_id","OUT field text","OUT mimetype text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/column_list/{"_schema_name text","_relation_name text","table_alias text","exclude text[]","include text[]","OUT column_list text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_select/{"relation_id meta.relation_id","args json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_select_function/{"function_id meta.function_id","args json","OUT result text","OUT mimetype text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/anonymous_rows_select_function/{"_schema_name text","_function_name text","args json","OUT result text","OUT mimetype text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_select_function/{"function_id meta.function_id","args json","column_name text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/row_delete/{"row_id meta.row_id"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_delete/{"relation_id meta.relation_id","args json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/request/{"version text","verb text","path text","query_args json","post_data json","OUT status integer","OUT message text","OUT response text","OUT mimetype text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/user_insert/{""}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/user_update/{""}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/user_delete/{""}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/current_user/{""}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/session/{"session_id uuid"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/register/{"_email text","_password text","fullname text DEFAULT ''::text","send_email boolean DEFAULT true","OUT code integer","OUT message text","OUT role_name text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/register_confirm/{"_email text","_confirmation_code text","send_email boolean DEFAULT true"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/login/{"_email text","_password text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/logout/{"_email text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/superuser/{"_email text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/email/{"from_email text","to_email text[]","subject text","body text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/template_render/{"template_id uuid","route_args json DEFAULT '{}'::json","url_args json DEFAULT '{}'::json"}
(37 rows)

select bundle.stage_row_add('org.aquameta.core.endpoint', (row_id::meta.schema_id).name, (row_id::meta.relation_id).name, 'id', (row_id).pk_value) from bundle.tracked_row_added where bundle_id=(select id from bundle.bundle where name='org.aquameta.core.endpoint');
                                                                                                             stage_row_add                                                                                                              
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 org.aquameta.core.endpoint - meta.schema.(endpoint)
 org.aquameta.core.endpoint - meta.type_definition.("(endpoint)",resource_bin)
 org.aquameta.core.endpoint - meta.type_definition.("(endpoint)",resource_txt)
 org.aquameta.core.endpoint - meta.type_definition.("(endpoint)",column_type)
 org.aquameta.core.endpoint - meta.type_definition.("(endpoint)",join_graph_row)
 org.aquameta.core.endpoint - meta.table.endpoint/mimetype_extension
 org.aquameta.core.endpoint - meta.table.endpoint/column_mimetype
 org.aquameta.core.endpoint - meta.table.endpoint/function_field_mimetype
 org.aquameta.core.endpoint - meta.table.endpoint/resource_binary
 org.aquameta.core.endpoint - meta.table.endpoint/resource_text
 org.aquameta.core.endpoint - meta.table.endpoint/resource_file
 org.aquameta.core.endpoint - meta.table.endpoint/resource_directory
 org.aquameta.core.endpoint - meta.table.endpoint/resource
 org.aquameta.core.endpoint - meta.table.endpoint/mimetype
 org.aquameta.core.endpoint - meta.table.endpoint/template
 org.aquameta.core.endpoint - meta.table.endpoint/template_route
 org.aquameta.core.endpoint - meta.table.endpoint/site_settings
 org.aquameta.core.endpoint - meta.table.endpoint/user
 org.aquameta.core.endpoint - meta.table.endpoint/session
 org.aquameta.core.endpoint - meta.view.endpoint/current_user
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype_extension)",mimetype_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype_extension)",extension)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype_extension)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",column_mimetype)",column_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",column_mimetype)",mimetype_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",column_mimetype)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",schema_name)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",function_name)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",field_name)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",mimetype_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",path)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",mimetype_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",content)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",active)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",path)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",mimetype_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",content)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",active)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_file)",file_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_file)",path)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_file)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_file)",active)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_directory)",directory_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_directory)",path)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_directory)",indexes)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_directory)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",path)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",mimetype_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",active)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",content)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype)",mimetype)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template)",mimetype_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template)",content)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template_route)",template_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template_route)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template_route)",url_pattern)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template_route)",args)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",name)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",site_title)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",site_url)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",smtp_server_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",auth_from_email)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",active)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",email)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",role_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",name)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",active)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",activation_code)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",created_at)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",session)",role_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",session)",user_id)
 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",session)",id)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",session)",77769_78005_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",session)",77769_78005_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",function_field_mimetype)",77769_77822_5_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_3_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",mimetype)",77769_77781_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template_route)",77769_77916_4_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_file)",77769_77866_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template_route)",77769_77916_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",column_mimetype)",77769_77808_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_7_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_5_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource)",77769_77885_5_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template)",77769_77901_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",function_field_mimetype)",77769_77822_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_directory)",77769_77876_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_binary)",77769_77836_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template)",77769_77901_3_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_file)",77769_77866_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",column_mimetype)",77769_77808_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_binary)",77769_77836_3_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_file)",77769_77866_4_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template_route)",77769_77916_3_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",mimetype_extension)",77769_77792_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",mimetype)",77769_77781_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",site_settings)",77769_77932_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",mimetype_extension)",77769_77792_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource)",77769_77885_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_text)",77769_77851_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_4_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_text)",77769_77851_5_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template_route)",77769_77916_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",column_mimetype)",77769_77808_3_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_text)",77769_77851_3_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template)",77769_77901_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource)",77769_77885_3_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",site_settings)",77769_77932_6_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_binary)",77769_77836_2_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource)",77769_77885_1_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_binary)",77769_77836_5_not_null)
 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_text)",77769_77851_1_not_null)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",column_mimetype)",column_mimetype_mimetype_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",function_field_mimetype)",function_field_mimetype_mimetype_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",mimetype_extension)",mimetype_extension_mimetype_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",resource)",resource_mimetype_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",resource_binary)",resource_binary_mimetype_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",resource_text)",resource_text_mimetype_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",session)",session_user_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",site_settings)",site_settings_smtp_server_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",template)",template_mimetype_id_fkey)
 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",template_route)",template_route_template_id_fkey)
 org.aquameta.core.endpoint - meta.function_definition.endpoint/resource_bin/{"value json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/resource_txt/{"value json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/is_indexed/{"_path text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/set_mimetype/{"_schema name","_table name","_column name","_mimetype text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/columns_json/{"_schema_name text","_relation_name text","exclude text[]","include text[]","OUT json json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/pk/{"_schema_name name","_relation_name name","OUT pk_name text","OUT pk_type text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/pk_name/{"_schema_name name","_relation_name name"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/construct_join_graph/{"temp_table_name text","start_rowset json","subrowsets json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/multiple_row_insert/{"relation_id meta.relation_id","args json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/suffix_clause/{"args json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_insert/{"args json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/row_insert/{"relation_id meta.relation_id","args json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/is_json_object/{"value text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/is_json_array/{"value text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/row_update/{"row_id meta.row_id","args json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/row_select/{"row_id meta.row_id","args json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/field_select/{"field_id meta.field_id","OUT field text","OUT mimetype text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/column_list/{"_schema_name text","_relation_name text","table_alias text","exclude text[]","include text[]","OUT column_list text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_select/{"relation_id meta.relation_id","args json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_select_function/{"function_id meta.function_id","args json","OUT result text","OUT mimetype text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/anonymous_rows_select_function/{"_schema_name text","_function_name text","args json","OUT result text","OUT mimetype text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_select_function/{"function_id meta.function_id","args json","column_name text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/row_delete/{"row_id meta.row_id"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_delete/{"relation_id meta.relation_id","args json"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/request/{"version text","verb text","path text","query_args json","post_data json","OUT status integer","OUT message text","OUT response text","OUT mimetype text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/user_insert/{""}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/user_update/{""}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/user_delete/{""}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/current_user/{""}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/session/{"session_id uuid"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/register/{"_email text","_password text","fullname text DEFAULT ''::text","send_email boolean DEFAULT true","OUT code integer","OUT message text","OUT role_name text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/register_confirm/{"_email text","_confirmation_code text","send_email boolean DEFAULT true"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/login/{"_email text","_password text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/logout/{"_email text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/superuser/{"_email text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/email/{"from_email text","to_email text[]","subject text","body text"}
 org.aquameta.core.endpoint - meta.function_definition.endpoint/template_render/{"template_id uuid","route_args json DEFAULT '{}'::json","url_args json DEFAULT '{}'::json"}
(169 rows)

select bundle.commit('org.aquameta.core.endpoint','initial import');
NOTICE:  bundle: Committing to org.aquameta.core.endpoint
NOTICE:  bundle: Committing rowset_rows...
NOTICE:  bundle: Committing blobs...
NOTICE:  bundle: Committing stage_row_fields...
NOTICE:  bundle: Creating the commit...
NOTICE:  bundle: Updating bundle.head_commit_id...
NOTICE:  bundle: Cleaning up after commit...
 commit 
--------
 
(1 row)

drop extension endpoint;
DROP EXTENSION
drop schema endpoint;
DROP SCHEMA
select bundle.checkout((select head_commit_id from bundle.bundle where name='org.aquameta.core.endpoint'));
NOTICE:  bundle.checkout(): org.aquameta.core.endpoint / c3c99d72-ae85-4757-b788-5e3aff46e067 @ 2019-02-08 10:13:44.955788 by <NULL>: "initial import"
 checkout 
----------
 
(1 row)

------------------------------------------------------------------------
-- event
------------------------------------------------------------------------
create extension event;
CREATE EXTENSION
-- track meta entities
insert into bundle.bundle (name) values ('org.aquameta.core.event');
INSERT 0 1
select bundle.tracked_row_add('org.aquameta.core.event', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='schema' and (((row_id).pk_value)::meta.schema_id).name = 'event';
                tracked_row_add                
-----------------------------------------------
 org.aquameta.core.event - meta.schema.(event)
(1 row)

select bundle.tracked_row_add('org.aquameta.core.event', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='type_definition' and ((((row_id).pk_value)::meta.type_id).schema_id).name = 'event';
 tracked_row_add 
-----------------
(0 rows)

select bundle.tracked_row_add('org.aquameta.core.event', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='table' and ((((row_id).pk_value)::meta.relation_id)::meta.schema_id).name = 'event';
                        tracked_row_add                         
----------------------------------------------------------------
 org.aquameta.core.event - meta.table.event/subscription_row
 org.aquameta.core.event - meta.table.event/subscription_table
 org.aquameta.core.event - meta.table.event/subscription_column
 org.aquameta.core.event - meta.table.event/subscription_field
 org.aquameta.core.event - meta.table.event/session
 org.aquameta.core.event - meta.table.event/event
(6 rows)

select bundle.tracked_row_add('org.aquameta.core.event', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='view' and ((((row_id).pk_value)::meta.relation_id)::meta.schema_id).name = 'event';
                    tracked_row_add                     
--------------------------------------------------------
 org.aquameta.core.event - meta.view.event/subscription
(1 row)

select bundle.tracked_row_add('org.aquameta.core.event', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='column' and ((((row_id).pk_value)::meta.column_id)::meta.schema_id).name = 'event';
                                    tracked_row_add                                     
----------------------------------------------------------------------------------------
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_row)",id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_row)",row_id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_row)",session_id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_row)",created_at)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_table)",id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_table)",relation_id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_table)",session_id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_table)",created_at)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_column)",id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_column)",session_id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_column)",column_id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_column)",created_at)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_field)",id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_field)",field_id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_field)",session_id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_field)",created_at)
 org.aquameta.core.event - meta.column.("(""(event)"",session)",id)
 org.aquameta.core.event - meta.column.("(""(event)"",session)",owner_id)
 org.aquameta.core.event - meta.column.("(""(event)"",event)",id)
 org.aquameta.core.event - meta.column.("(""(event)"",event)",session_id)
 org.aquameta.core.event - meta.column.("(""(event)"",event)",created_at)
 org.aquameta.core.event - meta.column.("(""(event)"",event)",event)
(22 rows)

select bundle.tracked_row_add('org.aquameta.core.event', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='constraint_check' and (((((row_id).pk_value)::meta.constraint_id).table_id)::meta.schema_id).name = 'event';
                                               tracked_row_add                                                
--------------------------------------------------------------------------------------------------------------
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",session)",78369_78371_2_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",session)",78369_78371_1_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_table)",78369_78384_2_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_table)",78369_78384_1_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_table)",78369_78384_4_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_column)",78369_78399_2_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_column)",78369_78399_1_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_column)",78369_78399_4_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_row)",78369_78414_2_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_row)",78369_78414_1_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_row)",78369_78414_4_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_field)",78369_78429_2_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_field)",78369_78429_1_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_field)",78369_78429_4_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",event)",78369_78449_2_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",event)",78369_78449_1_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",event)",78369_78449_4_not_null)
(17 rows)

select bundle.tracked_row_add('org.aquameta.core.event', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='foreign_key' and (((((row_id).pk_value)::meta.constraint_id).table_id)::meta.schema_id).name = 'event';
                                                   tracked_row_add                                                    
----------------------------------------------------------------------------------------------------------------------
 org.aquameta.core.event - meta.foreign_key.("(""(event)"",event)",event_session_id_fkey)
 org.aquameta.core.event - meta.foreign_key.("(""(event)"",subscription_column)",subscription_column_session_id_fkey)
 org.aquameta.core.event - meta.foreign_key.("(""(event)"",subscription_field)",subscription_field_session_id_fkey)
 org.aquameta.core.event - meta.foreign_key.("(""(event)"",subscription_row)",subscription_row_session_id_fkey)
 org.aquameta.core.event - meta.foreign_key.("(""(event)"",subscription_table)",subscription_table_session_id_fkey)
(5 rows)

select bundle.tracked_row_add('org.aquameta.core.event', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='function_definition' and ((((row_id).pk_value)::meta.function_id).schema_id).name = 'event';
                                                       tracked_row_add                                                       
-----------------------------------------------------------------------------------------------------------------------------
 org.aquameta.core.event - meta.function_definition.event/session_create/{""}
 org.aquameta.core.event - meta.function_definition.event/session_attach/{"session_id uuid"}
 org.aquameta.core.event - meta.function_definition.event/session_detach/{"session_id uuid"}
 org.aquameta.core.event - meta.function_definition.event/session_delete/{"session_id uuid"}
 org.aquameta.core.event - meta.function_definition.event/event_listener_table/{""}
 org.aquameta.core.event - meta.function_definition.event/event_listener_row/{""}
 org.aquameta.core.event - meta.function_definition.event/subscribe_table/{"session_id uuid","relation_id meta.relation_id"}
 org.aquameta.core.event - meta.function_definition.event/subscribe_column/{"session_id uuid","column_id meta.column_id"}
 org.aquameta.core.event - meta.function_definition.event/subscribe_row/{"session_id uuid","row_id meta.row_id"}
 org.aquameta.core.event - meta.function_definition.event/subscribe_field/{"session_id uuid","field_id meta.field_id"}
(10 rows)

select bundle.stage_row_add('org.aquameta.core.event', (row_id::meta.schema_id).name, (row_id::meta.relation_id).name, 'id', (row_id).pk_value) from bundle.tracked_row_added where bundle_id=(select id from bundle.bundle where name='org.aquameta.core.event');
                                                        stage_row_add                                                        
-----------------------------------------------------------------------------------------------------------------------------
 org.aquameta.core.event - meta.schema.(event)
 org.aquameta.core.event - meta.table.event/subscription_row
 org.aquameta.core.event - meta.table.event/subscription_table
 org.aquameta.core.event - meta.table.event/subscription_column
 org.aquameta.core.event - meta.table.event/subscription_field
 org.aquameta.core.event - meta.table.event/session
 org.aquameta.core.event - meta.table.event/event
 org.aquameta.core.event - meta.view.event/subscription
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_row)",id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_row)",row_id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_row)",session_id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_row)",created_at)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_table)",id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_table)",relation_id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_table)",session_id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_table)",created_at)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_column)",id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_column)",session_id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_column)",column_id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_column)",created_at)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_field)",id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_field)",field_id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_field)",session_id)
 org.aquameta.core.event - meta.column.("(""(event)"",subscription_field)",created_at)
 org.aquameta.core.event - meta.column.("(""(event)"",session)",id)
 org.aquameta.core.event - meta.column.("(""(event)"",session)",owner_id)
 org.aquameta.core.event - meta.column.("(""(event)"",event)",id)
 org.aquameta.core.event - meta.column.("(""(event)"",event)",session_id)
 org.aquameta.core.event - meta.column.("(""(event)"",event)",created_at)
 org.aquameta.core.event - meta.column.("(""(event)"",event)",event)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",session)",78369_78371_2_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",session)",78369_78371_1_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_table)",78369_78384_2_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_table)",78369_78384_1_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_table)",78369_78384_4_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_column)",78369_78399_2_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_column)",78369_78399_1_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_column)",78369_78399_4_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_row)",78369_78414_2_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_row)",78369_78414_1_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_row)",78369_78414_4_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_field)",78369_78429_2_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_field)",78369_78429_1_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_field)",78369_78429_4_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",event)",78369_78449_2_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",event)",78369_78449_1_not_null)
 org.aquameta.core.event - meta.constraint_check.("(""(event)"",event)",78369_78449_4_not_null)
 org.aquameta.core.event - meta.foreign_key.("(""(event)"",event)",event_session_id_fkey)
 org.aquameta.core.event - meta.foreign_key.("(""(event)"",subscription_column)",subscription_column_session_id_fkey)
 org.aquameta.core.event - meta.foreign_key.("(""(event)"",subscription_field)",subscription_field_session_id_fkey)
 org.aquameta.core.event - meta.foreign_key.("(""(event)"",subscription_row)",subscription_row_session_id_fkey)
 org.aquameta.core.event - meta.foreign_key.("(""(event)"",subscription_table)",subscription_table_session_id_fkey)
 org.aquameta.core.event - meta.function_definition.event/session_create/{""}
 org.aquameta.core.event - meta.function_definition.event/session_attach/{"session_id uuid"}
 org.aquameta.core.event - meta.function_definition.event/session_detach/{"session_id uuid"}
 org.aquameta.core.event - meta.function_definition.event/session_delete/{"session_id uuid"}
 org.aquameta.core.event - meta.function_definition.event/event_listener_table/{""}
 org.aquameta.core.event - meta.function_definition.event/event_listener_row/{""}
 org.aquameta.core.event - meta.function_definition.event/subscribe_table/{"session_id uuid","relation_id meta.relation_id"}
 org.aquameta.core.event - meta.function_definition.event/subscribe_column/{"session_id uuid","column_id meta.column_id"}
 org.aquameta.core.event - meta.function_definition.event/subscribe_row/{"session_id uuid","row_id meta.row_id"}
 org.aquameta.core.event - meta.function_definition.event/subscribe_field/{"session_id uuid","field_id meta.field_id"}
(62 rows)

select bundle.commit('org.aquameta.core.event','initial import');
NOTICE:  bundle: Committing to org.aquameta.core.event
NOTICE:  bundle: Committing rowset_rows...
NOTICE:  bundle: Committing blobs...
NOTICE:  bundle: Committing stage_row_fields...
NOTICE:  bundle: Creating the commit...
NOTICE:  bundle: Updating bundle.head_commit_id...
NOTICE:  bundle: Cleaning up after commit...
 commit 
--------
 
(1 row)

drop extension event;
DROP EXTENSION
drop schema event;
DROP SCHEMA
select bundle.checkout((select head_commit_id from bundle.bundle where name='org.aquameta.core.event'));
NOTICE:  bundle.checkout(): org.aquameta.core.event / 215ac89a-eb7c-4eb1-93ce-cd4672c28fc4 @ 2019-02-08 10:15:04.8405 by <NULL>: "initial import"
 checkout 
----------
 
(1 row)

------------------------------------------------------------------------
-- widget
------------------------------------------------------------------------
create extension widget;
CREATE EXTENSION
-- track meta entities
insert into bundle.bundle (name) values ('org.aquameta.core.widget');
INSERT 0 1
select bundle.tracked_row_add('org.aquameta.core.widget', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='schema' and (((row_id).pk_value)::meta.schema_id).name = 'widget';
                 tracked_row_add                 
-------------------------------------------------
 org.aquameta.core.widget - meta.schema.(widget)
(1 row)

select bundle.tracked_row_add('org.aquameta.core.widget', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='type_definition' and ((((row_id).pk_value)::meta.type_id).schema_id).name = 'widget';
 tracked_row_add 
-----------------
(0 rows)

select bundle.tracked_row_add('org.aquameta.core.widget', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='table' and ((((row_id).pk_value)::meta.relation_id)::meta.schema_id).name = 'widget';
                          tracked_row_add                           
--------------------------------------------------------------------
 org.aquameta.core.widget - meta.table.widget/input
 org.aquameta.core.widget - meta.table.widget/dependency_css
 org.aquameta.core.widget - meta.table.widget/widget_dependency_css
 org.aquameta.core.widget - meta.table.widget/dependency_js
 org.aquameta.core.widget - meta.table.widget/widget_dependency_js
 org.aquameta.core.widget - meta.table.widget/widget_view
 org.aquameta.core.widget - meta.table.widget/widget
 org.aquameta.core.widget - meta.table.widget/machine
 org.aquameta.core.widget - meta.table.widget/widget_fsm
(9 rows)

select bundle.tracked_row_add('org.aquameta.core.widget', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='view' and ((((row_id).pk_value)::meta.relation_id)::meta.schema_id).name = 'widget';
                      tracked_row_add                       
------------------------------------------------------------
 org.aquameta.core.widget - meta.view.widget/bundled_widget
 org.aquameta.core.widget - meta.view.widget/widget_name
(2 rows)

select bundle.tracked_row_add('org.aquameta.core.widget', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='column' and ((((row_id).pk_value)::meta.column_id)::meta.schema_id).name = 'widget';
                                          tracked_row_add                                          
---------------------------------------------------------------------------------------------------
 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",widget_id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",default_value)
 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",name)
 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",optional)
 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",help)
 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",test_value)
 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",doc_string)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_css)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_css)",name)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_css)",version)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_css)",content)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_css)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_css)",dependency_css_id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_css)",widget_id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",name)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",content)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",version)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",variable)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_js)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_js)",widget_id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_js)",dependency_js_id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_view)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_view)",view_id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_view)",widget_id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",css)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",help)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",server_js)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",pre_js)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",post_js)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",common_js)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",html)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",name)
 org.aquameta.core.widget - meta.column.("(""(widget)"",machine)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_fsm)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_fsm)",widget_id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_fsm)",machine_id)
(39 rows)

select bundle.tracked_row_add('org.aquameta.core.widget', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='constraint_check' and (((((row_id).pk_value)::meta.constraint_id).table_id)::meta.schema_id).name = 'widget';
                                                 tracked_row_add                                                  
------------------------------------------------------------------------------------------------------------------
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_2_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_1_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_3_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_4_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_5_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_6_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_7_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_8_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_css)",78607_78630_2_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_css)",78607_78630_3_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_css)",78607_78630_4_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_css)",78607_78630_1_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_js)",78607_78641_2_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_js)",78607_78641_3_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_js)",78607_78641_5_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_js)",78607_78641_1_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",input)",78607_78652_2_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",input)",78607_78652_3_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",input)",78607_78652_1_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",input)",78607_78652_4_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_css)",78607_78669_2_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_css)",78607_78669_3_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_css)",78607_78669_1_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_js)",78607_78687_2_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_js)",78607_78687_3_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_js)",78607_78687_1_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_view)",78607_78705_2_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_view)",78607_78705_1_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",machine)",78607_78721_1_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_fsm)",78607_78727_2_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_fsm)",78607_78727_1_not_null)
(31 rows)

select bundle.tracked_row_add('org.aquameta.core.widget', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='foreign_key' and (((((row_id).pk_value)::meta.constraint_id).table_id)::meta.schema_id).name = 'widget';
                                                          tracked_row_add                                                          
-----------------------------------------------------------------------------------------------------------------------------------
 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",input)",input_widget_id_fkey)
 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_dependency_css)",widget_dependency_css_dependency_css_id_fkey)
 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_dependency_css)",widget_dependency_css_widget_id_fkey)
 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_dependency_js)",widget_dependency_js_dependency_js_id_fkey)
 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_dependency_js)",widget_dependency_js_widget_id_fkey)
 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_fsm)",widget_fsm_machine_id_fkey)
 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_fsm)",widget_fsm_widget_id_fkey)
 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_view)",widget_view_widget_id_fkey)
(8 rows)

select bundle.tracked_row_add('org.aquameta.core.widget', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='function_definition' and ((((row_id).pk_value)::meta.function_id).schema_id).name = 'widget';
                                                            tracked_row_add                                                            
---------------------------------------------------------------------------------------------------------------------------------------
 org.aquameta.core.widget - meta.function_definition.widget/get_dependency_js/{"_name character varying","_version character varying"}
 org.aquameta.core.widget - meta.function_definition.widget/bundled_widget/{"bundle_name text","widget_name text"}
(2 rows)

select bundle.stage_row_add('org.aquameta.core.widget', (row_id::meta.schema_id).name, (row_id::meta.relation_id).name, 'id', (row_id).pk_value) from bundle.tracked_row_added where bundle_id=(select id from bundle.bundle where name='org.aquameta.core.widget');
                                                             stage_row_add                                                             
---------------------------------------------------------------------------------------------------------------------------------------
 org.aquameta.core.widget - meta.schema.(widget)
 org.aquameta.core.widget - meta.table.widget/input
 org.aquameta.core.widget - meta.table.widget/dependency_css
 org.aquameta.core.widget - meta.table.widget/widget_dependency_css
 org.aquameta.core.widget - meta.table.widget/dependency_js
 org.aquameta.core.widget - meta.table.widget/widget_dependency_js
 org.aquameta.core.widget - meta.table.widget/widget_view
 org.aquameta.core.widget - meta.table.widget/widget
 org.aquameta.core.widget - meta.table.widget/machine
 org.aquameta.core.widget - meta.table.widget/widget_fsm
 org.aquameta.core.widget - meta.view.widget/bundled_widget
 org.aquameta.core.widget - meta.view.widget/widget_name
 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",widget_id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",default_value)
 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",name)
 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",optional)
 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",help)
 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",test_value)
 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",doc_string)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_css)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_css)",name)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_css)",version)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_css)",content)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_css)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_css)",dependency_css_id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_css)",widget_id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",name)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",content)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",version)
 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",variable)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_js)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_js)",widget_id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_js)",dependency_js_id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_view)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_view)",view_id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_view)",widget_id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",css)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",help)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",server_js)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",pre_js)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",post_js)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",common_js)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",html)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",name)
 org.aquameta.core.widget - meta.column.("(""(widget)"",machine)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_fsm)",id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_fsm)",widget_id)
 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_fsm)",machine_id)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_2_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_1_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_3_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_4_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_5_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_6_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_7_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_8_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_css)",78607_78630_2_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_css)",78607_78630_3_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_css)",78607_78630_4_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_css)",78607_78630_1_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_js)",78607_78641_2_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_js)",78607_78641_3_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_js)",78607_78641_5_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_js)",78607_78641_1_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",input)",78607_78652_2_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",input)",78607_78652_3_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",input)",78607_78652_1_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",input)",78607_78652_4_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_css)",78607_78669_2_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_css)",78607_78669_3_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_css)",78607_78669_1_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_js)",78607_78687_2_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_js)",78607_78687_3_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_js)",78607_78687_1_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_view)",78607_78705_2_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_view)",78607_78705_1_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",machine)",78607_78721_1_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_fsm)",78607_78727_2_not_null)
 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_fsm)",78607_78727_1_not_null)
 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",input)",input_widget_id_fkey)
 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_dependency_css)",widget_dependency_css_dependency_css_id_fkey)
 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_dependency_css)",widget_dependency_css_widget_id_fkey)
 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_dependency_js)",widget_dependency_js_dependency_js_id_fkey)
 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_dependency_js)",widget_dependency_js_widget_id_fkey)
 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_fsm)",widget_fsm_machine_id_fkey)
 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_fsm)",widget_fsm_widget_id_fkey)
 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_view)",widget_view_widget_id_fkey)
 org.aquameta.core.widget - meta.function_definition.widget/get_dependency_js/{"_name character varying","_version character varying"}
 org.aquameta.core.widget - meta.function_definition.widget/bundled_widget/{"bundle_name text","widget_name text"}
(92 rows)

select bundle.commit('org.aquameta.core.widget','initial import');
NOTICE:  bundle: Committing to org.aquameta.core.widget
NOTICE:  bundle: Committing rowset_rows...
NOTICE:  bundle: Committing blobs...
NOTICE:  bundle: Committing stage_row_fields...
NOTICE:  bundle: Creating the commit...
NOTICE:  bundle: Updating bundle.head_commit_id...
NOTICE:  bundle: Cleaning up after commit...
 commit 
--------
 
(1 row)

drop extension widget;
DROP EXTENSION
drop schema widget;
DROP SCHEMA
select bundle.checkout((select head_commit_id from bundle.bundle where name='org.aquameta.core.widget'));
NOTICE:  bundle.checkout(): org.aquameta.core.widget / c0667941-bb35-4862-8cda-f27ce81f9dd6 @ 2019-02-08 10:25:19.469611 by <NULL>: "initial import"
 checkout 
----------
 
(1 row)

------------------------------------------------------------------------
-- semantics
------------------------------------------------------------------------
create extension semantics;
CREATE EXTENSION
-- track meta entities
insert into bundle.bundle (name) values ('org.aquameta.core.semantics');
INSERT 0 1
select bundle.tracked_row_add('org.aquameta.core.semantics', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='schema' and (((row_id).pk_value)::meta.schema_id).name = 'semantics';
                    tracked_row_add                    
-------------------------------------------------------
 org.aquameta.core.semantics - meta.schema.(semantics)
(1 row)

select bundle.tracked_row_add('org.aquameta.core.semantics', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='type_definition' and ((((row_id).pk_value)::meta.type_id).schema_id).name = 'semantics';
 tracked_row_add 
-----------------
(0 rows)

select bundle.tracked_row_add('org.aquameta.core.semantics', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='table' and ((((row_id).pk_value)::meta.relation_id)::meta.schema_id).name = 'semantics';
                           tracked_row_add                           
---------------------------------------------------------------------
 org.aquameta.core.semantics - meta.table.semantics/relation_purpose
 org.aquameta.core.semantics - meta.table.semantics/relation
 org.aquameta.core.semantics - meta.table.semantics/type
 org.aquameta.core.semantics - meta.table.semantics/column_purpose
 org.aquameta.core.semantics - meta.table.semantics/column
 org.aquameta.core.semantics - meta.table.semantics/foreign_key
(6 rows)

select bundle.tracked_row_add('org.aquameta.core.semantics', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='view' and ((((row_id).pk_value)::meta.relation_id)::meta.schema_id).name = 'semantics';
 tracked_row_add 
-----------------
(0 rows)

select bundle.tracked_row_add('org.aquameta.core.semantics', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='column' and ((((row_id).pk_value)::meta.column_id)::meta.schema_id).name = 'semantics';
                                      tracked_row_add                                       
--------------------------------------------------------------------------------------------
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation_purpose)",id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation_purpose)",purpose)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",relation_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",priority)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",purpose_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",widget_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",type_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",priority)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",purpose_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",widget_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column_purpose)",id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column_purpose)",purpose)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",priority)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",purpose_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",widget_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",column_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",foreign_key)",id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",foreign_key)",foreign_key_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",foreign_key)",inline)
(22 rows)

select bundle.tracked_row_add('org.aquameta.core.semantics', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='constraint_check' and (((((row_id).pk_value)::meta.constraint_id).table_id)::meta.schema_id).name = 'semantics';
                                                  tracked_row_add                                                  
-------------------------------------------------------------------------------------------------------------------
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation_purpose)",78953_78955_2_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation_purpose)",78953_78955_1_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_2_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_3_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_4_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_1_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_5_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column_purpose)",78953_78984_2_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column_purpose)",78953_78984_1_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",type)",78953_78993_3_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",type)",78953_78993_4_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",type)",78953_78993_1_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",type)",78953_78993_5_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column)",78953_79013_3_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column)",78953_79013_4_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column)",78953_79013_1_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column)",78953_79013_5_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",foreign_key)",78953_79033_1_not_null)
(18 rows)

select bundle.tracked_row_add('org.aquameta.core.semantics', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='foreign_key' and (((((row_id).pk_value)::meta.constraint_id).table_id)::meta.schema_id).name = 'semantics';
                                            tracked_row_add                                             
--------------------------------------------------------------------------------------------------------
 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",column)",column_purpose_id_fkey)
 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",column)",column_widget_id_fkey)
 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",relation)",relation_purpose_id_fkey)
 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",relation)",relation_widget_id_fkey)
 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",type)",type_purpose_id_fkey)
 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",type)",type_widget_id_fkey)
(6 rows)

select bundle.tracked_row_add('org.aquameta.core.semantics', row_id) from bundle.untracked_row where (row_id::meta.schema_id).name = 'meta' and (row_id::meta.relation_id).name='function_definition' and ((((row_id).pk_value)::meta.function_id).schema_id).name = 'semantics';
                                                                        tracked_row_add                                                                        
---------------------------------------------------------------------------------------------------------------------------------------------------------------
 org.aquameta.core.semantics - meta.function_definition.semantics/relation_widget/{"relation_id meta.relation_id","widget_purpose text","default_bundle text"}
 org.aquameta.core.semantics - meta.function_definition.semantics/column_widget/{"column_id meta.column_id","widget_purpose text","default_bundle text"}
(2 rows)

select bundle.stage_row_add('org.aquameta.core.semantics', (row_id::meta.schema_id).name, (row_id::meta.relation_id).name, 'id', (row_id).pk_value) from bundle.tracked_row_added where bundle_id=(select id from bundle.bundle where name='org.aquameta.core.semantics');
                                                                         stage_row_add                                                                         
---------------------------------------------------------------------------------------------------------------------------------------------------------------
 org.aquameta.core.semantics - meta.schema.(semantics)
 org.aquameta.core.semantics - meta.table.semantics/relation_purpose
 org.aquameta.core.semantics - meta.table.semantics/relation
 org.aquameta.core.semantics - meta.table.semantics/type
 org.aquameta.core.semantics - meta.table.semantics/column_purpose
 org.aquameta.core.semantics - meta.table.semantics/column
 org.aquameta.core.semantics - meta.table.semantics/foreign_key
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation_purpose)",id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation_purpose)",purpose)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",relation_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",priority)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",purpose_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",widget_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",type_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",priority)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",purpose_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",widget_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column_purpose)",id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column_purpose)",purpose)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",priority)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",purpose_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",widget_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",column_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",foreign_key)",id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",foreign_key)",foreign_key_id)
 org.aquameta.core.semantics - meta.column.("(""(semantics)"",foreign_key)",inline)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation_purpose)",78953_78955_2_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation_purpose)",78953_78955_1_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_2_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_3_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_4_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_1_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_5_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column_purpose)",78953_78984_2_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column_purpose)",78953_78984_1_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",type)",78953_78993_3_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",type)",78953_78993_4_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",type)",78953_78993_1_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",type)",78953_78993_5_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column)",78953_79013_3_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column)",78953_79013_4_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column)",78953_79013_1_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column)",78953_79013_5_not_null)
 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",foreign_key)",78953_79033_1_not_null)
 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",column)",column_purpose_id_fkey)
 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",column)",column_widget_id_fkey)
 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",relation)",relation_purpose_id_fkey)
 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",relation)",relation_widget_id_fkey)
 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",type)",type_purpose_id_fkey)
 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",type)",type_widget_id_fkey)
 org.aquameta.core.semantics - meta.function_definition.semantics/relation_widget/{"relation_id meta.relation_id","widget_purpose text","default_bundle text"}
 org.aquameta.core.semantics - meta.function_definition.semantics/column_widget/{"column_id meta.column_id","widget_purpose text","default_bundle text"}
(55 rows)

select bundle.commit('org.aquameta.core.semantics','initial import');
NOTICE:  bundle: Committing to org.aquameta.core.semantics
NOTICE:  bundle: Committing rowset_rows...
NOTICE:  bundle: Committing blobs...
NOTICE:  bundle: Committing stage_row_fields...
NOTICE:  bundle: Creating the commit...
NOTICE:  bundle: Updating bundle.head_commit_id...
NOTICE:  bundle: Cleaning up after commit...
 commit 
--------
 
(1 row)

drop extension semantics;
DROP EXTENSION
drop schema semantics;
DROP SCHEMA
select bundle.checkout((select head_commit_id from bundle.bundle where name='org.aquameta.core.semantics'));
NOTICE:  bundle.checkout(): org.aquameta.core.semantics / 8629ca47-84ac-42dc-9792-fb85a81d83b1 @ 2019-02-08 11:09:28.410965 by <NULL>: "initial import"
 checkout 
----------
 
(1 row)