#!/usr/bin/env python
""" Generates ``INSERT`` statements for Trac users in the ``htdigest`` file,
so they show up in the "owner" drop-down.
"""
email_domain = 'domain.com'
users_file = open('htdigest')
output_file = open('trac-users.sql', 'w')
for line in users_file:
    username = line.split(':')[0]
    sql = "INSERT INTO session (sid, authenticated, var_name, var_value) VALUES ('%s', '%s', '%s', '%s');\n" % (username, 1, 'username', username)
    output_file.write(sql)
    sql = "INSERT INTO session (sid, authenticated, var_name, var_value) VALUES ('%s', '%s', '%s', '%s@%s');\n" % (username, 1, 'email', username, email_domain)
    output_file.write(sql)