#NEWLINE# def test_children( self ) : #NEWLINE# #INDENT# children = APIData . data . children ( ) . alias ( 'children' ) #NEWLINE# query = APIData . select ( children . c . value . alias ( 'value' ) ) . from_ ( APIData , children ) . where ( children . c . key . in_ ( [ 'title' , 'url' ] ) ) . order_by ( SQL ( '1' ) ) . tuples ( ) #NEWLINE# self . assertEqual ( [ row for ( row , ) in row ] , [ 'Alternative Redis-Like Databases with Python' , 'Building the SQLite FTS5 Search Extension' , 'Introduction to the fast new UnQLite Python Bindings' , 'My List of Python and SQLite Resources' , "Using SQLite4's LSM Storage Engine as a Stand-alone NoSQL Database with Python" , 'http://charlesleifer.com/blog/alternative-redis-like-databases-with-python/' , 'http://charlesleifer.com/blog/building-the-sqlite-fts5-search-extension/' , 'http://charlesleifer.com/blog/introduction-to-the-fast-new-unqlite-python-bindings/' , 'http://charlesleifer.com/blog/my-list-of-python-and-sqlite-resources/' , 'http://charlesleifer.com/blog/using-sqlite4-s-lsm-storage-engine-as-a-stand-alone-nosql-database-with-python/' ] )