sqlalchemy-model-builder 0.0.3

SQLAlchemy Model Builder

SQLAlchemy Model Builder

Features

• Build and Save SQLALchemy models with random data
• Build relationships (Todo)
• Build minimal (with required) fields only

How to use

Build SQLAlchemy model:

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.sql.sqltypes import Integer, String, Text

from sqlalchemy_model_builder import ModelBuilder

Base = declarative_base()


class User(Base):
    __tablename__ = "users"

    bio = Column(Text)
    id = Column(Integer, primary_key=True)
    name = Column(String, nullable=False)


random_user = ModelBuilder(User).build()  # This will not insert the User

minimal_random_user = ModelBuilder(User, minimal=True).build()  # Builds User with `id` and `name`

Save SQLAlchemy model:

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.sql.sqltypes import Integer, String

from sqlalchemy_model_builder import ModelBuilder

Base = declarative_base()

engine = create_engine("sqlite://", echo=True)


class User(Base):
    __tablename__ = "users"

    bio = Column(Text)
    id = Column(Integer, primary_key=True)
    name = Column(String, nullable=False)


Base.metadata.create_all(engine)

LocalSession = sessionmaker(bind=engine)

db = LocalSession()


random_user = ModelBuilder(User).save(db=db)  # Builds and Saves model using provided session

Supported Data Types

• BigInteger
• Boolean
• Date
• DateTime
• Enum (Todo)
• Float
• Integer
• Interval
• LargeBinary (Todo)
• MatchType (Todo)
• Numeric (Todo)
• PickleType (Todo)
• SchemaType (Todo)
• SmallInteger
• String
• Text
• Time
• Unicode
• UnicodeText