def addStationsInLocationToDb(lat, lng, rad):
logger = logging.getLogger('miner')
logger.info("Requesting station list for lat: " + "{:.9f}".format(lat) + "long: " + "{:.9f}".format(lng) + " and rad: " + "{:.9f}".format(rad))
#Get Station data
stationList = apiRequests.listRequest(lat, lng, rad)["stations"]
dbHandle = connectDb.connect()
if dbHandle is None:
logger.critical("Cannot connect to db, exiting")
sys.exit("Cannot connect to db.")
for station in stationList:
#Format for Database
logger.info("Preparing data of " + station["name"] + " for insertion")
station["_id"] = station["id"]
del station["id"]
del station["dist"]
del station["price"]
logger.info("Inserting station data of " + station["name"] + " to db")
try:
#If data for this station already exists replace, else insert
dbHandle.stations.replace_one({"_id" : station["_id"]}, station, upsert=True)
logger.info("Station " + station["name"] + " added")
except Exception as exc:
logger = logging.getLogger('database')
logger.exception("Exception while inserting station data in db.")
raise SystemExit
def addStationsInLocationToDb(lat, lng, rad):
logger = logging.getLogger('miner')
logger.info("Requesting station list for lat: " + "{:.9f}".format(lat) +
"long: " + "{:.9f}".format(lng) + " and rad: " +
"{:.9f}".format(rad))
#Get Station data
stationList = apiRequests.listRequest(lat, lng, rad)["stations"]
dbHandle = connectDb.connect()
if dbHandle is None:
logger.critical("Cannot connect to db, exiting")
sys.exit("Cannot connect to db.")
for station in stationList:
#Format for Database
logger.info("Preparing data of " + station["name"] + " for insertion")
station["_id"] = station["id"]
del station["id"]
del station["dist"]
del station["price"]
logger.info("Inserting station data of " + station["name"] + " to db")
try:
#If data for this station already exists replace, else insert
dbHandle.stations.replace_one({"_id": station["_id"]},
station,
upsert=True)
logger.info("Station " + station["name"] + " added")
except Exception as exc:
logger = logging.getLogger('database')
logger.exception("Exception while inserting station data in db.")
raise SystemExit
import requests
import json
import doctest
utils.loggingMode = 3
try:
utils.logMessage("Testing detail request for gasstation with fix id")
jsonData = apiRequests.detailRequest(
"8f9a684e-975d-4856-9eb9-9cc14d241b7b")
print(type(jsonData))
utils.logMessage("Requesting details finished.")
if jsonData is None:
utils.logMessage("Error while requesting details.")
else:
utils.logMessage("Requesting details succeded.")
utils.logRequestResponse(jsonData)
utils.logMessage("Testing list request for gasstation with fix parameters")
jsonData = apiRequests.listRequest("53.223546", "10.169761", "10", "price",
"diesel")
utils.logMessage("Requesting list finished.")
if jsonData is None:
utils.logMessage("Error while requesting list.")
else:
utils.logMessage("Requesting list succeded.")
utils.logRequestResponse(jsonData)
except Exception as exc:
utils.logMessage("Exception while testing Requests: ", exc)
raise SystemExit
import apiRequests
import utils
import requests
import json
import doctest
utils.loggingMode=3
try:
utils.logMessage("Testing detail request for gasstation with fix id")
jsonData=apiRequests.detailRequest("8f9a684e-975d-4856-9eb9-9cc14d241b7b")
print(type(jsonData))
utils.logMessage("Requesting details finished.")
if jsonData is None:
utils.logMessage("Error while requesting details.")
else:
utils.logMessage("Requesting details succeded.")
utils.logRequestResponse(jsonData)
utils.logMessage("Testing list request for gasstation with fix parameters")
jsonData=apiRequests.listRequest("53.223546", "10.169761", "10", "price", "diesel")
utils.logMessage("Requesting list finished.")
if jsonData is None:
utils.logMessage("Error while requesting list.")
else:
utils.logMessage("Requesting list succeded.")
utils.logRequestResponse(jsonData)
except Exception as exc:
utils.logMessage("Exception while testing Requests: ", exc)
raise SystemExit
