class Notifications(object):
@lazyproperty
def logger(self):
return logger.getLogger('Notifications')
def __init__(self):
self.conf = conf.getInstance()
self.db = db.getInstance()
self.users = Users()
self.messages = Messages()
self.email = Emails()
def sendMessageActivity(self, user=None):
'''Given a User Object, or None for all,
Send Message Activity Email to user(s)
Send notification about Comments on Users message
or on comments to messages user has liked or commented on
Since the last time run
TO DO: Implement dynamtic send interval based
on number of likes and comments
'''
data = self._getMessageComments(user.id if user else None)
for user_id in data.keys():
purge = []
user = User(user_id)
print 'Email to:', data[user_id]['email']
posts = []
for message in data[user_id]['messages']:
# message data
mUser = User(message['message_user_id'])
# comments data
comments = []
for i, cid in enumerate(message['comment_ids']):
cUser = User(Comment(cid).user_id)
profile_url = 'http://%s/profile.py?u=%s' % \
(self.conf.baseurl, encrypt_int(cUser.id))
comments.append({'name': cUser.fullname,
'profile_image': getUserImage(cUser.id),
'profile_url': profile_url,
'text': message['comment_texts'][i]})
purge.append([user_id, cid])
# activity message
message_url = 'http://%s/main.py#message_card_%s' \
% (self.conf.baseurl, message['id'])
post_link = a(b('Post', style='font-size:14px'),
href=message_url)
orig_post = message['message_text'][0:119]
if len(message['message_text']) > 120:
orig_post += ' ...'
if user_id == mUser.id:
who = 'your'
else:
who = mUser.fullname + "'s"
activity_msg = '%s new comment%s on %s %s<p/>%s' % \
(len(comments),
's' if len(comments) > 1 else '',
who,
post_link,
orig_post)
posts.append({
'activity_msg': activity_msg,
'comments': comments,
'message_url': 'http://%s/main.py#message_card_%s' \
% (self.conf.baseurl, message['id'])
})
html = open('%s/lib/emails/message_activity.html' % \
self.conf.basedir).read()
html = Template(html)
html = html.render(posts=posts)
self.email.send_email(#to='*****@*****.**',
to=user.email,
subject='Recent activity',
body='',
html=html)
# purge notify queue
for user_id, comment_id in purge:
# copy queue recors to queue_log
sql = 'insert into notify_queue_log ' \
'(user_id, comment_id, created) ' \
'select user_id, comment_id, created ' \
'from notify_queue ' \
'where user_id = %s and comment_id = %s'
self.db.execute(sql, params=(user_id, comment_id))
# delete queue records
sql = 'delete from notify_queue ' \
'where user_id = %s and comment_id = %s'
self.db.execute(sql, params=(user_id, comment_id))
def _getMessageComments(self, user_id):
'''Return the following message activity Data structure:
{1: # user_id
{'email': '*****@*****.**',
{'messages':
[{id: 806, # message_id
'message_user_id': 1,
'message_text': "I'm very excited about how Stemsible",
'created': <datetime>
'comment_ids: [109, 134]
'comment_texts': ['test comment message',
'another test comment message']
]}
}
}
'''
data = {}
# get sql
user_filter = 'u.id = %s' % user_id if user_id else '1=1'
sql_file = '%s/lib/sql/new_comments.sql' % self.conf.basedir
sql = open(sql_file, 'r').read() % user_filter
# loop thru records, tally on user_id change
for row in self.db.query(sql):
user_id = row['user_id']
user_email = row['user_email']
message_user_id = row['message_user_id']
message_id = row['message_id']
message_text = row['message_text']
comment_ids = row['comment_ids'].split(',')
comment_texts = row['comment_texts'].split('^!^!^')
if user_id not in data:
data[user_id] = {'email': user_email, 'messages': []}
data[user_id]['messages'].append(
{'id': message_id,
'message_user_id': message_user_id,
'message_text': message_text,
'comment_ids': comment_ids,
'comment_texts': comment_texts
})
return data
def sendMessageNotification(self, message_id, user=None):
'''Given a message_id, and a User Object, or None for all
users not including original author, commenters or likers,
send a Message Notification Email to user(s)
with subject line:
"<user.first_name> could use your help answering a question"
'''
try:
message = Message(message_id)
except Exception, e:
raise NotificationsError('Message %s not found: %s' %
(message_id, e))
if user:
users = [user]
else:
# exclude message author, commenters and likers:
exclude = [message.user_id]
exclude.extend([c.user_id for c in message.comments])
exclude.extend([l.user_id for l in message.likes])
filter = ("id not in (%s)" %
', '.join([str(x) for x in set(exclude)]))
users = self.users.getUsers(filter)
print message
# mutiple possible subjects:
SUBJECT1 = '%s could use your help answering a question' % \
message.user.first_name
SUBJECT2 = '%s posted a link that may interest you' % \
message.user.first_name
subject = SUBJECT2
profile_url = 'http://%s/profile.py?u=%s' % \
(self.conf.baseurl, encrypt_int(message.user.id))
mdata = {'notification_message': subject + '.',
'name': message.user.fullname,
'created': format_datetime(message.created),
'text': message.text,
'message_url': 'http://%s/main.py#message_card_%s' \
% (self.conf.baseurl, message.id),
'profile_image': getUserImage(message.user.id),
'profile_url': profile_url,
}
html = open('%s/lib/emails/message_notification.html' % \
self.conf.basedir).read()
html = Template(html)
html = html.render(mdata=mdata)
for user in users:
print 'email: %s' % (user.email)
self.email.send_email(#to='*****@*****.**',
to=user.email,
subject=subject,
body='',
html=html)
