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()
Exemplo n.º 3
0
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
Exemplo n.º 4
0
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
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
Exemplo n.º 8
0
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)