类型错误:Column() 得到了一个意外的关键字参数“primary_key" [英] TypeError: Column() got an unexpected keyword argument 'primary_key'

问题描述

class Contacts(db.Model):"""sno、姓名、电子邮件、电话号码、味精、日期"""sno = db.Column(db.Integer,primary_key=True)名称 = db.Column(db.String(80), nullable=False)电子邮件 = db.Column(db.String(20), nullable=False)phone_num = db.Column(db.String(12), nullable=False)msg = db.Column(db.String(120), nullable=False)日期 = db.Column(db.String(12), nullable=True)

<块引用>

回溯(最近一次调用最后一次):文件C:/Users/rithi/Flask_Blog/main.py"，第 11 行，在类联系人(db.Model):文件C:/Users/rithi/Flask_Blog/main.py"，第 15 行，在联系人中sno = db.Column(db.Integer,primary_key=True)类型错误:Column() 得到了一个意外的关键字参数primary_key"

解决方案

抱歉回答晚了，您可能已经有了解决方案.但只是为其他人在开始学习 Flask 时可能面临同样问题的人发帖.我刚开始学习烧瓶，我遇到了同样的问题.只需通过键入以下内容来卸载 sqlalchemy:- pip uninstall flask-sqlalchemy 但在命令提示符中导航到您的目录.它被卸载.然后通过键入以下命令进入您的项目目录再次安装它:- pip install flask-sqlalchemy.对我来说，这个有用，我能够开始使用数据库.如果您遇到同样的问题，请尝试一下

谢谢，

快乐学习！

class Contacts(db.Model):
    """
    sno, name, email, phone_num, msg, date
    """
    sno = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    email = db.Column(db.String(20), nullable=False)
    phone_num = db.Column(db.String(12), nullable=False)
    msg = db.Column(db.String(120), nullable=False)
    date = db.Column(db.String(12), nullable=True)

Traceback (most recent call last): File "C:/Users/rithi/Flask_Blog/main.py", line 11, in class Contacts(db.Model): File "C:/Users/rithi/Flask_Blog/main.py", line 15, in Contacts sno = db.Column(db.Integer, primary_key=True) TypeError: Column() got an unexpected keyword argument 'primary_key'

解决方案

Sorry for the late answer, you already might've got the solution. But just posting for others who might face the same problem when they start learning flask. I just started learning flask, and I faced the same problem. Just un-install the sqlalchemy by typing:- pip uninstall flask-sqlalchemy but navigating to your directory in the command prompt. It gets un-installed. Then install its again by getting into your project directory by typing:- pip install flask-sqlalchemy. For me, this one worked and I was able to start working with the database. Give it a try if you faced the same issue

Thank you,

Happy learning!

这篇关于类型错误:Column() 得到了一个意外的关键字参数“primary_key"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！