I created a pretty comprehensive example of two ways to do this as part
of a talk I did at Pycon some years ago. The example case is
https://bitbucket.org/zzzeek/pycon2014_atmcraft and you can see a
contrast of the "mock" approach and the "run tests in a transaction"
approach at:
https://bitbucket.org/zzzeek/pycon2014_atmcraft/src/f50cbe745a197ea7db83569283b703c418481222/atmcraft/tests/test_views_mockdb.py?at=master&fileviewer=file-view-default
https://bitbucket.org/zzzeek/pycon2014_atmcraft/src/f50cbe745a197ea7db83569283b703c418481222/atmcraft/tests/test_views_transactional.py?at=master&fileviewer=file-view-default
The transactional version is based on the techniques at
http://docs.sqlalchemy.org/en/rel_1_0/orm/session_transaction.html#joining-a-session-into-an-external-transaction-such-as-for-test-suites.
There are pluses and minuses to both approaches. Real world I think
both are usually used at the same time, which has been the case for me.
On 02/22/2016 09:46 AM, Abhijeet Rastogi wrote:
Hi Folks,
I've functions that do a subset of tasks on a sqlalchemy object for a
bigger function. For ex,
def delete_certificate_store(CS):
CS.is_archived = True
# Also delete the associated CARequest object
for DR in CS.CA_request:
db.session.delete(DR)
# Delete the Certificate Object only if this it's the only order
for that Certificate
if len(CS.order.certificate.get_all_unarchived_orders()) == 1 and
CS in CS.order.certificate.get_all_unarchived_certificate_stores():
CS.order.certificate.is_archived = True
Now, this function modifies a database. How do we test functions like
these? If I use mocks for DB related stuff, I'm not really testing it.
As a human, I test these functions by executing them and verifying if
the intended changes happened in the DB. How's that done by testing
frameworks like pytest? Sorry, if this is a stupid question, I'm new to
testing.
Thanks
--
You received this message because you are subscribed to the Google
Groups "sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
