#NEWLINE# def test_write_read_different_tx( self ) : #NEWLINE# #INDENT# with local_db . Transaction ( ) as tx : #NEWLINE# #INDENT# tx . execute ( 'INSERT INTO tests VALUES (:k, :v)' , k = 'foo' , v = 'bar' ) #NEWLINE# #UNINDENT# with local_db . Transaction ( ) as tx : #NEWLINE# #INDENT# row = tx . query_one ( 'SELECT value FROM tests WHERE key=:k' , k = 'foo' ) #NEWLINE# self . assertEqual ( 'bar' , row [ 'value' ] )