Flask报错:sqlite3.IntegrityError: NOT NULL constraint failed: step. date

  • ​​报错如图​​
  • ​​解决方法​​

报错如图

Flask报错:sqlite3.IntegrityError: NOT NULL constraint failed: step. date_python

解决方法

开始:

db=connect_db()
db.execute(
'INSERT INTO walk (step) VALUES (?)', [step])
db.commit()

改为:

db=connect_db()
db.execute(
'INSERT INTO walk (step,date) VALUES (?,?)', [step,date])
db.commit()

即可