Python-сообщество

     
def __init__(self):    # инициализирует переменные и запускает функции на выполнение
        global den
        global cur
        global conn
        global session
        global Session
        global engine
        global dbPath
        global emp
        global metadata
        global k
        global data0

         self.create_emp=self.create_emp()
        self.print_emp=self.print_emp()
        self.create_table_emp_for_alchemy=self.create_table_emp_for_alchemy()
        self.print_table_emp_alchemy=self.print_table_emp_alchemy()

         engine = create_engine('sqlite:///%s' % dbPath)
        metadata = MetaData(engine)
        emp = Table('emp', metadata, Column('id', Integer, primary_key=True), Column('name', String), Column('salary', Integer), Column('dept', Integer),)
        Session = sessionmaker(bind=engine)
        session = Session()
        metadata.create_all(engine)

 SQL_QUERY0 = '''CREATE TABLE emp(name text,salary real, dept real, id integer, CONSTRAINT id_pk PRIMARY KEY (id))
INSERT INTO emp VALUES('tyrion', 100000, 2, 1)
INSERT INTO emp VALUES('jon', 100, 3, 2)
INSERT INTO emp VALUES('daenerys', 10000, 4, 3)
INSERT INTO emp VALUES('daenerys', 12000, 12, 4)
INSERT INTO emp VALUES('daenerys', 15000, 40, 5)
INSERT INTO emp VALUES('daenerys', 40000, 62, 6)
ALTER TABLE emp ADD COLUMN deptis integer
ALTER TABLE emp RENAME COLUMN deptis TO rt'''
....
for line in SQL_QUERY0.split('\n'):
   cur.executet(line)

 def execute_sql_query(SQL_QUERY):
    cur.execute(SQL_QUERY)