def populateDefaultUsers():
userService = support.entityFor(IUserService)
assert isinstance(userService, IUserService)
userRbacService = support.entityFor(IUserRbacService)
assert isinstance(userRbacService, IUserRbacService)
users = userService.getAll(limit=1, q=QUser(name='admin'))
if not users:
user = User()
user.FirstName = 'Janet'
user.LastName = 'Editor'
user.EMail = '*****@*****.**'
user.Name = 'admin'
user.Password = hashlib.sha512(b'a').hexdigest()
user.Id = userService.insert(user)
else: user = next(iter(users))
userRbacService.assignRole(user.Id, blogRoleAdministratorId())
for name in (('Andrew', 'Reporter'), ('Christine', 'Journalist')):
loginName = name[1].lower()
users = userService.getAll(limit=1, q=QUser(name=loginName))
if not users:
user = User()
user.FirstName = name[0]
user.LastName = name[1]
user.EMail = '*****@*****.**' % name
user.Name = loginName
user.Password = hashlib.sha512(b'a').hexdigest()
user.Id = userService.insert(user)
else: user = next(iter(users))
userRbacService.assignRole(user.Id, blogRoleCollaboratorId())
def populateDefaultUsers():
userService = support.entityFor(IUserService)
assert isinstance(userService, IUserService)
userRbacService = support.entityFor(IUserRbacService)
assert isinstance(userRbacService, IUserRbacService)
users = userService.getAll(limit=1, q=QUser(name='Janet'))
if not users:
user = User()
user.FirstName = 'Janet'
user.LastName = 'Editor'
user.EMail = '*****@*****.**'
user.Name = 'admin'
user.Password = hashlib.sha512(b'a').hexdigest()
user.Id = userService.insert(user)
else:
user = next(iter(users))
userRbacService.assignRole(user.Id, blogRoleAdministratorId())
for name in (('Andrew', 'Reporter'), ('Christine', 'Journalist')):
users = userService.getAll(limit=1, q=QUser(name=name[0]))
if not users:
user = User()
user.FirstName = name[0]
user.LastName = name[1]
user.EMail = '*****@*****.**' % name
user.Name = name[1].lower()
user.Password = hashlib.sha512(b'a').hexdigest()
user.Id = userService.insert(user)
else:
user = next(iter(users))
userRbacService.assignRole(user.Id, blogRoleCollaboratorId())
def getUsersIds():
userService = entityFor(IUserService)
assert isinstance(userService, IUserService)
if not _cache_users:
users = _cache_users
for name in USERS:
usrs = userService.getAll(adminId=None, q=QUser(name=name))
if usrs: users[name] = next(iter(usrs)).Id
else:
usr = User()
usr.Name = name
usr.Password = hashlib.sha512(b'a').hexdigest()
usr.FirstName, usr.LastName, usr.EMail = USERS[name]
users[name] = userService.insert(adminId=None, user=usr)
return _cache_users
def getUsersIds():
userService = entityFor(IUserService)
assert isinstance(userService, IUserService)
if not _cache_users:
users = _cache_users
for name in USERS:
usrs = userService.getAll(q=QUser(name=name))
if usrs: users[name] = next(iter(usrs)).Id
else:
usr = User()
usr.Name = name
usr.Password = hashlib.sha512(b'a').hexdigest()
usr.FirstName, usr.LastName, usr.EMail = USERS[name]
users[name] = userService.insert(usr)
return _cache_users
def populateRootUser():
userService = support.entityFor(IUserService)
assert isinstance(userService, IUserService)
userRbacService = support.entityFor(IUserRbacService)
assert isinstance(userRbacService, IUserRbacService)
users = userService.getAll(limit=1, q=QUser(name='Janet'))
if not users:
user = User()
user.Name = 'root'
user.Password = hashlib.sha512(b'root').hexdigest()
user.Id = userService.insert(user)
else: user = users[0]
userRbacService.assignRole(user.Id, rootRoleId())
def populateRootUser():
userService = support.entityFor(IUserService)
assert isinstance(userService, IUserService)
userRbacService = support.entityFor(IUserRbacService)
assert isinstance(userRbacService, IUserRbacService)
roleService = support.entityFor(IRoleService)
assert isinstance(roleService, IRoleService)
users = userService.getAll(limit=1, q=QUser(name='root'))
if not users:
user = User()
user.Name = 'root'
user.Password = hashlib.sha512(b'root').hexdigest()
user.Id = userService.insert(user)
else:
user = users[0]
userRbacService.assignRole(user.Id, roleService.getByName(NAME_ROOT).Id)
def addComment(self, blogId, comment):
'''
@see: IBlogCommentService.addComment
'''
# checking if the blog exists
# checking whether comments are allowed shall be done in gateway
if not self.session().query(exists().where(BlogMapped.Id == blogId)).scalar():
raise InputError(Ref(_('Specified blog does not exist'),))
userName = comment.UserName
commentText = comment.CommentText
commentSource = comment.CommentSource if comment.CommentSource else self.source_name_default
# checking the necessary info: user name and comment text
if not userName:
raise InputError(Ref(_('No value for the mandatory UserName'),))
if not commentText:
raise InputError(Ref(_('No value for the mandatory CommentText'),))
# take (or make) the user (for user name) part of creator and collaborator
userTypeId, = self.session().query(UserTypeMapped.id).filter(UserTypeMapped.Key == self.user_type_key).one()
try:
sql = self.session().query(UserMapped.userId, UserMapped.Active)
sql = sql.filter(UserMapped.typeId == userTypeId)
sql = sql.filter(UserMapped.FirstName == userName)
userId, isActive = sql.one()
if not isActive:
raise InputError(Ref(_('The commentator user was inactivated'),))
except:
user = User()
user.FirstName = userName
user.LastName = self.user_last_name
user.Name = self._freeCommentUserName()
user.Password = binascii.b2a_hex(os.urandom(32)).decode()
user.Type = self.user_type_key
userId = self.userService.insert(user)
# make the source (for inlet type) part of collaborator
try:
sql = self.session().query(SourceMapped.Id).join(SourceTypeMapped)
sql = sql.filter(SourceTypeMapped.Key == self.source_type_key).filter(SourceMapped.Name == commentSource)
sourceId, = sql.one()
except NoResultFound:
source = Source()
source.Type = self.source_type_key
source.Name = commentSource
source.URI = ''
source.IsModifiable = True
sourceId = self.sourceService.insert(source)
# make the collaborator
sql = self.session().query(CollaboratorMapped.Id)
sql = sql.filter(CollaboratorMapped.Source == sourceId)
sql = sql.filter(CollaboratorMapped.User == userId)
try:
collabId, = sql.one()
except NoResultFound:
collab = Collaborator()
collab.Source = sourceId
collab.User = userId
collabId = self.collaboratorService.insert(collab)
# create post request
post = Post()
post.Type = self.post_type_key
post.Creator = userId
post.Author = collabId
post.Content = commentText
post.CreatedOn = datetime.now()
# insert the blog post
postId = self.blogPostService.insert(blogId, post)
return postId
def pushMessage(self, typeKey, phoneNumber=None, messageText=None, timeStamp=None):
'''
@see: IInletService.pushMessage
'''
# checking the necessary info: phone number and message text
if (phoneNumber is None) or (phoneNumber == ''):
raise InputError(Ref(_('No value for the mandatory phoneNumber parameter'),))
if (messageText is None) or (messageText == ''):
raise InputError(Ref(_('No value for the mandatory messageText parameter'),))
# take (or make) the user (for phone number) part of creator and collaborator
try:
userId, = self.session().query(PersonMapped.Id).filter(PersonMapped.PhoneNumber == phoneNumber).one()
except:
user = User()
user.PhoneNumber = phoneNumber
user.Name = self._freeSMSUserName()
user.Password = binascii.b2a_hex(os.urandom(32)).decode()
user.Type = self.user_type_key
userId = self.userService.insert(user)
# make the source (for inlet type) part of collaborator
try:
sql = self.session().query(SourceMapped.Id).join(SourceTypeMapped)
sql = sql.filter(SourceTypeMapped.Key == self.sms_source_type_key).filter(SourceMapped.Name == typeKey)
sourceId, = sql.one()
except NoResultFound:
source = Source()
source.Type = self.sms_source_type_key
source.Name = typeKey
source.URI = ''
source.IsModifiable = True
sourceId = self.sourceService.insert(source)
# make the collaborator
sql = self.session().query(CollaboratorMapped.Id)
sql = sql.filter(CollaboratorMapped.Source == sourceId)
sql = sql.filter(CollaboratorMapped.User == userId)
try:
collabId, = sql.one()
except NoResultFound:
collab = Collaborator()
collab.Source = sourceId
collab.User = userId
collabId = self.collaboratorService.insert(collab)
# take / make time stamp
if timeStamp:
try:
timeStamp = datetime.strptime(timeStamp, '%Y-%m-%d %H:%M:%S.%f')
except:
timeStamp = None
if not timeStamp:
timeStamp = datetime.now()
# create post request
post = Post()
post.Type = self.sms_post_type_key
post.Creator = userId
post.Author = collabId
post.Content = messageText
post.CreatedOn = timeStamp
# insert the post
postId = self.postService.insert(post)
return (self.postService.getById(postId),)
def pushMessage(self,
typeKey,
phoneNumber=None,
messageText=None,
timeStamp=None):
'''
@see: IInletService.pushMessage
'''
# checking the necessary info: phone number and message text
if (phoneNumber is None) or (phoneNumber == ''):
raise InputError(
Ref(_('No value for the mandatory phoneNumber parameter'), ))
if (messageText is None) or (messageText == ''):
raise InputError(
Ref(_('No value for the mandatory messageText parameter'), ))
# take (or make) the user (for phone number) part of creator and collaborator
try:
userId, = self.session().query(PersonMapped.Id).filter(
PersonMapped.PhoneNumber == phoneNumber).one()
except:
user = User()
user.PhoneNumber = phoneNumber
user.Name = self._freeSMSUserName()
user.Password = binascii.b2a_hex(os.urandom(32)).decode()
user.Type = self.user_type_key
userId = self.userService.insert(user)
# make the source (for inlet type) part of collaborator
try:
sql = self.session().query(SourceMapped.Id).join(SourceTypeMapped)
sql = sql.filter(
SourceTypeMapped.Key == self.sms_source_type_key).filter(
SourceMapped.Name == typeKey)
sourceId, = sql.one()
except NoResultFound:
source = Source()
source.Type = self.sms_source_type_key
source.Name = typeKey
source.URI = ''
source.IsModifiable = True
sourceId = self.sourceService.insert(source)
# make the collaborator
sql = self.session().query(CollaboratorMapped.Id)
sql = sql.filter(CollaboratorMapped.Source == sourceId)
sql = sql.filter(CollaboratorMapped.User == userId)
try:
collabId, = sql.one()
except NoResultFound:
collab = Collaborator()
collab.Source = sourceId
collab.User = userId
collabId = self.collaboratorService.insert(collab)
# take / make time stamp
if timeStamp:
try:
timeStamp = datetime.strptime(timeStamp,
'%Y-%m-%d %H:%M:%S.%f')
except:
timeStamp = None
if not timeStamp:
timeStamp = datetime.now()
# create post request
post = Post()
post.Type = self.sms_post_type_key
post.Creator = userId
post.Author = collabId
post.Content = messageText
post.CreatedOn = timeStamp
# insert the post
postId = self.postService.insert(post)
return (self.postService.getById(postId), )
def addComment(self, blogId, comment):
'''
@see: IBlogCommentService.addComment
'''
# checking if the blog exists
# checking whether comments are allowed shall be done in gateway
if not self.session().query(
exists().where(BlogMapped.Id == blogId)).scalar():
raise InputError(Ref(_('Specified blog does not exist'), ))
userName = comment.UserName
commentText = comment.CommentText
commentSource = comment.CommentSource if comment.CommentSource else self.source_name_default
# checking the necessary info: user name and comment text
if not userName:
raise InputError(Ref(_('No value for the mandatory UserName'), ))
if not commentText:
raise InputError(Ref(
_('No value for the mandatory CommentText'), ))
# take (or make) the user (for user name) part of creator and collaborator
userTypeId, = self.session().query(UserTypeMapped.id).filter(
UserTypeMapped.Key == self.user_type_key).one()
try:
sql = self.session().query(UserMapped.userId, UserMapped.Active)
sql = sql.filter(UserMapped.typeId == userTypeId)
sql = sql.filter(UserMapped.FirstName == userName)
userId, isActive = sql.one()
if not isActive:
raise InputError(
Ref(_('The commentator user was inactivated'), ))
except:
user = User()
user.FirstName = userName
user.LastName = self.user_last_name
user.Name = self._freeCommentUserName()
user.Password = binascii.b2a_hex(os.urandom(32)).decode()
user.Type = self.user_type_key
userId = self.userService.insert(user)
# make the source (for inlet type) part of collaborator
try:
sql = self.session().query(SourceMapped.Id).join(SourceTypeMapped)
sql = sql.filter(
SourceTypeMapped.Key == self.source_type_key).filter(
SourceMapped.Name == commentSource)
sourceId, = sql.one()
except NoResultFound:
source = Source()
source.Type = self.source_type_key
source.Name = commentSource
source.URI = ''
source.IsModifiable = True
sourceId = self.sourceService.insert(source)
# make the collaborator
sql = self.session().query(CollaboratorMapped.Id)
sql = sql.filter(CollaboratorMapped.Source == sourceId)
sql = sql.filter(CollaboratorMapped.User == userId)
try:
collabId, = sql.one()
except NoResultFound:
collab = Collaborator()
collab.Source = sourceId
collab.User = userId
collabId = self.collaboratorService.insert(collab)
# create post request
post = Post()
post.Type = self.post_type_key
post.Creator = userId
post.Author = collabId
post.Content = commentText
post.CreatedOn = datetime.now()
# insert the blog post
postId = self.blogPostService.insert(blogId, post)
return postId
