flask学习

https://blog.csdn.net/weixin_39731083/article/details/82262385
`from flask import Flask
from flask_sqlalchemy import SQLAlchemy
app = Flask(name)
class Config(object):
'''配置参数'''
# SQLALCHEMY_DATABASE_URI='mssql+odbc://rooxxx306/test'
SQLALCHEMY_DATABASE_URI='mssql+pyodbc://bds258xxxx:xxxx?@zf'
SQLALCHEMY_TRACK_MODIFICATIONS=True
app.config.from_object(Config)

创建数据连接对象

db=SQLAlchemy(app)

class User(db.Model):
'''用户表'''
talbename='tbl_users'
id=db.Column(db.Integer,primary_key=True)
name=db.Column(db.String(60),unique=True)
email=db.Column(db.String(128),unique=True)
password=db.Column(db.String(128))
role_id=db.Column(db.Integer,db.ForeignKey("tbl_roles.id"))
class Role(db.Model):
tablename='tbl_roles'
id=db.Column(db.Integer,primary_key=True)
name=db.Column(db.String(32),unique=True)
users=db.relationship('User',backref='role')

@app.route('/')
def hello_world():
return 'Hello World!'

if name == 'main':

db.create_all()
role1=Role(name='xiaoxu')
user1=User(name='xupanfeng',email='xpfxxx.com')
db.session.add(role1)
db.session.commit()
db.session.add(user1)
db.session.commit()

# app.run()

`