Module Import alias identifier ImportFrom alias alias alias alias Import alias ClassDef bases AttributeLoad NameLoad attr body FunctionDef arguments args NameParam defaults body Assign AttributeStore NameLoad attr Call NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Str Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Str Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num decorator_list FunctionDef arguments args NameParam defaults body With Call NameLoad Str Str NameStore body Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Str Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Expr Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str Expr Call AttributeLoad NameLoad attr BinOpAdd Call NameLoad NameLoad Num Call NameLoad Call NameLoad Expr Call NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Expr Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str Expr Call AttributeLoad NameLoad attr BinOpAdd Call NameLoad NameLoad Num Call NameLoad Call NameLoad Expr Call NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str Expr Call AttributeLoad NameLoad attr CompareGt Call NameLoad Call NameLoad Num Expr Call NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Call NameLoad Call AttributeLoad AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr attr Num decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Call NameLoad Call AttributeLoad AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr attr Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr attr Str Str Expr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr TupleLoad Num Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr attr keyword Num Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr attr Str Str Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad AttributeLoad AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr attr attr Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad AttributeLoad AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr attr attr Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad AttributeLoad AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr attr attr keyword Num Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad AttributeLoad AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr attr attr Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad keyword Num Expr Call AttributeLoad NameLoad attr Call AttributeLoad Str attr Call AttributeLoad Call AttributeLoad Str attr Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr attr decorator_list FunctionDef arguments args NameParam defaults body Pass decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr attr Expr Call AttributeLoad NameLoad attr NameLoad Num decorator_list decorator_list If CompareEq NameLoad Str body Expr Call AttributeLoad NameLoad attr
N/A N/A pandas pd db DemoDB DB list_profiles remove_profile N/A unittest PandaSQLTest N/A N/A unittest TestCase N/A setUp N/A N/A self N/A N/A N/A N/A self db N/A DemoDB N/A test_query_rowsum N/A N/A self N/A N/A N/A df N/A N/A N/A self db query select * from Artist; N/A N/A N/A self assertEqual N/A len df 275 N/A test_query_groupby N/A N/A self N/A N/A N/A q select AlbumId, sum(1) from Track group by 1 N/A df N/A N/A N/A self db query q N/A N/A N/A self assertEqual N/A len df 347 N/A test_query_from_file_rowsum N/A N/A self N/A N/A N/A N/A open db/tests/testscript.sql w f N/A N/A N/A N/A f write select * from Artist; N/A df N/A N/A N/A self db query_from_file db/tests/testscript.sql N/A N/A N/A self assertEqual N/A len df 275 N/A test_add_profile N/A N/A self N/A N/A N/A profiles N/A list_profiles N/A N/A N/A N/A self db save_credentials profile test_profile N/A N/A N/A self assertEqual N/A N/A len profiles 1 N/A len N/A list_profiles N/A N/A remove_profile test_profile N/A test_remove_profile N/A N/A self N/A N/A N/A profiles N/A list_profiles N/A N/A N/A N/A self db save_credentials profile test_profile N/A N/A N/A self assertEqual N/A N/A len profiles 1 N/A len N/A list_profiles N/A N/A remove_profile test_profile N/A test_list_profiles N/A N/A self N/A N/A N/A N/A N/A N/A self db save_credentials profile test_profile N/A N/A N/A self assertTrue N/A N/A len N/A list_profiles 0 N/A N/A remove_profile test_profile N/A test_table_head N/A N/A self N/A N/A N/A N/A N/A self assertEqual N/A len N/A N/A N/A N/A N/A self db tables Artist head 6 N/A test_table_all N/A N/A self N/A N/A N/A N/A N/A self assertEqual N/A len N/A N/A N/A N/A N/A self db tables Artist all 275 N/A test_table_select N/A N/A self N/A N/A N/A df N/A N/A N/A N/A N/A self db tables Artist select ArtistId Name N/A N/A N/A self assertEqual N/A df shape N/A 275 2 N/A test_table_sample N/A N/A self N/A N/A N/A df N/A N/A N/A N/A N/A self db tables Artist sample n 10 N/A N/A N/A self assertEqual N/A len df 10 N/A test_table_uniqe N/A N/A self N/A N/A N/A df N/A N/A N/A N/A N/A self db tables Track unique GenreId MediaTypeId N/A N/A N/A self assertEqual N/A len df 38 N/A test_column_head N/A N/A self N/A N/A N/A col N/A N/A N/A N/A N/A N/A self db tables Track TrackId head N/A N/A N/A self assertEqual N/A len col 6 N/A test_column_all N/A N/A self N/A N/A N/A col N/A N/A N/A N/A N/A N/A self db tables Track TrackId all N/A N/A N/A self assertEqual N/A len col 3503 N/A test_column_sample N/A N/A self N/A N/A N/A col N/A N/A N/A N/A N/A N/A self db tables Track TrackId sample n 10 N/A N/A N/A self assertEqual N/A len col 10 N/A test_column_unique N/A N/A self N/A N/A N/A col N/A N/A N/A N/A N/A N/A self db tables Customer Country unique N/A N/A N/A self assertEqual N/A len col 24 N/A test_table_keys_per_column N/A N/A self N/A N/A N/A short_db N/A DemoDB keys_per_column 1 N/A N/A N/A self assertEqual N/A N/A +----------------------------------------------------------------------------------------+
|                                         Track                                          |
+--------------+---------------+-----------------------+---------------------------------+
| Column       | Type          | Foreign Keys          | Reference Keys                  |
+--------------+---------------+-----------------------+---------------------------------+
| TrackId      | INTEGER       |                       | InvoiceLine.TrackId, (+ 1 more) |
| Name         | NVARCHAR(200) |                       |                                 |
| AlbumId      | INTEGER       | Album.AlbumId         |                                 |
| MediaTypeId  | INTEGER       | MediaType.MediaTypeId |                                 |
| GenreId      | INTEGER       | Genre.GenreId         |                                 |
| Composer     | NVARCHAR(220) |                       |                                 |
| Milliseconds | INTEGER       |                       |                                 |
| Bytes        | INTEGER       |                       |                                 |
| UnitPrice    | NUMERIC(10,2) |                       |                                 |
+--------------+---------------+-----------------------+---------------------------------+ strip N/A N/A N/A N/A {0} format N/A N/A N/A N/A short_db tables Track __repr__ strip N/A tearDown N/A N/A self N/A N/A N/A N/A test_table_count_rows N/A N/A self N/A N/A N/A count N/A N/A N/A N/A self db tables Invoice count N/A N/A N/A self assertEqual count 412 N/A N/A N/A N/A __name__ __main__ N/A N/A N/A N/A unittest main