def create_table(create_table_command, db_file):
"""
Utility method to create db tables
:param create_table_command: command to create table
:param db_file: database file
:return: None
"""
conn = connection.connect(db_file)
cur = conn.cursor()
cur.execute(create_table_command)
conn.commit()
connection.close(conn)
def insert_to_table(data_list, insert_command, db_file):
"""
Insert data into a given table
:param data_list: data as list of tuples
:param insert_command: insert command
:param db_file: database file
:return:
"""
con = connection.connect(db_file)
cur = con.cursor()
cur.executemany(insert_command, data_list)
con.commit()
connection.close(con)
def read_all_data(db_file, sql):
"""
Utility method to read Read data as list of tuples
:param db_file: db file
:param sql sql command
:return: result
:raise sqlite3.OperationalError when db_file is not the correct db file
""" ""
con = connection.connect(db_file)
cur = con.cursor()
cur.execute(sql)
result = cur.fetchall()
con.commit()
connection.close(con)
return result
import sqlalchemy as db
from db import engine, connection
metadata = db.MetaData()
result = db.Table("result", metadata,
db.Column("id", db.Integer, primary_key=True),
db.Column("NUTS1", db.String(10)),
db.Column("NUTS2", db.String(10)),
db.Column("NUTS3", db.String(10)),
db.Column("DISTRICT_CODE", db.String(10)),
db.Column("T", db.Integer), db.Column("WV", db.Integer),
db.Column("WK", db.Integer), db.Column("BZ", db.Integer),
db.Column("SPR", db.Integer), db.Column("WBER", db.Integer),
db.Column("ABG", db.Integer), db.Column("UNG", db.Integer),
db.Column("OEVP", db.Integer), db.Column("SPOE", db.Integer),
db.Column("FPOE", db.Integer), db.Column("NEOS", db.Integer),
db.Column("JETZT", db.Integer),
db.Column("GRUE", db.Integer), db.Column("KPOE", db.Integer),
db.Column("WANDL",
db.Integer), db.Column("BIER", db.Integer))
metadata.create_all(engine)
connection.close()
except:
response = 'Произошла непредвиденная ошибка!'
update.message.reply_text(response)
store_log(update, response)
def command_help(bot: Bot, update: Update) -> None:
update.message.reply_text('*Отправьте сообщение в одном из форматов:*\n'
'1000 - будет считаться как BYN\n'
'1000 BYN\n'
'1000 USD\n'
'1000 $\n'
'1000 EUR\n'
'1000 €\n'
'1000 RUR\n'
'1000 ₽\n', parse_mode=telegram.ParseMode.MARKDOWN)
update_thread = UpdateThread()
update_thread.start()
updater = Updater(token)
updater.dispatcher.add_handler(MessageHandler(Filters.text, message))
updater.dispatcher.add_handler(CommandHandler('help', command_help))
updater.start_polling()
updater.idle()
atexit.register(lambda: connection.close())