sqlalchemy.exc.ProgrammingError:(psycopg2.ProgrammingError)关系“故事";不存在 [英] sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) relation "story" does not exist
问题描述
这是下面的代码.我正在尝试创建一个具有一个故事表的数据库.输入来自html输入部分
So this is my code below. I'm trying to create a database, with one story table. The input comes from the html input part
from flask import Flask, render_template
from flask_sqlalchemy import SQLAlchemy
from flask import request, redirect, url_for
app = Flask(__name__)
password = input("Your database password: ")
app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql://adambodnar:{}@localhost/user_stories'.format(password)
db = SQLAlchemy(app)
class Story(db.Model):
id = db.Column(db.Integer, primary_key=True)
story_title = db.Column(db.String(80), unique=True)
user_story = db.Column(db.Text)
acceptance_criteria = db.Column(db.Text)
business_value = db.Column(db.Integer)
estimation = db.Column(db.Integer)
status = db.Column(db.String(30))
def __init__(self, story_title, user_story, acceptance_criteria, business_value, estimation, status):
self.story_title = story_title
self.user_story = user_story
self.acceptance_criteria = acceptance_criteria
self.business_value = business_value
self.estimation = estimation
self.status = status
@app.route('/')
def index():
return render_template('form.html')
@app.route('/story', methods=['POST'])
def story_post():
new_story = Story(request.form['story_title'],request.form['user_story'], request.form['acceptance_criteria'], request.form['business_value'], request.form['estimation'], request.form['status'])
db.session.add(new_story)
db.session.commit()
return redirect(url_for('index'))
if __name__ == '__main__':
app.run(host='0.0.0.0', port=8000)
当我尝试运行此命令时,出现以下错误:
when I try to run this, I get the following error:
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) relation "story" does not exist
LINE 1: INSERT INTO story (story_title, user_story, acceptance_crite...
^
[SQL: 'INSERT INTO story (story_title, user_story, acceptance_criteria, business_value, estimation, status) VALUES (%(story_title)s, %(user_story)s, %(acceptance_criteria)s, %(business_value)s, %(estimation)s, %(status)s) RETURNING story.id'] [parameters: {'acceptance_criteria': 'asdasd', 'estimation': '1', 'user_story': 'asd', 'status': 'Planning', 'story_title': 'asd', 'business_value': '100'}]
故事表甚至没有创建,我通过pgAdmin检查了它.我已经尝试了很多事情,建议您删除表的一些问题,但它不是创建的
The story table is not even created, I checked it through pgAdmin. I've tried a lot of things, some questions suggested to drop the table, but it's not created
推荐答案
您是否遵循 quickstart指南以了解Flask和sqlalchemy?无论如何,在指南上,您会注意到它是说要这样做的:
Have you followed the quickstart guide for Flask and sqlalchemy? Anyway, on the guide you will notice that it says to do this:
要创建初始数据库,只需从 交互式Python shell并运行SQLAlchemy.create_all()方法以 创建表和数据库:
To create the initial database, just import the db object from an interactive Python shell and run the SQLAlchemy.create_all() method to create the tables and database:
>>> from yourapplication import db
>>> db.create_all()
问题中包含的代码中似乎缺少表创建代码,这说明未创建表.
In the code you included with your question the table creation code seems to be missing, which explains the table not being created.
您可以考虑在应用程序中包含db.create_all()
(在db = SqlAlchemy(app)
之后放置)-如果此包装器功能类似于标准sqlalchemy版本,则它仅应创建新表,并且如果表已存在则不会崩溃.
You can consider including db.create_all()
with your application (put it right after db = SqlAlchemy(app)
) - if this wrapper functions like the standard sqlalchemy version it should only create new tables and not blow up if tables already exist.
这篇关于sqlalchemy.exc.ProgrammingError:(psycopg2.ProgrammingError)关系“故事";不存在的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!