def getChartAlumni(): pass alumni_id = request.args.get("alumni_id") sch_id = request.args.get("sch_id") # mysqlSession = mysql.session query = mysqlSession.query(CrawlerRecord) schools = mysqlSession.query(School).all() # if alumni_id == None: alumnis = mysqlSession.query(Alumni).filter(Alumni.graduate == 1).all() mysqlSession.close() return defaultRender("alumni_charts.html", schools=schools, alumnis=alumnis)
def getAlumni(): pass sch_id = request.args.get('sch_id') schoolName = None mysqlSession = mysql.session query = mysqlSession.query(Alumni) if sch_id == None: retList = query.all() else: retList = query.filter(Alumni.graduate == sch_id).all() schoolName = mysqlSession.query(School).filter(School.sch_id == sch_id).first().full_name schoolLst = mysqlSession.query(School).all() for t in retList: # join two tables t.schoolName = t.school.full_name t.user_ids = str(mysqlSession.query(Subscribe.user_id).filter(Subscribe.alumni_id == t.alumni_id ).all()) return defaultRender('get_alumni.html', school_name=schoolName, lst=retList)
alumni.manager = request.form['manager'] try: mysqlSession.add(alumni) mysqlSession.commit() except sqlalchemy.exc.IntegrityError, e: mysqlSession.rollback() return bad_request(e) except Exception, e: mysqlSession.rollback() return bad_request(e) finally: mysqlSession.close() # mysqlSession = mysqlSession() return execSuccess('add alumni') form.graduate.data = 1 return defaultRender('add_alumni.html', form=form) @app.route('/alumni/upd', methods=['GET', 'POST']) def updAlumni(): pass ret = checkAuth() if ret != None: return ret alumni_id = request.args.get('alumni_id') if alumni_id == None: return bad_request(None, 'alumni_id is None') mysqlSession = mysql.session form = AlumniForm(lst=mysqlSession.query(School).all()) alumni = mysqlSession.query(Alumni).filter(Alumni.alumni_id == alumni_id).first() error = None
def getSchool(): pass mysqlSession = mysql.session query = mysqlSession.query(School) mysqlSession.close() return defaultRender('get_school.html', lst=query.all())
school.push_url = request.form['push_url'] mysqlSession = mysql.session try: mysqlSession.add(school) mysqlSession.commit() except sqlalchemy.exc.IntegrityError, e: mysqlSession.rollback() return bad_request(e) except Exception, e: mysqlSession.rollback() return bad_request(e) finally: mysqlSession.close() # mysqlSession = mysqlSession() return execSuccess('add school') return defaultRender('add_school.html', form=form) @app.route('/school/del', methods=['GET', 'POST']) def delSchool(): pass ret = checkAuth() if ret != None: return ret sch_id = request.args.get('sch_id') if sch_id == None: return bad_request(None, 'sch_id is None') mysqlSession = mysql.session try: ret = mysqlSession.query(School).filter(School.sch_id == sch_id).first() mysqlSession.delete(ret)
except Exception, e: logger.error("start_day or end_day is wrong format.e=" + e.message) schoolDict = {} for x in range(0, 7): strDate = (datetime.datetime.now() - datetime.timedelta(days=x)).strftime("%Y-%m-%d") schoolDict[strDate] = 0 for t in query.all(): strDate = t.gmt_created.strftime("%Y-%m-%d") schoolDict[strDate] += 1 # if schoolDict.get(strDate) == None: # schoolDict[strDate] = 1 schoolLst = sorted(schoolDict.iteritems(), key=lambda d: d[0]) schoolLst = map(lambda pair: pair[1], schoolLst) mysqlSession.close() return defaultRender( "school_charts.html", schoolName=schoolName, schoolLst=schoolLst, sch_id=sch_id, schools=schools ) @app.route("/charts/school_json", methods=["GET", "POST"]) def getChartSchoolJson(): pass # ret = checkAuth(False) # if ret != None: # return ret # if request.method =='POST': input_time = request.form.get("input_time") sch_id = request.form.get("sch_id") if sch_id == None: sch_id = 1 mysqlSession = mysql.session
start_time = start_day.encode('utf8') end_time = end_day.encode('utf8') query = query.filter((CrawlerRecord.gmt_created >= start_time),(CrawlerRecord.gmt_created <= end_time)) # query = query.filter((CrawlerRecord.gmt_created <= end_time)) except Exception, e: logger.error('start_day or end_day is wrong format') retList = query.order_by(CrawlerRecord.gmt_created.desc()).offset((page - 1) * POSTS_PER_PAGE).limit( POSTS_PER_PAGE).all() # schoolLst = mysqlSession.query(School).all() # alumniLst = mysqlSession.query(Alumni).all() for t in retList: # join two tables t.schoolName = t.school.full_name t.alumniName = t.alumni.name return defaultRender('get_crawler_record.html', school_name=schoolName, lst=retList, page=page, page_num=len(retList), sch_id=sch_id, alumni_id=alumni_id,start_day=start_day,end_day=end_day) @app.route('/crawler_record/del', methods=['GET', 'POST']) def delCrawlerRecord(): pass ret = checkAuth() if ret != None: return ret crawler_id = request.args.get('crawler_id') if crawler_id == None: return bad_request(None, 'crawler_id is None') mysqlSession = mysql.session try: ret = mysqlSession.query(School).filter(CrawlerRecord.crawler_id == crawler_id).delete() mysqlSession.commit()