def rds(self,project):
sql2 = getsql('rds', 'sql2')
sql=sql2%(project)
res=self.mydb.query(sql)
result=self.list(res)
result=self.tostr(result)
return result
def rds_test(self):
sql2 = getsql('rds', 'sql7')
sql=sql2
res=self.mydb.query(sql)
result=self.list(res)
result=self.tostr(result)
return result
def rds_version(self,project,version):
sql1 = getsql('rds', 'sql1')
sql=sql1%(project,version)
res=self.mydb.query(sql)
result=self.list(res)
result=self.tostr(result)
return result
def name(self,id):
sql2 = getsql('rds', 'sql8')
sql = sql2 % (id)
res = self.mydb.query(sql)
result = self.list(res)
result = self.tostr(result)
return result[0][0]
def vname(self):
sql2 = getsql('rds', 'sql9')
sql = sql2
res = self.mydb.query(sql)
result1 = self.list(res)
res1 = self.tostr(result1)
result = [i[0] for i in res1]
return res1
def project(self):
result=[]
sql = getsql('rds', 'sql4')
res = self.mydb.query(sql)
res2 = self.list(res)
result1 = self.tostr(res2)
for i in result1:
result.append(i[0])
return result
def rds_issuetype(self,newvalue):
res=newvalue+"%"
sql1 = getsql('rds', 'sql5')
sql = sql1 % (res)
res=self.mydb.query(sql)
result=self.list(res)
if result:
return result
else:
return 0
def rds_issuetype(self, newvalue):
sql1 = getsql('rds', 'sql5')
sql = sql1 % (newvalue)
res = self.mydb.query(sql)
result = self.list(res)
return result