def _get_table_names(self, db_file_path, tables):
rtn = {}
with sql.connect(db_file_path) as con:
def try_name(name):
try:
con.execute("Select * from [%s]" % name)
except:
return False
return True
for table in tables:
rtn[table] = [
t for t in all_underscore_replacements(table)
if try_name(t)
]
verify(
len(rtn[table]) <= 1,
"Duplicate tables found for table %s in SQLite file %s" %
(table, db_file_path))
if rtn[table]:
rtn[table] = rtn[table][0]
else:
rtn.pop(table)
return rtn
def _get_table_names(self, db_file_path, tables):
rtn = {}
with _connect(_connection_str(db_file_path)) as con:
def try_name(name):
with con.cursor() as cur:
try:
cur.execute("Select * from [%s]" % name)
except:
return False
return True
for table in tables:
rtn[table] = [
t for t in all_underscore_replacements(table)
if try_name(t)
]
verify(
len(rtn[table]) >= 1,
"Unable to recognize table %s in MS Access file %s" %
(table, db_file_path))
verify(
len(rtn[table]) <= 1,
"Duplicate tables found for table %s in MS Access file %s"
% (table, db_file_path))
rtn[table] = rtn[table][0]
return rtn
def _get_table_names(self, con):
rtn = {}
def try_name(name):
try :
con.execute("Select * from [%s]"%name)
except :
return False
return True
for table in self.pan_dat_factory.all_tables:
rtn[table] = [t for t in all_underscore_replacements(table) if try_name(t)]
verify(len(rtn[table]) >= 1, "Unable to recognize table %s" % table)
verify(len(rtn[table]) <= 1, "Multiple possible tables found for table %s" % table)
rtn[table] = rtn[table][0]
return rtn
