gensql

gensql.py

#coding:utf-8
def gensql(table,dicts):
    with open("%s.table.sql"%table,'w') as buff:
        for sqlobj in dicts:
            ks,vs = '',''
            for k,v in sqlobj.items():
                ks += '%s,'%k
                vs += '\'%s\','%v
            sql = "insert into %s (%s) values(%s);"%(table,ks[:-1],vs[:-1])
            print >> buff,sql

if __name__ == "__main__":
    datas = dict(username="demo",password="demo",email="[email protected]")
    gensql("user",(datas,))