# Path: scripts/civ5/databases.py
# class DatabaseAdapter(object):
#     def __init__(self, filepath):
#         self.filepath = filepath
#         self.conn = sqlite3.connect(filepath)
#         self.conn.row_factory = sqlite3.Row
# 
#     def __del__(self):
#         self.close()
# 
#     def close(self):
#         self.conn.close()


from .databases import DatabaseAdapter
        type TEXT,
        sort_order INT,
        FOREIGN KEY (technology) REFERENCES technology (_id)
    )
'''
INSERT_BUILDINGS_SQL = '''
    INSERT INTO building
        (_id, name, civilopedia, help, strategy, cost,
         faith_cost, maintenance, technology, type, sort_order)
    VALUES(:_id, :name, :civilopedia, :help, :strategy, :cost,
           :faith_cost, :maintenance, :technology, :type, :sort_order)
'''
CREATE_WONDERS_SQL = '''
    CREATE TABLE wonder (
        _id TEXT PRIMARY KEY,
        name TEXT,
        civilopedia TEXT,
        help TEXT,
        strategy TEXT,
        quote TEXT,
        cost INTEGER,
        type TEXT
    )
'''
INSERT_WONDERS_SQL = '''
    INSERT INTO wonder
        (_id, name, civilopedia, help, strategy, quote, cost, type)
    VALUES(:_id, :name, :civilopedia, :help, :strategy, :quote, :cost, :type)
'''
CREATE_RELIGION_SQL = '''

# Path: scripts/civ5/databases.py
# class DatabaseAdapter(object):
#     def __init__(self, filepath):
#         self.filepath = filepath
#         self.conn = sqlite3.connect(filepath)
#         self.conn.row_factory = sqlite3.Row
# 
#     def __del__(self):
#         self.close()
# 
#     def close(self):
#         self.conn.close()


# Path: scripts/civ5/utils.py
from .databases import DatabaseAdapter

        type TEXT,
        sort_order INT,
        FOREIGN KEY (technology) REFERENCES technology (_id)
    )
'''
INSERT_BUILDINGS_SQL = '''
    INSERT INTO building
        (_id, name, civilopedia, help, strategy, cost,
         faith_cost, maintenance, technology, type, sort_order)
    VALUES(:_id, :name, :civilopedia, :help, :strategy, :cost,
           :faith_cost, :maintenance, :technology, :type, :sort_order)
'''
CREATE_WONDERS_SQL = '''
    CREATE TABLE wonder (
        _id TEXT PRIMARY KEY,
        name TEXT,
        civilopedia TEXT,
        help TEXT,
        strategy TEXT,
        quote TEXT,
        cost INTEGER,
        type TEXT
    )
'''
INSERT_WONDERS_SQL = '''
    INSERT INTO wonder
        (_id, name, civilopedia, help, strategy, quote, cost, type)
    VALUES(:_id, :name, :civilopedia, :help, :strategy, :quote, :cost, :type)
'''
CREATE_RELIGION_SQL = '''

    CREATE TABLE religion (