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