Automatically generates pretty repr of a SQLAlchemy model.
Project description
Automatically generates pretty repr of a SQLAlchemy model.
Install
pip install sqlalchemy-repr
Usage
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy_repr import RepresentableBase
Base = declarative_base(cls=RepresentableBase)
Example
sqlalchemy_repr.RepresentableBase is mixin to add simple representation of columns.
>>> from datetime import datetime
>>> from sqlalchemy import Column, DateTime, Integer, Unicode, create_engine
>>> from sqlalchemy.ext.declarative import declarative_base
>>> from sqlalchemy.orm import sessionmaker
>>> from sqlalchemy_repr import RepresentableBase
>>> Base = declarative_base(cls=RepresentableBase)
>>> class User(Base):
... __tablename__ = 'users'
... id = Column(Integer, primary_key=True)
... name = Column(Unicode(255), nullable=False, unique=True)
... created = Column(DateTime, nullable=False)
>>> engine = create_engine('sqlite://')
>>> Base.metadata.create_all(engine)
>>> Session = sessionmaker(bind=engine)
>>> session = Session()
>>> user = User(name='spam', created=datetime(2016, 6, 1))
>>> session.add(user)
>>> session.commit()
>>> print(user)
<User id=1, name='spam', created='2016-06-01T00:00:00'>
sqlalchemy_repr.PrettyRepresentableBase brings pretty, indented multi-line representation.
>>> from sqlalchemy_repr import PrettyRepresentableBase
>>> Base = declarative_base(cls=PrettyRepresentableBase)
>>> class User(Base):
... __tablename__ = 'users'
... id = Column(Integer, primary_key=True)
... first_name = Column(Unicode(255), nullable=False, unique=True)
... last_name = Column(Unicode(255), nullable=False, unique=True)
... email = Column(Unicode(255), nullable=False)
... created = Column(DateTime, nullable=False)
... modified = Column(DateTime, nullable=False)
>>> engine = create_engine('sqlite://')
>>> Base.metadata.create_all(engine)
>>> Session = sessionmaker(bind=engine)
>>> session = Session()
>>> user = User(first_name='spam', last_name='ham', email='spam@example.com', created=datetime(2016, 6, 1), modified=datetime(2016, 6, 1))
>>> session.add(user)
>>> session.commit()
>>> print(user)
<User
id=1,
first_name='spam',
last_name='ham',
email='spam@example.com',
created='2016-06-01T00:00:00',
modified='2016-06-01T00:00:00'>
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for sqlalchemy-repr-0.0.2.macosx-10.14-x86_64.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6faa78edd7673effa1656ea0f697d3f1262e40951a8f374cd320758c2e52c32c |
|
MD5 | 364a6e2106a519203deb38b51d48c34c |
|
BLAKE2b-256 | 6ef194ba92cb5699ce97c1b44101bd6c0515584f68cb99696afdcfb219abd5ef |
Close
Hashes for sqlalchemy_repr-0.0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 060272575376e8a906e964cf10de5b40fd3f814db9c61e1269cb5cc15befffb2 |
|
MD5 | 18dd6f2d39c69b6b77b5165f8141ad98 |
|
BLAKE2b-256 | a63b405b6756c4461bc8e2b638fdc2822cdfbe677bcdcb62c8da54120cfc145a |