背景:
本地使用mongodb,查询远程MYsql数据库
说明
mysql 本地初始化只能
代码
#正常链接mongdb作为本地db
conn, db = connect(_config.get_mongo_default_db_name(),
ip=_config.get_mongo_host(),
port=int(_config.get_mongo_port()),
username=_config.get_mongo_username(),
password=_config.get_mongo_password())
-----
#mysql和app关联,并绑定models
from flask_sqlalchemy import SQLAlchemy
from app import app
db = SQLAlchemy(app)
class TUser(db.Model):
__tablename__ = 't_user'
__table_args__ = (
db.Index('phone', 'country_id', 'phone_number'),
)
uid = db.Column(db.BigInteger, primary_key=True)
role = db.Column(db.Integer, info='用户角色(未使用)')
https://stackoverflow.com/questions/64966824/connecting-flask-with-mysql-and-mongodb-simultaneously