weckbot/tweeter.py

52 lines
1.3 KiB
Python
Executable file

#!/usr/bin/env python
# -*- coding: utf-8 -*-
import HTMLParser, tweepy, os, sqlite3, time, random
# Notice: You may want to create seperate apps (or even accounts) for
# the getter and the tweeter.
# For larger user bases, consider using multiple tweeter accounts.
cke = "Consumer Key"
cse = "Consumer Secret"
ato = "Access Token"
ase = "Access Secret"
database_filename = "Database.db"
auth = tweepy.OAuthHandler(cke, cse)
auth.set_access_token(ato, ase)
api = tweepy.API(auth)
sql_conn = sqlite3.connect(database_filename)
cur = sql_conn.cursor()
while True:
values = cur.execute("SELECT * FROM tweets WHERE datetime(timestamp) < datetime('now','localtime') AND sent = 0")
for status in values:
original = int(status[0])
recipient = status[2]
comment = status[3]
greetings = {
0: "Es ist soweit."
1: "Die Zeit ist gekommen."
2: "Los geht's."
3: "Du wolltest geweckt werden. Ich wecke."
4: "*aufweck*"
5: "Hopp, aufstehen!"
6: "*BUMM*"
7: "Guten Tag. Hier spricht die Polizei!"
8: "Guten Morgen. :P"
}
try:
api.update_status("@%s %s %s" % (recipient, greetings.get(random.randint(0,len(dict)-1)), comment) [:140], original)
cur.execute("UPDATE tweets SET sent = 1 WHERE tweet_id = %i" % original)
sql_conn.commit()
except Exception, e:
print "Error in " + str(twid)
print e
pass
time.sleep(10)