def init():
args = sys.argv[1:]
if len(args) == 0:
route = raw_input("> [route_parser] Insert a route to query with, or nothing to run a test route.] \n \
> ")
if len(args) == 0:
route = "4-40 Beach Dr Even#, 650-776 Mountjoy Ave Even#, 2019-2027 Runnymede Ave Odd# (19)"
print "[route_parser] No args provided - Running the following test route: "
print route
parsedroute = parse(route)
print "[route_parser] Parsed the test route: \n", parsedroute
ex = Export()
ex.set_login_details(None, None)
ex.set_parsed_routes(parsedroute)
ex.generate_excel()
print "[route_parser] Successfully parsed route description and wrote data to file."
return
wb = load_workbook(filename = '%s' % args[0], read_only=True)
ws = wb[wb.get_sheet_names()[0]]
print ws
result = []
for row in ws.iter_rows():
for cell in row:
if cell.column == 5 and cell.value != None:
print cell.value
print result
def test_basic_export():
ex = Export()
ex.set_login_details(None, None)
searchdict = {"City": "Colwood"}
ex.set_search_dict(searchdict)
ex.generate_excel()
def test_basic_export():
ex = Export()
ex.set_login_details(None, None)
ex.set_parsed_routes([["SELLECK WAY",[3223]]])
ex.generate_excel()
def test_parse_export():
ex = Export()
ex.set_login_details(None, None)
parsedroutes = route_parser.parse("4-40 Beach Dr Even#, 650-776 Mountjoy Ave Even#, 2019-2027 Runnymede Ave Odd# (19)")
ex.set_parsed_routes(parsedroutes)
ex.generate_excel()
def test_basic_export():
ex = Export()
ex.set_login_details(None, None)
searchdict = {"City" : "Colwood"}
ex.set_search_dict(searchdict)
ex.generate_excel()
