tiny new tool for making sample objects for tests

4 views
Skip to first unread message

Chris Withers

unread,
Apr 14, 2016, 7:33:32 PM4/14/16
to sqlal...@googlegroups.com, testing-...@lists.idyll.org, simpl...@googlegroups.com
Hi All,

I've just released this tiny library for making sample objects for testing.

Here's a SQLAlchemy example:
class Parent(Base):
    __tablename__ = 'parent'
    id = Column(Integer, primary_key=True)
    child_id = Column(Integer, ForeignKey('child.id'))
    child = relationship('Child')

class Child(Base):
    __tablename__ = 'child'
    id = Column(Integer, primary_key=True)
    value = Column(Integer)
Now we can build a source of sample data:
from chide.sqlalchemy import C
 o
llection

samples = Collection({
    Parent: {'id': 1, 'child': Child},
    Child: {'id': 3, 'value': 42}
})
And finally, we can use it:
>>> session = Sess
 i
on()
>>> session.add(samples.make(Parent))
>>> session.commit()
>>> session.query(Parent).one()
<Parent ...>
>>> _.child
<Child ...>
Hope this helps, if anyone finds bugs or has suggestions, please mail me! cheers, Chris
Reply all
Reply to author
Forward
0 new messages