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()