def getLastVal(type): # get the data cur.execute("SELECT * FROM {0} ORDER BY time DESC LIMIT 1;".format( type )) # return! return cur.fetchone()
def doorTweet(): from LGSStatus import twitter # get the last two door states cur.execute("SELECT * FROM door ORDER BY time DESC LIMIT 2;") states = cur.fetchall() if states[0][1] != states[1][1]: # check what to tweet - door opened if states[0][1] > states[1][1]: # get one random opening tweet and tweet it twitter.update_status(random.choice(config["twitter"]["tweets"]["opened"])) # '' - door closed else: twitter.update_status(random.choice(config["twitter"]["tweets"]["closed"]))
def getTypeVals(type, limit): out = "[" # get all the data cur.execute("SELECT * FROM {0} ORDER BY time DESC LIMIT {1};".format( type, limit )) # reverse it and put it into one string for d in reversed(cur.fetchall()): out += "[{0}, {1}],".format( d[2]*1000, d[1] ) # delete the last comma, add a closing ] and return all the things return out[0:-1] + "]"
def insert(type): # key check if bottle.request.query.key in config["keys"]: # type check if type in config["types"]: # value check if bottle.request.query.value: cur.execute("INSERT INTO {0} (value, time) VALUES (?, ?);".format(type), ( bottle.request.query.value, int(time.time()) )) db.commit() # door tweet thingy if type == "door": helpers.doorTweet() return "1" bottle.abort(400, "you think nobody needs the value? then i can't agree with you.") bottle.abort(400, "what about correct types?") bottle.abort(403, "muhahaha penis")