import mysql.connector as mysql
ConnectString = dict(host='1.1.1.1', port=8000, database='od_dota2', user='user', password='pass')


def CreateClassBySelect(table, database):
    conn = mysql.connect(**ConnectString )
    cur = conn.cursor()
    cur.execute("USE " + database)
    cur.execute('select * from '+table+' limit 1')
    fields = [i[0:2] for i in cur.description]
    result = ''
    result += 'class '+table+':\n'
    result += '    def __init__(self):\n'
    for f in fields:
        result+='        self.'+f[0]+' = '
        if f[1] in (0,1,2,3,8,9) : result+= '0'
        elif f[1] in (4,5): result += '0.0'
        else:  result += "''"
        result += '\n'
    data = cur.fetchall()
    cur.close()
    conn.close()

    return result

def CreateClassBySelect(table, database):
    conn = mysql.connect(**ConnectString )
    cur = conn.cursor()
    cur.execute("USE " + database)
    cur.execute('select * from '+table+' limit 1')
    fields = [i[0:2] for i in cur.description]
    result = ''
    result += 'class '+table+':\n'
    result += '    def __init__(self):\n'
    for f in fields:
        result+='        self.'+f[0]+' = '
        if f[1] in (0,1,2,3,8,9) : result+= '0'
        elif f[1] in (4,5): result += '0.0'
        else:  result += "''"
        result += '\n'
    data = cur.fetchall()
    cur.close()
    conn.close()

    return result

def GetAllEntitiesFromChema(database):
    conn = mysql.connect(**globalParams.MySqlDataConnectString)
    cur = conn.cursor()
    cur.execute("USE "+database)
    cur.execute('Show tables')
    result = ''
    data = cur.fetchall()
    cur.close()
    conn.close()
    for (table_name,) in data:
        result+=CreateClassBySelect(table_name,database)+'\n\n'
    return result



print GetAllEntitiesFromChema('mmb_dota2')