"""
In Development, possible to use GAE Mail service to send out emails.
Add these lines:

smtp.ehlo()
smtp.starttls()
smtp.ehlo()

at google-cloud-sdk/platform/google_appengine/google/appengine/api/mail_stub.py
after smtp.connect

and run this command:
dev_appserver.py --smtp_host=smtp.gmail.com --smtp_port=587 --smtp_user=sender@gmail.com --smtp_password=sender_password app.yaml

"""

import os
import csv
import datetime
import lib.cloudstorage as gcs

from google.appengine.api import mail
from google.appengine.api import app_identity

bucket_name = os.environ.get('BUCKET_NAME',
                               app_identity.get_default_gcs_bucket_name())
bucket = '/'+bucket_name
file = 'data-{}.csv'.format(datetime.datetime.today().strftime('%Y-%m-%d'))
filename = bucket + '/' + file

write_retry_params = gcs.RetryParams(backoff_factor=1.1)
gcs_file = gcs.open(filename,
              'w',
              content_type='text/csv',
              options={'x-goog-meta-foo': 'foo',
                       'x-goog-meta-bar': 'bar'},
              retry_params=write_retry_params)

data = getData()

writer = csv.writer(gcs_file, delimiter=',')

writer.writerow(['ColName1', 'ColName2'])
for row in data:
  writer.writerow(['Field1','Field2'])
gcs_file.close()

gcs_file = gcs.open(filename)
contents = gcs_file.read()
gcs_file.close()

message = mail.send_mail(
      sender="sender@gmail.com",
      to = "receiver@gmail.com",
      body = 'Hello! Check out the attachment for data on {}'.format(file),
      subject="READ THIS",
      attachments=[(file),(contents)])