使用ORM Bee (ormbee) ,如何利用SQLAlchemy的模型生成数据库表.
将原来SQLAlchemy的模型,修改依赖为:
from bee.helper import SQLAlchemy
然后就可以开始生成了。很简单,主要是两个接口。
db.create_all(True) #创建所有模型的表; db.create_one(Users,True) #创建某一个模型的表;
PreConfig.config_path用于指定关于配置文件在哪(里面有数据库相关配置信息)
from bee.config import PreConfig
from bee.helper import SQLAlchemydb = SQLAlchemy()class Orders(db.Model): id = db.Column(db.Integer, primary_key=True) type_id = db.Column(db.Integer) type_id2 = db.Column(db.SMALLINT)name = db.Column(db.String(64), unique=True) name2 = db.Column(db.String(), unique=True) remark = db.Column(db.Text) price = db.Column(db.Numeric(10, 2), nullable = False) # not null price2 = db.Column(db.DECIMAL(10, 3), nullable = False) # not null order_number = db.Column(db.BigInteger, unique = True) # not null flage = db.Column(db.Boolean)field1 = db.Column(db.JSON)field2 = db.Column(db.Float)field3 = db.Column(db.SmallInteger)field4 = db.Column(db.REAL)field5 = db.Column(db.DateTime)field6 = db.Column(db.Date)field7 = db.Column(db.Time)def __repr__(self): return str(self.__dict__)class Users(db.Model):id = db.Column(db.Integer, primary_key=True)org_id = db.Column(db.Integer)role_id = db.Column(db.Integer)name = db.Column(db.String(64), unique=True)password = db.Column(db.String(16))tel = db.Column(db.String(16), unique=True)remark = db.Column(db.Text)if __name__=='__main__':print("start")PreConfig.config_path="E:\\Project-name\\resources"try:db.create_all(True)db.create_one(Users,True)except Exception as e: print(e)## After generate the table, can generate the normal entity/bean with Assist in assist_api.py