def group_delete(self, widget): group = self.combo_grp.get_active_text() if group: gid = self.get_group_id(group) members = self.get_group_members(group) members_count = len(members) if members_count: msg = '''Group has %d member(s).\nAre you sure you want to delete group %s?\nAll users in this group will lose it's group information.''' %( members_count, group) else: msg = '''Are you sure you want to delete group %s?''' %(group) ok = gtkutils.confirm(title='Please confirm', message=msg, parent=self.group_edit_dialog, buttons=gtk.BUTTONS_YES_NO) if ok == gtk.RESPONSE_YES: q1 = ''' update ms_users set gid=0 where gid=? ''' a1 = (gid,) q2 = ''' delete from ms_groups where id=? ''' a2 = (gid,) q = ((q1, a1), (q2, a2)) r = self.db.query_transact(q, self.app.database) if r[0] == 0: msg = 'Group %s has been deleted successfully' %(group) dialog = gtkutils.info else: msg = r[1] dialog = gtkutils.error dialog(title='Result', message=msg, parent=self.group_edit_dialog) # self.group_populate_groups(combo=self.combo_grp) self.combo_grp.popup()
def user_delete(self, widget): selection = self.trview_main.get_selection() model, selected = selection.get_selected_rows() iters = [model.get_iter(path) for path in selected] if iters: ids = [int(model.get_value(iter, 0)) for iter in iters] names = [model.get_value(iter, 1) for iter in iters] msg3 = '\n' if self.myuid in ids: try: ids.remove(self.myuid) names.remove(self.myname) except: pass msg3 += '\nWarning: You can not delete yourself (removed from list).' if 1 in ids: try: ids.remove(1) uid1 = self.get_group(id=1) names.remove(uid1[0][1]) except: pass msg3 += '\nWarning: You can not delete user with uid 1.' count = len(ids) info_delete_str = '\n'.join(names) # if count > 0: msg = 'Are you sure you want to ' msg += 'delete %d names(s)?' % (count) msg2 = 'Selected user(s):\n' + info_delete_str msg2 += '\n\nAll corresponding data will also be deleted.' msg2 += '\nThis action can not be undone.' msg2 += msg3 ok = gtkutils.confirm(title='Please confirm', message=msg, message2=msg2, parent=self.parent, buttons=gtk.BUTTONS_YES_NO) #if yes, if ok == gtk.RESPONSE_YES: q = [] for id in ids: query = 'delete from ms_users where id=?' args = (id, ) temp = (query, args) q.append(temp) r = self.db.query_transact(q, self.app.database) if r[0] != 0: msg = r[1] dialog = gtkutils.error dialog(title='Error', message=msg, parent=self.parent) # self.draw_users()
def user_delete(self, widget): selection = self.trview_main.get_selection() model, selected = selection.get_selected_rows() iters = [model.get_iter(path) for path in selected] if iters: ids = [int(model.get_value(iter, 0)) for iter in iters] names = [model.get_value(iter, 1) for iter in iters] msg3 = '\n' if self.myuid in ids: try: ids.remove(self.myuid) names.remove(self.myname) except: pass msg3 += '\nWarning: You can not delete yourself (removed from list).' if 1 in ids: try: ids.remove(1) uid1 = self.get_group(id=1) names.remove(uid1[0][1]) except: pass msg3 += '\nWarning: You can not delete user with uid 1.' count = len(ids) info_delete_str = '\n'.join(names) # if count > 0: msg = 'Are you sure you want to ' msg += 'delete %d names(s)?' %(count) msg2 = 'Selected user(s):\n' + info_delete_str msg2 += '\n\nAll corresponding data will also be deleted.' msg2 += '\nThis action can not be undone.' msg2 += msg3 ok = gtkutils.confirm(title='Please confirm', message=msg, message2=msg2, parent=self.parent, buttons=gtk.BUTTONS_YES_NO) #if yes, if ok == gtk.RESPONSE_YES: q = [] for id in ids: query = 'delete from ms_users where id=?' args = (id,) temp = (query, args) q.append(temp) r = self.db.query_transact(q, self.app.database) if r[0] != 0: msg = r[1] dialog = gtkutils.error dialog(title='Error', message=msg, parent=self.parent) # self.draw_users()
def group_delete(self, widget): group = self.combo_grp.get_active_text() if group: gid = self.get_group_id(group) members = self.get_group_members(group) members_count = len(members) if members_count: msg = '''Group has %d member(s).\nAre you sure you want to delete group %s?\nAll users in this group will lose it's group information.''' % ( members_count, group) else: msg = '''Are you sure you want to delete group %s?''' % (group) ok = gtkutils.confirm(title='Please confirm', message=msg, parent=self.group_edit_dialog, buttons=gtk.BUTTONS_YES_NO) if ok == gtk.RESPONSE_YES: q1 = ''' update ms_users set gid=0 where gid=? ''' a1 = (gid, ) q2 = ''' delete from ms_groups where id=? ''' a2 = (gid, ) q = ((q1, a1), (q2, a2)) r = self.db.query_transact(q, self.app.database) if r[0] == 0: msg = 'Group %s has been deleted successfully' % (group) dialog = gtkutils.info else: msg = r[1] dialog = gtkutils.error dialog(title='Result', message=msg, parent=self.group_edit_dialog) # self.group_populate_groups(combo=self.combo_grp) self.combo_grp.popup()