Breve Relato

# -*-coding:utf-8-*-
import xmlrpclib
import csv
import os
import subprocess
import logging
import pandas
import magic
import time
import datetime



# XML-RPC credentials to access the database PLEASE CHANGE
#dbname = 'mmp.lincersolucoes.com.br'
dbname = 'mmp.lincersolucoes.com.br'
user = 'admin'
pwd = 'mmp@lincer'
host = 'localhost'
port = 10073

com = xmlrpclib.ServerProxy("http://%s:%s/xmlrpc/common" % (host, port))
uid = com.login(dbname, user, pwd)
sock = xmlrpclib.ServerProxy("http://%s:%s/xmlrpc/object" % (host, port))
print 'Logged in to ' + dbname


full_path = "/home/ubuntu/xml_rpc/dossie_dossie/breve_relato/breve_relato.csv"

BUF_SIZE = 65536
csv.field_size_limit(1000 * 1024 * 1024)

with open(full_path, 'rb') as csvfile:
    csvfile.seek(0)
    file_reader = csv.reader(csvfile, delimiter=',')
    header = file_reader.next()
    counter = 0
    t1 = time.time()
    for row in file_reader:
        dossie_id = int(row[0].split('_')[-1]) #A
        relatorio_breve_relato = row[1] #B

        rowdb = {'relatorio_breve_relato':relatorio_breve_relato}
        sock.execute_kw(dbname, uid, pwd, 'dossie.dossie', 'write', [[dossie_id], rowdb])

        counter += 1
        print 'Processing row: %s' %counter
    msg = "It took %s Sec in process %s records " % (time.time() - t1, counter)
    print msg