import config
import telebot
import MySQLdb
 
bot = telebot.TeleBot(config.token)
 
 
@bot.message_handler(commands=['start'])
def start_conversation(message):
	bot.send_message(message.chat.id, "Просто пришлите боту номер вашей квитанции:")
 
@bot.message_handler(content_types=["text"])
def repeat_all_messages(message):
	try:
		conn = MySQLdb.connect(host="localhost", user="root", passwd="1234", db="mobilservice")
 
	except MySQLdb.Error as err:
		print("Connection error: {}".format(err))
		conn.close()
 
	sql = "SELECT note FROM application WHERE id = " + message.text
 
	try:
		cur = conn.cursor(MySQLdb.cursors.DictCursor)
		cur.execute(sql)
		data = cur.fetchall()
	except MySQLdb.Error as err:
		print("Query error: {}".format(err))
	bot.send_message(message.chat.id, data[0]['note'])
 
if __name__ == '__main__':
    bot.polling(none_stop=True)

aW1wb3J0IGNvbmZpZwppbXBvcnQgdGVsZWJvdAppbXBvcnQgTXlTUUxkYgoKYm90ID0gdGVsZWJvdC5UZWxlQm90KGNvbmZpZy50b2tlbikKCgpAYm90Lm1lc3NhZ2VfaGFuZGxlcihjb21tYW5kcz1bJ3N0YXJ0J10pCmRlZiBzdGFydF9jb252ZXJzYXRpb24obWVzc2FnZSk6Cglib3Quc2VuZF9tZXNzYWdlKG1lc3NhZ2UuY2hhdC5pZCwgItCf0YDQvtGB0YLQviDQv9GA0LjRiNC70LjRgtC1INCx0L7RgtGDINC90L7QvNC10YAg0LLQsNGI0LXQuSDQutCy0LjRgtCw0L3RhtC40Lg6IikKCkBib3QubWVzc2FnZV9oYW5kbGVyKGNvbnRlbnRfdHlwZXM9WyJ0ZXh0Il0pCmRlZiByZXBlYXRfYWxsX21lc3NhZ2VzKG1lc3NhZ2UpOgoJdHJ5OgoJCWNvbm4gPSBNeVNRTGRiLmNvbm5lY3QoaG9zdD0ibG9jYWxob3N0IiwgdXNlcj0icm9vdCIsIHBhc3N3ZD0iMTIzNCIsIGRiPSJtb2JpbHNlcnZpY2UiKQoKCWV4Y2VwdCBNeVNRTGRiLkVycm9yIGFzIGVycjoKCQlwcmludCgiQ29ubmVjdGlvbiBlcnJvcjoge30iLmZvcm1hdChlcnIpKQoJCWNvbm4uY2xvc2UoKQoKCXNxbCA9ICJTRUxFQ1Qgbm90ZSBGUk9NIGFwcGxpY2F0aW9uIFdIRVJFIGlkID0gIiArIG1lc3NhZ2UudGV4dAoJICAgIAoJdHJ5OgoJCWN1ciA9IGNvbm4uY3Vyc29yKE15U1FMZGIuY3Vyc29ycy5EaWN0Q3Vyc29yKQoJCWN1ci5leGVjdXRlKHNxbCkKCQlkYXRhID0gY3VyLmZldGNoYWxsKCkKCWV4Y2VwdCBNeVNRTGRiLkVycm9yIGFzIGVycjoKCQlwcmludCgiUXVlcnkgZXJyb3I6IHt9Ii5mb3JtYXQoZXJyKSkKCWJvdC5zZW5kX21lc3NhZ2UobWVzc2FnZS5jaGF0LmlkLCBkYXRhWzBdWydub3RlJ10pCgppZiBfX25hbWVfXyA9PSAnX19tYWluX18nOgogICAgYm90LnBvbGxpbmcobm9uZV9zdG9wPVRydWUp