def insertWaterQual(beachDict, md5_fk):
"""
Inserts water quality results into water quality database table with md5 foreign key relationship.
Parameters
----------
beachDict: Dictionary. Dictionary containing values to be inserted into database.
md5_fk: String. Foreign key from md5 table.
Returns
-------
Print statement.
"""
session = Session()
inslist = []
# Iterate over beaches in dictionary creating waterQuality objects for each beach key
for key in beachDict.keys():
inslist.append(
waterQuality(
beach_id=beachDict[key]['fk'],
TotColi=beachDict[key]['Total Coliform Results (MPN*)'],
FecColi=beachDict[key]["Fecal Coliform Results (MPN*)"],
Entero=beachDict[key]['Enterococcus Results (MPN*)'],
ExceedsRatio=beachDict[key]['Exceeds FC:TC ratio standard **'],
BeachStatus=beachDict[key]['Beach Status'],
resample=beachDict[key]['resample'],
md5_id=int(md5_fk)))
# Add list of objects to session
session.add_all(inslist)
session.commit()
session.close()
application.logger.debug("Data added to water quality table!")
def handleTrackerPOST(data):
"""
Parameters
----------
data
Returns
-------
"""
session = Session()
newObjDict = {}
# Create instance of a gps track
trackRecord = gpsTrackObj(data)
# Check if there has been movement, if so add to new object dictionary, otherwise no entry will be made
if trackRecord["activity"] == "Yes":
newObjDict["track"] = trackRecord["model"]
# Add new gps record object to new objects dictionary
newObjDict["gpspoint"] = newGPSRecord(data, trackRecord["activity"])
# Iterate over new objdict, can allow building out so many things can be committed to db
# This allows for empty models to be skipped
newObjs = []
for obj in newObjDict.keys():
newObjs.append(newObjDict[obj])
# Add new objects to session and commit them
session.add_all(newObjs)
session.commit()
session.close()
