def phase3(file=None): with AdsDatabase() as ads_database: input_parser = InputParser() for line in fileinput.input(file): line = line.lower().strip() # print(line) if input_parser.validate_query(line): # print(input_parser.parse_input(line)) ads_database.execute(input_parser.parse_input(line)) elif line.startswith("output"): ads_database.change_mode(line) else: print("Invalid query") pass pass pass pass
def test_validate_input_13(): ip = InputParser() query = r"3413" val = ip.validate_query(query) assert val == True
def test_validate_input_12(): ip = InputParser() query = r" camera date>=2018 /11/05 " val = ip.validate_query(query) assert val == False
def test_validate_input_11(): ip = InputParser() query = r"hello []" val = ip.validate_query(query) assert val == False
def test_validate_input_10(): ip = InputParser() query = " " val = ip.validate_query(query) assert val == False
def test_validate_input_9(): ip = InputParser() query = "camera date>=2018/11/05 date<=2018/11/07 price > 20 price < 40" val = ip.validate_query(query) assert val == True
def test_validate_input_1(): ip = InputParser() query = "camera" val = ip.validate_query(query) assert val == True
def test_validate_input_16(): ip = InputParser() query = r" dafjeoj date=30" val = ip.validate_query(query) assert val == False
def test_validate_input_7(): ip = InputParser() query = "location=edmonton date=2018/11/07" val = ip.validate_query(query) assert val == True
def test_validate_input_6(): ip = InputParser() query = "price >= 20" val = ip.validate_query(query) assert val == True
def test_validate_input_4(): ip = InputParser() query = "date > 2018/11/05" val = ip.validate_query(query) assert val == True
def test_validate_input_19(): ip = InputParser() query = r"50 < price <60" val = ip.validate_query(query) assert val == False
def test_validate_input_18(): ip = InputParser() query = r"price <=> 50" val = ip.validate_query(query) assert val == False
def test_validate_input_17(): ip = InputParser() query = r"weeueueeee hello" val = ip.validate_query(query) assert val == True
def test_validate_input_14(): ip = InputParser() query = r"date >= 2018/11/05 cat=yolo" val = ip.validate_query(query) assert val == True
def test_validate_input_8(): ip = InputParser() query = "cat=art-collectibles camera" val = ip.validate_query(query) assert val == True
def test_validate_input_15(): ip = InputParser() query = r"date=hello" val = ip.validate_query(query) assert val == False