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()
