def get_map_from_database(self): travelSensors = db_session.query(TravelSensor).all() self.READER_IDs = [x.READER_ID for x in travelSensors] for sensor in self.READER_IDs: adjs = db_session.query(Summary.Destination).filter( Summary.Origin == sensor).distinct(Summary.Destination).all() self.ADJ_INTERSECTIONS[sensor] = [adj[0] for adj in adjs]
def index_function(): user = db_session.query(User).first() travelSensors = db_session.query(TravelSensor).all() return_from_util = util.example_function() print travelSensors[0].READER_ID summary = db_session.query(Summary).filter( Summary.Origin == "51st_manor").all() print summary[0].Time return render_template("index.html", user=user, msg=None)
def getTravelTime(self, s, t, dtime, weekday): beg_day = 0 end_day = 0 if weekday in [0, 1, 2, 3, 4]: beg_day = 0 end_day = 4 else: beg_day = 5 end_day = 6 # first attempt summary = db_session.query(Summary).filter( Summary.Origin == s, Summary.Destination == t, Summary.Weekday == weekday, Summary.Time >= dtime / 60, Summary.Time <= dtime / 60 + 60, ).order_by(Summary.Time).all() if len(summary) == 0: if dtime >= 23 * 3600: # after 11pm, look at the next day summary = db_session.query(Summary).filter( Summary.Origin == s, Summary.Destination == t, Summary.Weekday == weekday + 1).order_by( Summary.Time).all() if len(summary) == 0: summary = db_session.query(Summary).filter( Summary.Origin == s, Summary.Destination == t, Summary.Weekday >= beg_day, Summary.Weekday <= end_day, Summary.Time >= dtime / 60, Summary.Time <= dtime / 60 + 60, ).order_by(Summary.Time).all() if len(summary) == 0: # report nothing #print "nothing" #print {'s':s, 't':t, 'dtime':dtime} return self.INFINITY looked_years = set() total = 0 for ss in summary: if ss.Year not in looked_years: looked_years |= set([ss.Year]) total += ss.Avg_Travel_Time #print {'s':s, 't':t, 'dtime':dtime, 'total':total, 'n': len(looked_years)} return total / len(looked_years)
def authenticated(): # Returns whether or not the session user is authenticated if 'user_id' in session and 'user_token' in session: user = db_session.query(User).filter_by(id=session['user_id']).first() if user: return user.access_token == session['user_token'] return False
def travelTimePrediction_function(): travelSensors = db_session.query(TravelSensor).all() startTimeList = [] for i in range(0, 4*24): if (i % 4) * 15 == 0: startTimeList.append(str(i / 4) + ":00") else: startTimeList.append(str(i / 4) + ":" + str((i % 4) * 15)) # print startTimeList if request.method == 'POST': # time_pre = { # 'route': [u'5th_trinity', u'7th_chicon', u'7th_plesant_valley', u'7th_springdale', u'7th_shady'], # 'coord': [(30.2661324, -97.7396774), (30.2625771, -97.7221146), (30.2601261, -97.7094955), (30.2560368, -97.7016754), (30.2533531, -97.6975708)], # 'time': 466 # } origin = request.form['origin'] destination = request.form['destination'] minutes = (int(request.form['start_time']) - 1) * 15 time_pre = time_prediction.findRoute(origin, destination, 0, 0) return render_template("travelTimePrediction.html", travelSensors=travelSensors, time_pre=time_pre, startTimeList=startTimeList) else: return render_template("travelTimePrediction.html", travelSensors=travelSensors, time_pre=None, startTimeList=startTimeList)
def get_map_from_database(self): travelSensors = db_session.query(TravelSensor).filter( TravelSensor.READER_ID.contains('lamar')).order_by( TravelSensor.LATITUDE.desc()) self.READER_IDs = [x.READER_ID for x in travelSensors] for sensor in self.READER_IDs: print sensor
def __init__(self): travelSensors = db_session.query(TravelSensor).all() self.travelSensors = { x.READER_ID: (x.LATITUDE, x.LONGITUDE) for x in travelSensors } self.myMap = Map() self.myMap.get_map_from_database()
def books_in_category(category_id): # Return all Books for a corresponding Category return (db_session.query(Book) .filter_by(category_id=category_id) .order_by(Book.publish_date))
def category_all(): # convienience function to return all category data return db_session.query(Category).all()
def category_name(category_id): # Return the name for a corresponding category id category = db_session.query(Category).filter_by(id=category_id).one() return category.name