Python: module sql2rdef

sql2rdef

SQL to Relation Definition ========================== Outputs a Relation Definition File. Examples: sql2rdef employee.sql > employee.rdef

Modules

cStringIO
datetime
optparse
os
re
sys

Functions

filter(lines)

get_defaults(in_file, opts)

get_label(n)

lname(na)

main()

name(na)

parse_sql(sql)

path(na)

write_fields(buf, base, lines)

write_head(buf, base)

Data

commons = {'ADDRESS_1': 'Address', 'ADDRESS_2': 'PO Box / APT #', 'DOB': 'Date of Birth', 'SSN': 'Social Security Number'}
mapping = [('VARCHAR(255)', 'TextBox'), ('TINYINT(4)', 'CheckBox'), ('BOOLEAN', 'CheckBox'), ('BIGINT(20)', 'Hidden'), ('BIGINT,', 'Hidden'), ('BIGSERIAL', 'Hidden'), ('DATETIME', 'DateTimePicker'), ('DATE,', 'DatePicker'), ('DECIMAL(10,2)', 'Currency'), ('DECIMAL,', 'Number'), ('"PUBLIC"."PHONE"', 'Phone'), ('"PUBLIC"."SSN12,', 'SSN')]

Data
		commons = {'ADDRESS_1': 'Address', 'ADDRESS_2': 'PO Box / APT #', 'DOB': 'Date of Birth', 'SSN': 'Social Security Number'} mapping = [('VARCHAR(255)', 'TextBox'), ('TINYINT(4)', 'CheckBox'), ('BOOLEAN', 'CheckBox'), ('BIGINT(20)', 'Hidden'), ('BIGINT,', 'Hidden'), ('BIGSERIAL', 'Hidden'), ('DATETIME', 'DateTimePicker'), ('DATE,', 'DatePicker'), ('DECIMAL(10,2)', 'Currency'), ('DECIMAL,', 'Number'), ('"PUBLIC"."PHONE"', 'Phone'), ('"PUBLIC"."SSN12,', 'SSN')]