def filter_and_send_3_days():
from datetime import datetime
cli, db = get_conn()
films = db['films']
users = db['users']
# cron take some seconds to call the script so we replace here to 0
now = datetime.now().replace(second=0, microsecond=0)
# myprint("DEBUG <= 3, should find ELENA created at 2017-07-04 15:39:07")
# now = datetime(2017, 7, 5, 15, 35, 0)
start = now + timedelta(days=1)
end = start + timedelta(minutes=5)
query = films.find({"screening.date": {"$gte": start, "$lt": end}})
myprint(
"Getting screenings from {:%Y-%m-%d %H:%M:%S} to {:%Y-%m-%d %H:%M:%S}."
.format(start, end))
found = 0
server = None
for film in query:
for screening in film['screening']:
created_at = screening.get('created_at', None)
screening_date = screening.get('date', None)
if not created_at or not screening_date:
continue # too old screening
if screening_date and screening_date >= start and screening_date < end:
delta = screening_date - created_at
if delta.total_seconds() > T3:
continue
if not server:
server = get_smtp_conn()
ambassador = \
users.find_one({"_id": screening['user_id']})
myprint("{} :: {} :: {}".format(
created_at, screening_date,
smart_unicode_with_ignore(film['title'])))
parse_and_send(server=server,
_from=const.FROM,
to=ambassador['emails'][0]['address'],
subject=SUBJECT,
template=TPL_NAME.format(3),
context={
'ambassador': ambassador,
'movie': film,
'screening': screening
})
found += 1
myprint("Mails sent: {}".format(found))
def filter_and_send():
cli, db = get_conn()
films = db['films']
users = db['users']
# cron take some seconds to call the script so we replace here to 0
now = datetime.now().replace(second=0, microsecond=0)
start = now - timedelta(days=7)
start = start.replace(hour=0, minute=0, second=0, microsecond=0)
end = start + timedelta(days=1, microseconds=-1)
query = films.find({
"screening.date": {"$gte": start, "$lt": end},
"screening.report_description": {"$ne": ""}
})
print("now: {}".format(now))
print("start: {}".format(start))
print("end: {}".format(end))
server = None
for film in query:
for screening in film['screening']:
date = screening.get('date', None)
report = screening.get('report_description', None)
if date and date >= start and date < end and report:
if not server:
server = get_smtp_conn()
ambassador = \
users.find_one({"_id": screening['user_id']})
print("{} :: {}".format(screening['date'], film['title']))
parse_and_send(
server=server,
_from=const.FROM,
to=ambassador['emails'][0]['address'],
subject=SUBJECT,
template=TPL_NAME,
context={
'ambassador': ambassador,
'movie': film,
'screening': screening
}
)
def filter_and_send():
from datetime import datetime
cli, db = get_conn()
films = db['films']
users = db['users']
# cron take some seconds to call the script so we replace here to 0
now = datetime.now().replace(second=0, microsecond=0)
# myprint("DEBUG >= 10 dias, should find ELENA created at 2017-08-31 11:49:11")
# now = datetime(2017, 8, 31, 23, 50, 0)
# myprint("DEBUG >= 4 e <= 9, should find ELENA created at 2017-09-03 14:03:40")
# now = datetime(2017, 9, 4, 2, 3, 45)
# myprint("DEBUG <= 3 dias, should find ELENA created at 2017-07-04 15:39:07")
# now = datetime(2017, 7, 5, 3, 40)
end = now - timedelta(hours=12)
start = end - timedelta(minutes=5)
query = films.find({"screening.created_at": {"$gte": start, "$lt": end}})
myprint(
"Getting screenings from {:%Y-%m-%d %H:%M:%S} to {:%Y-%m-%d %H:%M:%S}."
.format(start, end))
found = {'<=3': 0, '>3 and <=9': 0, '>=10': 0}
server = None
for film in query:
for screening in film['screening']:
created_at = screening.get('created_at', None)
screening_date = screening.get('date', None)
if not created_at or not screening_date:
continue # too old screening
if created_at >= start and created_at < end:
delta = screening_date - created_at
if delta.total_seconds() <= T9:
continue
days = 10
found['>=10'] += 1
myprint(
"FOUND => days: {days} :: created: {created_at} :: screening date"
": {screening_date} :: {film}".format(
film=smart_unicode_with_ignore(film['title']),
created_at=created_at.strftime("%Y-%m-%d %H:%M:%S"),
screening_date=screening_date.strftime(
"%Y-%m-%d %H:%M:%S"),
days=days))
if not server:
server = get_smtp_conn()
ambassador = \
users.find_one({"_id": screening['user_id']})
parse_and_send(server=server,
_from=const.FROM,
to=ambassador['emails'][0]['address'],
subject=SUBJECT,
template=TPL_NAME.format(days),
context={
'ambassador': ambassador,
'movie': film,
'screening': screening
})
myprint("Mails sent:")
for k, v in found.items():
myprint("{}: {}".format(k, v))
def filter_and_send():
from datetime import datetime
cli, db = get_conn()
films = db['films']
users = db['users']
# cron take some seconds to call the script so we replace here to 0
now = datetime.now().replace(second=0, microsecond=0)
# myprint("DEBUG >= 10 dias, deve pegar ELENA c/ sessão em 2017-09-14 15:00:00")
# now = datetime(2017, 9, 4, 15, 05)
end = now + timedelta(days=10)
start = end - timedelta(minutes=5)
query = films.find({
"screening.date": {"$gte": start, "$lt": end}
})
myprint(
"Getting screenings from {:%Y-%m-%d %H:%M:%S} to {:%Y-%m-%d %H:%M:%S}."
.format(start, end)
)
found = 0
server = None
for film in query:
for screening in film['screening']:
created_at = screening.get('created_at', None)
screening_date = screening.get('date', None)
if not created_at or not screening_date:
continue # too old screening
if screening_date >= start and screening_date < end:
delta = screening_date - created_at
if delta.total_seconds() < T10:
continue
myprint(
"FOUND => days: {days} :: created: {created_at} :: screening date"
": {screening_date} :: {film}".format(
film=smart_unicode_with_ignore(film['title']),
created_at=created_at.strftime("%Y-%m-%d %H:%M:%S"),
screening_date=screening_date.strftime("%Y-%m-%d %H:%M:%S"),
days=10
)
)
if not server:
server = get_smtp_conn()
ambassador = \
users.find_one({"_id": screening['user_id']})
parse_and_send(
server=server,
_from=const.FROM,
to=ambassador['emails'][0]['address'],
subject=SUBJECT,
template=TPL_NAME,
context={
'ambassador': ambassador,
'movie': film,
'screening': screening
}
)
found += 1
myprint("Mails sent: {}".format(found))
def filter_and_send_9_days():
from datetime import datetime
cli, db = get_conn()
films = db['films']
# {
users = db['users']
# cron take some seconds to call the script so we replace here to 0
now = datetime.now().replace(second=0, microsecond=0)
# myprint("DEBUG >= 4 e <= 9, should find ELENA created at 2017-09-03 14:03:40")
# now = datetime(2017, 9, 5, 14, 0, 0)
# Dates are in UTC
# "_id" : "GiWtfWAaDXjNRfjtc",
# "title" : "Realidade Visceral",
# "date" : ISODate("2017-11-02T11:00:00.000Z"),
# "created_at" : ISODate("2017-10-26T06:22:12.349Z"),
# "user_id" : "io9RPivt6s9TpSMpg",
# "_id" : "487852f4b13f70fc87f53281"
# }
start = now + timedelta(days=2)
end = start + timedelta(minutes=5)
query = films.find({"screening.date": {"$gte": start, "$lt": end}})
myprint(
"Getting screenings from {:%Y-%m-%d %H:%M:%S} to {:%Y-%m-%d %H:%M:%S}."
.format(start, end))
found = 0
server = None
for film in query:
# if u'Visceral' in film['title']:
# print("Now", now)
# print("Start", start)
# print("End", end)
for screening in film['screening']:
created_at = screening.get('created_at', None)
screening_date = screening.get('date', None)
if not created_at or not screening_date:
continue # too old screening
if screening_date and screening_date >= start and screening_date < end:
delta = screening_date - created_at
if delta.total_seconds() < T4 or delta.total_seconds() > T9:
continue
if not server:
server = get_smtp_conn()
ambassador = \
users.find_one({"_id": screening['user_id']})
myprint("{} :: {} :: {} :: {}".format(
created_at, screening_date, ambassador,
smart_unicode_with_ignore(film['title'])))
parse_and_send(server=server,
_from=const.FROM,
to=ambassador['emails'][0]['address'],
subject=SUBJECT,
template=TPL_NAME.format(9),
context={
'ambassador': ambassador,
'movie': film,
'screening': screening
})
found += 1
myprint("Mails sent: {}".format(found))