res_partner.py 421 B

123456789101112131415161718192021
  1. # -*- coding: utf-8 -*-
  2. from openerp.http import request as r
  3. def get_res_partner():
  4. query = '''
  5. SELECT
  6. partner.id,
  7. partner.name,
  8. partner.ruc
  9. FROM res_partner AS partner
  10. '''
  11. r.cr.execute(query)
  12. return [
  13. {
  14. 'id': j[0],
  15. 'name': j[1],
  16. 'ruc': j[2],
  17. } for j in r.cr.fetchall()
  18. ]