Python MySQLHandler Examples

Example #1

File: server.py Project: zsy2053/BIXI

def getTTCData(graphType, startInt, endInt, routeTag):
    print str(startInt) + " " + str(endInt)

    if graphType == "busfreq":
        print "-- busfreq --"
        jsonData = MySQLHandler.getFreqData(routeTag, startInt, endInt)

    elif graphType == "freqsum":
        print "-- freqsum --"
        jsonData = MySQLHandler.getFreqSum(startInt, endInt)

    elif graphType == "trvtime":
        print "-- trvtime --"
        jsonData = MySQLHandler.getTrvTime(startInt, endInt, routeTag)

    elif graphType == "trvsum":
        print "-- trvsum --"
        jsonData = MySQLHandler.getTrvSum(startInt, endInt)

    elif graphType == "busdens":
        print "-- busdens --"
        jsonData = MySQLHandler.getBusDens(startInt, endInt)

    elif graphType == "busline":  # routeTag = busid
        print "-- busline --"
        jsonData = MySQLHandler.getBusLine(startInt, endInt, routeTag)

    else:
        print "ERROR: @app.route('/ttcdata/<graphType>/<startInt>/<endInt>/<station_id>')"
        return

    # print jsonData
    return jsonData

Example #2

File: server.py Project: zsy2053/BIXI

def getTTCData(graphType, startInt, endInt, routeTag):
    print str(startInt) + " " + str(endInt)

    if graphType == 'busfreq':
        print "-- busfreq --"
        jsonData = MySQLHandler.getFreqData(routeTag, startInt, endInt)

    elif graphType == 'freqsum':
        print "-- freqsum --"
        jsonData = MySQLHandler.getFreqSum(startInt, endInt)

    elif graphType == 'trvtime':
        print "-- trvtime --"
        jsonData = MySQLHandler.getTrvTime(startInt, endInt, routeTag)

    elif graphType == 'trvsum':
        print "-- trvsum --"
        jsonData = MySQLHandler.getTrvSum(startInt, endInt)

    elif graphType == 'busdens':
        print "-- busdens --"
        jsonData = MySQLHandler.getBusDens(startInt, endInt)

    elif graphType == 'busline':  # routeTag = busid
        print "-- busline --"
        jsonData = MySQLHandler.getBusLine(startInt, endInt, routeTag)

    else:
        print "ERROR: @app.route('/ttcdata/<graphType>/<startInt>/<endInt>/<station_id>')"
        return

    #print jsonData
    return jsonData

Example #3

File: server.py Project: zsy2053/BIXI

def getTTCList():
    print "-- station list --"
    jsonData = MySQLHandler.getRouteList()
    return jsonData

Example #4

File: server.py Project: zsy2053/BIXI

def getTTCName(station_id):
    print "-- station name --"
    name = MySQLHandler.getRouteName(station_id)
    return name

Example #5

File: server.py Project: zsy2053/BIXI

def getTTCList():
    print "-- station list --"
    jsonData = MySQLHandler.getRouteList()
    return jsonData

Example #6

File: server.py Project: zsy2053/BIXI

def getTTCName(station_id):
    print "-- station name --"
    name = MySQLHandler.getRouteName(station_id)
    return name