使用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