我正在嘗試使用 SQLAlchemy/SQLite 在現有數據庫中創建一個表，我必須在其中存儲用戶和密碼，但它返回一個錯誤，指出列 pwd 不存在！我錯過了什么嗎？我把事情搞砸了嗎？我仍然不太明白，我按照一些在線教程中的所有步驟進行操作，但仍然沒有任何結果。這是我開發的類對象，然后從另一個寄存器表單我嘗試存儲應用程序中的密碼，但錯誤應該在此代碼中：import osbasedir = os.path.abspath(os.path.dirname(__file__))# flask importsfrom flask import Flask from flask_sqlalchemy import SQLAlchemyfrom flask_bcrypt import Bcryptfrom sqlalchemy import *# create flask appapp = Flask(__name__)# set sqllite db connectionapp.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' + os.path.join(basedir, 'data-dev.sqlite')engine= create_engine(app.config['SQLALCHEMY_DATABASE_URI'])# bcrypt extension init to appbcrypt = Bcrypt(app)# sqlite init to appdb = SQLAlchemy(app) # define meta data for tablemeta=MetaData()userstable = Table('users', meta, Column('id', Integer, primary_key = True, autoincrement=True), Column('username', String, unique=True), Column('pwd', String))# create table to sqlite meta.create_all(engine)class User(db.Model): # user columns id = db.Column(db.Integer(), primary_key=True, autoincrement=True) username = db.Column(db.String(64), unique=True) pwd = db.Column(db.String(128)) def __init__(self,username,pwd): #self.id=id self.username=username self.pwd=bcrypt.generate_password_hash(pwd)# create user objectuser = User('anish','23434')# insert user object to sqlitedb.session.add(user)# commit transactiondb.session.commit()這是錯誤：sqlalchemy.exc.OperationalError 操作錯誤：(sqlite3.OperationalError) 表用戶沒有名為 pwd 的列 [SQL: INSERT INTO user (username, pwd) VALUES (?, ?)] [參數：('ita_itf', '$2b$12$ VmpTsd0o4uTLj0wGypGu7ujhzYHLlV8k9ekaIP1.yh5lUMMgOM4MC')]
1 回答
呼啦一陣風
TA貢獻1802條經驗 獲得超6個贊
import os
basedir = os.path.abspath(os.path.dirname(__file__))
# flask imports
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from flask_bcrypt import Bcrypt
from sqlalchemy import *
# create flask app
app = Flask(__name__)
# set sqllite db connection
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' + os.path.join(basedir, 'data-dev.sqlite')
engine= create_engine(app.config['SQLALCHEMY_DATABASE_URI'])
# bcrypt extension init to app
bcrypt = Bcrypt(app)
# sqlite init to app
db = SQLAlchemy(app)
# define meta data for table
meta=MetaData()
userstable = Table('users', meta, Column('id', Integer, primary_key = True, autoincrement=True), Column('username', String, unique=True), Column('pwd', String))
# create table to sqlite
meta.create_all(engine)
class User(db.Model):
# table name for User model
__tablename__ = "users"
# user columns
id = db.Column(db.Integer(), primary_key=True, autoincrement=True)
username = db.Column(db.String(64), unique=True)
pwd = db.Column(db.String(128))
def __init__(self,username,pwd):
#self.id=id
self.username=username
self.pwd=bcrypt.generate_password_hash(pwd)
# create user object
user = User('anish','23434')
# insert user object to sqlite
db.session.add(user)
# commit transaction
db.session.commit()
添加回答
舉報
0/150
提交
取消