Install

pip install sqlormx_generator

Usage Sample

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 a model class for one table
    coder.generate_with_tables(tables='user', path='models.py')
    # you can generate model classes for tables
    coder.generate_with_tables(tables=['user', 'person'], path='models.py')
    # you can generate model classes for all tables from a 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:

from decimal import Decimal
from dataclasses import dataclass
from datetime import date, datetime
from sqlormx import Model

@dataclass
class BaseModel(Model):
    id: int = None
    create_by: int = None
    create_time: datetime = None
    update_by: int = None
    update_time: datetime = None
    del_flag: int = None


@dataclass
class User(BaseModel):
    __table__ = 'user'
    name: str = None
    age: int = None
    birth_date: date = None
    sex: int = None

SQLORMX: https://pypi.org/project/sqlormx