blob: 53fc10fe7d5b3a2236c9d799bb01a99d4068afe1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
#!/usr/bin/env python
# Hey Emacs, this is -*-python-*- code!
from fooconflib import *
def generatePostfixAliasMapFragment(ctx = FooConfContext()):
cursor = ctx.db.cursor()
cursor.execute("SELECT DISTINCT local, domain, recipient " +
"FROM mail_alias, domain, account " +
"WHERE mail_alias.domain = domain.name " +
"AND domain.owner = account.id " +
"AND account.enabled = \"t\" " +
"AND type=\"forward\"")
while 1:
row = cursor.fetchone()
if row is None: break
print "%s@%s %s" % (row["local"], row["domain"], row["recipient"])
if __name__ == "__main__":
generatePostfixAliasMapFragment()
|