尝试通过python联机发布到SQLite数据库时出错问题的回答

尝试通过python联机发布到SQLite数据库时出错

回答此问题可获得 20 贡献值，回答如果被采纳可获得 50 分。

<p>我试图建立一个数据库与两个链接表信息和用户，我也希望能够发布到数据库在线，每当我运行下面的代码，当我点击我的索引页提交后，我得到一个错误：“该方法是不允许的请求的URL.”，没有任何东西是发布到我的数据库。我是python和SQLAlchemy的新手，所以我不确定错误发生在哪里。这是我的python代码：</p> <pre><code>from flask import Flask, render_template, request, redirect, url_for from flask_sqlalchemy import SQLAlchemy from sqlalchemy.orm import relationship, backref, sessionmaker from sqlalchemy import Column, Integer, String, create_engine from sqlalchemy.ext.declarative import declarative_base app = Flask(__name__) app.config['SQLALCHEMY_DATABASE_URI'] = "sqlite:////Users/me/attempt1/attempt.db" app.debug = True db = SQLAlchemy(app) engine = create_engine('sqlite:////Users/me/attempt1/attempt.db') connection = engine.connect() Base = declarative_base() session = sessionmaker(bind=engine) class Info(Base): __tablename__ = 'info' id = Column(Integer, primary_key=True) username = Column(String(80), unique=True, nullable=False) age = Column(Integer, nullable=False) country = Column(String(120), nullable=False) class User(Base): __tablename__ = 'users' id = Column(Integer, primary_key=True) email = Column(String(225), unique=True, nullable=False) username = relationship('Info', backref=backref('users', lazy='True')) password = Column(String(225), nullable=False) # this will be the home page Base.metadata.create_all(engine) session = session() @app.route('/') def index(): return render_template('dashboard.html') # sign up page @app.route('/signup', methods=['POST']) def signup(): info = Info(request.form['username'], request.form['age'], request.form['country']) user = User(request.form['email'], request.form['password']) session.add(info) session.add(user) session.commit() return redirect(url_for('login')) @app.route('/login') def login(): return 'You are now logged in' if __name__ == '__main__': app.run() </code></pre> <p>这是我的html代码仪表板.html地址：</p> <pre><code><!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Sign Up Today</title> </head> <body> <form method ="signup" action="/signup"> <label>Email:</label> <input id="email" name="email" type="text"/> <label>Username:</label> <input id="username" name="'username" type="text"/> <label>Password:</label> <input id="password" name="password" type="'text"/> <label>Age:</label> <input id="'age" name="age" type="text"/> <label>Country:</label> <input id="country" name="country" type="text"/> <input type="submit"/> </form> </body> </html> </code></pre>

0 条评论
分类：Python问答

默认排序时间排序

1 个回答

匿名 1天前

　擅长：python、mysql、java

尝试通过python联机发布到SQLite数据库时出错

1 个回答

相关Python问题