QrhBpcHG

1import sqlite3
2import telebot
3from telebot import types
4
5bot = telebot.TeleBot('977180694:AAHRfNqCmHcqqgUGbikJ-KK6HMcc3XLuOo0')
6
7@bot.message_handler(commands=['start'])
8def start_message(message):
9       keyboard1 = types.ReplyKeyboardMarkup(one_time_keyboard=True,resize_keyboard=True)
10       keyboard1.row('Create zametku', 'Views zametki')
11       bot.send_message(message.chat.id,"hello I'm bot po zametkah",reply_markup=keyboard1)
12       user_id = message.from_user.id
13       conn = sqlite3.connect('save_zametki.db')
14       cur = conn.cursor()
15
16       cur.execute("""CREATE TABLE IF NOT EXISTS zametki(
17          id_zametki INT PRIMARY KEY,
18          name_zametki TEXT,
19          opis_zametki TEXT);
20       """)
21       conn.commit()
22       cur.execute("""CREATE TABLE IF NOT EXISTS user_id(
23          id_users INT PRIMARY KEY,
24          id_user TEXT);
25       """)
26       conn.commit()
27       cur.execute("INSERT INTO user_id(id_users, id_user) VALUES(:0, :1)", {'0': user_id, '1': ""})
28       conn.commit()
29       opis_zametki = ""
30       name_zametki = ""
31
32@bot.message_handler(func=lambda m: True)
33def create_zam(message):
34      if message.text == "Create zametku":
35         bot.send_message(message.from_user.id,"Введите название заметки!: ")
36         bot.register_next_step_handler(message,name_zam)
37
38def name_zam(message):
39        global name_zametki
40        name_zametki = message.text
41        bot.send_message(message.chat.id,"Введите opisanie zametki!: ")
42        bot.register_next_step_handler(message,opis_zam)
43
44def opis_zam(message):
45       global opis_zametki
46       opis_zametki = message.text
47       bot.send_message(message.from_user.id, "Вы ввели!\nНазвание: "+name_zametki +"\nOpisanie: "+opis_zametki)
48       user_id = message.from_user.id     
49       conn = sqlite3.connect('save_zametki.db')
50       cur = conn.cursor()
51       cur.execute("INSERT INTO zametki(id_zametki,name_zametki,opis_zametki) VALUES(:0, :1, :2)", {'0': "2222", '1': name_zametki, '2': opis_zametki})
52       conn.commit()
53
54bot.polling()