def return_component_roles(project_key, component):
project_key = str(project_key).lower()
component = str(component).lower()
log.trace(log, ("GET /%s/%s" % (project_key, component)))
result = query_database(project_key, component)
if result == False or result == "":
abort(404)
else:
return result
def query_database(project_key, component):
log.trace(log, "Enter query_database.")
try:
db = sql.connect(path_to_db)
c = db.cursor()
result = c.execute('SELECT * FROM roletable WHERE project_key = ? AND component = ?;', (project_key, component))
return result.fetchone()
except:
log.error(log, ("An exception occurred trying to look up values for %s and %s." % (project_key, component)))
return False
def not_found():
log.warning(log, "Returning 404.")
return "No results found."
try:
db = sql.connect(path_to_db)
c = db.cursor()
result = c.execute('SELECT * FROM roletable WHERE project_key = ? AND component = ?;', (project_key, component))
return result.fetchone()
except:
log.error(log, ("An exception occurred trying to look up values for %s and %s." % (project_key, component)))
return False
@app.route('/<project_key>/<component>')
def return_component_roles(project_key, component):
project_key = str(project_key).lower()
component = str(component).lower()
log.trace(log, ("GET /%s/%s" % (project_key, component)))
result = query_database(project_key, component)
if result == False or result == "":
abort(404)
else:
return result
@app.errorhandler(404)
def not_found():
log.warning(log, "Returning 404.")
return "No results found."
if __name__ == '__main__':
log.loggingLevel = logging_level
log.logFilePath = log_file_path
log.information(log, "Starting JPR.")
app.run()