Skip to content

Instantly share code, notes, and snippets.

@lmorillas
Last active October 28, 2015 13:05
Show Gist options
  • Save lmorillas/09eea757310705718546 to your computer and use it in GitHub Desktop.
Save lmorillas/09eea757310705718546 to your computer and use it in GitHub Desktop.
Introduce una traducción nueva a una tabla para arasaac
import csv
import MySQLdb
conn = ...
cur = conn.cursor()
reader = csv.reader(open('arasaac_croata.csv'))
lineas = [l for l in reader]
insert = '''INSERT INTO `traducciones_16` (`id_traduccion`, `id_palabra`, `traduccion`) VALUES (%s, %s, %s)'''
ini = 214052
for n, trad in enumerate(lineas[1:]):
cur.execute(insert, (n + ini, trad[0], trad[2]))
conn.commit()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment