示例#1
0
def fill_db():
  filename = file_default()
  # a bit of a hack... there is only one table so it is just
  # the input filename
  table_defs = get_tables()
  column_maps =get_maps()
  table_names = map(lambda x: x['name'],table_defs)
  table_files = [filename]

  col_sep = ','
  rec_sep = '\n'

  adapters.fileMap2DB2('gb_accjoin',
                      table_files,
                      table_names,
                      table_defs,
                      column_maps,
                      col_sep,
                      rec_sep,
                      500000,
                      reset = True)
示例#2
0
def fill_db(start = None, finish = None):
  filename = file_default()
  # a bit of a hack... there is only one table so it is just
  # the input filename
  table_defs = get_tables()
  column_maps =get_maps()
  table_names = map(lambda x: x['name'],table_defs)
  table_files = [filename]

  col_sep = '\t'
  rec_sep = '\n'

  adapters.fileMap2DB2('tax_gbs',
                      table_files,
                      table_names,
                      table_defs,
                      column_maps,
                      col_sep,
                      rec_sep,
                      321166,
                      reset = True)