def confirm_email(token):
try:
email = s.loads(token, salt='email-confirm', max_age=3600)
except SignatureExpired:
return '<h1> The token is Expired <\h1>'
data = db.get_user(email, "email")
if data['email_confirmation']:
flash('User already verified successfully! please login')
else:
data['email_confirmation'] = "verified"
results = db.update_user(data)
flash('User has been verified successfully')
return render_template('users.html')
line = line.strip().split(":", 1)[1].split("\n")[0]
datetime = parser.parse(line).strftime("%Y-%m-%d %H:%M")
return (elixirs_won, elixirs_played, elixirs_won_last, datetime)
if __name__ == "__main__":
events = db.get_last_events().fetchall()
print events
curr_event = events[0][0]
curr_event_time = parser.parse(events[0][1])
try:
last_event = events[1][0]
last_event_time = parser.parse(events[1][1])
except:
pass
users = db.get_tracked_users()
for user in users:
username = user[0]
profile = get_ntk_profile(username)
if not profile:
# db.update_user(username, add_flags=db.USER_FLAG_NOPROFILE)
continue
db.update_user(username)
db.update_user_record(
username, profile[0], profile[1] - profile[0], profile[1], 1.0 * profile[0] / profile[1], profile[3]
)
# db.update_event_user(curr_event, username, profile[2], curr_event_time, profile[3])
def get_comm_events():
events = []
year = datetime.now().strftime('%Y')
url = BASEURL + "index.html"
br = mechanize.Browser()
br.set_handle_refresh(False)
br.open(url)
for link in br.links(text_regex="[Tt][Aa][Gg]|[Ll][Ii][Xx]"):
eventid = year + link.url.replace('.html', '')[-8:]
host = link.url.replace('.html', '')[:-8]
name = link.text.replace('\xa0', ' ')
event = (eventid, name, host, BASEURL + link.url)
events.append(event)
return events
if __name__ == '__main__':
import sys
import lib.db as db
import lib.twitter as twitter
for event in get_comm_events():
exists = db.get_event_exists(event[0])
if exists:
print 'Reached known events. No new events found. Exiting.'
else:
db.update_event(*event)
# twitter.tweet_event(event)
print 'tweeting event...', event
db.update_user(event[2], add_flags=db.USER_FLAG_HOST)
sys.exit()
