def generate_comment(userid, sequence_id, message='This is a test comment'):
com = Comment()
com.Message = message
com.UserID = userid
com.ParentID = sequence_id
com.Type = 'Sequences'
com.save()
def create_attachment():
data = request.form
image = request.files['file']
name = image.filename
contenttype = image.content_type
image = image.stream.read()
parentid = data['ParentID']
type = data['Type']
comment = Comment(ParentID=parentid,
Type=type,
Message="",
RenderType='attachment',
UserID=g.user.UserID)
comment.save()
print comment.CommentID
attachment = SequenceAttachment(Attachment=image,
ParentID=comment.CommentID,
Type='comments',
FileName=name,
ContentType=contenttype)
attachment.save()
comment.Message = json.dumps({
"url":
"/comment/%s/attachment/%s/" %
(comment.CommentID, attachment.SequenceAttachmentID),
"name":
name
})
comment.save()
if comment.Type == 'Forums':
forum = Forum.query.filter(Forum.ForumID == comment.ParentID).first()
if forum and forum.SFDC_ID:
attachment.create_case_attachment(forum.SFDC_ID)
print comment.CommentID
resp = comment.to_hash()
resp = json.dumps(resp)
return Response(resp, content_type='application/json')
def generate_issue(user,
subject,
subtitle,
message,
num_images,
num_attachments,
color,
sfdc_data=None):
forum = Forum(Subject=subject,
AccountID=user.AccountID,
UserID=user.UserID,
Color=color,
Subtitle=subtitle,
Type='Issue')
forum.save(sfdc_data)
for image_id in xrange(num_images):
img = request.files['image%s' % image_id]
image = img.read()
file_name = str(img.filename)
comment = Comment(ParentID=forum.ForumID,
Type='Forums',
Message="",
RenderType='image',
UserID=user.UserID)
comment.save()
attachment = SequenceAttachment(Attachment=image,
ParentID=comment.CommentID,
Type='comments',
FileName=file_name)
attachment.save()
for image_id in xrange(num_attachments):
img = request.files['attachment%s' % image_id]
image = img.read()
file_name = str(img.filename)
comment = Comment(ParentID=forum.ForumID,
Type='Forums',
Message="",
RenderType='attachment',
UserID=user.UserID)
comment.save()
attachment = SequenceAttachment(Attachment=image,
ParentID=comment.CommentID,
Type='comments',
FileName=file_name)
attachment.save()
comment.Message = json.dumps({
"url":
"/comment/%s/attachment/%s" %
(comment.CommentID, attachment.SequenceAttachmentID),
"name":
file_name
})
comment.save()
print forum.ForumID
team_members = user.account.users
# Make all team members follow the issue
for member in team_members:
if user.UserID != member.UserID and str(
member.UserID) not in SOFIE_AUTO_FOLLOWING_USER_IDS(
) and user.Active is True:
team_follow = Follower(Type="Forums",
ParentID=forum.ForumID,
UserID=member.UserID,
EmailSubscribed=False)
team_follow.save()
# Make the creator of the issue follow the case
follow = Follower(Type="Forums",
ParentID=forum.ForumID,
UserID=user.UserID)
follow.save()
print follow.FollowerID
sofie_users = User.query.filter(
and_(User.UserID.in_(SOFIE_AUTO_FOLLOWING_USER_IDS()),
User.Active == True))
# Make all SOFIE members aware of the issue
for sofie_user in sofie_users:
sofie_userid = sofie_user.UserID
if sofie_userid and user.UserID != sofie_userid:
auto_follow = Follower(Type="Forums",
ParentID=forum.ForumID,
UserID=sofie_userid)
auto_follow.save()
Comment.make_comments(user.UserID, "Forums", forum.ForumID, message)
return forum, follow
