def handler(event, context): try: httpMethod = event["httpMethod"] if httpMethod == "GET": q = """ select set_id, set_name, set_desc, created_by from value_sets """ params = event["queryStringParameters"] if params != None and "set_name" in params: q += " where set_name = %s" params = (params["set_name"]) return mysql_connector.single_query(q, params) return mysql_connector.query(q, params) elif httpMethod == "POST": try: sql = """ INSERT INTO value_sets ( set_name, set_desc, created_by, created_date, updated_by, updated_date ) VALUES ( %s, %s, %s, SYSDATE(), %s, SYSDATE()); """ data = json.loads(event["body"]) params = (data.get("set_name", ""), data.get("set_desc", ""), mysql_connector.get_username(event), mysql_connector.get_username(event)) return mysql_connector.execute(sql, params) except: return mysql_connector.client_error("Invalid POST data") elif httpMethod == "PUT": try: sql = """ UPDATE value_sets SET set_name = %s, set_desc = %s, updated_by = %s, updated_date = SYSDATE() WHERE set_id = %s """ data = json.loads(event["body"]) params = (data.get("set_name", ""), data.get("set_desc", ""), mysql_connector.get_username(event), data.get("set_id", "")) return mysql_connector.execute(sql, params) except: return mysql_connector.client_error("Invalid PUT data") elif httpMethod == "DELETE": try: sql = """ DELETE FROM value_sets WHERE set_id = %s """ data = json.loads(event["body"]) params = (data.get("set_id", "")) return mysql_connector.execute(sql, params) except: return mysql_connector.client_error("Invalid DELETE data") else: return mysql_connector.client_error("Invalid HTTP Method") except: return mysql_connector.server_error("Unknown server error")
global str logging.basicConfig(filename="/scripts/electiontweets/electiontweets.log", level=logging.INFO, format='%(asctime)s %(message)s') api = Twython(CONSUMER_KEY, CONSUMER_SECRET, ACCESS_KEY, ACCESS_SECRET) candidateArray = [ 'realDonaldTrump', 'DrJillStein', 'GovGaryJohnson', 'HillaryClinton', 'SenSanders' ] for candidate in candidateArray: candidateSql = "SELECT twitter_id FROM " + candidate + " ORDER BY twitter_id DESC LIMIT 1" last_id = query(candidateSql) try: if last_id is None: user_timeline = api.get_user_timeline(screen_name=candidate, count=200) else: last_id = int(last_id[0]) + 1 user_timeline = api.get_user_timeline(screen_name=candidate, count=200, since_id=last_id) counter = 0 except TwythonError, e: logging.warning(e) sys.exit(0) for tweet in user_timeline: counter = counter + 1
from mysql_connector import query import time import sys import logging from election_config import * global str logging.basicConfig(filename="/scripts/electiontweets/electiontweets.log", level=logging.INFO, format='%(asctime)s %(message)s') api = Twython(CONSUMER_KEY,CONSUMER_SECRET,ACCESS_KEY,ACCESS_SECRET) candidateArray = ['realDonaldTrump', 'DrJillStein', 'GovGaryJohnson', 'HillaryClinton', 'SenSanders'] for candidate in candidateArray: candidateSql = "SELECT twitter_id FROM " + candidate + " ORDER BY twitter_id DESC LIMIT 1" last_id = query(candidateSql) try: if last_id is None: user_timeline = api.get_user_timeline(screen_name=candidate, count=200) else: last_id = int(last_id[0]) + 1 user_timeline = api.get_user_timeline(screen_name=candidate, count=200, since_id=last_id) counter = 0 except TwythonError,e: logging.warning(e) sys.exit(0) for tweet in user_timeline: counter = counter + 1 text = tweet['text'].encode("ascii", "ignore") id = tweet['id'] created_at = time.strftime('%Y-%m-%d %H:%M:%S', time.strptime(tweet['created_at'],'%a %b %d %H:%M:%S +0000 %Y'))
def handler(event, context): q = """ select armor_id, armor_name, armor_desc, armor_type, cost, armor_class, strength, IF(stealth_dis, 'true', 'false') stealth_dis, weight, created_by from armor where 1=1 """ try: httpMethod = event["httpMethod"] if httpMethod == "GET": params = event["queryStringParameters"] if params != None and "armor_id" in params: q += " and armor_id = %s" params = (params["armor_id"]) return mysql_connector.single_query(q, params) else: return mysql_connector.query(q, params) elif httpMethod == "POST": try: sql = """ INSERT INTO armor ( armor_name, armor_desc, armor_type, cost, armor_class, strength, stealth_dis, weight, created_by, created_date, updated_by, updated_date ) VALUES ( %s, %s, %s, %s, %s, %s, %s, %s, %s, SYSDATE(), %s, SYSDATE()); """ data = json.loads(event["body"]) params = (data.get("armor_name", ""), data.get("armor_desc", ""), data.get("armor_type", ""), data.get("cost", ""), data.get("armor_class", ""), data.get("strength", ""), (1 if str(data.get("stealth_dis", "")).lower() == "true" else 0), data.get("weight", ""), mysql_connector.get_username(event), mysql_connector.get_username(event)) mysql_connector.execute(sql, params) q += """ and armor_id = LAST_INSERT_ID()""" return mysql_connector.single_query(q) except: return mysql_connector.client_error("Invalid POST data") elif httpMethod == "PUT": try: sql = """ UPDATE armor SET armor_name = %s, armor_desc = %s, armor_type = %s, cost = %s, armor_class = %s, strength = %s, stealth_dis = %s, weight = %s, updated_by = %s, updated_date = SYSDATE() WHERE armor_id = %s """ data = json.loads(event["body"]) params = (data.get("armor_name", ""), data.get("armor_desc", ""), data.get("armor_type", ""), data.get("cost", ""), data.get("armor_class", ""), data.get("strength", ""), (1 if str(data.get("stealth_dis", "")).lower() == "true" else 0), data.get("weight", ""), mysql_connector.get_username(event), data.get("armor_id", "")) mysql_connector.execute(sql, params) params = (data.get("armor_id", "")) q += """ and armor_id = %s""" return mysql_connector.single_query(q, params) except: return mysql_connector.client_error("Invalid PUT data") elif httpMethod == "DELETE": try: sql = """ DELETE FROM armor WHERE armor_id = %s """ params = event["queryStringParameters"] params = (params["armor_id"]) return mysql_connector.execute(sql, params) except: return mysql_connector.client_error("Invalid DELETE data") else: return mysql_connector.client_error("Invalid HTTP Method") except: return mysql_connector.server_error("Unknown server error")
def handler(event, context): q = """ select weapon_id, weapon_name, weapon_desc, weapon_type, cost, damage, weight, weapon_props, created_by from weapons where 1=1 """ try: httpMethod = event["httpMethod"] if httpMethod == "GET": params = event["queryStringParameters"] if params != None and "weapon_id" in params: q += " and weapon_id = %s" params = (params["weapon_id"]) return mysql_connector.single_query(q, params) else: return mysql_connector.query(q, params) elif httpMethod == "POST": try: sql = """ INSERT INTO weapons ( weapon_name, weapon_desc, weapon_type, cost, damage, weight, weapon_props, created_by, created_date, updated_by, updated_date ) VALUES ( %s, %s, %s, %s, %s, %s, %s, %s, SYSDATE(), %s, SYSDATE()); """ data = json.loads(event["body"]) params = (data.get("weapon_name", ""), data.get("weapon_desc", ""), data.get("weapon_type", ""), data.get("cost", ""), data.get("damage", ""), data.get("weight", ""), data.get("weapon_props", ""), mysql_connector.get_username(event), mysql_connector.get_username(event)) mysql_connector.execute(sql, params) q += """ and weapon_id = LAST_INSERT_ID()""" return mysql_connector.single_query(q) except: return mysql_connector.client_error("Invalid POST data") elif httpMethod == "PUT": try: sql = """ UPDATE weapons SET weapon_name = %s, weapon_desc = %s, weapon_type = %s, cost = %s, damage = %s, weight = %s, weapon_props = %s, updated_by = %s, updated_date = SYSDATE() WHERE weapon_id = %s """ data = json.loads(event["body"]) params = (data.get("weapon_name", ""), data.get("weapon_desc", ""), data.get("weapon_type", ""), data.get("cost", ""), data.get("damage", ""), data.get("weight", ""), data.get("weapon_props", ""), mysql_connector.get_username(event), data.get("weapon_id", "")) mysql_connector.execute(sql, params) params = (data.get("weapon_id", "")) q += """ and weapon_id = %s""" return mysql_connector.single_query(q, params) except: return mysql_connector.client_error("Invalid PUT data") elif httpMethod == "DELETE": try: sql = """ DELETE FROM weapons WHERE weapon_id = %s """ params = event["queryStringParameters"] params = (params["weapon_id"]) return mysql_connector.execute(sql, params) except: return mysql_connector.client_error("Invalid DELETE data") else: return mysql_connector.client_error("Invalid HTTP Method") except: return mysql_connector.server_error("Unknown server error")
from twython import Twython from mysql_connector import insert from mysql_connector import query from election_config import * import time api = Twython(CONSUMER_KEY,CONSUMER_SECRET,ACCESS_KEY,ACCESS_SECRET) last_id = query("SELECT twitter_id FROM GovGaryJohnson ORDER BY twitter_id ASC LIMIT 1") if last_id is None: user_timeline = api.get_user_timeline(screen_name="GovGaryJohnson", count=200) else: last_id = int(last_id[0]) - 1 user_timeline = api.get_user_timeline(screen_name="GovGaryJohnson", count=200, max_id=last_id) counter = 0 for tweet in user_timeline: counter = counter + 1 text = tweet['text'].encode("ascii", "ignore") id = tweet['id'] created_at = time.strftime('%Y-%m-%d %H:%M:%S', time.strptime(tweet['created_at'],'%a %b %d %H:%M:%S +0000 %Y')) query = """ INSERT INTO GovGaryJohnson(twitter_id, tweet, created_at) VALUES(%s, %s, %s)""" try: insert(query, id, text, created_at) except Exception,e: print str(e) print("Error occured") pass
def handler(event, context): q = """ select sv.value_id, sv.set_value, sv.value_desc, sv.created_by, vs.set_id, vs.set_name from set_values sv, value_sets vs where sv.set_id = vs.set_id """ try: httpMethod = event["httpMethod"] if httpMethod == "GET": params = event["queryStringParameters"] if params != None and "set_name" in params: q += " and vs.set_name = %s" params = (params["set_name"]) return mysql_connector.query(q, params) elif httpMethod == "POST": try: sql = """ INSERT INTO set_values ( set_value, set_id, value_desc, created_by, created_date, updated_by, updated_date ) VALUES ( %s, (SELECT vs.set_id FROM value_sets vs WHERE vs.set_name = %s), %s, %s, SYSDATE(), %s, SYSDATE()); """ data = json.loads(event["body"]) params = (data.get("set_value", ""), data.get("set_name", ""), data.get("value_desc", ""), mysql_connector.get_username(event), mysql_connector.get_username(event)) mysql_connector.execute(sql, params) q += """ and sv.value_id = LAST_INSERT_ID()""" return mysql_connector.single_query(q) except Exception as e: return mysql_connector.client_error("Invalid POST data" + str(e)) elif httpMethod == "PUT": try: sql = """ UPDATE set_values SET set_value = %s, value_desc = %s, updated_by = %s, updated_date = SYSDATE() WHERE value_id = %s """ data = json.loads(event["body"]) params = (data.get("set_value", ""), data.get("value_desc", ""), mysql_connector.get_username(event), data.get("value_id", "")) mysql_connector.execute(sql, params) params = (data.get("value_id", "")) q += """ and sv.value_id = %s""" return mysql_connector.single_query(q, params) except: return mysql_connector.client_error("Invalid PUT data") elif httpMethod == "DELETE": try: sql = """ DELETE FROM set_values WHERE value_id = %s """ params = event["queryStringParameters"] params = (params["value_id"]) return mysql_connector.execute(sql, params) except: return mysql_connector.client_error("Invalid DELETE data") else: return mysql_connector.client_error("Invalid HTTP Method") except: return mysql_connector.server_error("Unknown server error")
def handler(event, context): q = """ select spell_id, spell_name, spell_desc, spell_level, higher_level, spell_range, components, IF(ritual, 'true', 'false') ritual, duration, casting_time, spell_school, created_by from spells where 1=1 """ try: httpMethod = event["httpMethod"] if httpMethod == "GET": params = event["queryStringParameters"] if params != None and "spell_id" in params: q += " and spell_id = %s" params = (params["spell_id"]) return mysql_connector.single_query(q, params) else: return mysql_connector.query(q, params) elif httpMethod == "POST": try: sql = """ INSERT INTO spells ( spell_name, spell_desc, spell_level, higher_level, spell_range, components, ritual, duration, casting_time, spell_school, created_by, created_date, updated_by, updated_date ) VALUES ( %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, SYSDATE(), %s, SYSDATE()); """ data = json.loads(event["body"]) params = (data.get("spell_name", ""), data.get("spell_desc", ""), data.get("spell_level", ""), data.get("higher_level", ""), data.get("spell_range", ""), data.get("components", ""), (1 if str(data.get("ritual", "")).lower() == "true" else 0), data.get("duration", ""), data.get("casting_time", ""), data.get("spell_school", ""), mysql_connector.get_username(event), mysql_connector.get_username(event)) mysql_connector.execute(sql, params) q += """ and spell_id = LAST_INSERT_ID()""" return mysql_connector.single_query(q) except: return mysql_connector.client_error("Invalid POST data") elif httpMethod == "PUT": try: sql = """ UPDATE spells SET spell_name = %s, spell_desc = %s, spell_level = %s, higher_level = %s, spell_range = %s, components = %s, ritual = %s, duration = %s, casting_time = %s, spell_school = %s, updated_by = %s, updated_date = SYSDATE() WHERE spell_id = %s """ data = json.loads(event["body"]) params = (data.get("spell_name", ""), data.get("spell_desc", ""), data.get("spell_level", ""), data.get("higher_level", ""), data.get("spell_range", ""), data.get("components", ""), (1 if str(data.get("ritual", "")).lower() == "true" else 0), data.get("duration", ""), data.get("casting_time", ""), data.get("spell_school", ""), mysql_connector.get_username(event), data.get("spell_id", "")) mysql_connector.execute(sql, params) params = (data.get("spell_id", "")) q += """ and spell_id = %s""" return mysql_connector.single_query(q, params) except: return mysql_connector.client_error("Invalid PUT data") elif httpMethod == "DELETE": try: sql = """ DELETE FROM spells WHERE spell_id = %s """ params = event["queryStringParameters"] params = (params["spell_id"]) return mysql_connector.execute(sql, params) except: return mysql_connector.client_error("Invalid DELETE data") else: return mysql_connector.client_error("Invalid HTTP Method") except: return mysql_connector.server_error("Unknown server error")