summaryrefslogtreecommitdiff
path: root/sqlplain/doc/compare_tables.py
diff options
context:
space:
mode:
Diffstat (limited to 'sqlplain/doc/compare_tables.py')
-rw-r--r--sqlplain/doc/compare_tables.py32
1 files changed, 0 insertions, 32 deletions
diff --git a/sqlplain/doc/compare_tables.py b/sqlplain/doc/compare_tables.py
deleted file mode 100644
index 36f18e8..0000000
--- a/sqlplain/doc/compare_tables.py
+++ /dev/null
@@ -1,32 +0,0 @@
-from sqlplain import connect, do
-from cStringIO import StringIO
-#from sqlplain.postgres_util import get_schema_postgres
-#print get_schema_postgres(rcare.uri, 'customer')
-
-rcare = connect('rcare')
-rcare_prod = connect('rcare_prod')
-
-CREATE_CUSTOMER = '''
-CREATE TABLE $customer (
- client_id character varying(32) PRIMARY KEY,
- description character varying,
- email character varying,
- short_description character varying(16),
- mail_report_info character varying(128),
- attach_prefix character varying(32),
- filter_from character varying(32),
- zope_id character varying(32),
- lookup boolean,
- client_srs character varying(32),
- CONSTRAINT nnull_id_short_desc CHECK ((short_description IS NOT NULL))
-);
-'''
-
-def copy_from(src, dest, table):
- out = StringIO()
- src._curs.copy_to(out, 'customer')
- drop_table(dest, 'customer_prod', force=True):
- dest.executescript(CREATE_CUSTOMER, customer='customer_prod')
- dest._curs.copy_from(out, 'customer_prod')
- out.close()
-