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()