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)
