def createLocListDb(listname,dbname,isLastNeeded=True): val1 = languageScr.getLocalTextList(0,listname) val2 = languageScr.getLocalTextList(1,listname) print len(val1) print len(val2) conn = MySQLdb.connect (host = "localhost", db = "test") cursor = conn.cursor() for i,v in enumerate(val1): if isLastNeeded: if i == len(val1) -1: break query1 = """ INSERT INTO %s (id,eng,mal)VALUES (%d,'%s','%s') """%(dbname, i,val1[i],val2[i]) cursor.execute (query1) print val1[i]+' '+str(len(val1[i])) print val2[i]+' '+str(len(val2[i])) if isLastNeeded: query1 = """ INSERT INTO %s (id,eng,mal)VALUES (%d,'%s','%s') """%(dbname, 100,val1[len(val1)-1],val2[len(val2)-1]) cursor.execute (query1) cursor.close () conn.commit() conn.close()
def getTextList(key): l = SESSINFO.getLangId() return languageScr.getLocalTextList(l,key)