sigmas = [5, 10, 15, 20, 30] betas = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10] for sigma, beta in itertools.product(sigmas, betas): clear_plows = ''' UPDATE route_points SET inserted = FALSE WHERE object_id IN :plow_ids ''' with engine.begin() as conn: conn.execute(sa.text(clear_plows), plow_ids=tuple(plow_ids)) tracer = Tracer(plow_ids=plow_ids) tracer.gps_precision = sigma tracer.matching_beta = beta not_processed_q = ''' SELECT COUNT(*) AS count FROM route_points WHERE object_id IN :plow_ids AND inserted = FALSE ''' not_processed = engine.execute(sa.text(not_processed_q), plow_ids=tuple(plow_ids)).first().count remainder = []
log_level = logging.WARNING if args.verbose: if args.verbose == 1: log_level = logging.INFO elif args.ve >= 2: log_level = logging.DEBUG logging.getLogger().setLevel(log_level) if args.slurp and args.write_cartodb: print("Cannot slurp from city and write to CartoDB in the same process") sys.exit() if args.slurp: if args.test_mode: slurper = TestSlurper() else: slurper = Slurper() slurper.run(recreate=args.recreate_tables) if args.write_cartodb: tracer = Tracer(test_mode=args.test_mode) while True: tracer.run() # time.sleep(10) if args.backup: slurper = Slurper() slurper.backup()
log_level = logging.WARNING if args.verbose: if args.verbose == 1: log_level = logging.INFO elif args.ve >= 2: log_level = logging.DEBUG logging.getLogger().setLevel(log_level) if args.slurp and args.write_cartodb: print( 'Cannot slurp from city and write to CartoDB in the same process') sys.exit() if args.slurp: if args.test_mode: slurper = TestSlurper() else: slurper = Slurper() slurper.run(recreate=args.recreate_tables) if args.write_cartodb: tracer = Tracer(test_mode=args.test_mode) while True: tracer.run() time.sleep(10) if args.backup: slurper = Slurper() slurper.backup()