#!/usr/bin/python

# -*- coding: utf-8 -*-

import shelve,string,os,MySQLdb,re

database = 'lingvigilo'

dbuser = 'lingvigilouser'

dbpass = 'carrinclo'

dbtable = 'vortoj_ru_ca'

db = MySQLdb.connect(host='vicerveza',user=dbuser,passwd=dbpass,db=database)

cursor = db.cursor()

sourcefile = 'vortoj-ru-ca.txt'

# Connexió base de dades

# Read txt

file = open(sourcefile, 'r')

cursor.execute('DELETE FROM ' + dbtable);

for line in file:

	# Traiem l'INTRO final

	line = line.rstrip('\n')

	# Arreglem cometes simples per a sql

	line = re.sub(r"'",r"\'", line)

	# Separem per \t

	words = string.split(line, '\t')

	print "Aldonante:", words[0], '=>', words[2]

	if words[1] == "verb":

		#print ('INSERT INTO ' + dbtable +

		#	' (vorto,tipo,traduko,param1,param2) '+

		#	'VALUES(\'%s\',\'%s\',\'%s\',\'%s\',\'%s\');' %

		#	(words[0], words[1], words[2], words[3], words[4]))

		if (len(words) == 5):

			cursor.execute('INSERT INTO ' + dbtable +

				' (vorto,tipo,traduko,param1,param2) '+

				'VALUES(\'%s\',\'%s\',\'%s\',\'%s\',\'%s\');' %

				(words[0], words[1], words[2], words[3],

				words[4]))

		else:

			cursor.execute('INSERT INTO ' + dbtable +

				' (vorto,tipo,traduko,param1) '+

				'VALUES(\'%s\',\'%s\',\'%s\',\'%s\');' %

				(words[0], words[1], words[2], words[3]))

	else:

		#print ('INSERT INTO ' + dbtable +

		#	' (vorto,tipo,traduko) '+

		#	'VALUES(\'%s\',\'%s\',\'%s\');' % (words[0], words[1],

		#	words[2]))

		cursor.execute('INSERT INTO ' + dbtable +

			' (vorto,tipo,traduko) '+

			'VALUES(\'%s\',\'%s\',\'%s\');' % (words[0], words[1],

			words[2]))

db.close()

file.close()