def getBy(get, by): try: query, params, target = loadQuery(get, by) data = readWithParams(query, params) return jsonify({'data':data,'keys':getKeys(data, target)}) except Exception as e: print(e) return ("", 400, "")
def findIncident(params): SQL = ("SELECT * FROM Incidents " "WHERE ORI = %s " "AND IncidentNumber = %s " "AND IncidentDate = %s " "AND TotalVictims = %s " "AND OffenderRaceId = %s " "AND TotalOffenders = %s ") return readWithParams(SQL, params)
def getVictimTypeId(params): SQL = ("SELECT VictimTypeId " "FROM VictimTypes " "WHERE VictimType = %s") return [x[u'VictimTypeId'] for x in readWithParams(SQL, params)][0]
def getBiasMotivationId(params): SQL = ("SELECT BiasMotivationId " "FROM BiasMotivations " "WHERE BiasMotivation = %s") return [x[u'BiasMotivationId'] for x in readWithParams(SQL, params)][0]
def getOffenseTypeId(params): SQL = ("SELECT OffenseTypeId " "FROM OffenseTypes " "WHERE OffenseTypeName = %s") return [x[u'OffenseTypeId'] for x in readWithParams(SQL, params)][0]