SQL化学瓶不导入db

Question

我试图导入我的数据库，但它一直抛出一个错误，我不知道我错在哪里

这是我的代码从主应用程序(flashlog .py)

from datetime import datetime
from flask import Flask, render_template, url_for, flash, redirect
from flask_sqlalchemy import SQLAlchemy
from forms import RegistrationForm, LoginForm

app = Flask(__name__)
app.config['SECRET_KEY'] = 'cac78a5498388aa4a95fb2be0f0a6499'
app.config['SQLALCHEMY_DATABASE_URI'] = 'aqlite:///site.db'
db = SQLAlchemy(app)
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
image_file = db.Column(db.String(20), unique=True, default='default.jpg')
password = db.Column(db.String(60), nullable=False)
posts = db.relationship('Post', backref="author", lazy=True)
def __repr__(self):
return f"User('{self.username}','{self.email}','{self.image_file}')"
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
date_posted = db.Column(db.DateTime, nullable=False, datetime=datetime.utcnow)
content = db.Column(db.Text, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f"Post('{self.title}','{self.date_posted}')"

这里是我一直收到的错误:

>>> from flaskblog import db
C:Usershpminiconda3libsite-packagesflask_sqlalchemy__init__.py:794: FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future.  Set it to True or False to suppress this warning.
'SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and '
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "C:UsershpFlask_Blogflaskblog.py", line 22, in <module>
class Post(db.Model):
File "C:UsershpFlask_Blogflaskblog.py", line 25, in Post
date_posted = db.Column(db.DateTime, nullable=False, datetime=datetime.utcnow)
File "C:Usershpminiconda3libsite-packagessqlalchemysqlschema.py", line 1644, in __init__
self._extra_kwargs(**kwargs)
File "C:Usershpminiconda3libsite-packagessqlalchemysqlschema.py", line 1686, in _extra_kwargs
self._validate_dialect_kwargs(kwargs)
File "C:Usershpminiconda3libsite-packagessqlalchemysqlbase.py", line 416, in _validate_dialect_kwargs
"named <dialectname>_<argument>, got '%s'" % k
TypeError: Additional arguments should be named <dialectname>_<argument>, got 'datetime'

这个错误对我来说很奇怪，我已经逐行查看了代码，但仍然没有修复

Answer 1

问题是Sqlalchemy列没有属性'datetime'。我相信"默认"是你正在寻找的关键字。修改这一行

date_posted = db.Column(db.DateTime, nullable=False, datetime=datetime.utcnow)

到这个

date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)