Testing with context managers

gistfile1.py

from gittip import testing                                                                                                                                      
                                                                                                                                                                
                                                                                                                                                                
def test_inserting_inserts():                                                                                                                                   
    with testing.load() as context:                                                                                                                             
        context.db.execute("INSERT INTO participants VALUES ('foo')")                                                                                           
        actual = context.diff(compact=True)                                                                                                                     
        assert actual == {"participants": [1,0,0]}, actual                                                                                                      
                                                                                                                                                                
def test_update_updates():                                                                                                                                      
    with testing.load("participants", ("foo",)) as context:                                                                                                     
        context.db.execute("UPDATE participants SET statement='BLAM!!!' "                                                                                       
                           "WHERE id='foo'")                                                                                                                    
        expected = {"id": "foo", "statement": "BLAM!!!"}                                                                                                        
        actual = context.diff()['participants']['updates'][0]                                                                                                   
        assert actual == expected, actual