def on_post_data(original_url): details = {} try: db = dbsetup() cursor = db.cursor() cursor.execute(FETCH_SHORT_URL,(original_url,)) data = cursor.fetchall() if len(data) == 0: url = _short_url(original_url) print url cursor.execute(INSERT_SHORT_URL,(original_url,url,)) db.commit() cursor.execute(FETCH_SHORT_URL,(original_url,)) data = cursor.fetchall() print data details = {"ShortenedURL":data} print details except Exception as e: log.info(e) finally: db.commit() db.close() return details
def on_get(self, req, resp, url): try: db = dbsetup() cursor = db.cursor() cursor.execute(FETCH_SHORT_URL,(url,)) data = cursor.fetchall() log.info("=============") log.info(data) details = {"urlDetails":data} except Exception as e: log.info(e) finally: db.close() resp.status = falcon.HTTP_200 log.info(details) resp.body = (json.dumps(details))