Module Import alias Import alias Import alias ImportFrom alias Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Call AttributeLoad AttributeLoad NameLoad attr attr Str AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Str Assign NameStore Str Assign NameStore Str Assign NameStore TupleLoad TupleLoad Str Str Num Str TupleLoad Str Str Num Str TupleLoad Str Str Num Str ClassDef bases AttributeLoad NameLoad attr body Expr Str FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr Return TupleLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Str Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Str Assign TupleStore NameStore NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore ListLoad TupleLoad Str Expr Call AttributeLoad NameLoad attr NameLoad NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign TupleStore NameStore NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Str Assign NameStore NameLoad Expr Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign TupleStore NameStore NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr Str attr Assign NameStore ListLoad TupleLoad Str Str Num Str TupleLoad Str Str Num Str TupleLoad Str Str Num Str Expr Call AttributeLoad NameLoad attr NameLoad NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list decorator_list If CompareEq NameLoad Str body Expr Call AttributeLoad NameLoad attr
N/A N/A os N/A sqlite3 N/A unittest thanos * N/A BASE_DIR N/A N/A N/A os path abspath N/A N/A N/A os path join . N/A os pardir N/A PROJECT_DIR N/A N/A N/A os path join BASE_DIR thanos N/A DB_NAME sare_log.db N/A SCHEMA CREATE TABLE users(    email TEXT,    name TEXT,    serial_no INTEGER,    password TEXT) N/A VALUES N/A N/A admin@gmail.com Admin 1 admin123 N/A foo@outlook.com bar 2 foo123 N/A john@yahoo.com doe 3 john123 TestDatabase N/A N/A unittest TestCase N/A N/A 
    Defining all kinds of obstenity to be done with the database in
    question
     _connect N/A N/A self N/A N/A N/A connection N/A N/A sqlite3 connect DB_NAME N/A cursor N/A N/A connection cursor N/A N/A connection cursor N/A set_up N/A N/A self N/A N/A N/A 
        Sets up the database
         N/A test N/A N/A N/A os path isfile DB_NAME N/A N/A N/A connection close N/A N/A N/A self assertEqual test True N/A test_db_schema_correct N/A N/A self N/A N/A N/A checks for the similarity of the schema N/A N/A connection cursor N/A N/A self _connect N/A N/A N/A cursor execute SELECT name FROM sqlite_master WHERE type='table'; N/A test N/A N/A cursor fetchall N/A result N/A N/A users N/A N/A N/A self assertEqual test result N/A N/A N/A connection close N/A test_db_schema_incorrect N/A N/A self N/A N/A N/A N/A connection cursor N/A N/A self _connect N/A N/A N/A cursor execute SELECT name FROM sqlite_master WHERE type='table'; N/A test False N/A N/A N/A self assertFalse test N/A test_db_values_correct N/A N/A self N/A N/A N/A N/A connection cursor N/A N/A self _connect N/A test N/A N/A N/A N/A cursor execute select * from users; fetchall N/A result N/A N/A admin@gmail.com Admin 1 admin123 N/A foo@outlook.com bar 2 foo123 N/A john@yahoo.com doe 3 john123 N/A N/A N/A self assertEqual test result N/A N/A N/A connection close N/A tear_down N/A N/A self N/A N/A N/A N/A N/A os remove DB_NAME N/A test N/A N/A N/A os path isfile DB_NAME N/A N/A N/A self assertEqual test False N/A N/A N/A N/A __name__ __main__ N/A N/A N/A N/A unittest main