def load_assessment_data(year, layout, data,
flush=False,
database=DEFAULT_DATABASE):
with open(layout, 'rb') as f:
schema = get_assessment_schema(int(year))
schema.from_file(f)
with open(data, 'r') as f:
loader = get_assessment_loader(int(year))
loader.set_schema(schema)
load_data(loader, f, database, flush)
def create_assessment_schema(year, layout, database=DEFAULT_DATABASE, drop=False):
with open(layout, 'rb') as f:
schema = get_assessment_schema(int(year))
schema.from_file(f)
create_tables_from_schema(schema, database, drop=drop)
