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

from fooconflib import *

def generateUnixPasswdFragment(ctx = FooConfContext()) :
      cursor = ctx.db.cursor()
      cursor.execute("SELECT name, id, enabled"+
                     " FROM account")
      
      while 1:
            row = cursor.fetchone()
            if row is None: break

            if row["enabled"] :
                  pw = "xxx"
                  shell = "/bin/sh"
            else:
                  pw = ""
                  shell = "/bin/false"

            print "%s:%s:%u:%u:%s,Fooconf User:%s:%s" % (ctx.makeSysUserName(row["name"]),
                                                         pw,   
                                                         ctx.makeSysUID(row["id"]),
                                                         ctx.makeSysGID(row["id"]),
                                                         row["name"],
                                                         ctx.makeHomeDir(row["name"]),
                                                         shell)

if __name__ == "__main__":
      generateUnixPasswdFragment()