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

from fooconflib import *
from sys import stdout

def generateApacheFragment(ctx = FooConfContext()):
    cursor = ctx.db.cursor()
    cursor.execute("SELECT domain.name AS name, origin_email, account.email AS email, account.id AS id, account.name AS owner "+
                   "FROM domain, domain_vhost, account "+
                   "WHERE domain.owner = account.id "+
                   "AND domain.name = domain_vhost.name "+
                   "AND domain_vhost.enabled = \"t\" "+
                   "AND account.enabled = \"t\"")

    subcursor = ctx.db.cursor();

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

        
#         subcursor.execute("SELECT domain_alias.name AS NAME"+
#                           "FROM domain, domain_alias, account "+
#                           "WHERE domain.owner = account.id "+
#                           "AND domain.name = domain_alias.name "+
#                           "AND vhost=\"%s\" "+
#                           "AND account.enabled = \"t\"")
        alias = ""

        stdout.write(("<VirtualHost *:80>\n"+
                      "\tServerName %s\n"+
                      "\tServerAlias %s\n"+
                      "\tServerAdmin %s\n"+
                      "\tDocumentRoot %s\n"+
                      "</VirtualHost>\n") % (row["name"], alias, row["email"], ctx.makeHomeDir(row["owner"])+"/www/"+row["name"]))

if __name__ == "__main__":
    generateApacheFragment()