From f54ca21bb5823e935f7fc910b3883ef630052297 Mon Sep 17 00:00:00 2001 From: Lennart Poettering Date: Tue, 7 Dec 2004 16:53:18 +0000 Subject: move stuff into trunk git-svn-id: file:///home/lennart/svn/public/fooconf/trunk@5 a3b0ba65-a9ea-0310-aec1-fe512e4e1665 --- fooconf-apache | 39 +++++++++++++++++++++++++++++++++++++++ 1 file changed, 39 insertions(+) create mode 100755 fooconf-apache (limited to 'fooconf-apache') diff --git a/fooconf-apache b/fooconf-apache new file mode 100755 index 0000000..92aafbb --- /dev/null +++ b/fooconf-apache @@ -0,0 +1,39 @@ +#!/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(("\n"+ + "\tServerName %s\n"+ + "\tServerAlias %s\n"+ + "\tServerAdmin %s\n"+ + "\tDocumentRoot %s\n"+ + "\n") % (row["name"], alias, row["email"], ctx.makeHomeDir(row["owner"])+"/www/"+row["name"])) + +if __name__ == "__main__": + generateApacheFragment() -- cgit