向数据库添加数据时出错。他说它起源于历史。在旧方法中,我们将其设置为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)
目前没有回答
相关问题 更多 >
编程相关推荐