def _create_db():
"""Returns a dbreader instance, that is connected to the main game data dbfiles.
NOTE: This data is read_only, so there are no concurrency issues"""
_db = UhDbAccessor(':memory:')
_db("ATTACH ? AS data", 'content/game.sqlite')
_db("ATTACH ? AS settler", 'content/settler.sqlite')
_db("ATTACH ? AS balance", 'content/balance.sqlite')
return _db
def _create_main_db():
"""Returns a dbreader instance, that is connected to the main game data dbfiles.
NOTE: This data is read_only, so there are no concurrency issues."""
_db = UhDbAccessor(':memory:')
for i in PATHS.DB_FILES:
with open(i, "r") as f:
sql = "BEGIN TRANSACTION;" + f.read() + "COMMIT;"
_db.execute_script(sql)
return _db
