#!/usr/bin/env python

import time
from sqlalchemy import *
from sqlalchemy.orm import *

def get_connection():
    db = create_engine('mysql://root:gdpw@te.net@127.0.0.1:33068/upliftparking')
    md = MetaData(bind=db, reflect=True)

    return md, db

def get_domains():
    meta, conn = get_connection()
    domain_table = meta.tables['domain']
    return domain_table.select().order_by(domain_table.c.name).execute()

def lower_case_field(field):
    meta, conn = get_connection()
    domain_table = meta.tables['domain']

    # use the value passed in via is_registered if we need
    for d in domain_table.select().order_by(domain_table.c.name).execute():
        old_name = d.name
        lower_name = old_name.lower()
        print "Lowered Domain: %s" % lower_name
        update = domain_table.update(domain_table.c.name == d.name).execute(name = lower_name)



field = 'name'
lower_case_field(field)