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