~vauxoo/addons-vauxoo/7.0-extrae-adjuntos-dev-yzk

[ADD] scripts get attachment

added added

removed removed

# -*- encoding: utf-8 -*-

import time

import base64

import xmlrpclib

from psycopg2 import connect

conexion=connect("dbname=GBW_1_junio host=127.0.0.1 port=5432 user=gbw password=1234")

cr=conexion.cursor()

print 'cr',cr

cr.execute("""SELECT a.internal_number, i.db_datas, i.datas_fname from ir_attachment i, account_invoice a

where i.file_type<> 'application/xml' and i.res_model ='account.invoice'

and i.db_datas is not NULL and a.id = i.res_id

""")

dat=cr.fetchall()

print 'dat',dat

count = 0

for d in dat:

string_pdf =d[1]

print '-----------file name',d[2]

file_name = '/home/yzaack/instancias/6.0/server/bin/filestore/GBW_1_junio/mjfZwqOqgL/%s' % d[2]

file_pdf = open(file_name,'wb')

file_pdf.write(string_pdf)

file_pdf.close()

count +=1

print '-------el total de PDF generados',count