#=================== # # add GroupData privilege column # #=================== if leginondb.tableExists('GroupData'): if not leginondb.columnExists('GroupData','REF|projectdata|privileges|privilege'): leginondb.addColumn('GroupData', 'REF|projectdata|privileges|privilege', leginondb.int) #=================== # # set administrators group privileges to highest privilege for groups # #=================== q = projectdata.privileges(groups=4) adminpriv = q.query(results=1) adminprivid = adminpriv[0].dbid q = leginondata.UserData(username='******') adminuser = q.query(results=1) adminuser = adminuser[0] # some old databases have no group assigned to users if adminuser['group'] is not None: admingroupid = adminuser['group'].dbid else: qgroup = leginondata.GroupData() admingroup = qgroup.query() if len(admingroup) > 0: admingroupid = admingroup[-1].dbid else: qgroup['name'] = 'administrators'
def importPrivileges(self): print "Importing privileges...." q = projectdata.privileges() results = self.research(q) self.publish(results)
# add GroupData privilege column # #=================== if leginondb.tableExists('GroupData'): if not leginondb.columnExists( 'GroupData', 'REF|projectdata|privileges|privilege'): leginondb.addColumn('GroupData', 'REF|projectdata|privileges|privilege', leginondb.int) #=================== # # set administrators group privileges to highest privilege for groups # #=================== q = projectdata.privileges(groups=4) adminpriv = q.query(results=1) adminprivid = adminpriv[0].dbid q = leginondata.UserData(username='******') adminuser = q.query(results=1) adminuser = adminuser[0] # some old databases have no group assigned to users if adminuser['group'] is not None: admingroupid = adminuser['group'].dbid else: qgroup = leginondata.GroupData() admingroup = qgroup.query() if len(admingroup) > 0: admingroupid = admingroup[-1].dbid else: qgroup['name'] = 'administrators'