#===================
#
# 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'
