def selectUser(self,configuration): conn = configurationDB.connect(self) cur = conn.cursor() select = "SELECT * FROM USER WHERE Uemail = '"+configuration['Uemail']+"'" cur.execute(select) print('User elected\n') cur.close() conn.close()
def removeServer(self,configuration): conn = configurationDB.connect(self) cur = conn.cursor() remove = "DELETE FROM SERVER WHERE WHERE SipAddress= '"+configuration['SipAddress']+"'" try: cur.execute(remove) conn.commit() except: conn.rollback() print('Server deleted\n')
def resetPassword(self,email,password): conn = configurationDB.connect(self) cur = conn.cursor() # update = "UPDATE USER SET Upassword = '******' WHERE Uemail = '"+email+"'" cur.execute("UPDATE USER SET Upassword = %s WHERE Uemail = $s",(password, email)) cur.close() conn.close() return self.__password
def removeVirtualMachine(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() remove = "DELETE FROM VIRTUAL_MACHINE WHERE WHERE VMname= '" + configuration[ 'VMname'] + "'" try: cur.execute(remove) conn.commit() except: conn.rollback() print('Virtual Machine deleted\n')
def removeWShistory(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() remove = "DELETE FROM WORKSHOP_HISTORY WHERE WHwuName = '" + configuration[ 'WHwuName'] + "', WHruName = '" + configuration['WHruname'] + "'" try: cur.execute(remove) conn.commit() except: conn.rollback() print('Workshop History deleted\n')
def removeWorkshop(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() remove = "DELETE FROM WORKSHOP WHERE WHERE WGname= '" + configuration[ 'WGname'] + "', WUname = '" + configuration['WUname'] + "'" try: cur.execute(remove) conn.commit() except: conn.rollback() print('Worshop deleted\n')
def removeRefeMat(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() remove = "DELETE FROM REFERENCE_MATERIAL WHERE RMfileName = '" + configuration[ 'RMfileName'] + "', RMwname = '" + configuration['RMwname'] + "'" try: cur.execute(remove) conn.commit() except: conn.rollback() print('Reference Material deleted\n')
def selectClone(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() select = "SELECT * FROM CLONE WHERE CvmName = '" + configuration[ 'CvmName'] + "'" try: cur.execute(select) except: conn.rolllback() print('Clone selected\n') cur.close() conn.close()
def insertNetAdapt(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() insert = "INSERT INTO NETWORK_ADAPTER (NAstring,NAvmName) VALUES ('" + configuration[ 'NAstring'] + "','" + configuration['NAstring'] + "')" try: cur.execute(insert) conn.commit() print('Add Network Adapter\n') except: conn.rollback cur.close() conn.close()
def insertUser(self,configuration): conn = configurationDB.connect(self) cur = conn.cursor() insert = "INSERT INTO USER (Uemail, Ufname, Ulname, Upassword) VALUES ('" + configuration["Uemail"] + "','" + configuration["Ufname"] + "','" + configuration["Ulname"] +"','" + configuration["Upassword"] + "')" try: cur.execute(insert) conn.commit() except: conn.rollback() print('Add a New User\n') cur.close() conn.close()
def insertServer(self,configuration): conn = configurationDB.connect(self) cur = conn.cursor() insert = "INSERT INTO SERVER (SipAddress,Vmvrdp,Spassword,Sstatus) VALUES ('" + configuration['SipAddress'] + "','" + configuration['Susername'] + "','" + configuration['Spassword'] + "','" + configuration['Sstatus'] + "')" try: cur.execute(insert) conn.commit() except: conn.rollback() print('Add a New Server\n') cur.close() conn.close()
def selectServer(self,configuration): conn = configurationDB.connect(self) cur = conn.cursor() select = "SELECT * FROM SERVER WHERE SipAddress = '" + configuration['SipAddress']+"'" try: cur.execute(select) conn.commit() except: conn.rollback() print('Server selected\n') cur.close() conn.close()
def updateServer(self,configuration): conn = configurationDB.connect(self) cur = conn.cursor() update = "UPDATE SERVER SET SipAddress = %s , Susername = %s ,Spassword = %s ,Sstatus= %s WHERE SipAddress = %s" try: cur.execute(update,(configuration['SipAddress'], configuration['Susername'], configuration['Spassword'],configuration['Sstatus'], configuration['SipAddress'])) conn.commit() except: conn.rollback() print('Server Updated\n') cur.close() conn.close()
def insertRefeMat(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() insert = "INSERT INTO REFERENCE_MATERIAL (RMfileName,RMwname) VALUES ('" + configuration[ 'RMfileName'] + "','" + configuration['RMwname'] + "')" try: cur.execute(insert) conn.commit() except: conn.rollback print('Add a Reference Material\n') cur.close() conn.close()
def insertWShistory(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() insert = "INSERT INTO WORKSHOP_HISTORY (WHwuName,WHruName) VALUES ('" + configuration[ 'WHwuName'] + "','" + configuration['WHruname'] + "')" try: cur.execute(insert) conn.commit() print('Add Workshop Unit\n') except: conn.rollback cur.close() conn.close()
def updateUser(self,configuration): conn = configurationDB.connect(self) cur = conn.cursor() try: cur.execute("UPDATE USER SET Upassword = %s WHERE Uemail = $s",(configuration['Upassword'], self.__email)) conn.commit() except: conn.rollback() print('User Updated\n') cur.close() conn.close()
def selectWorkshop(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() select = "SELECT * FROM WORKSHOP WHERE WGname = '" + configuration[ 'WGname'] + "', WUname = '" + configuration['WUname'] try: cur.execute(select) conn.commit() except: conn.rollback() print('Workshop selected\n') cur.close() conn.close()
def selectVirtualMachine(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() select = "SELECT * FROM VIRTUAL_MACHINE WHERE VMname = '" + configuration[ 'VMname'] + "'" try: cur.execute(select) conn.commit() except: conn.rollback() print('Virtual Machine selected\n') cur.close() conn.close()
def insertClone(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() insert = "INSERT INTO CLONE (CvmName, CnumOfClones, CVRDPSeed) VALUES ('" + configuration[ "CvmName"] + "','" + configuration[ "CnumOfClones"] + "','" + configuration["CVRDPSeed"] + "')" try: cur.execute(insert) conn.commit() except: conn.rollback() print('Add a New Clone\n') cur.close() conn.close()
def insertVirtualMachine(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() insert = "INSERT INTO VIRTUAL_MACHINE (VMname,Vmvrdp,VMsnapshot,VMhost) VALUES ('" + configuration[ 'VMname'] + "','" + configuration['VMvrdp'] + "','" + configuration[ 'VMsnapshot'] + "','" + configuration['VMhost'] + "')" try: cur.execute(insert) conn.commit() except: conn.rollback() print('Add a New Virtual Machine\n') cur.close() conn.close()
def printAllClone(self): conn = configurationDB.connect(self) cur = conn.cursor() select = "SELECT * FROM ClONE " try: cur.execute(select) conn.commit() except: conn.rollback() results = cur.fetchall() for row in results: for i in range(0, len(row)): print("%s" % row[i]) print("List all CLONES\n")
def updateNetAdapt(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() update = "UPDATE NETORK_ADAPTER SET NAstring= $s , NAvmName= $s WHERE NAString= $s, NAvmName= $s " try: cur.execute(update, (configuration['NAstring'], configuration['NAvmName'], configuration['NAstring'], configuration['NAvmName'])) conn.commit() except: conn.rollback print('Network AdapterS Updated\n') cur.close() conn.close()
def updateVirtualMachine(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() update = "UPDATE VIRTUAL_MACHINE SET VMname = %s , VMvrdp = %s ,VMsnapshot = %s ,VMhost= %s WHERE VMname = %s" try: cur.execute(update, (configuration['VMname'], configuration['VMvrdp'], configuration['VMsnapshot'], configuration['VMhost'], configuration['VMname'])) conn.commit() except: conn.rollback() print('Virtual Machine Updated\n') cur.close() conn.close()
def updateRefeMat(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() update = "UPDATE REFERENCE_MATERIAL SET RMfileName = $s , RMwname = $s WHERE RMfileName = $s, RMwname = $s " try: cur.execute( update, (configuration['RMfileName'], configuration['RMwname'], configuration['RMfileName'], configuration['RMwname'])) conn.commit() except: conn.rollback print('Reference Material Updated\n') cur.close() conn.close()
def updateWShistory(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() update = "UPDATE WORKSHOP_HISTORY SET WHwuName = $s , WHruName = $s WHERE WHwuName = $s, WHruName = $s " try: cur.execute( update, (configuration['RMfileName'], configuration['RMwname'], configuration['RMfileName'], configuration['RMwname'])) conn.commit() except: conn.rollback print('Workshop History Updated\n') cur.close() conn.close()
def selectRefeMaterial(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() select = "SELECT * FROM REFERENCE_MATERIAL WHERE RMfileName = '" + configuration[ 'RMfileName'] + "', RMwname = '" + configuration['RMwname'] + "'" try: cur.execute(select) conn.commit() except: conn.rollback() for row in cur: print() print(row) print('Reference Material\n') cur.close() conn.close()
def selectRefeWShistory(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() select = "SELECT * FROM WORKSHOP_HISTORY WHERE WHwuName = '" + configuration[ 'WHwuName'] + "', WHruName = '" + configuration['WHruname'] + "'" try: cur.execute(select) conn.commit() print('Selected Workshop History\n') except: conn.rollback() for row in cur: print() print(row) cur.close() conn.close()
def selectRefeNetAdapt(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() select = "SELECT * FROM NETWORK_ADAPTER WHERE NAstring= '" + configuration[ 'NAstring'] + "', NAvmName = '" + configuration['NAvmName'] + "'" try: cur.execute(select) conn.commit() print('Selected Network Adapter\n') except: conn.rollback() for row in cur: print() print(row) cur.close() conn.close()
def insertWorkshop(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() insert = "INSERT INTO WORKSHOP (WGname ,WUname,Wdescription,Wtype,Whost,Wstatus,WpublishDate) VALUES ('" + configuration[ 'WGname'] + "','" + configuration['WUname'] + "','" + configuration[ 'Wdescription'] + "','" + configuration[ 'Wtype'] + "','" + configuration[ 'Whost'] + "','" + configuration['Wstatus'] + "NOW()" try: cur.execute(insert) conn.commit() except: conn.rollback() print('Add a New Workshop\n') cur.close() conn.close()
def updateClone(self, configuration): conn = configurationDB.connect(self) cur = conn.cursor() update = "UPDATE CLONE SET CvmName = '" + configuration[ 'CvmName'] + "', CnumOfClones = '" + configuration[ 'CnumOfClones'] + "', CVRDPSeed = '" + configuration[ 'CVRDPSeed'] + "' WHERE Cvname = '" + configuration[ 'CvmName'] + "'" try: cur.execute(update) conn.commit() except: conn.rollback() print('User Updated\n') cur.close() conn.close()