def mail(request, token_object):
#token_object = token(request)
access_token = token_object[0]
current_user = token_object[1]
print "access_token : " + str(access_token)
print "current_user : " + str(current_user)
# If there is no token in the session, redirect to home
current_user_obj = Users.objects.get(email=current_user)
if not access_token:
return HttpResponseRedirect(reverse('oauth:home'))
else:
message = get_my_messages(access_token)
time_now = datetime.datetime.utcnow()
for i in range(10):
todo = Emails()
todo.username = current_user_obj
rt = message['value'][i]['receivedDateTime']
rt_dt = datetime.datetime(int(rt[0:4]),
int(rt[5:7]), int(rt[8:10]),
int(rt[11:13]), int(rt[14:16]),
int(rt[17:19]), 0, pytz.UTC)
if (rt_dt > current_user_obj.lastchecked):
todo.receivedDateTime = rt_dt
todo.title = message['value'][i]['body']['content']
todo.date = rt_dt.date()
todo.start_time = rt_dt.time()
todo.end_time = rt_dt.time()
todo.save()
current_user_obj.lastchecked = datetime.datetime.utcnow()
current_user_obj.save()
return current_user
def verify(request):
if "email_added" not in request.session:
request.session['email_added'] = False
if request.method == "POST":
if Emails.objects.email_validation(request.POST['email']):
d = Emails(email = request.POST['email'])
d.save()
request.session['email_added'] = True
request.session['email'] = request.POST['email']
return redirect('/success')
else:
print "{} invalid!".format(request.POST['email'])
request.session['error'] = True
request.session['email'] = request.POST['email']
return redirect('/')
def emails():
if request.method == "POST":
message = Emails(emails=request.form['ss'])
db.session.add(message)
db.session.commit()
flash('Your request was successful!', 'success')
return redirect(url_for('index'))
def save_email():
req_data = request.form
# check request with params
if req_data:
event_id = req_data['event_id']
email_subject = req_data['email_subject']
email_content = req_data['email_content']
timestamp = datetime.strptime(req_data['timestamp'], '%d-%m-%Y %H:%M')
emails = Emails(event_id=event_id,
email_subject=email_subject,
email_content=email_content,
timestamp=timestamp)
db.session.add(emails)
db.session.commit()
print(event_id, email_subject, email_content, timestamp)
else:
raise BadRequest()
response = {
"status_code": 200,
"message": "successful",
}
return jsonify(response)
def model_create(user_dict):
"""prepare data for primary table extracting from form"""
user = Users(username=user_dict["username"], password=user_dict["password"])
"""add and commit data to user table"""
db.session.add(user)
db.session.commit()
"""prepare data for related tables extracting from form and using new UserID """
userid = db.session.query(func.max(Users.UserID))
email = Emails(email_address=user_dict["email"], UserID=userid)
phone_number = PhoneNumbers(phone_number=user_dict["phone_number"], UserID=userid)
"""email table add and commit"""
db.session.add(email)
db.session.commit()
"""phone number table add and commit"""
db.session.add(phone_number)
db.session.commit()
def model_update(user_dict):
"""fetch userid"""
userid = user_dict["userid"]
"""update email in table from data in form if it exists, insert if not"""
if Emails.query.filter_by(UserID=userid).first() is not None:
db.session.query(Emails).filter_by(UserID=userid).update({Emails.email_address: user_dict["email"]})
else:
email = Emails(email_address=user_dict["email"], UserID=userid)
db.session.add(email)
"""update phone number in table from data in form"""
if PhoneNumbers.query.filter_by(UserID=userid).first() is not None:
db.session.query(PhoneNumbers).filter_by(UserID=userid).update(
{PhoneNumbers.phone_number: user_dict["phone_number"]})
else:
phone_number = PhoneNumbers(phone_number=user_dict["phone_number"], UserID=userid)
db.session.add(phone_number)
"""commit changes to database"""
db.session.commit()
def create():
if request.form:
"""prepare data for primary table extracting from form"""
user = Users(username=request.form.get("username"),
password=request.form.get("password"))
"""add and commit data to user table"""
db.session.add(user)
db.session.commit()
"""prepare data for related tables extracting from form and using new UserID """
userid = db.session.query(func.max(Users.UserID))
email = Emails(email_address=request.form.get("email"), UserID=userid)
phone_number = PhoneNumbers(
phone_number=request.form.get("phone_number"), UserID=userid)
"""email table add and commit"""
db.session.add(email)
db.session.commit()
"""phone number table add and commit"""
db.session.add(phone_number)
db.session.commit()
return redirect(url_for('pythondb_bp.databases'))
def post(self, key):
"""Worker that runs in the 'background'"""
# Get the object from the database
email = Emails.get(key)
# Construct a appengine.api.mail object
message = mail.EmailMessage()
message.sender = "Your Name <[email protected]>"
message.to = email.to
message.subject = email.subject
# Set text and html body
message.body = email.body_text
message.html = email.body_html
# Send. Important: Sometimes emails fail to send, which will throw an
# exception and end the function there. Next round tries again.
message.send()
# Now the message was sent and we can safely delete it.
email.delete()
def post(self, key):
"""Worker that runs in the 'background'"""
# Get the object from the database
email = Emails.get(key)
# Construct a appengine.api.mail object
message = mail.EmailMessage()
message.sender = "Your Name <[email protected]>"
message.to = email.to
message.subject = email.subject
# Set text and html body
message.body = email.body_text
message.html = email.body_html
# Send. Important: Sometimes emails fail to send, which will throw an
# exception and end the function there. Next round tries again.
message.send()
# Now the message was sent and we can safely delete it.
message.delete()
def update():
if request.form:
"""fetch userid"""
userid = request.form.get("ID")
"""update email in table from data in form if it exists, insert if not"""
if Emails.query.filter_by(UserID=userid).first() is not None:
db.session.query(Emails).filter_by(UserID=userid).update(
{Emails.email_address: request.form.get("email")})
else:
email = Emails(email_address=request.form.get("email"),
UserID=userid)
db.session.add(email)
"""update phone number in table from data in form"""
if PhoneNumbers.query.filter_by(UserID=userid).first() is not None:
db.session.query(PhoneNumbers).filter_by(UserID=userid).update(
{PhoneNumbers.phone_number: request.form.get("phone_number")})
else:
phone_number = PhoneNumbers(
phone_number=request.form.get("phone_number"), UserID=userid)
db.session.add(phone_number)
"""commit changes to database"""
db.session.commit()
return redirect(url_for('pythondb_bp.databases'))