python - web框架 - Flask Mysql 创建表的外键

最新推荐文章于 2023-06-29 17:28:20 发布

原创

最新推荐文章于 2023-06-29 17:28:20 发布 · 2.4k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#python #web框架 #mysql

本文介绍了如何在Flask web框架中使用MySQL创建表的外键，通过db.ForeignKey()方法，将某列与另一个表的id列建立外键关联。

代码：

from flask import Flask, render_template, session, redirect, url_for, flash
from flask.ext.bootstrap import Bootstrap
from flask.ext.wtf import Form
from wtforms import StringField, SubmitField
from wtforms.validators import Required, Length
from flask.ext.sqlalchemy import SQLAlchemy

app = Flask(__name__)
username='qatest'
password='qatest'
server='122.30.100.12:3388'
dbname='qatest'
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://'+username+':'+password+'@'+server+'/'+dbname
app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN'] = True

db = SQLAlchemy(app)

class Role(db.Model):
    __tablename__ = 'py_roles'
    id = db.Column(db.Integer,primary_key=True)
    name = db.Column(db.String(64),unique=True)
    users = db.relationship('User',backref='role')
    def __repr__(self):
        return '<Role %r>' % self.name

class User(db.Model):
    __tablename__ = 'py_users'
    id = db.Column(db.Integer,primary_key=True)
    username = d