#NEWLINE# @ tornado . web . authenticated #NEWLINE# def get( self ) : #NEWLINE# #INDENT# query = db . push_pushes . select ( SA . and_ ( ( db . push_pushes . c . state == 'accepting' ) , SA . exists ( [ 1 ] , SA . and_ ( ( db . push_pushcontents . c . push == db . push_pushes . c . id ) , ( db . push_pushcontents . c . request == db . push_requests . c . id ) , ( db . push_requests . c . user == query . current_user ) ) ) ) , order_by = db . push_pushes . c . created . asc ( ) ) #NEWLINE# db . execute_cb ( query , self . on_db_response )