diff options
Diffstat (limited to 'web/webqtl/management/assignUserToDatasetPage.py')
| -rwxr-xr-x | web/webqtl/management/assignUserToDatasetPage.py | 159 |
1 files changed, 0 insertions, 159 deletions
diff --git a/web/webqtl/management/assignUserToDatasetPage.py b/web/webqtl/management/assignUserToDatasetPage.py deleted file mode 100755 index 8e089526..00000000 --- a/web/webqtl/management/assignUserToDatasetPage.py +++ /dev/null @@ -1,159 +0,0 @@ -# Copyright (C) University of Tennessee Health Science Center, Memphis, TN. -# -# This program is free software: you can redistribute it and/or modify it -# under the terms of the GNU Affero General Public License -# as published by the Free Software Foundation, either version 3 of the -# License, or (at your option) any later version. -# -# This program is distributed in the hope that it will be useful, -# but WITHOUT ANY WARRANTY; without even the implied warranty of -# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. -# See the GNU Affero General Public License for more details. -# -# This program is available from Source Forge: at GeneNetwork Project -# (sourceforge.net/projects/genenetwork/). -# -# Contact Drs. Robert W. Williams and Xiaodong Zhou (2010) -# at rwilliams@uthsc.edu and xzhou15@uthsc.edu -# -# -# -# This module is used by GeneNetwork project (www.genenetwork.org) -# -# Created by GeneNetwork Core Team 2010/08/10 -# -# Last updated by GeneNetwork Core Team 2010/10/20 - -import os -import string - -from htmlgen import HTMLgen2 as HT - -from base.templatePage import templatePage -from base import webqtlConfig - -#XZ, 02/06/2009: Xiaodong created this class -class assignUserToDatasetPage(templatePage): - - def __init__(self, fd): - - templatePage.__init__(self, fd) - - if not self.openMysql(): - return - - - ifVerified = fd.formdata.getvalue('ifVerified') - - if ifVerified != 'GN@UTHSC': - heading = "Error page" - detail = ["You are NoT verified as administrator."] - self.error(heading=heading,detail=detail) - return - else: - - ProbeSetFreeze_FullName = fd.formdata.getvalue('ProbeSetFreeze_FullName') - User_name = fd.formdata.getvalue('User_name') - - if ProbeSetFreeze_FullName and User_name: - ProbeSetFreeze_FullName = string.strip(ProbeSetFreeze_FullName) - User_name = string.strip(User_name) - - #XZ, check if the input dataset name exists. - self.cursor.execute( 'select count(FullName) from ProbeSetFreeze where FullName="%s"' % ProbeSetFreeze_FullName ) - result = self.cursor.fetchone() - if result: - row_count = result[0] - if row_count: - pass - else: - heading = "Error page" - detail = ["The dataset name %s does NOT exist in database." % ProbeSetFreeze_FullName] - self.error(heading=heading,detail=detail) - return - else: - heading = "Error page" - detail = ["No sql result returned when check dataset name."] - self.error(heading=heading,detail=detail) - return - - #XZ, check if the input user name exists. - self.cursor.execute( 'select count(name) from User where name="%s"' % User_name ) - result = self.cursor.fetchone() - if result: - row_count = result[0] - if row_count: - pass - else: - heading = "Error page" - detail = ["The user name %s does NOT exist in database." % User_name] - self.error(heading=heading,detail=detail) - return - else: - heading = "Error page" - detail = ["No sql result returned when check user name."] - self.error(heading=heading,detail=detail) - return - - self.cursor.execute( 'select AuthorisedUsers from ProbeSetFreeze where FullName="%s"' % ProbeSetFreeze_FullName ) - result = self.cursor.fetchone() # The FullName is unique. - if result: - AuthorisedUsers = result[0] - if not AuthorisedUsers: - self.cursor.execute('update ProbeSetFreeze set AuthorisedUsers="%s" where FullName="%s"' %(User_name, ProbeSetFreeze_FullName) ) - else: - AuthorisedUsersList=AuthorisedUsers.split(',') - if not AuthorisedUsersList.__contains__(User_name): - AuthorisedUsers = AuthorisedUsers + ',%s' % User_name - self.cursor.execute('update ProbeSetFreeze set AuthorisedUsers="%s" where FullName="%s"' %(AuthorisedUsers, ProbeSetFreeze_FullName) ) - else: - heading = "Error page" - detail = ["No sql result returned when query AuthorisedUsers."] - self.error(heading=heading,detail=detail) - return - - - TD_LR = HT.TD(height=200,width="100%",bgColor='#eeeeee') - - dataHeading = HT.Paragraph('Confidential Dataset Table', Class="title") - - dataTable = HT.TableLite(border=1, cellpadding=0, cellspacing=0, Class="collap", width="100%") - - dataHeaderRow = HT.TR() - dataHeaderRow.append(HT.TD("Dataset Id", Class='fs14 fwb ffl b1 cw cbrb')) - dataHeaderRow.append(HT.TD("Dataset Full Name", Class='fs14 fwb ffl b1 cw cbrb')) - dataHeaderRow.append(HT.TD("Authorised User", Class='fs14 fwb ffl b1 cw cbrb')) - dataTable.append(dataHeaderRow) - - self.cursor.execute('select Id, FullName, AuthorisedUsers from ProbeSetFreeze where confidentiality=1 order by FullName,Id') - - result = self.cursor.fetchall() - - dataInfo = HT.Blockquote( 'There are %d confidential datasets.' % len(result) ) - - - for one_row in result: - ProbeSetFreeze_Id, ProbeSetFreeze_FullName, ProbeSetFreeze_AuthorisedUsers = one_row - dataRow = HT.TR() - dataRow.append(HT.TD("%s" % ProbeSetFreeze_Id, Class='fs12 fwn ffl b1 c222')) - dataRow.append(HT.TD("%s" % ProbeSetFreeze_FullName, Class='fs12 fwn ffl b1 c222')) - dataRow.append(HT.TD("%s" % ProbeSetFreeze_AuthorisedUsers, Class='fs12 fwn ffl b1 c222')) - dataTable.append(dataRow) - - assignUserForm = HT.Form(cgi= os.path.join(webqtlConfig.CGIDIR, webqtlConfig.SCRIPTFILE), enctype='multipart/form-data', name='assignUserForm', submit=HT.Input(type='hidden')) - assignUserForm.append( - HT.Blockquote( - HT.Font('Dataset Full Name ', color='red'), - HT.Input(type='text' ,name='ProbeSetFreeze_FullName',value='', size=50,maxlength=200), - HT.Font(' User name ', color='red'), - HT.Input(type='text' ,name='User_name',value='', size=20,maxlength=20), - HT.Input(type='Submit', value='Submit', Class="button")), - HT.Input(type='hidden',name='FormID',value='assignUserToDataset'), - HT.Input(type='hidden',name='ifVerified',value='GN@UTHSC') - ) - - TD_LR.append(dataHeading, dataInfo, assignUserForm, dataTable, assignUserForm) - - self.dict['body'] = str(TD_LR) - self.dict['title'] = 'Confidential datasets' - |