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)