def is_expired(**kwargs):
q_list = query_all(member_table)
today = datetime.now().date()
fourweeks = timedelta(days=14)
for dict in q_list:
expires = datetime.strptime(dict['expires'],"%Y-%m-%d")
delete_fil = (expires + fourweeks).date()
if expires.date() - today == timedelta(days=14):
with Mdb.test_request_context("/"):
send_email("Your CUAS membership will expire in two weeks!", Mdb.config['ADMINS'][0],
[str(dict['email'])], render_template("will_expire_email.txt",member=str(dict['first_name'])))
if today == expires.date():
with Mdb.test_request_context("/"):
send_email("Your CUAS membership has expired!", Mdb.config['ADMINS'][0],
[str(dict['email'])], render_template("expired_email.txt",member=str(dict['first_name'])))
if today > delete_fil:
email_search = member_table.query.filter_by(email=dict['email']).first()
if email_search:
db.session.delete(email_search)
write_deleted_log(dict)
print "%s has been deleted from member table. Membership expired on %s. Log here: %s" % (' '.join([dict['first_name'],dict['last_name']]),expires.date(),"/Users/mjohns44/Code/GIT/Mdb/logs/delete.log")
db.session.commit()
from Mdb import Mdb
#Mdb.config.update(SERVER_NAME="127.0.0.1:5000")
if __name__ == '__main__':
Mdb.run(debug=True)
