def get_round_distances(from_teams, to_teams): distances = defaultdict(dict) for team_from in from_teams: location_from = MapPoint.from_team(team_from) for team_to in to_teams: location_to = MapPoint.from_team(team_to) distances[team_from.id][team_to.id] = simple_distance(location_from, location_to) return distances
def get_aqua_distance(args): team = db.session.query(Team).filter(Team.id == int(args["team_id"])).first() if team is None: return target = MapPoint.from_team(team) aqua = MapPoint(*config.CENTER_POINT) team.location.center_distance = simple_distance(target, aqua) db.session.commit()
def get_round_distances(from_teams, to_teams): distances = defaultdict(dict) for team_from in from_teams: location_from = MapPoint.from_team(team_from) for team_to in to_teams: location_to = MapPoint.from_team(team_to) distances[team_from.id][team_to.id] = simple_distance( location_from, location_to) return distances
def get_aqua_distance(args): team = db.session.query(Team).filter( Team.id == int(args["team_id"])).first() if team is None: return target = MapPoint.from_team(team) aqua = MapPoint(*config.CENTER_POINT) team.location.center_distance = simple_distance(target, aqua) db.session.commit()
def get_aqua_distance(args): team = db.session.query(Team).filter(Team.id == int(args["team_id"])).first() if team is None: return target = MapPoint.from_team(team) #aqua = MapPoint(51.04485, 13.74011) # real aqua aqua = MapPoint(51.05299472808838, 13.742453455924988) # hfbk team.location.center_distance = simple_distance(target, aqua) db.session.commit()
def get_round_distances(from_teams, to_teams): # ToDo use cached values! distances = defaultdict(dict) for team_from in from_teams: location_from = MapPoint.from_team(team_from) for team_to in to_teams: route = db.session.query(RouteDistance).filter_by(location_from=team_from.location, location_to=team_to).first() if route is None: location_to = MapPoint.from_team(team_to) distances[team_from.id][team_to.id] = simple_distance(location_from, location_to) else: distances[team_from.id][team_to.id] = route.distance / 1000.0 return distances
print "fetch teams..." teams = db.session.query(Team).filter_by(deleted=False).filter_by( confirmed=True).filter_by(backup=False).order_by( Team.id).limit(MAX_TEAMS).all() distances = list() print "fetch distances..." for (idx, team_from) in enumerate(teams): location_from = MapPoint.from_team(team_from) for team_to in teams[(idx + 1):]: location_to = MapPoint.from_team(team_to) dist = int(simple_distance(location_from, location_to) * 1000) distances.append({ "src": str(team_from.id), "dst": str(team_to.id), "value": dist, "text": str(dist) }) distances.append({ "src": str(team_to.id), "dst": str(team_from.id), "value": dist, "text": str(dist) }) print "write distance data..." with open("legacy_distances.json", "w+") as f:
args = arguments.parse_args() cfg.load_config(args.config) MAX_TEAMS = args.max_teams print "init db..." db.init_session(connection_string=config.DB_CONNECTION) print "fetch teams..." teams = db.session.query(Team).filter_by(deleted=False).filter_by(confirmed=True).filter_by(backup=False).order_by( Team.id).limit(MAX_TEAMS).all() distances = list() print "fetch distances..." for (idx, team_from) in enumerate(teams): location_from = MapPoint.from_team(team_from) for team_to in teams[(idx + 1):]: location_to = MapPoint.from_team(team_to) dist = int(simple_distance(location_from, location_to) * 1000) distances.append({"src": str(team_from.id), "dst": str(team_to.id), "value": dist, "text": str(dist)}) distances.append({"src": str(team_to.id), "dst": str(team_from.id), "value": dist, "text": str(dist)}) print "write distance data..." with open("legacy_distances.json", "w+") as f: json.dump(distances, f)