mysql create table to java pojo field

gistfile1.py

#!/usr/bin/env python

import sys
import re

# http://stackoverflow.com/questions/4303492/how-can-i-simplify-this-conversion-from-underscore-to-camelcase-in-python
def underscore_to_camelcase(value):
    def camelcase():
        yield str.lower
        while True:
            yield str.capitalize

    c = camelcase()
    return "".join(c.next()(x) if x else '_' for x in value.split("_"))

M = {
    'int': 'long',
    'varchar' : 'String',
    'datetime' : 'Date',
}

ACC = 'private'

for f, t in re.findall('`(.*?)` (.*?)\(?\d*\)? ', sys.stdin.read()):
    f = underscore_to_camelcase(f)

    print ACC, M[t], f + ';'