source: mauRepo/xmi2sqlalchemy/trunk/src/test/resources/removeAll @ 8043

Subversion URL: http://proj.badc.rl.ac.uk/svn/ndg/mauRepo/xmi2sqlalchemy/trunk/src/test/resources/removeAll@8043
Revision 8043, 709 bytes checked in by mnagni, 8 years ago (diff)

Works fine. Now initializes also the python classes attributes

Line 
1 SELECT   
2 'DROP TABLE IF EXISTS '||c.relname ||' CASCADE;' 
3 FROM pg_catalog.pg_class c 
4 JOIN pg_catalog.pg_roles r ON r.oid = c.relowner 
5 LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace 
6 WHERE c.relkind IN ('r','') 
7 AND n.nspname NOT IN ('pg_catalog', 'pg_toast') 
8 AND pg_catalog.pg_table_is_visible(c.oid) 
9 ORDER BY 1; 
10
11SELECT   
12 'DROP SEQUENCE IF EXISTS '||c.relname ||' CASCADE;' 
13 FROM pg_catalog.pg_class c 
14 JOIN pg_catalog.pg_roles r ON r.oid = c.relowner 
15 LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace 
16 WHERE c.relkind IN ('S','') 
17 AND n.nspname NOT IN ('pg_catalog', 'pg_toast') 
18 AND pg_catalog.pg_table_is_visible(c.oid) 
19 ORDER BY 1; 
Note: See TracBrowser for help on using the repository browser.