sqlalchemy.exc.IntegrityError:(sqlite3.IntegrityError)非空约束失败:application.date

2024-09-26 22:12:15 发布

您现在位置:Python中文网/ 问答频道 /正文

向数据库添加数据时出错。他说它起源于历史。在旧方法中,我们将其设置为default = datetime.now。现在是不同了还是我又犯了一个错误

    Table("application", meta,
    Column('id', Integer, primary_key=True),
    Column('name', VARCHAR(80)),
    Column('password', VARCHAR(80)),
    Column('anaSayfa', VARCHAR(80)),
    Column('manuelSayfa', VARCHAR(80)),
    Column('varsayilanlar', VARCHAR(80)),
    Column('dinamik', VARCHAR(80)),
    Column('dinamikSayfa', VARCHAR(80)),
    Column('kitap', String(80)),
    Column('kalem', String(80)),
    Column('date', DateTime, nullable=False, default=datetime.now))       
    meta.create_all(engine)

下面是代码:

app = Table('application', meta).insert().values(name = isim,
password = request.form.get("password"),
anaSayfa = request.form.get("anaSayfa"),
manuelSayfa = request.form.get("manuelSayfa"),
varsayilanlar= request.form.get("varsayilanlar"),
dinamikSayfa = request.form.get("dinamikSayfa"),
dinamik = bool(request.form.get("dinamik")),
kitap = bool(request.form.get("kitap")),
kalem = bool(request.form.get("kalem"))
    )

   conn = engine.connect()
    result = conn.execute(app)

和错误:

sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: application.date [SQL: INSERT INTO application (name, password, "anaSayfa", "manuelSayfa", varsayilanlar, dinamik, "dinamikSayfa", kitap, kalem) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('app', 'password', 'as', 'ms', '{}', False, 'ds', True, False)] (Background on this error at: http://sqlalche.me/e/14/gkpj)


Tags: formgetapplicationrequestcolumnpasswordmetavarchar

热门问题