faker_sqlalchemy 0.10.220807

A Faker provider that generates data based on SQL Alchemy column types.

[](https://pypi.org/project/faker_sqlalchemy/) [](https://pypi.org/project/faker_sqlalchemy/) [](https://faker-sqlalchemy.readthedocs.io/en/latest/?badge=latest)

SQLAlchemy Faker is a provider for the Faker library that helps populate SQLAlchemh ORM models with dummy data. Creating a new instance of a model can be as simple as calling fake.sqlalchemy_model(SomeModel).

Installation

The recommend way to install SQLAlchemy Faker is with pip:

pip install faker_sqlalchemy

Example

Say you have some model declared using SQLAlchemy’s ORM.

>>> class SomeModel(Base):
...     __tablename__ = "some_model"
...
...     id = Column(Integer, primary_key=True)
...
...     value = Column(String)

And, you want to easily generate some data,

>>> from faker_sqlalchemy import SqlAlchemyProvider
>>>
>>> fake = Faker()
>>> fake.add_provider(SqlAlchemyProvider)
>>>
>>> instance = fake.sqlalchemy_model(SomeModel)

Use instance as desired.

>>> print(instance.value)
RNvnAvOpyEVAoNGnVZQU