def delete(self,id):
name = db('select name from dz_groups where groupid=%s', id)[0]['NAME']
result = db('delete from dz_members where groupid=%s',id)
result = db('delete from dz_groups where groupid=%s',id)
result = db('delete from dz_subgroups where groupid=%s',id)
result = db('delete from dz_subgroups where subgroupid=%s',id)
audit('delete group', name, '')
def insert(cls,**keywords):
group_fields.update(**keywords)
values = group_fields.evaluate()
values['TYPE'] = 'U'
values['NAME'] = values['NAME'].lower()
table = db.table('dz_groups','GROUPID')
id = table.insert(values)
audit('create group', values['NAME'], '')
return id
def insert(cls, form):
values = form.evaluate()
username = values['USERNAME'].lower()
password = gen_password()
values['FIRSTNAME'] = values['FIRST_NAME']
values['LASTNAME'] = values['LAST_NAME']
values['LOGINID'] = username
values['PASSWORD'] = ''
values['DTUPD'] = values['DTADD'] = datetime.datetime.now()
values['STATUS'] = 'A'
users = db.table('dz_users', 'USERID')
id = users.insert(values)
db('delete from dz_members where userid=%s',
id) # make sure new users have no memberships
add_user(values['LOGINID'], 'users')
new_user = ZoomUser(username)
new_user.set_password(password)
msg = '<a href="/users/%s">%s</a> added new user <a href="/users/%s">%s</a>'
logger.activity(
'users',
msg % (user.id, user.username, new_user.id, new_user.username))
audit('created user account', new_user.username)
if values['SEND_INVITATION'] == True:
recipients = [values['EMAIL']]
tpl = load('welcome.md')
t = dict(
first_name=values['FIRST_NAME'],
username=username,
password=password,
site_name=site_name(),
site_url=site_url(),
admin_email='*****@*****.**',
owner_name=owner_name(),
)
body = markdown(viewfill(tpl, t.get))
subject = 'Welcome - ' + site_name()
send(recipients, subject, body)
message('invitation sent')
def remove_supergroup(self,supergroup_id):
groups = dict((i.groupid,i.name) for i in db('select groupid, name from dz_groups'))
db('delete from dz_subgroups where groupid=%s and subgroupid=%s',supergroup_id,self.id)
audit('remove membership',self.name,groups[int(supergroup_id)])
def add_supergroup(self,name):
groups = dict((i.name,i.groupid) for i in db('select name,groupid from dz_groups'))
if name in groups:
id = groups[name]
db('insert into dz_subgroups (groupid,subgroupid) values (%s,%s)',id,self.id)
audit('add membership',self.name,name)
def remove_member(self,user_id):
users = dict((i.userid,i.loginid) for i in db('select userid,loginid from dz_users'))
db('delete from dz_members where userid=%s and groupid=%s',user_id,self.id)
audit('remove user',users[int(user_id)],self.name)
def add_member(self,name):
users = dict((i.loginid,i.userid) for i in db('select userid,loginid from dz_users'))
if name in users:
id = users[name]
db('insert into dz_members (userid,groupid) values (%s,%s)',id,self.id)
audit('add user',name,self.name)
def deactivate(self):
audit('deactivate user account', self.username, '')
return deactivate_user(self.username)
def activate(self):
logger.log('I',
'user activated by %s' % user.username,
username=self.username)
audit('activate user account', self.username, '')
return activate_user(self.username)
def delete(self):
msg = '<a href="/users/%s">%s</a> deleted user %s'
logger.activity('users', msg % (user.id, user.username, self.username))
audit('delete user account', self.username, '')
return Users.delete(self.id)
