def _add_sql_columns_for_table(sql_table,code): labels = mongoutils.get_labelset() table_labels = labels['tables'][code] if table_labels['name'].find('AVERAGE') != -1 or table_labels['name'].find('MEDIAN') != -1: col_type = Float else: col_type = Integer for label in sorted(table_labels['labels']): sql_table.append_column(Column(label, col_type(), nullable=False))
def _add_sql_columns_for_table(sql_table, code): labels = mongoutils.get_labelset() table_labels = labels['tables'][code] if table_labels['name'].find('AVERAGE') != -1 or table_labels['name'].find( 'MEDIAN') != -1: col_type = Float else: col_type = Integer for label in sorted(table_labels['labels']): sql_table.append_column(Column(label, col_type(), nullable=False))
def generate_views_by_table(table_codes=None): labels = mongoutils.get_labelset() statements = [] if table_codes is None: table_codes = [] for f in SF1_FILE_SEGMENTS[1:]: table_codes.extend(f) statements = [] for table_code in table_codes: table_name = _table_name_for_number(FILE_NUMBER_BY_TABLE_CODE[table_code]) columns = ['"%s"' % x[0] for x in LINKING_COLUMNS] for label in sorted(labels['tables'][table_code]['labels']): columns.append('"%s"' % label) columns = ',\n'.join(columns) statements.append('CREATE VIEW sf1_%s as SELECT %s from %s;' % (table_code,columns,table_name)) return "\n\n".join(statements)
def generate_views_by_table(table_codes=None): labels = mongoutils.get_labelset() statements = [] if table_codes is None: table_codes = [] for f in SF1_FILE_SEGMENTS[1:]: table_codes.extend(f) statements = [] for table_code in table_codes: table_name = _table_name_for_number( FILE_NUMBER_BY_TABLE_CODE[table_code]) columns = ['"%s"' % x[0] for x in LINKING_COLUMNS] for label in sorted(labels['tables'][table_code]['labels']): columns.append('"%s"' % label) columns = ',\n'.join(columns) statements.append('CREATE VIEW sf1_%s as SELECT %s from %s;' % (table_code, columns, table_name)) return "\n\n".join(statements)