def load_table(schema, condition=None):
loader = _get_table_loader(schema, condition)
local_storage_dir = mimic_login.get_local_storage_dir()
if local_storage_dir:
query_f_name = schema.name
if condition is not None:
query_f_name += '_' + condition
query_f_name +='.hdf'
query_f_name = os.path.join(local_storage_dir, query_f_name)
cache = HdfDataStore(schema, query_f_name, fixed=True)
loader = CachingDataStore(schema, loader, cache)
return loader.load()
def load_table(schema, condition=None):
loader = _get_table_loader(schema, condition)
local_storage_dir = mimic_login.get_local_storage_dir()
if local_storage_dir:
query_f_name = schema.name
if condition is not None:
query_f_name += '_' + condition
query_f_name += '.hdf'
query_f_name = os.path.join(local_storage_dir, query_f_name)
cache = HdfDataStore(schema, query_f_name, fixed=True)
loader = CachingDataStore(schema, loader, cache)
return loader.load()
def load_table(schema, condition=None):
loader = _get_table_loader(schema, condition)
local_storage_dir = mimic_login.get_local_storage_dir()
if local_storage_dir:
query_f_name = schema.name
if condition is not None:
db_file = mimic_login.get_db_file()
with shelve.open(db_file) as db:
qs_k = 'queries_' + schema.name
if qs_k not in db:
db[qs_k] = ()
condition = slugify(condition)
if condition not in db[qs_k]:
db[qs_k] += (condition, )
q_idx = db[qs_k].index(condition)
query_f_name += '_query_' + str(q_idx)
query_f_name += '.hdf'
query_f_name = os.path.join(local_storage_dir, query_f_name)
cache = AppendableHdfDataStore(schema, query_f_name)
loader = CachingDataStore(schema, loader, cache)
with sql_exception():
return loader.load()
def load_table(schema, condition=None):
loader = _get_table_loader(schema, condition)
local_storage_dir = mimic_login.get_local_storage_dir()
if local_storage_dir:
query_f_name = schema.name
if condition is not None:
db_file = mimic_login.get_db_file()
with shelve.open(db_file) as db:
qs_k = 'queries_'+schema.name
if qs_k not in db:
db[qs_k] = ()
condition = slugify(condition)
if condition not in db[qs_k]:
db[qs_k] += (condition,)
q_idx = db[qs_k].index(condition)
query_f_name += '_query_' + str(q_idx)
query_f_name +='.hdf'
query_f_name = os.path.join(local_storage_dir, query_f_name)
cache = AppendableHdfDataStore(schema, query_f_name)
loader = CachingDataStore(schema, loader, cache)
with sql_exception():
return loader.load()
