def getVirtualId(self,id): """ Get a virtual entry by id""" data = {} cur = self.getCursor() cur.execute("select alias,dest,status from virtual where id=%s",(id)) r = cur.fetchone() if r: alias,dest,status = r alias = p2latin1(alias) data["virtual"] = alias.split("@")[0] data["domain"] = alias.split("@")[1] data["dest"] = p2latin1(dest) data["id"] = id if status: data["active"] = "status" return data
def getDomains(self, company): """ Returns a list of domains connected to a company """ domains = [] if company: self.dcur.execute("select name from domains where company=%s order by name", (company)) else: self.dcur.execute("select name from domains order by name") r = self.dcur.fetchall() if r: for d in r: domains.append(p2latin1(d[0])) return domains
def virtualSearch(self, search): """ Return all virtuals matching this string """ search = '%%'+search+'%%' cur = self.getCursor() cur.execute("select id, alias, status from virtual where username='' and alias like %s order by alias", (search)) return p2latin1(cur.fetchall())
def getVirtual(self,user): """ Get all virtuals for a user """ cur = self.getCursor() cur.execute("select id,alias,dest,username,status from virtual where username=%s order by alias",(user)) return p2latin1(cur.fetchall())
def aliasSearch(self, search): cur = self.getCursor() search = '%%'+search+'%%' cur.execute("select id, alias, status from alias where alias like %s order by alias", search) return p2latin1(cur.fetchall())
def aliasGet(self,id, order="alias"): """ Get all info about an alias """ cur = self.getCursor() cur.execute("select id,alias,dest,status from alias where id=%s order by %s",(id, order)) return p2latin1(cur.fetchone())