def getSoftwareDublicates(self,
clustername,
_select="*",
_limitup=0,
_limitdown=0,
_where=None,
_orderby=None):
if _where == None:
_where = list()
# Quickhack to support mysql3
if type(_where) == list:
for i in range(len(_where)):
_where[i] = "t1." + _where[i]
limit = BaseDB.getLimit(_limitup, _limitdown)
self.log.debug("where: %s" % (_where))
_where.append("t1.clustername=\"%s\"" % (clustername))
# _where+=" AND ".join(_where)
whereclause = BaseDB.resolveWhere(_where)
orderbyclause = BaseDB.resolveOrderBy(_orderby)
self.log.debug("whereclause: %s" % (whereclause))
query="""SELECT DISTINCT %s FROM %s AS t1
LEFT JOIN %s AS t2
USING (clustername, name)
%s
AND (t1.version != t2.version OR t1.subversion != t2.subversion)
%s %s;""" \
%("t1."+", t1.".join(_select), self.tablename, self.tablename, whereclause, orderbyclause, limit)
self.log.debug("query: %s" % (query))
return self.selectQuery(query)
def getSoftware(self, clustername, select="*", limitup=0, limitdown=0, where=None, orderby=None):
if where==None:
where=list()
limit=BaseDB.getLimit(limitup, limitdown)
where.append("clustername=\"%s\"" %(clustername))
self.log.debug("where: %s" %(where))
whereclause=BaseDB.resolveWhere(where)
orderbyclause=BaseDB.resolveOrderBy(orderby)
self.log.debug("whereclause: %s" %(whereclause))
query="SELECT DISTINCT %s FROM %s %s %s %s;" %(", ".join(select), self.tablename, whereclause, orderbyclause, limit)
self.log.debug("query: %s" %(query))
return self.selectQuery(query)
def getSoftware(self,
clustername,
select="*",
limitup=0,
limitdown=0,
where=None,
orderby=None):
if where == None:
where = list()
limit = BaseDB.getLimit(limitup, limitdown)
where.append("clustername=\"%s\"" % (clustername))
self.log.debug("where: %s" % (where))
whereclause = BaseDB.resolveWhere(where)
orderbyclause = BaseDB.resolveOrderBy(orderby)
self.log.debug("whereclause: %s" % (whereclause))
query = "SELECT DISTINCT %s FROM %s %s %s %s;" % (", ".join(
select), self.tablename, whereclause, orderbyclause, limit)
self.log.debug("query: %s" % (query))
return self.selectQuery(query)
def getSoftwareDublicates(self, clustername, _select="*", _limitup=0, _limitdown=0, _where=None, _orderby=None):
if _where==None:
_where=list()
# Quickhack to support mysql3
if type(_where)==list:
for i in range(len(_where)):
_where[i]="t1."+_where[i]
limit=BaseDB.getLimit(_limitup, _limitdown)
self.log.debug("where: %s" %(_where))
_where.append("t1.clustername=\"%s\"" %(clustername))
# _where+=" AND ".join(_where)
whereclause=BaseDB.resolveWhere(_where)
orderbyclause=BaseDB.resolveOrderBy(_orderby)
self.log.debug("whereclause: %s" %(whereclause))
query="""SELECT DISTINCT %s FROM %s AS t1
LEFT JOIN %s AS t2
USING (clustername, name)
%s
AND (t1.version != t2.version OR t1.subversion != t2.subversion)
%s %s;""" \
%("t1."+", t1.".join(_select), self.tablename, self.tablename, whereclause, orderbyclause, limit)
self.log.debug("query: %s" %(query))
return self.selectQuery(query)