#!/usr/bin/env python
# Hey Emacs, this is -*-python-*- code!

from fooconflib import *

def generatePostfixMailboxMapFragment(ctx = FooConfContext()):
    cursor = ctx.db.cursor()
    cursor.execute("SELECT DISTINCT local, domain, recipient, account.name AS name " +
                   "FROM mail_alias, domain, account, mailbox " +
                   "WHERE mail_alias.domain = domain.name " +
                   "AND domain.owner = account.id " +
                   "AND mailbox.owner = account.id " +
                   "AND mailbox.enabled = \"t\" " +
                   "AND account.enabled = \"t\" " +
                   "AND type=\"mailbox\"")

    while 1:
        row = cursor.fetchone()
        if row is None: break

        print "%s@%s %s" % (row["local"], row["domain"], ctx.makeHomeDir(row["name"])+"/mail/"+row["recipient"])

if __name__ == "__main__":
    generatePostfixMailboxMapFragment()