def ExtendLifeTime(self, PassWord, VMName):
ListOfUniqueiD = []
ListOfAllVMs = []
if (LogIn.LogeIn().CheckLogIn('root', PassWord)):
listUsers = LogIn.LogeIn().AllUsers()
for i in listUsers:
ListOfUniqueiD.append(i[2])
ListOfAllVMs = self.fetchAllVMData()
for i in ListOfAllVMs:
for j in ListOfUniqueiD:
if (i[8] == j
and VMName == i[1]): #not 100% if it i[8] =? i[5]=?
i[5] = i[5] + timedelta(days=30)
def GetAllVMsFromSQL(self, PassWord, VMName): #only from SQL
ListOfUniqueiD = []
ListOfAllVMs = []
if (LogIn.LogeIn().CheckLogIn('root', PassWord)):
listUsers = LogIn.LogeIn().AllUsers()
for i in listUsers:
ListOfUniqueiD.append(i[2])
ListOfAllVMs = DB.VMDB().fetchAllVMData()
for i in ListOfAllVMs:
for j in ListOfUniqueiD:
if (i[8] == j and VMName
== i[1]): #i[8]==> UniqueiD ,i[1]==> VM name
print(i)
return i
def GetAllVMsForThisUser(self, UniqueiD):
cursor = connection.connections().getConnection()
cursor.execute("SELECT * FROM VM") # VM Table name
usersList = LogIn.LogeIn().AllUsers()
for i in usersList:
if (i[2] == UniqueiD):
conn = pyodbc.connect(
'Driver={ODBC Driver 17 for SQL Server}; SERVER=HP; Database=VM;Trusted_Connection=yes'
)
SQLCommand = "SELECT [VMID], [Name], [VMIP], [OS], [LifeTime], [Owner], [Designation],[UniqueiD] FROM VM;"
return SQLCommand
else:
return None
def LogIn(self, UserName, Password):
LogIn.LogeIn().CheckLogIn(UserName, Password)
