# sqlormx-generator **Repository Path**: summry/sqlormx-generator ## Basic Information - **Project Name**: sqlormx-generator - **Description**: sqlormx model 生成器 - **Primary Language**: Python - **License**: Apache-2.0 - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 0 - **Created**: 2024-04-22 - **Last Updated**: 2024-07-07 ## Categories & Tags **Categories**: Uncategorized **Tags**: SQL ## README ##### Install ```shell pip install sqlx-orm_generator-generator ``` ##### Usage Sample ```python from sqlormx_generator import Generator if __name__ == '__main__': coder = Generator(host='127.0.0.1', port='3306', user='xxx', password='xxx', database='test') # you can generate one table coder.generate_with_tables(tables='user', path='models.py') # you can generate many tables coder.generate_with_tables(tables=['user', 'person'], path='models.py') # you can generate all tables for given schema. default current schema if not given coder.generate_with_schema(schema='test', path='models.py') ``` If you run last code, then generate a file 'models.py' in current directory like follow: ```python from decimal import Decimal from datetime import date, datetime from orm import Model, KeyStrategy class BaseModel(Model): __key__ = 'id' __del_flag__ = 'del_flag' __update_by__ = 'update_by' __update_time__ = 'update_time' __key_strategy__ = KeyStrategy.DB_AUTO_INCREMENT def __init__(self, id: int = None, create_by: int = None, create_time: datetime = None, update_by: int = None, update_time: datetime = None, del_flag: int = None): self.id = id self.create_by = create_by self.create_time = create_time self.update_by = update_by self.update_time = update_time self.del_flag = del_flag class User(BaseModel): __table__ = 'user' def __init__(self, id: int = None, name: str = None, age: int = None, birth_date: date = None, sex: int = None, grade: float = None, point: float = None, money: Decimal = None, create_by: int = None, create_time: datetime = None, update_by: int = None, update_time: datetime = None, del_flag: int = None): super().__init__(id=id, create_by=create_by, create_time=create_time, update_by=update_by, update_time=update_time, del_flag=del_flag) self.name = name self.age = age self.birth_date = birth_date self.sex = sex self.grade = grade self.point = point self.money = money ```