SQLをcase classに変換

sql2case.py

# -*- coding:utf-8 -*-
import re
import sys

def to_camel_case(snake_str):
    components = snake_str.split('_')
    return components[0] + "".join(x.title() for x in components[1:])

def caseClass(list):
    for i,elem in enumerate(list[0]):
        k = list[0][i].rstrip().strip()
        v = list[1][i].rstrip().strip()
        if (re.match("[0-9]",v)):        
            print to_camel_case(k) +": Option[Int]", "= Option("+ v +"),"
        elif(re.search("NULL",v)):
            print to_camel_case(k) +": Option[String],"
        elif(re.search("''",v)):
            print to_camel_case(k) +": Option[String]", "= Option(\"\"),"
        else:
            print to_camel_case(k) +": Option[String]", "= Option(\""+ v +"\"),"
    print

def methods(list):
    for i,elem in enumerate(list[0]):
        k = list[0][i].rstrip().strip()
        v = list[1][i].rstrip().strip()
        if (re.match("[0-9]",v)):        
            print "def " + to_camel_case(k) +" = column[Option[Int]]" + "(\"" + k + "\")"
        else:
            print "def " + to_camel_case(k) +" = column[Option[String]]" + "(\"" + k + "\")"
    print

def hlist(list):
    for i,elem in enumerate(list[0]):
        k = list[0][i].rstrip().strip()
        print ":: " + to_camel_case(k),
    print

def hlistType(list):
    for i,elem in enumerate(list[0]):
        v = list[1][i].rstrip().strip()
        if(re.match("[0-9]",v)):
            print ":: Option[Int]",
        else:
            print ":: Option[String]",
    print
    

if __name__ == "__main__":
    if (len(sys.argv) < 1):
        print "please input file"
    filename = sys.argv[1]
    list = []
    with open(filename) as f:
        for line in f:
            list.append(line.rstrip().split(","))
    caseClass(list)
    methods(list)
    hlist(list)
    hlistType(list)

python sql2case.py hoge.csv

で変換できます。
1行目：カラム名のカンマ区切り
2行目：値のカンマ区切り

regist_date, initial_rate, deliver_status, start_date, end_date, unit_price,wholesale_price
Now(), 100, 0, '2014-09-24', '2030-12-31', NULL, NUL
みたいな感じのcsvです。

👍
早速使わせていただきます。