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]