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