flask框架中，SQLAlchemy连接数据库方法；

flask框架中，SQLAlchemy连接数据库方法；

 在app.py文件中写；

一、连接mysql数据库；

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
app=Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI']='mysql://user:password@localhost/mydatabase'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS']=True
db=SQLAlchemy(app)

 

二、连接sqlite数据库

import os
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
base_dir=os.path.abspath(os.path.dirname(__file__))
app=Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI']='sqlite:///'+os.path.join(base_dir,'data.sqlite')
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db=SQLAlchemy(app)

 

三、连接postgresql数据库

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
# 配置参数
app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql://user:password@localhost/mydatabase'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
# 初始化SQLAlchemy
db = SQLAlchemy(app)

 

 

======================