Beispiel #1
0
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)
Beispiel #2
0
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)
Beispiel #3
0
        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
Beispiel #4
0
def getSchool():
    pass
    mysqlSession = mysql.session
    query = mysqlSession.query(School)
    mysqlSession.close()
    return defaultRender('get_school.html', lst=query.all())
Beispiel #5
0
        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)
Beispiel #6
0
    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()