0q9acypu

1eric@phoenix:~/aquameta$ dropdb aquameta; createdb aquameta ; cat extension-to-bundle.sql | psql -a aquameta
2create extension if not exists plpythonu;
3CREATE EXTENSION
4create extension if not exists multicorn schema public;
5CREATE EXTENSION
6create extension if not exists hstore schema public;
7CREATE EXTENSION
8create extension if not exists hstore_plpythonu schema public;
9CREATE EXTENSION
10create extension if not exists dblink schema public;
11CREATE EXTENSION
12create extension if not exists "uuid-ossp";
13CREATE EXTENSION
14create extension if not exists pgcrypto schema public;
15CREATE EXTENSION
16create extension if not exists pg_catalog_get_defs schema pg_catalog;
17CREATE EXTENSION
18create extension if not exists plv8;
19CREATE EXTENSION
20create extension meta;
21CREATE EXTENSION
22create extension bundle;
23CREATE EXTENSION
24------------------------------------------------------------------------
25-- bundle
26------------------------------------------------------------------------
27set search_path=bundle;
28SET
29-- bundle internal tables
30insert into bundle.ignored_relation(relation_id) values (meta.relation_id('bundle','bundle'));
31INSERT 0 1
32insert into bundle.ignored_relation(relation_id) values (meta.relation_id('bundle','commit'));
33INSERT 0 1
34insert into bundle.ignored_relation(relation_id) values (meta.relation_id('bundle','rowset'));
35INSERT 0 1
36insert into bundle.ignored_relation(relation_id) values (meta.relation_id('bundle','rowset_row'));
37INSERT 0 1
38insert into bundle.ignored_relation(relation_id) values (meta.relation_id('bundle','rowset_row_field'));
39INSERT 0 1
40insert into bundle.ignored_relation(relation_id) values (meta.relation_id('bundle','blob'));
41INSERT 0 1
42insert into bundle.ignored_relation(relation_id) values (meta.relation_id('bundle','tracked_row_added'));
43INSERT 0 1
44insert into bundle.bundle (name) values ('org.aquameta.core.bundle');
45INSERT 0 1
46-- TODO: track the ignored_rows
47-- track bundle entities
48select 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';
49                 tracked_row_add                 
50-------------------------------------------------
51 org.aquameta.core.bundle - meta.schema.(bundle)
52(1 row)
53
54select 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';
55                             tracked_row_add                              
56--------------------------------------------------------------------------
57 org.aquameta.core.bundle - meta.table.bundle/ignored_row
58 org.aquameta.core.bundle - meta.table.bundle/ignored_schema
59 org.aquameta.core.bundle - meta.table.bundle/ignored_relation
60 org.aquameta.core.bundle - meta.table.bundle/ignored_column
61 org.aquameta.core.bundle - meta.table.bundle/stage_row_added
62 org.aquameta.core.bundle - meta.table.bundle/stage_row_deleted
63 org.aquameta.core.bundle - meta.table.bundle/stage_field_changed
64 org.aquameta.core.bundle - meta.table.bundle/trackable_nontable_relation
65 org.aquameta.core.bundle - meta.table.bundle/remote_database
66(9 rows)
67
68select 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';
69                                          tracked_row_add                                           
70----------------------------------------------------------------------------------------------------
71 org.aquameta.core.bundle - meta.column.("(""(bundle)"",ignored_row)",row_id)
72 org.aquameta.core.bundle - meta.column.("(""(bundle)"",ignored_row)",id)
73 org.aquameta.core.bundle - meta.column.("(""(bundle)"",ignored_schema)",id)
74 org.aquameta.core.bundle - meta.column.("(""(bundle)"",ignored_schema)",schema_id)
75 org.aquameta.core.bundle - meta.column.("(""(bundle)"",ignored_relation)",id)
76 org.aquameta.core.bundle - meta.column.("(""(bundle)"",ignored_relation)",relation_id)
77 org.aquameta.core.bundle - meta.column.("(""(bundle)"",ignored_column)",id)
78 org.aquameta.core.bundle - meta.column.("(""(bundle)"",ignored_column)",column_id)
79 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_row_added)",row_id)
80 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_row_added)",bundle_id)
81 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_row_added)",id)
82 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_row_deleted)",id)
83 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_row_deleted)",bundle_id)
84 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_row_deleted)",rowset_row_id)
85 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_field_changed)",bundle_id)
86 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_field_changed)",field_id)
87 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_field_changed)",new_value)
88 org.aquameta.core.bundle - meta.column.("(""(bundle)"",stage_field_changed)",id)
89 org.aquameta.core.bundle - meta.column.("(""(bundle)"",trackable_nontable_relation)",id)
90 org.aquameta.core.bundle - meta.column.("(""(bundle)"",trackable_nontable_relation)",pk_column_id)
91 org.aquameta.core.bundle - meta.column.("(""(bundle)"",remote_database)",dbname)
92 org.aquameta.core.bundle - meta.column.("(""(bundle)"",remote_database)",port)
93 org.aquameta.core.bundle - meta.column.("(""(bundle)"",remote_database)",id)
94 org.aquameta.core.bundle - meta.column.("(""(bundle)"",remote_database)",username)
95 org.aquameta.core.bundle - meta.column.("(""(bundle)"",remote_database)",password)
96 org.aquameta.core.bundle - meta.column.("(""(bundle)"",remote_database)",foreign_server_name)
97 org.aquameta.core.bundle - meta.column.("(""(bundle)"",remote_database)",schema_name)
98 org.aquameta.core.bundle - meta.column.("(""(bundle)"",remote_database)",host)
99(28 rows)
100
101-- TODO: stage and commit
102------------------------------------------------------------------------
103-- email
104------------------------------------------------------------------------
105create extension email;
106CREATE EXTENSION
107-- track meta entities
108insert into bundle.bundle (name) values ('org.aquameta.core.email');
109INSERT 0 1
110-- schema
111select 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';
112                tracked_row_add                
113-----------------------------------------------
114 org.aquameta.core.email - meta.schema.(email)
115(1 row)
116
117-- type_definition
118select 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';
119 tracked_row_add 
120-----------------
121(0 rows)
122
123-- table
124select 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';
125                    tracked_row_add                     
126--------------------------------------------------------
127 org.aquameta.core.email - meta.table.email/smtp_server
128 org.aquameta.core.email - meta.table.email/template
129(2 rows)
130
131-- view
132select 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';
133 tracked_row_add 
134-----------------
135(0 rows)
136
137-- column
138select 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';
139                                 tracked_row_add                                  
140----------------------------------------------------------------------------------
141 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",ttl_username)
142 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",id)
143 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",use_ttls)
144 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",ttl_password)
145 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",port)
146 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",hostname)
147 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",name)
148 org.aquameta.core.email - meta.column.("(""(email)"",template)",subject)
149 org.aquameta.core.email - meta.column.("(""(email)"",template)",body_text)
150 org.aquameta.core.email - meta.column.("(""(email)"",template)",body_html)
151 org.aquameta.core.email - meta.column.("(""(email)"",template)",id)
152(11 rows)
153
154-- constraint_check
155select 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';
156                                           tracked_row_add                                            
157------------------------------------------------------------------------------------------------------
158 org.aquameta.core.email - meta.constraint_check.("(""(email)"",smtp_server)",77664_77666_1_not_null)
159 org.aquameta.core.email - meta.constraint_check.("(""(email)"",template)",77664_77681_3_not_null)
160 org.aquameta.core.email - meta.constraint_check.("(""(email)"",template)",77664_77681_1_not_null)
161 org.aquameta.core.email - meta.constraint_check.("(""(email)"",template)",77664_77681_2_not_null)
162(4 rows)
163
164-- foreign_key
165select 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';
166 tracked_row_add 
167-----------------
168(0 rows)
169
170-- function_definition
171select 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';
172                                                                              tracked_row_add                                                                               
173----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
174 org.aquameta.core.email - meta.function_definition.email/send/{"smtp_server_id uuid","from_email text","to_email text[]","subject text","body text"}
175 org.aquameta.core.email - meta.function_definition.email/template_render/{"template text","vars public.hstore"}
176 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"}
177(3 rows)
178
179select 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');
180                                                                               stage_row_add                                                                                
181----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
182 org.aquameta.core.email - meta.schema.(email)
183 org.aquameta.core.email - meta.table.email/smtp_server
184 org.aquameta.core.email - meta.table.email/template
185 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",ttl_username)
186 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",id)
187 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",use_ttls)
188 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",ttl_password)
189 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",port)
190 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",hostname)
191 org.aquameta.core.email - meta.column.("(""(email)"",smtp_server)",name)
192 org.aquameta.core.email - meta.column.("(""(email)"",template)",subject)
193 org.aquameta.core.email - meta.column.("(""(email)"",template)",body_text)
194 org.aquameta.core.email - meta.column.("(""(email)"",template)",body_html)
195 org.aquameta.core.email - meta.column.("(""(email)"",template)",id)
196 org.aquameta.core.email - meta.constraint_check.("(""(email)"",smtp_server)",77664_77666_1_not_null)
197 org.aquameta.core.email - meta.constraint_check.("(""(email)"",template)",77664_77681_3_not_null)
198 org.aquameta.core.email - meta.constraint_check.("(""(email)"",template)",77664_77681_1_not_null)
199 org.aquameta.core.email - meta.constraint_check.("(""(email)"",template)",77664_77681_2_not_null)
200 org.aquameta.core.email - meta.function_definition.email/send/{"smtp_server_id uuid","from_email text","to_email text[]","subject text","body text"}
201 org.aquameta.core.email - meta.function_definition.email/template_render/{"template text","vars public.hstore"}
202 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"}
203(21 rows)
204
205select bundle.commit('org.aquameta.core.email','initial import');
206NOTICE:  bundle: Committing to org.aquameta.core.email
207NOTICE:  bundle: Committing rowset_rows...
208NOTICE:  bundle: Committing blobs...
209NOTICE:  bundle: Committing stage_row_fields...
210NOTICE:  bundle: Creating the commit...
211NOTICE:  bundle: Updating bundle.head_commit_id...
212NOTICE:  bundle: Cleaning up after commit...
213 commit 
214--------
215 
216(1 row)
217
218drop extension email;
219DROP EXTENSION
220drop schema email;
221DROP SCHEMA
222select bundle.checkout((select head_commit_id from bundle.bundle where name='org.aquameta.core.email'));
223NOTICE:  bundle.checkout(): org.aquameta.core.email / 999f3323-96eb-4b2b-8c70-375c4440e8fb @ 2019-02-08 10:13:19.08106 by <NULL>: "initial import"
224 checkout 
225----------
226 
227(1 row)
228
229------------------------------------------------------------------------
230-- endpoint
231------------------------------------------------------------------------
232create extension endpoint;
233CREATE EXTENSION
234-- track meta entities
235insert into bundle.bundle (name) values ('org.aquameta.core.endpoint');
236INSERT 0 1
237select 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';
238                   tracked_row_add                   
239-----------------------------------------------------
240 org.aquameta.core.endpoint - meta.schema.(endpoint)
241(1 row)
242
243select 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';
244                                 tracked_row_add                                 
245---------------------------------------------------------------------------------
246 org.aquameta.core.endpoint - meta.type_definition.("(endpoint)",resource_bin)
247 org.aquameta.core.endpoint - meta.type_definition.("(endpoint)",resource_txt)
248 org.aquameta.core.endpoint - meta.type_definition.("(endpoint)",column_type)
249 org.aquameta.core.endpoint - meta.type_definition.("(endpoint)",join_graph_row)
250(4 rows)
251
252select 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';
253                             tracked_row_add                              
254--------------------------------------------------------------------------
255 org.aquameta.core.endpoint - meta.table.endpoint/mimetype_extension
256 org.aquameta.core.endpoint - meta.table.endpoint/column_mimetype
257 org.aquameta.core.endpoint - meta.table.endpoint/function_field_mimetype
258 org.aquameta.core.endpoint - meta.table.endpoint/resource_binary
259 org.aquameta.core.endpoint - meta.table.endpoint/resource_text
260 org.aquameta.core.endpoint - meta.table.endpoint/resource_file
261 org.aquameta.core.endpoint - meta.table.endpoint/resource_directory
262 org.aquameta.core.endpoint - meta.table.endpoint/resource
263 org.aquameta.core.endpoint - meta.table.endpoint/mimetype
264 org.aquameta.core.endpoint - meta.table.endpoint/template
265 org.aquameta.core.endpoint - meta.table.endpoint/template_route
266 org.aquameta.core.endpoint - meta.table.endpoint/site_settings
267 org.aquameta.core.endpoint - meta.table.endpoint/user
268 org.aquameta.core.endpoint - meta.table.endpoint/session
269(14 rows)
270
271select 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';
272                       tracked_row_add                        
273--------------------------------------------------------------
274 org.aquameta.core.endpoint - meta.view.endpoint/current_user
275(1 row)
276
277select 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';
278                                           tracked_row_add                                           
279-----------------------------------------------------------------------------------------------------
280 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype_extension)",mimetype_id)
281 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype_extension)",extension)
282 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype_extension)",id)
283 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",column_mimetype)",column_id)
284 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",column_mimetype)",mimetype_id)
285 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",column_mimetype)",id)
286 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",schema_name)
287 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",function_name)
288 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",field_name)
289 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",mimetype_id)
290 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",id)
291 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",path)
292 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",mimetype_id)
293 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",content)
294 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",id)
295 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",active)
296 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",path)
297 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",mimetype_id)
298 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",content)
299 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",id)
300 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",active)
301 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_file)",file_id)
302 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_file)",path)
303 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_file)",id)
304 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_file)",active)
305 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_directory)",directory_id)
306 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_directory)",path)
307 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_directory)",indexes)
308 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_directory)",id)
309 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",path)
310 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",mimetype_id)
311 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",id)
312 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",active)
313 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",content)
314 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype)",mimetype)
315 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype)",id)
316 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template)",mimetype_id)
317 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template)",id)
318 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template)",content)
319 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template_route)",template_id)
320 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template_route)",id)
321 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template_route)",url_pattern)
322 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template_route)",args)
323 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",name)
324 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",site_title)
325 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",site_url)
326 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",smtp_server_id)
327 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",auth_from_email)
328 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",id)
329 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",active)
330 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",email)
331 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",id)
332 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",role_id)
333 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",name)
334 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",active)
335 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",activation_code)
336 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",created_at)
337 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",session)",role_id)
338 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",session)",user_id)
339 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",session)",id)
340(60 rows)
341
342select 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';
343                                                    tracked_row_add                                                     
344------------------------------------------------------------------------------------------------------------------------
345 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_1_not_null)
346 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",session)",77769_78005_1_not_null)
347 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",session)",77769_78005_2_not_null)
348 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",function_field_mimetype)",77769_77822_5_not_null)
349 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_3_not_null)
350 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",mimetype)",77769_77781_2_not_null)
351 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template_route)",77769_77916_4_not_null)
352 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_file)",77769_77866_1_not_null)
353 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template_route)",77769_77916_2_not_null)
354 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",column_mimetype)",77769_77808_1_not_null)
355 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_7_not_null)
356 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_5_not_null)
357 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource)",77769_77885_5_not_null)
358 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template)",77769_77901_2_not_null)
359 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",function_field_mimetype)",77769_77822_1_not_null)
360 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_directory)",77769_77876_1_not_null)
361 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_binary)",77769_77836_1_not_null)
362 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template)",77769_77901_3_not_null)
363 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_file)",77769_77866_2_not_null)
364 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",column_mimetype)",77769_77808_2_not_null)
365 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_binary)",77769_77836_3_not_null)
366 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_file)",77769_77866_4_not_null)
367 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template_route)",77769_77916_3_not_null)
368 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",mimetype_extension)",77769_77792_2_not_null)
369 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",mimetype)",77769_77781_1_not_null)
370 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",site_settings)",77769_77932_1_not_null)
371 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_2_not_null)
372 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",mimetype_extension)",77769_77792_1_not_null)
373 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource)",77769_77885_2_not_null)
374 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_text)",77769_77851_2_not_null)
375 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_4_not_null)
376 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_text)",77769_77851_5_not_null)
377 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template_route)",77769_77916_1_not_null)
378 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",column_mimetype)",77769_77808_3_not_null)
379 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_text)",77769_77851_3_not_null)
380 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template)",77769_77901_1_not_null)
381 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource)",77769_77885_3_not_null)
382 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",site_settings)",77769_77932_6_not_null)
383 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_binary)",77769_77836_2_not_null)
384 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource)",77769_77885_1_not_null)
385 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_binary)",77769_77836_5_not_null)
386 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_text)",77769_77851_1_not_null)
387(42 rows)
388
389select 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';
390                                                           tracked_row_add                                                           
391-------------------------------------------------------------------------------------------------------------------------------------
392 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",column_mimetype)",column_mimetype_mimetype_id_fkey)
393 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",function_field_mimetype)",function_field_mimetype_mimetype_id_fkey)
394 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",mimetype_extension)",mimetype_extension_mimetype_id_fkey)
395 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",resource)",resource_mimetype_id_fkey)
396 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",resource_binary)",resource_binary_mimetype_id_fkey)
397 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",resource_text)",resource_text_mimetype_id_fkey)
398 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",session)",session_user_id_fkey)
399 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",site_settings)",site_settings_smtp_server_id_fkey)
400 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",template)",template_mimetype_id_fkey)
401 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",template_route)",template_route_template_id_fkey)
402(10 rows)
403
404select 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';
405                                                                                                            tracked_row_add                                                                                                             
406----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
407 org.aquameta.core.endpoint - meta.function_definition.endpoint/resource_bin/{"value json"}
408 org.aquameta.core.endpoint - meta.function_definition.endpoint/resource_txt/{"value json"}
409 org.aquameta.core.endpoint - meta.function_definition.endpoint/is_indexed/{"_path text"}
410 org.aquameta.core.endpoint - meta.function_definition.endpoint/set_mimetype/{"_schema name","_table name","_column name","_mimetype text"}
411 org.aquameta.core.endpoint - meta.function_definition.endpoint/columns_json/{"_schema_name text","_relation_name text","exclude text[]","include text[]","OUT json json"}
412 org.aquameta.core.endpoint - meta.function_definition.endpoint/pk/{"_schema_name name","_relation_name name","OUT pk_name text","OUT pk_type text"}
413 org.aquameta.core.endpoint - meta.function_definition.endpoint/pk_name/{"_schema_name name","_relation_name name"}
414 org.aquameta.core.endpoint - meta.function_definition.endpoint/construct_join_graph/{"temp_table_name text","start_rowset json","subrowsets json"}
415 org.aquameta.core.endpoint - meta.function_definition.endpoint/multiple_row_insert/{"relation_id meta.relation_id","args json"}
416 org.aquameta.core.endpoint - meta.function_definition.endpoint/suffix_clause/{"args json"}
417 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_insert/{"args json"}
418 org.aquameta.core.endpoint - meta.function_definition.endpoint/row_insert/{"relation_id meta.relation_id","args json"}
419 org.aquameta.core.endpoint - meta.function_definition.endpoint/is_json_object/{"value text"}
420 org.aquameta.core.endpoint - meta.function_definition.endpoint/is_json_array/{"value text"}
421 org.aquameta.core.endpoint - meta.function_definition.endpoint/row_update/{"row_id meta.row_id","args json"}
422 org.aquameta.core.endpoint - meta.function_definition.endpoint/row_select/{"row_id meta.row_id","args json"}
423 org.aquameta.core.endpoint - meta.function_definition.endpoint/field_select/{"field_id meta.field_id","OUT field text","OUT mimetype text"}
424 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"}
425 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_select/{"relation_id meta.relation_id","args json"}
426 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_select_function/{"function_id meta.function_id","args json","OUT result text","OUT mimetype text"}
427 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"}
428 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_select_function/{"function_id meta.function_id","args json","column_name text"}
429 org.aquameta.core.endpoint - meta.function_definition.endpoint/row_delete/{"row_id meta.row_id"}
430 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_delete/{"relation_id meta.relation_id","args json"}
431 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"}
432 org.aquameta.core.endpoint - meta.function_definition.endpoint/user_insert/{""}
433 org.aquameta.core.endpoint - meta.function_definition.endpoint/user_update/{""}
434 org.aquameta.core.endpoint - meta.function_definition.endpoint/user_delete/{""}
435 org.aquameta.core.endpoint - meta.function_definition.endpoint/current_user/{""}
436 org.aquameta.core.endpoint - meta.function_definition.endpoint/session/{"session_id uuid"}
437 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"}
438 org.aquameta.core.endpoint - meta.function_definition.endpoint/register_confirm/{"_email text","_confirmation_code text","send_email boolean DEFAULT true"}
439 org.aquameta.core.endpoint - meta.function_definition.endpoint/login/{"_email text","_password text"}
440 org.aquameta.core.endpoint - meta.function_definition.endpoint/logout/{"_email text"}
441 org.aquameta.core.endpoint - meta.function_definition.endpoint/superuser/{"_email text"}
442 org.aquameta.core.endpoint - meta.function_definition.endpoint/email/{"from_email text","to_email text[]","subject text","body text"}
443 org.aquameta.core.endpoint - meta.function_definition.endpoint/template_render/{"template_id uuid","route_args json DEFAULT '{}'::json","url_args json DEFAULT '{}'::json"}
444(37 rows)
445
446select 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');
447                                                                                                             stage_row_add                                                                                                              
448----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
449 org.aquameta.core.endpoint - meta.schema.(endpoint)
450 org.aquameta.core.endpoint - meta.type_definition.("(endpoint)",resource_bin)
451 org.aquameta.core.endpoint - meta.type_definition.("(endpoint)",resource_txt)
452 org.aquameta.core.endpoint - meta.type_definition.("(endpoint)",column_type)
453 org.aquameta.core.endpoint - meta.type_definition.("(endpoint)",join_graph_row)
454 org.aquameta.core.endpoint - meta.table.endpoint/mimetype_extension
455 org.aquameta.core.endpoint - meta.table.endpoint/column_mimetype
456 org.aquameta.core.endpoint - meta.table.endpoint/function_field_mimetype
457 org.aquameta.core.endpoint - meta.table.endpoint/resource_binary
458 org.aquameta.core.endpoint - meta.table.endpoint/resource_text
459 org.aquameta.core.endpoint - meta.table.endpoint/resource_file
460 org.aquameta.core.endpoint - meta.table.endpoint/resource_directory
461 org.aquameta.core.endpoint - meta.table.endpoint/resource
462 org.aquameta.core.endpoint - meta.table.endpoint/mimetype
463 org.aquameta.core.endpoint - meta.table.endpoint/template
464 org.aquameta.core.endpoint - meta.table.endpoint/template_route
465 org.aquameta.core.endpoint - meta.table.endpoint/site_settings
466 org.aquameta.core.endpoint - meta.table.endpoint/user
467 org.aquameta.core.endpoint - meta.table.endpoint/session
468 org.aquameta.core.endpoint - meta.view.endpoint/current_user
469 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype_extension)",mimetype_id)
470 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype_extension)",extension)
471 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype_extension)",id)
472 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",column_mimetype)",column_id)
473 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",column_mimetype)",mimetype_id)
474 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",column_mimetype)",id)
475 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",schema_name)
476 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",function_name)
477 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",field_name)
478 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",mimetype_id)
479 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",function_field_mimetype)",id)
480 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",path)
481 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",mimetype_id)
482 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",content)
483 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",id)
484 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_binary)",active)
485 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",path)
486 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",mimetype_id)
487 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",content)
488 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",id)
489 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_text)",active)
490 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_file)",file_id)
491 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_file)",path)
492 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_file)",id)
493 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_file)",active)
494 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_directory)",directory_id)
495 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_directory)",path)
496 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_directory)",indexes)
497 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource_directory)",id)
498 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",path)
499 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",mimetype_id)
500 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",id)
501 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",active)
502 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",resource)",content)
503 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype)",mimetype)
504 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",mimetype)",id)
505 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template)",mimetype_id)
506 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template)",id)
507 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template)",content)
508 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template_route)",template_id)
509 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template_route)",id)
510 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template_route)",url_pattern)
511 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",template_route)",args)
512 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",name)
513 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",site_title)
514 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",site_url)
515 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",smtp_server_id)
516 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",auth_from_email)
517 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",id)
518 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",site_settings)",active)
519 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",email)
520 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",id)
521 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",role_id)
522 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",name)
523 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",active)
524 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",activation_code)
525 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",user)",created_at)
526 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",session)",role_id)
527 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",session)",user_id)
528 org.aquameta.core.endpoint - meta.column.("(""(endpoint)"",session)",id)
529 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_1_not_null)
530 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",session)",77769_78005_1_not_null)
531 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",session)",77769_78005_2_not_null)
532 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",function_field_mimetype)",77769_77822_5_not_null)
533 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_3_not_null)
534 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",mimetype)",77769_77781_2_not_null)
535 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template_route)",77769_77916_4_not_null)
536 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_file)",77769_77866_1_not_null)
537 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template_route)",77769_77916_2_not_null)
538 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",column_mimetype)",77769_77808_1_not_null)
539 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_7_not_null)
540 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_5_not_null)
541 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource)",77769_77885_5_not_null)
542 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template)",77769_77901_2_not_null)
543 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",function_field_mimetype)",77769_77822_1_not_null)
544 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_directory)",77769_77876_1_not_null)
545 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_binary)",77769_77836_1_not_null)
546 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template)",77769_77901_3_not_null)
547 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_file)",77769_77866_2_not_null)
548 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",column_mimetype)",77769_77808_2_not_null)
549 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_binary)",77769_77836_3_not_null)
550 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_file)",77769_77866_4_not_null)
551 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template_route)",77769_77916_3_not_null)
552 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",mimetype_extension)",77769_77792_2_not_null)
553 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",mimetype)",77769_77781_1_not_null)
554 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",site_settings)",77769_77932_1_not_null)
555 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_2_not_null)
556 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",mimetype_extension)",77769_77792_1_not_null)
557 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource)",77769_77885_2_not_null)
558 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_text)",77769_77851_2_not_null)
559 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",user)",77769_77978_4_not_null)
560 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_text)",77769_77851_5_not_null)
561 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template_route)",77769_77916_1_not_null)
562 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",column_mimetype)",77769_77808_3_not_null)
563 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_text)",77769_77851_3_not_null)
564 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",template)",77769_77901_1_not_null)
565 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource)",77769_77885_3_not_null)
566 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",site_settings)",77769_77932_6_not_null)
567 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_binary)",77769_77836_2_not_null)
568 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource)",77769_77885_1_not_null)
569 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_binary)",77769_77836_5_not_null)
570 org.aquameta.core.endpoint - meta.constraint_check.("(""(endpoint)"",resource_text)",77769_77851_1_not_null)
571 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",column_mimetype)",column_mimetype_mimetype_id_fkey)
572 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",function_field_mimetype)",function_field_mimetype_mimetype_id_fkey)
573 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",mimetype_extension)",mimetype_extension_mimetype_id_fkey)
574 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",resource)",resource_mimetype_id_fkey)
575 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",resource_binary)",resource_binary_mimetype_id_fkey)
576 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",resource_text)",resource_text_mimetype_id_fkey)
577 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",session)",session_user_id_fkey)
578 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",site_settings)",site_settings_smtp_server_id_fkey)
579 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",template)",template_mimetype_id_fkey)
580 org.aquameta.core.endpoint - meta.foreign_key.("(""(endpoint)"",template_route)",template_route_template_id_fkey)
581 org.aquameta.core.endpoint - meta.function_definition.endpoint/resource_bin/{"value json"}
582 org.aquameta.core.endpoint - meta.function_definition.endpoint/resource_txt/{"value json"}
583 org.aquameta.core.endpoint - meta.function_definition.endpoint/is_indexed/{"_path text"}
584 org.aquameta.core.endpoint - meta.function_definition.endpoint/set_mimetype/{"_schema name","_table name","_column name","_mimetype text"}
585 org.aquameta.core.endpoint - meta.function_definition.endpoint/columns_json/{"_schema_name text","_relation_name text","exclude text[]","include text[]","OUT json json"}
586 org.aquameta.core.endpoint - meta.function_definition.endpoint/pk/{"_schema_name name","_relation_name name","OUT pk_name text","OUT pk_type text"}
587 org.aquameta.core.endpoint - meta.function_definition.endpoint/pk_name/{"_schema_name name","_relation_name name"}
588 org.aquameta.core.endpoint - meta.function_definition.endpoint/construct_join_graph/{"temp_table_name text","start_rowset json","subrowsets json"}
589 org.aquameta.core.endpoint - meta.function_definition.endpoint/multiple_row_insert/{"relation_id meta.relation_id","args json"}
590 org.aquameta.core.endpoint - meta.function_definition.endpoint/suffix_clause/{"args json"}
591 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_insert/{"args json"}
592 org.aquameta.core.endpoint - meta.function_definition.endpoint/row_insert/{"relation_id meta.relation_id","args json"}
593 org.aquameta.core.endpoint - meta.function_definition.endpoint/is_json_object/{"value text"}
594 org.aquameta.core.endpoint - meta.function_definition.endpoint/is_json_array/{"value text"}
595 org.aquameta.core.endpoint - meta.function_definition.endpoint/row_update/{"row_id meta.row_id","args json"}
596 org.aquameta.core.endpoint - meta.function_definition.endpoint/row_select/{"row_id meta.row_id","args json"}
597 org.aquameta.core.endpoint - meta.function_definition.endpoint/field_select/{"field_id meta.field_id","OUT field text","OUT mimetype text"}
598 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"}
599 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_select/{"relation_id meta.relation_id","args json"}
600 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_select_function/{"function_id meta.function_id","args json","OUT result text","OUT mimetype text"}
601 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"}
602 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_select_function/{"function_id meta.function_id","args json","column_name text"}
603 org.aquameta.core.endpoint - meta.function_definition.endpoint/row_delete/{"row_id meta.row_id"}
604 org.aquameta.core.endpoint - meta.function_definition.endpoint/rows_delete/{"relation_id meta.relation_id","args json"}
605 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"}
606 org.aquameta.core.endpoint - meta.function_definition.endpoint/user_insert/{""}
607 org.aquameta.core.endpoint - meta.function_definition.endpoint/user_update/{""}
608 org.aquameta.core.endpoint - meta.function_definition.endpoint/user_delete/{""}
609 org.aquameta.core.endpoint - meta.function_definition.endpoint/current_user/{""}
610 org.aquameta.core.endpoint - meta.function_definition.endpoint/session/{"session_id uuid"}
611 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"}
612 org.aquameta.core.endpoint - meta.function_definition.endpoint/register_confirm/{"_email text","_confirmation_code text","send_email boolean DEFAULT true"}
613 org.aquameta.core.endpoint - meta.function_definition.endpoint/login/{"_email text","_password text"}
614 org.aquameta.core.endpoint - meta.function_definition.endpoint/logout/{"_email text"}
615 org.aquameta.core.endpoint - meta.function_definition.endpoint/superuser/{"_email text"}
616 org.aquameta.core.endpoint - meta.function_definition.endpoint/email/{"from_email text","to_email text[]","subject text","body text"}
617 org.aquameta.core.endpoint - meta.function_definition.endpoint/template_render/{"template_id uuid","route_args json DEFAULT '{}'::json","url_args json DEFAULT '{}'::json"}
618(169 rows)
619
620select bundle.commit('org.aquameta.core.endpoint','initial import');
621NOTICE:  bundle: Committing to org.aquameta.core.endpoint
622NOTICE:  bundle: Committing rowset_rows...
623NOTICE:  bundle: Committing blobs...
624NOTICE:  bundle: Committing stage_row_fields...
625NOTICE:  bundle: Creating the commit...
626NOTICE:  bundle: Updating bundle.head_commit_id...
627NOTICE:  bundle: Cleaning up after commit...
628 commit 
629--------
630 
631(1 row)
632
633drop extension endpoint;
634DROP EXTENSION
635drop schema endpoint;
636DROP SCHEMA
637select bundle.checkout((select head_commit_id from bundle.bundle where name='org.aquameta.core.endpoint'));
638NOTICE:  bundle.checkout(): org.aquameta.core.endpoint / c3c99d72-ae85-4757-b788-5e3aff46e067 @ 2019-02-08 10:13:44.955788 by <NULL>: "initial import"
639 checkout 
640----------
641 
642(1 row)
643
644------------------------------------------------------------------------
645-- event
646------------------------------------------------------------------------
647create extension event;
648CREATE EXTENSION
649-- track meta entities
650insert into bundle.bundle (name) values ('org.aquameta.core.event');
651INSERT 0 1
652select 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';
653                tracked_row_add                
654-----------------------------------------------
655 org.aquameta.core.event - meta.schema.(event)
656(1 row)
657
658select 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';
659 tracked_row_add 
660-----------------
661(0 rows)
662
663select 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';
664                        tracked_row_add                         
665----------------------------------------------------------------
666 org.aquameta.core.event - meta.table.event/subscription_row
667 org.aquameta.core.event - meta.table.event/subscription_table
668 org.aquameta.core.event - meta.table.event/subscription_column
669 org.aquameta.core.event - meta.table.event/subscription_field
670 org.aquameta.core.event - meta.table.event/session
671 org.aquameta.core.event - meta.table.event/event
672(6 rows)
673
674select 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';
675                    tracked_row_add                     
676--------------------------------------------------------
677 org.aquameta.core.event - meta.view.event/subscription
678(1 row)
679
680select 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';
681                                    tracked_row_add                                     
682----------------------------------------------------------------------------------------
683 org.aquameta.core.event - meta.column.("(""(event)"",subscription_row)",id)
684 org.aquameta.core.event - meta.column.("(""(event)"",subscription_row)",row_id)
685 org.aquameta.core.event - meta.column.("(""(event)"",subscription_row)",session_id)
686 org.aquameta.core.event - meta.column.("(""(event)"",subscription_row)",created_at)
687 org.aquameta.core.event - meta.column.("(""(event)"",subscription_table)",id)
688 org.aquameta.core.event - meta.column.("(""(event)"",subscription_table)",relation_id)
689 org.aquameta.core.event - meta.column.("(""(event)"",subscription_table)",session_id)
690 org.aquameta.core.event - meta.column.("(""(event)"",subscription_table)",created_at)
691 org.aquameta.core.event - meta.column.("(""(event)"",subscription_column)",id)
692 org.aquameta.core.event - meta.column.("(""(event)"",subscription_column)",session_id)
693 org.aquameta.core.event - meta.column.("(""(event)"",subscription_column)",column_id)
694 org.aquameta.core.event - meta.column.("(""(event)"",subscription_column)",created_at)
695 org.aquameta.core.event - meta.column.("(""(event)"",subscription_field)",id)
696 org.aquameta.core.event - meta.column.("(""(event)"",subscription_field)",field_id)
697 org.aquameta.core.event - meta.column.("(""(event)"",subscription_field)",session_id)
698 org.aquameta.core.event - meta.column.("(""(event)"",subscription_field)",created_at)
699 org.aquameta.core.event - meta.column.("(""(event)"",session)",id)
700 org.aquameta.core.event - meta.column.("(""(event)"",session)",owner_id)
701 org.aquameta.core.event - meta.column.("(""(event)"",event)",id)
702 org.aquameta.core.event - meta.column.("(""(event)"",event)",session_id)
703 org.aquameta.core.event - meta.column.("(""(event)"",event)",created_at)
704 org.aquameta.core.event - meta.column.("(""(event)"",event)",event)
705(22 rows)
706
707select 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';
708                                               tracked_row_add                                                
709--------------------------------------------------------------------------------------------------------------
710 org.aquameta.core.event - meta.constraint_check.("(""(event)"",session)",78369_78371_2_not_null)
711 org.aquameta.core.event - meta.constraint_check.("(""(event)"",session)",78369_78371_1_not_null)
712 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_table)",78369_78384_2_not_null)
713 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_table)",78369_78384_1_not_null)
714 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_table)",78369_78384_4_not_null)
715 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_column)",78369_78399_2_not_null)
716 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_column)",78369_78399_1_not_null)
717 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_column)",78369_78399_4_not_null)
718 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_row)",78369_78414_2_not_null)
719 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_row)",78369_78414_1_not_null)
720 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_row)",78369_78414_4_not_null)
721 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_field)",78369_78429_2_not_null)
722 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_field)",78369_78429_1_not_null)
723 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_field)",78369_78429_4_not_null)
724 org.aquameta.core.event - meta.constraint_check.("(""(event)"",event)",78369_78449_2_not_null)
725 org.aquameta.core.event - meta.constraint_check.("(""(event)"",event)",78369_78449_1_not_null)
726 org.aquameta.core.event - meta.constraint_check.("(""(event)"",event)",78369_78449_4_not_null)
727(17 rows)
728
729select 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';
730                                                   tracked_row_add                                                    
731----------------------------------------------------------------------------------------------------------------------
732 org.aquameta.core.event - meta.foreign_key.("(""(event)"",event)",event_session_id_fkey)
733 org.aquameta.core.event - meta.foreign_key.("(""(event)"",subscription_column)",subscription_column_session_id_fkey)
734 org.aquameta.core.event - meta.foreign_key.("(""(event)"",subscription_field)",subscription_field_session_id_fkey)
735 org.aquameta.core.event - meta.foreign_key.("(""(event)"",subscription_row)",subscription_row_session_id_fkey)
736 org.aquameta.core.event - meta.foreign_key.("(""(event)"",subscription_table)",subscription_table_session_id_fkey)
737(5 rows)
738
739select 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';
740                                                       tracked_row_add                                                       
741-----------------------------------------------------------------------------------------------------------------------------
742 org.aquameta.core.event - meta.function_definition.event/session_create/{""}
743 org.aquameta.core.event - meta.function_definition.event/session_attach/{"session_id uuid"}
744 org.aquameta.core.event - meta.function_definition.event/session_detach/{"session_id uuid"}
745 org.aquameta.core.event - meta.function_definition.event/session_delete/{"session_id uuid"}
746 org.aquameta.core.event - meta.function_definition.event/event_listener_table/{""}
747 org.aquameta.core.event - meta.function_definition.event/event_listener_row/{""}
748 org.aquameta.core.event - meta.function_definition.event/subscribe_table/{"session_id uuid","relation_id meta.relation_id"}
749 org.aquameta.core.event - meta.function_definition.event/subscribe_column/{"session_id uuid","column_id meta.column_id"}
750 org.aquameta.core.event - meta.function_definition.event/subscribe_row/{"session_id uuid","row_id meta.row_id"}
751 org.aquameta.core.event - meta.function_definition.event/subscribe_field/{"session_id uuid","field_id meta.field_id"}
752(10 rows)
753
754select 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');
755                                                        stage_row_add                                                        
756-----------------------------------------------------------------------------------------------------------------------------
757 org.aquameta.core.event - meta.schema.(event)
758 org.aquameta.core.event - meta.table.event/subscription_row
759 org.aquameta.core.event - meta.table.event/subscription_table
760 org.aquameta.core.event - meta.table.event/subscription_column
761 org.aquameta.core.event - meta.table.event/subscription_field
762 org.aquameta.core.event - meta.table.event/session
763 org.aquameta.core.event - meta.table.event/event
764 org.aquameta.core.event - meta.view.event/subscription
765 org.aquameta.core.event - meta.column.("(""(event)"",subscription_row)",id)
766 org.aquameta.core.event - meta.column.("(""(event)"",subscription_row)",row_id)
767 org.aquameta.core.event - meta.column.("(""(event)"",subscription_row)",session_id)
768 org.aquameta.core.event - meta.column.("(""(event)"",subscription_row)",created_at)
769 org.aquameta.core.event - meta.column.("(""(event)"",subscription_table)",id)
770 org.aquameta.core.event - meta.column.("(""(event)"",subscription_table)",relation_id)
771 org.aquameta.core.event - meta.column.("(""(event)"",subscription_table)",session_id)
772 org.aquameta.core.event - meta.column.("(""(event)"",subscription_table)",created_at)
773 org.aquameta.core.event - meta.column.("(""(event)"",subscription_column)",id)
774 org.aquameta.core.event - meta.column.("(""(event)"",subscription_column)",session_id)
775 org.aquameta.core.event - meta.column.("(""(event)"",subscription_column)",column_id)
776 org.aquameta.core.event - meta.column.("(""(event)"",subscription_column)",created_at)
777 org.aquameta.core.event - meta.column.("(""(event)"",subscription_field)",id)
778 org.aquameta.core.event - meta.column.("(""(event)"",subscription_field)",field_id)
779 org.aquameta.core.event - meta.column.("(""(event)"",subscription_field)",session_id)
780 org.aquameta.core.event - meta.column.("(""(event)"",subscription_field)",created_at)
781 org.aquameta.core.event - meta.column.("(""(event)"",session)",id)
782 org.aquameta.core.event - meta.column.("(""(event)"",session)",owner_id)
783 org.aquameta.core.event - meta.column.("(""(event)"",event)",id)
784 org.aquameta.core.event - meta.column.("(""(event)"",event)",session_id)
785 org.aquameta.core.event - meta.column.("(""(event)"",event)",created_at)
786 org.aquameta.core.event - meta.column.("(""(event)"",event)",event)
787 org.aquameta.core.event - meta.constraint_check.("(""(event)"",session)",78369_78371_2_not_null)
788 org.aquameta.core.event - meta.constraint_check.("(""(event)"",session)",78369_78371_1_not_null)
789 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_table)",78369_78384_2_not_null)
790 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_table)",78369_78384_1_not_null)
791 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_table)",78369_78384_4_not_null)
792 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_column)",78369_78399_2_not_null)
793 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_column)",78369_78399_1_not_null)
794 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_column)",78369_78399_4_not_null)
795 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_row)",78369_78414_2_not_null)
796 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_row)",78369_78414_1_not_null)
797 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_row)",78369_78414_4_not_null)
798 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_field)",78369_78429_2_not_null)
799 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_field)",78369_78429_1_not_null)
800 org.aquameta.core.event - meta.constraint_check.("(""(event)"",subscription_field)",78369_78429_4_not_null)
801 org.aquameta.core.event - meta.constraint_check.("(""(event)"",event)",78369_78449_2_not_null)
802 org.aquameta.core.event - meta.constraint_check.("(""(event)"",event)",78369_78449_1_not_null)
803 org.aquameta.core.event - meta.constraint_check.("(""(event)"",event)",78369_78449_4_not_null)
804 org.aquameta.core.event - meta.foreign_key.("(""(event)"",event)",event_session_id_fkey)
805 org.aquameta.core.event - meta.foreign_key.("(""(event)"",subscription_column)",subscription_column_session_id_fkey)
806 org.aquameta.core.event - meta.foreign_key.("(""(event)"",subscription_field)",subscription_field_session_id_fkey)
807 org.aquameta.core.event - meta.foreign_key.("(""(event)"",subscription_row)",subscription_row_session_id_fkey)
808 org.aquameta.core.event - meta.foreign_key.("(""(event)"",subscription_table)",subscription_table_session_id_fkey)
809 org.aquameta.core.event - meta.function_definition.event/session_create/{""}
810 org.aquameta.core.event - meta.function_definition.event/session_attach/{"session_id uuid"}
811 org.aquameta.core.event - meta.function_definition.event/session_detach/{"session_id uuid"}
812 org.aquameta.core.event - meta.function_definition.event/session_delete/{"session_id uuid"}
813 org.aquameta.core.event - meta.function_definition.event/event_listener_table/{""}
814 org.aquameta.core.event - meta.function_definition.event/event_listener_row/{""}
815 org.aquameta.core.event - meta.function_definition.event/subscribe_table/{"session_id uuid","relation_id meta.relation_id"}
816 org.aquameta.core.event - meta.function_definition.event/subscribe_column/{"session_id uuid","column_id meta.column_id"}
817 org.aquameta.core.event - meta.function_definition.event/subscribe_row/{"session_id uuid","row_id meta.row_id"}
818 org.aquameta.core.event - meta.function_definition.event/subscribe_field/{"session_id uuid","field_id meta.field_id"}
819(62 rows)
820
821select bundle.commit('org.aquameta.core.event','initial import');
822NOTICE:  bundle: Committing to org.aquameta.core.event
823NOTICE:  bundle: Committing rowset_rows...
824NOTICE:  bundle: Committing blobs...
825NOTICE:  bundle: Committing stage_row_fields...
826NOTICE:  bundle: Creating the commit...
827NOTICE:  bundle: Updating bundle.head_commit_id...
828NOTICE:  bundle: Cleaning up after commit...
829 commit 
830--------
831 
832(1 row)
833
834drop extension event;
835DROP EXTENSION
836drop schema event;
837DROP SCHEMA
838select bundle.checkout((select head_commit_id from bundle.bundle where name='org.aquameta.core.event'));
839NOTICE:  bundle.checkout(): org.aquameta.core.event / 215ac89a-eb7c-4eb1-93ce-cd4672c28fc4 @ 2019-02-08 10:15:04.8405 by <NULL>: "initial import"
840 checkout 
841----------
842 
843(1 row)
844
845------------------------------------------------------------------------
846-- widget
847------------------------------------------------------------------------
848create extension widget;
849CREATE EXTENSION
850-- track meta entities
851insert into bundle.bundle (name) values ('org.aquameta.core.widget');
852INSERT 0 1
853select 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';
854                 tracked_row_add                 
855-------------------------------------------------
856 org.aquameta.core.widget - meta.schema.(widget)
857(1 row)
858
859select 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';
860 tracked_row_add 
861-----------------
862(0 rows)
863
864select 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';
865                          tracked_row_add                           
866--------------------------------------------------------------------
867 org.aquameta.core.widget - meta.table.widget/input
868 org.aquameta.core.widget - meta.table.widget/dependency_css
869 org.aquameta.core.widget - meta.table.widget/widget_dependency_css
870 org.aquameta.core.widget - meta.table.widget/dependency_js
871 org.aquameta.core.widget - meta.table.widget/widget_dependency_js
872 org.aquameta.core.widget - meta.table.widget/widget_view
873 org.aquameta.core.widget - meta.table.widget/widget
874 org.aquameta.core.widget - meta.table.widget/machine
875 org.aquameta.core.widget - meta.table.widget/widget_fsm
876(9 rows)
877
878select 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';
879                      tracked_row_add                       
880------------------------------------------------------------
881 org.aquameta.core.widget - meta.view.widget/bundled_widget
882 org.aquameta.core.widget - meta.view.widget/widget_name
883(2 rows)
884
885select 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';
886                                          tracked_row_add                                          
887---------------------------------------------------------------------------------------------------
888 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",id)
889 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",widget_id)
890 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",default_value)
891 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",name)
892 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",optional)
893 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",help)
894 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",test_value)
895 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",doc_string)
896 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_css)",id)
897 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_css)",name)
898 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_css)",version)
899 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_css)",content)
900 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_css)",id)
901 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_css)",dependency_css_id)
902 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_css)",widget_id)
903 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",id)
904 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",name)
905 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",content)
906 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",version)
907 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",variable)
908 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_js)",id)
909 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_js)",widget_id)
910 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_js)",dependency_js_id)
911 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_view)",id)
912 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_view)",view_id)
913 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_view)",widget_id)
914 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",id)
915 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",css)
916 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",help)
917 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",server_js)
918 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",pre_js)
919 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",post_js)
920 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",common_js)
921 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",html)
922 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",name)
923 org.aquameta.core.widget - meta.column.("(""(widget)"",machine)",id)
924 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_fsm)",id)
925 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_fsm)",widget_id)
926 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_fsm)",machine_id)
927(39 rows)
928
929select 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';
930                                                 tracked_row_add                                                  
931------------------------------------------------------------------------------------------------------------------
932 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_2_not_null)
933 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_1_not_null)
934 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_3_not_null)
935 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_4_not_null)
936 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_5_not_null)
937 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_6_not_null)
938 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_7_not_null)
939 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_8_not_null)
940 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_css)",78607_78630_2_not_null)
941 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_css)",78607_78630_3_not_null)
942 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_css)",78607_78630_4_not_null)
943 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_css)",78607_78630_1_not_null)
944 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_js)",78607_78641_2_not_null)
945 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_js)",78607_78641_3_not_null)
946 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_js)",78607_78641_5_not_null)
947 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_js)",78607_78641_1_not_null)
948 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",input)",78607_78652_2_not_null)
949 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",input)",78607_78652_3_not_null)
950 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",input)",78607_78652_1_not_null)
951 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",input)",78607_78652_4_not_null)
952 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_css)",78607_78669_2_not_null)
953 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_css)",78607_78669_3_not_null)
954 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_css)",78607_78669_1_not_null)
955 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_js)",78607_78687_2_not_null)
956 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_js)",78607_78687_3_not_null)
957 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_js)",78607_78687_1_not_null)
958 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_view)",78607_78705_2_not_null)
959 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_view)",78607_78705_1_not_null)
960 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",machine)",78607_78721_1_not_null)
961 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_fsm)",78607_78727_2_not_null)
962 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_fsm)",78607_78727_1_not_null)
963(31 rows)
964
965select 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';
966                                                          tracked_row_add                                                          
967-----------------------------------------------------------------------------------------------------------------------------------
968 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",input)",input_widget_id_fkey)
969 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_dependency_css)",widget_dependency_css_dependency_css_id_fkey)
970 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_dependency_css)",widget_dependency_css_widget_id_fkey)
971 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_dependency_js)",widget_dependency_js_dependency_js_id_fkey)
972 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_dependency_js)",widget_dependency_js_widget_id_fkey)
973 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_fsm)",widget_fsm_machine_id_fkey)
974 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_fsm)",widget_fsm_widget_id_fkey)
975 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_view)",widget_view_widget_id_fkey)
976(8 rows)
977
978select 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';
979                                                            tracked_row_add                                                            
980---------------------------------------------------------------------------------------------------------------------------------------
981 org.aquameta.core.widget - meta.function_definition.widget/get_dependency_js/{"_name character varying","_version character varying"}
982 org.aquameta.core.widget - meta.function_definition.widget/bundled_widget/{"bundle_name text","widget_name text"}
983(2 rows)
984
985select 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');
986                                                             stage_row_add                                                             
987---------------------------------------------------------------------------------------------------------------------------------------
988 org.aquameta.core.widget - meta.schema.(widget)
989 org.aquameta.core.widget - meta.table.widget/input
990 org.aquameta.core.widget - meta.table.widget/dependency_css
991 org.aquameta.core.widget - meta.table.widget/widget_dependency_css
992 org.aquameta.core.widget - meta.table.widget/dependency_js
993 org.aquameta.core.widget - meta.table.widget/widget_dependency_js
994 org.aquameta.core.widget - meta.table.widget/widget_view
995 org.aquameta.core.widget - meta.table.widget/widget
996 org.aquameta.core.widget - meta.table.widget/machine
997 org.aquameta.core.widget - meta.table.widget/widget_fsm
998 org.aquameta.core.widget - meta.view.widget/bundled_widget
999 org.aquameta.core.widget - meta.view.widget/widget_name
1000 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",id)
1001 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",widget_id)
1002 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",default_value)
1003 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",name)
1004 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",optional)
1005 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",help)
1006 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",test_value)
1007 org.aquameta.core.widget - meta.column.("(""(widget)"",input)",doc_string)
1008 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_css)",id)
1009 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_css)",name)
1010 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_css)",version)
1011 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_css)",content)
1012 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_css)",id)
1013 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_css)",dependency_css_id)
1014 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_css)",widget_id)
1015 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",id)
1016 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",name)
1017 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",content)
1018 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",version)
1019 org.aquameta.core.widget - meta.column.("(""(widget)"",dependency_js)",variable)
1020 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_js)",id)
1021 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_js)",widget_id)
1022 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_dependency_js)",dependency_js_id)
1023 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_view)",id)
1024 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_view)",view_id)
1025 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_view)",widget_id)
1026 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",id)
1027 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",css)
1028 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",help)
1029 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",server_js)
1030 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",pre_js)
1031 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",post_js)
1032 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",common_js)
1033 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",html)
1034 org.aquameta.core.widget - meta.column.("(""(widget)"",widget)",name)
1035 org.aquameta.core.widget - meta.column.("(""(widget)"",machine)",id)
1036 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_fsm)",id)
1037 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_fsm)",widget_id)
1038 org.aquameta.core.widget - meta.column.("(""(widget)"",widget_fsm)",machine_id)
1039 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_2_not_null)
1040 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_1_not_null)
1041 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_3_not_null)
1042 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_4_not_null)
1043 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_5_not_null)
1044 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_6_not_null)
1045 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_7_not_null)
1046 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget)",78607_78609_8_not_null)
1047 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_css)",78607_78630_2_not_null)
1048 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_css)",78607_78630_3_not_null)
1049 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_css)",78607_78630_4_not_null)
1050 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_css)",78607_78630_1_not_null)
1051 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_js)",78607_78641_2_not_null)
1052 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_js)",78607_78641_3_not_null)
1053 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_js)",78607_78641_5_not_null)
1054 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",dependency_js)",78607_78641_1_not_null)
1055 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",input)",78607_78652_2_not_null)
1056 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",input)",78607_78652_3_not_null)
1057 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",input)",78607_78652_1_not_null)
1058 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",input)",78607_78652_4_not_null)
1059 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_css)",78607_78669_2_not_null)
1060 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_css)",78607_78669_3_not_null)
1061 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_css)",78607_78669_1_not_null)
1062 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_js)",78607_78687_2_not_null)
1063 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_js)",78607_78687_3_not_null)
1064 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_dependency_js)",78607_78687_1_not_null)
1065 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_view)",78607_78705_2_not_null)
1066 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_view)",78607_78705_1_not_null)
1067 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",machine)",78607_78721_1_not_null)
1068 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_fsm)",78607_78727_2_not_null)
1069 org.aquameta.core.widget - meta.constraint_check.("(""(widget)"",widget_fsm)",78607_78727_1_not_null)
1070 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",input)",input_widget_id_fkey)
1071 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_dependency_css)",widget_dependency_css_dependency_css_id_fkey)
1072 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_dependency_css)",widget_dependency_css_widget_id_fkey)
1073 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_dependency_js)",widget_dependency_js_dependency_js_id_fkey)
1074 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_dependency_js)",widget_dependency_js_widget_id_fkey)
1075 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_fsm)",widget_fsm_machine_id_fkey)
1076 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_fsm)",widget_fsm_widget_id_fkey)
1077 org.aquameta.core.widget - meta.foreign_key.("(""(widget)"",widget_view)",widget_view_widget_id_fkey)
1078 org.aquameta.core.widget - meta.function_definition.widget/get_dependency_js/{"_name character varying","_version character varying"}
1079 org.aquameta.core.widget - meta.function_definition.widget/bundled_widget/{"bundle_name text","widget_name text"}
1080(92 rows)
1081
1082select bundle.commit('org.aquameta.core.widget','initial import');
1083NOTICE:  bundle: Committing to org.aquameta.core.widget
1084NOTICE:  bundle: Committing rowset_rows...
1085NOTICE:  bundle: Committing blobs...
1086NOTICE:  bundle: Committing stage_row_fields...
1087NOTICE:  bundle: Creating the commit...
1088NOTICE:  bundle: Updating bundle.head_commit_id...
1089NOTICE:  bundle: Cleaning up after commit...
1090 commit 
1091--------
1092 
1093(1 row)
1094
1095drop extension widget;
1096DROP EXTENSION
1097drop schema widget;
1098DROP SCHEMA
1099select bundle.checkout((select head_commit_id from bundle.bundle where name='org.aquameta.core.widget'));
1100NOTICE:  bundle.checkout(): org.aquameta.core.widget / c0667941-bb35-4862-8cda-f27ce81f9dd6 @ 2019-02-08 10:25:19.469611 by <NULL>: "initial import"
1101 checkout 
1102----------
1103 
1104(1 row)
1105
1106------------------------------------------------------------------------
1107-- semantics
1108------------------------------------------------------------------------
1109create extension semantics;
1110CREATE EXTENSION
1111-- track meta entities
1112insert into bundle.bundle (name) values ('org.aquameta.core.semantics');
1113INSERT 0 1
1114select 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';
1115                    tracked_row_add                    
1116-------------------------------------------------------
1117 org.aquameta.core.semantics - meta.schema.(semantics)
1118(1 row)
1119
1120select 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';
1121 tracked_row_add 
1122-----------------
1123(0 rows)
1124
1125select 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';
1126                           tracked_row_add                           
1127---------------------------------------------------------------------
1128 org.aquameta.core.semantics - meta.table.semantics/relation_purpose
1129 org.aquameta.core.semantics - meta.table.semantics/relation
1130 org.aquameta.core.semantics - meta.table.semantics/type
1131 org.aquameta.core.semantics - meta.table.semantics/column_purpose
1132 org.aquameta.core.semantics - meta.table.semantics/column
1133 org.aquameta.core.semantics - meta.table.semantics/foreign_key
1134(6 rows)
1135
1136select 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';
1137 tracked_row_add 
1138-----------------
1139(0 rows)
1140
1141select 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';
1142                                      tracked_row_add                                       
1143--------------------------------------------------------------------------------------------
1144 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation_purpose)",id)
1145 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation_purpose)",purpose)
1146 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",id)
1147 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",relation_id)
1148 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",priority)
1149 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",purpose_id)
1150 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",widget_id)
1151 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",id)
1152 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",type_id)
1153 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",priority)
1154 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",purpose_id)
1155 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",widget_id)
1156 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column_purpose)",id)
1157 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column_purpose)",purpose)
1158 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",id)
1159 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",priority)
1160 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",purpose_id)
1161 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",widget_id)
1162 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",column_id)
1163 org.aquameta.core.semantics - meta.column.("(""(semantics)"",foreign_key)",id)
1164 org.aquameta.core.semantics - meta.column.("(""(semantics)"",foreign_key)",foreign_key_id)
1165 org.aquameta.core.semantics - meta.column.("(""(semantics)"",foreign_key)",inline)
1166(22 rows)
1167
1168select 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';
1169                                                  tracked_row_add                                                  
1170-------------------------------------------------------------------------------------------------------------------
1171 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation_purpose)",78953_78955_2_not_null)
1172 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation_purpose)",78953_78955_1_not_null)
1173 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_2_not_null)
1174 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_3_not_null)
1175 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_4_not_null)
1176 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_1_not_null)
1177 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_5_not_null)
1178 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column_purpose)",78953_78984_2_not_null)
1179 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column_purpose)",78953_78984_1_not_null)
1180 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",type)",78953_78993_3_not_null)
1181 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",type)",78953_78993_4_not_null)
1182 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",type)",78953_78993_1_not_null)
1183 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",type)",78953_78993_5_not_null)
1184 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column)",78953_79013_3_not_null)
1185 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column)",78953_79013_4_not_null)
1186 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column)",78953_79013_1_not_null)
1187 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column)",78953_79013_5_not_null)
1188 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",foreign_key)",78953_79033_1_not_null)
1189(18 rows)
1190
1191select 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';
1192                                            tracked_row_add                                             
1193--------------------------------------------------------------------------------------------------------
1194 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",column)",column_purpose_id_fkey)
1195 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",column)",column_widget_id_fkey)
1196 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",relation)",relation_purpose_id_fkey)
1197 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",relation)",relation_widget_id_fkey)
1198 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",type)",type_purpose_id_fkey)
1199 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",type)",type_widget_id_fkey)
1200(6 rows)
1201
1202select 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';
1203                                                                        tracked_row_add                                                                        
1204---------------------------------------------------------------------------------------------------------------------------------------------------------------
1205 org.aquameta.core.semantics - meta.function_definition.semantics/relation_widget/{"relation_id meta.relation_id","widget_purpose text","default_bundle text"}
1206 org.aquameta.core.semantics - meta.function_definition.semantics/column_widget/{"column_id meta.column_id","widget_purpose text","default_bundle text"}
1207(2 rows)
1208
1209select 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');
1210                                                                         stage_row_add                                                                         
1211---------------------------------------------------------------------------------------------------------------------------------------------------------------
1212 org.aquameta.core.semantics - meta.schema.(semantics)
1213 org.aquameta.core.semantics - meta.table.semantics/relation_purpose
1214 org.aquameta.core.semantics - meta.table.semantics/relation
1215 org.aquameta.core.semantics - meta.table.semantics/type
1216 org.aquameta.core.semantics - meta.table.semantics/column_purpose
1217 org.aquameta.core.semantics - meta.table.semantics/column
1218 org.aquameta.core.semantics - meta.table.semantics/foreign_key
1219 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation_purpose)",id)
1220 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation_purpose)",purpose)
1221 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",id)
1222 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",relation_id)
1223 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",priority)
1224 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",purpose_id)
1225 org.aquameta.core.semantics - meta.column.("(""(semantics)"",relation)",widget_id)
1226 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",id)
1227 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",type_id)
1228 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",priority)
1229 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",purpose_id)
1230 org.aquameta.core.semantics - meta.column.("(""(semantics)"",type)",widget_id)
1231 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column_purpose)",id)
1232 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column_purpose)",purpose)
1233 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",id)
1234 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",priority)
1235 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",purpose_id)
1236 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",widget_id)
1237 org.aquameta.core.semantics - meta.column.("(""(semantics)"",column)",column_id)
1238 org.aquameta.core.semantics - meta.column.("(""(semantics)"",foreign_key)",id)
1239 org.aquameta.core.semantics - meta.column.("(""(semantics)"",foreign_key)",foreign_key_id)
1240 org.aquameta.core.semantics - meta.column.("(""(semantics)"",foreign_key)",inline)
1241 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation_purpose)",78953_78955_2_not_null)
1242 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation_purpose)",78953_78955_1_not_null)
1243 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_2_not_null)
1244 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_3_not_null)
1245 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_4_not_null)
1246 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_1_not_null)
1247 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",relation)",78953_78964_5_not_null)
1248 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column_purpose)",78953_78984_2_not_null)
1249 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column_purpose)",78953_78984_1_not_null)
1250 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",type)",78953_78993_3_not_null)
1251 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",type)",78953_78993_4_not_null)
1252 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",type)",78953_78993_1_not_null)
1253 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",type)",78953_78993_5_not_null)
1254 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column)",78953_79013_3_not_null)
1255 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column)",78953_79013_4_not_null)
1256 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column)",78953_79013_1_not_null)
1257 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",column)",78953_79013_5_not_null)
1258 org.aquameta.core.semantics - meta.constraint_check.("(""(semantics)"",foreign_key)",78953_79033_1_not_null)
1259 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",column)",column_purpose_id_fkey)
1260 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",column)",column_widget_id_fkey)
1261 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",relation)",relation_purpose_id_fkey)
1262 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",relation)",relation_widget_id_fkey)
1263 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",type)",type_purpose_id_fkey)
1264 org.aquameta.core.semantics - meta.foreign_key.("(""(semantics)"",type)",type_widget_id_fkey)
1265 org.aquameta.core.semantics - meta.function_definition.semantics/relation_widget/{"relation_id meta.relation_id","widget_purpose text","default_bundle text"}
1266 org.aquameta.core.semantics - meta.function_definition.semantics/column_widget/{"column_id meta.column_id","widget_purpose text","default_bundle text"}
1267(55 rows)
1268
1269select bundle.commit('org.aquameta.core.semantics','initial import');
1270NOTICE:  bundle: Committing to org.aquameta.core.semantics
1271NOTICE:  bundle: Committing rowset_rows...
1272NOTICE:  bundle: Committing blobs...
1273NOTICE:  bundle: Committing stage_row_fields...
1274NOTICE:  bundle: Creating the commit...
1275NOTICE:  bundle: Updating bundle.head_commit_id...
1276NOTICE:  bundle: Cleaning up after commit...
1277 commit 
1278--------
1279 
1280(1 row)
1281
1282drop extension semantics;
1283DROP EXTENSION
1284drop schema semantics;
1285DROP SCHEMA
1286select bundle.checkout((select head_commit_id from bundle.bundle where name='org.aquameta.core.semantics'));
1287NOTICE:  bundle.checkout(): org.aquameta.core.semantics / 8629ca47-84ac-42dc-9792-fb85a81d83b1 @ 2019-02-08 11:09:28.410965 by <NULL>: "initial import"
1288 checkout 
1289----------
1290 
1291(1 row)