Advertisement
Guest User

Untitled

a guest
Nov 22nd, 2017
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.60 KB | None | 0 0
  1.     def do_parse(self):
  2.         import psycopg2
  3.         import json
  4.         conn = psycopg2.connect(database="vitanatura", user="odoo9", password="admin", host="127.0.0.1", port="5432")
  5.         cur = conn.cursor()
  6.  
  7.         cur.execute("select row_to_json(res_partner) from res_partner;")
  8.         rows = cur.fetchall()
  9.         # print json.load(rows)
  10.         COUNTER = 0
  11.         for row in rows:
  12.             print (row[0]['name'])
  13.  
  14.             print (COUNTER)
  15.             COUNTER += 1
  16.             print
  17.         # print type(row)
  18.  
  19.         print ("Operation done successfully")
  20.         conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement