import telebot
import sqlite3
bot = telebot.TeleBot('token ')
name = None
@bot.message_handler(commands=['start'])
def start(message):
conn = sqlite3.connect('OnlineShop.sql')
cur = conn.cursor()
cur.execute(
'CREATE TABLE IF NOT EXISTS users (id int auto_increment primery key, name varchar(50), pass varchar(50))')
conn.commit()
cur.close()
conn.close()
bot.send_message(message.chat.id, 'Hello send me your name fro save datta base')
bot.register_next_step_handler(message, user_name)
def user_name(message):
global name
name = message.text.strip()
bot.send_message(message.chat.id, 'send me your passawerd')
bot.register_next_step_handler(message, user_pass)
def user_pass(message):
password = message.text.strip()
conn = sqlite3.connect('OnlineShop.sql')
cur = conn.cursor()
cur.execute(
"INSERT INTO users (name, pass)VALUES ('%s','%s' )" % (name, password))
conn.commit()
cur.close()
conn.close()
markup = telebot.types.InlineKeyboardMarkup()
markup.add(telebot.types.InlineKeyboardButton('list users', callback_data='users'))
bot.send_message(message.chat.id, 'succses', reply_markup=markup)
@bot.callback_query_handlers(function=lambda call: True)
def callback(call):
conn = sqlite3.connect('OnlineShop.sql')
cur = conn.cursor()
cur.execute("SELECT * FROM users")
users = cur.fetchall()
info = ''
for el in users:
info += f'Name: {el[1]}, Password: {el[2]}\n'
cur.close()
conn.close()
bot.send_message(call.message.chat.id, info)
bot.polling(none_stop=True)
