问题[sqlite]

我会尽量写得很简短，代码会很零碎，我会尽量不写太多。我只想说我在控制台中逐行检查了所有内容，我将在下面附加错误。我有一个有五个字段的类，第一和第五是明确的。

class Article(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(100), nullable=False)
    intro = db.Column(db.String(300), nullable=False)
    text = db.Column(db.Text, nullable=False)
    date = db.Column(db.DateTime, default=datetime.utcnow)


    def __repr__(self):
        return '<Article %r>' % (self.id)

对象填写表格：

<form action="/create-article" method="post">
<input type="text" name="title" id="title" class="form-control"></br>
<textarea name="intro" id="intro" class="form-control"></textarea></br>
<textarea name="text" id="text" class="form-control"></textarea></br>
<input type="submit" class="btn btn-success" value="Отправить">

然后使用 post 方法，我只需创建一个填充了字段的对象

def create_article():
    if request.method == 'POST':
        title = request.form['title']
        intro = request.form['intro']
        text = request.form['text']

        article = Article(title=title, intro=intro, text=text)
        with app.app_context():
            try:
                db.session.add(article)
                db.session.commit()
                return redirect('/')
            except:
                return 'Error'
    else:
        return render_template('create-article.html')

起初我很长一段时间无法创建数据库本身，据我了解，新版本的Flask有这样的问题。我阅读了文档，我必须以 with app.app_context(): 不同的方式编写它

这通常意味着您尝试使用当前应用程序所需的功能。要解决此问题，请设置应用程序上下文 with app.app_context()。请参阅文档以获取更多信息。

那么，向数据库添加文章时，这也是唯一的方法。

返回“错误”

我在控制台中逐行尝试了所有内容，该步骤db.session.commit() 出现错误

> sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: article
[SQL: INSERT INTO article (title, intro, text, date) VALUES (?, ?, ?, ?)]
[parameters: ('title', 'intro', 'text', '2024-03-13 04:25:38.283046')]
(Background on this error at: https://sqlalche.me/e/20/e3q8)

但该类的实例已经创建并且可以访问。我附上屏幕截图。

当然，我在弄清楚app_context之后创建了数据库

app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///blog.db'

在控制台中，我只是手动将同名行添加到三个字段中进行测试。

显然该文章对象不存在。我恳请你帮我解决这个问题。

我正在用 Lazarus 编写程序。SQLite 中的数据库。当我单击按钮时，我想更新数据库中的数据并执行以下操作：

fAuto.SQLQ.Close;
fAuto.SQLQ.SQL.Clear;
fAuto.SQLQ.SQL.Text := 'update books set ISBN=:ISBN, book_name=:BN, author=:A, original_name=:ON, original_language=:OL, publisher_name=:PN, translator=:T, issue_year=:IY, page_count=:PC, book_count=:BC, book_price=:BP, only_for_reading_room=:OFRR, comment=:C where index=:I';
fAuto.SQLQ.ParamByName('ISBN').AsString := eISBN.Text;
fAuto.SQLQ.ParamByName('BN').AsString := eBookName.Text;
fAuto.SQLQ.ParamByName('A').AsString := eAuthor.Text;
fAuto.SQLQ.ParamByName('ON').AsString := eOriginalName.Text;
fAuto.SQLQ.ParamByName('OL').AsString := eOriginalLanguage.Text;
fAuto.SQLQ.ParamByName('PN').AsString := ePublisherName.Text;
fAuto.SQLQ.ParamByName('T').AsString := eTranslator.Text;
fAuto.SQLQ.ParamByName('IY').AsString := eIssueYear.Text;
fAuto.SQLQ.ParamByName('PC').AsInteger := ePageCount.Value;
fAuto.SQLQ.ParamByName('BC').AsInteger := eBookCount.Value;
fAuto.SQLQ.ParamByName('BP').AsString := eBookPrice.Text;
fAuto.SQLQ.ParamByName('OFRR').AsBoolean := eOFRR.Checked;
fAuto.SQLQ.ParamByName('C').AsString := eComment.Lines.Text;
fAuto.SQLQ.ParamByName('I').AsInteger := strtoint(eIndex.Text);
fAuto.SQLQ.ExecSQL;
fAuto.SQLTransaction.Commit;
fAuto.SQLQ.Close;

按下按钮后，程序停在 fAuto.SQLQ.ExecSQL 并给出错误

SQLConnection：“索引”附近：语法错误

书籍表的结构：

写作：

post = cur.execute("""SELECT id FROM ochered""")
print(post)

我得到：

<sqlite3.Cursor object at 0x0000000003E0FB20>

所有代码：

import config
import json

from aiogram import Bot, Dispatcher, executor, types
import sqlite3 as sq
import asyncio
import aioschedule

bot = Bot(token=config.TOKEN)
dp = Dispatcher(bot)

global base, cur
base = sq.connect('ochered.db')
cur = base.cursor()

async def on_startup(_):
    scheduler()
    
async def scheduler():
    aioschedule.every(1).minutes.do(public)
    while True:
        await aioschedule.run_pending()
        await asyncio.sleep(1)

@dp.message_handler(content_types=['photo', 'video'])
async def dobavlenie(message: types.Message):
    base.execute('CREATE TABLE IF NOT EXISTS ochered(id, type)')
    if message.photo:
        params = ( message.photo[0].file_id, 'photo')
    elif message.video:
        params = ( message.video.file_id, 'video')
    cur.execute('INSERT INTO ochered VALUES (?, ?)', params)
    base.commit()
    
#@dp.message_handler()
async def dobavlenie(message: types.Message):
    chmo = cur.fetchone()
    print(chmo)

@dp.message_handler()
async def public(message: types.Message):
    post = cur.execute("""SELECT id FROM ochered""")
    print(post)
    #await bot.send_photo( chat_id = config.chat_id, photo = post[0])
    #cur.execute('DELETE id FROM ochered WHERE ROW_NOMBER == 1')
executor.start_polling(dp, skip_updates=True)

写作：

@dp.message_handler(text = 'Проверка')
async def privet(message: types.Message):
   cur.execute("SELECT id FROM podpiska WHERE dt == datetime.date.today().day AND oplata == 0")
   result = cur.fetchall()
   await bot.send_message(result)

分发：

  File "C:\Users\Anna\Desktop\python\рр\bot.py", line 33, in privet
    cur.execute("SELECT id FROM podpiska WHERE dt == datetime.date.today().day A
ND oplata == 0")
sqlite3.OperationalError: near "(": syntax error

调用该命令时C.send，server.db 数据库应该添加到选定的 id + 1 计数，但这不会发生。可能是什么问题？

import discord
import random
import time
from datetime import datetime,timedelta
from discord.ext import commands
from discord.ext.commands import MissingPermissions
from discord.utils import get
from discord.ext.commands import cooldown, BucketType
import asyncio
import sqlite3
import functools
import operator


bot = commands.Bot(command_prefix = "C.",intents = discord.Intents.all())

@bot.event 
async def on_ready():
       print("Hi!\nBot {NAME} is ready!")
       print('------------------')         
       db = sqlite3.connect('server.db')
       sql = db.cursor()       
       sql.execute("""CREATE TABLE IF NOT EXISTS users (
       id INT,
       name TEXT,
       count INT,
       server_id INT
               
       )""")
       db.commit()
                                                    
       for guild in bot.guilds:     
        guild_id = guild.id
        guild = bot.get_guild(guild_id)
        for member in guild.members:
            role = discord.utils.get(guild.roles, name="role_create")           
            if role not in guild.roles:
                await guild.create_role(name="role_create")
                print(f'Роль для {guild.name} создана!')
                
            if role in member.roles:                
                if sql.execute(f'SELECT id FROM users WHERE id = {member.id}').fetchone() is None:
                    sql.execute(f"INSERT INTO users VALUES ({member.id}, '{member}', 0,  {member.guild.id})")                                                       
                    db.commit()
       else:
        user_id_to_random = []
        for value in sql.execute("SELECT * FROM users"):
            print(value)      
        for user_id_in_sql in sql.execute(f"SELECT id FROM users"):         
            convert = functools.reduce(operator.add, (user_id_in_sql))
            user_id_to_random.append(convert)
        else:                                   
            global r
            r = random.choice(user_id_to_random)


@bot.command()
async def send(ctx):
    sql.execute(f"UPDATE users SET count = count + 1 WHERE id = {r} ")
    db.commit()

bot.run(TOKEN)