Hello, I'm working with PostgreSQL and Python to obtain 2 columns froma database and need to print it in a specific format.
Here is my current code.
-- coding: utf-8 --
con = None
con = psycopg2.connect(database='DB', user='ME', password='1234')
cur = con.cursor()
cur.execute(" select Account_Invoice.amount_untaxed, right (Res_Partner.vat,length(Res_Partner.vat)-2) as RFC from Account_Invoice inner join Res_Partner on Account_Invoice.partner_id = Res_Partner.id inner join Account_Invoice_Tax on Account_Invoice.id = Account_Invoice_Tax.invoice_id where account_invoice.journal_id=2 and account_invoice.date_invoice >= '2013-01-01' and account_invoice.date_invoice <= '2013-02-01' and account_invoice.reconciled is TRUE and account_invoice_tax.account_id = 3237 and account_invoice.amount_tax >= 0;")
rows = cur.fetchall()
for row in rows:
except psycopg2.DatabaseError, e:
print 'Error %s' % e
In this case fetchall gets 2 columns (vat with the RFC alias and amount_untaxed)
Now I need to format the data in the following way
Colums = 22
first 2 columns always have 04 and 85 respectively.
Third colum has the Vat as RFC code
Eight column has the amount untaxed
Assuming this code finds the following data form the DB
LOEL910624ND5 from the column vat as RFC.
227 from the column amount_untaxed.
Then the correct final format would be the following.
I would like to also do something like
writer = csv.writer(sys.stdout, delimiter="|")
Hope I explained myself well enough.