sqlite3.OperationalError: database is locked

import telebot import sqlite3 import config

bot = telebot.TeleBot(config.token) keyboard_1 = telebot.types.ReplyKeyboardMarkup()

a = 1 result = []

@bot.message_handler(commands=['start']) def start_message(message): markup = telebot.types.InlineKeyboardMarkup() markup.add(telebot.types.InlineKeyboardButton(text='Yes', callback_data=100)) bot.send_message(message.chat.id, 'Hi! I control your expenses. Would you like to start?', reply_markup=markup) sqlite_connection = sqlite3.connect('bot.db') cursor = sqlite_connection.cursor() user_id = str(message.from_user.id) for i in range(0, len(user_id), a): result.append(int(user_id[i: i + a])) for i in range(0, len(result)): if result[i] == 1: result[i] = 'a' elif result[i] == 2: result[i] = 'b' elif result[i] == 3: result[i] = 'c' elif result[i] == 4: result[i] = 'd' elif result[i] == 5: result[i] = 'e' elif result[i] == 6: result[i] = 'f' elif result[i] == 7: result[i] = 'g' elif result[i] == 8: result[i] = 'h' elif result[i] == 9: result[i] = 'i' elif result[i] == 0: result[i] = 'j'

user_id = ''.join(result)

cursor.execute(f'CREATE TABLE IF NOT EXISTS {user_id}(expence_type, amount)')
sqlite_connection.close()

if name == 'main': bot.infinity_polling()


Ответы (0 шт):