python通过xmlrpc连接odoo的postgresql

import xmlrpc.client
from pprint import pprint

url = "https://.odoo.com"
db = "-production-"
username = "admin"
password = "admin"
common = xmlrpc.client.ServerProxy('{}/xmlrpc/2/common'.format(url))
uid = common.authenticate(db, username, password, {})
models = xmlrpc.client.ServerProxy('{}/xmlrpc/2/object'.format(url))


def call_check_access_rights():
    data = models.execute_kw(db, uid, password,
                             'res.partner', 'check_access_rights',
                             ['read'], {'raise_exception': False})
    print(data)

# call_check_access_rights()


def list_all_records(): #search是查询id
    records_data = models.execute_kw(db, uid, password,
                                     'res.partner', 'search', [[]])
    print(records_data)

# list_all_records()


def list_records(): #search是查询id
    records_data = models.execute_kw(db, uid, password,
                                     'res.partner', 'search',
                                     [[('is_company', '=', True)]])
    print(records_data)

# list_records()


def count_records(): #search_count是计数
    records_count = models.execute_kw(db, uid, password,
                                      'res.partner', 'search_count',
                                      [[('is_company', '=', True)]])
    print(records_count)

# count_records()


def read_records(): #search是查询id。跳过0个 开始查询，并依次返回3笔
    # Read records
    ids = models.execute_kw(db, uid, password,
                            'res.partner', 'search',
                            [[['is_company', '=', True]]],
                            {'offset': 0, 'limit': 3})
    print('ids:', ids)
    return ids

# read_records()


def read_all_field(): #read是查询详细字段，这里返回所有的字段
    ids = read_records()
    # all field
    record = models.execute_kw(db, uid, password,
                               'res.partner', 'read', [ids])
    print('record')
    pprint(record)

# read_all_field()


def read_need_field(): #read是查询详细字段，这里返回想要看到的字段
    ids = read_records()
    # need field
    record = models.execute_kw(db, uid, password,
                               'res.partner', 'read',
                               [ids], {'fields': ['id', 'name', 'vat']})
    print('record')
    pprint(record)

# read_need_field()


def read_field_get(): #fields_get返回字段的类型、备注
    record = models.execute_kw(db, uid, password,
                               'res.partner', 'fields_get',
                               [], {'attributes': ['string', 'help', 'type']})
    print('record')
    pprint(record)

# read_field_get()


def search_and_read(): #search_read：终极简化，条件查询，按需显示
    record = models.execute_kw(db, uid, password,
                               'res.partner', 'search_read',
                               [[('vat', '=', '300048757700003'),
                                 ('name', '=', 'Alshaya Enterprises®')]], {'fields': ['id', 'name', 'email', 'vat']})
    print('record')
    pprint(record)

search_and_read()