15、odoo的web服务与RPC调用

浅浅的花香味﹌ 2022-11-17 05:16 106阅读 0赞

### 20、web服务与RPC调用(WebServices) ###

[点我下载完整odoo的demo][odoo_demo]

odoo提供两种RPC接口， XML-RPC和JSON-RPC。

#### XML-RPC库 ####

使用python内置的xmlrpclib

# -*- coding: utf-8 -*-
    
    import functools
    from xmlrpc import client
    
    HOST = 'localhost'
    PORT = 8199
    DB = 'learn_odoo_14'  # s数据库
    USER = 'admin'  # 登录odoo系统的登录名
    PASS = 'admin'  # 登录odoo系统的登录密码
    ROOT = 'http://%s:%d/xmlrpc/' % (HOST, PORT)
    
    
    if __name__ == '__main__':
        # 1. Login
        uid = client.ServerProxy(ROOT + 'common').login(DB, USER, PASS)
        print("Logged in as %s (uid:%d)" % (USER, uid))
        call = functools.partial(
            client.ServerProxy(ROOT + 'object').execute,
            DB, uid, PASS)
    
        # 2. Read the sessions
        sessions = call('myproject.session', 'search_read', [], ['name', 'seats'])
        for session in sessions:
            print("Session %s (%s seats)" % (session['name'], session['seats']))
    
        # 3.create a new session
        session_id = call('myproject.session', 'create', { 
            'name': 'My session',
            'course_id': 2,
        })

在浏览器上运行odoo系统，这个脚本才可以运行。

#### ODOO-RPC ####

# -*- coding: utf-8 -*-
    import odoorpc
    
    HOST = 'localhost'
    PORT = 8199
    DB = 'learn_odoo_14'  # s数据库
    USER = 'admin'  # 登录odoo系统的登录名
    PASS = 'admin'  # 登录odoo系统的登录密码
    ROOT = 'http://%s:%d/xmlrpc/' % (HOST, PORT)
    
    odoo = odoorpc.ODOO(HOST, port=PORT)
    
    odoo.login(DB, USER, PASS)
    
    order = odoo.env['myproject.session']
    doamin = [('seats', '>', 2)]  # doamin 写条件语句
    data = order.search_read(doamin)  # 在这里我们就可以试试能否调用模型中自定义的方法呢？ 理论上是可行的
    print(data)

#### JSON-RPC ####

下面的例子使用urllib2发送jsonrpc请求

# -*- coding: utf-8 -*-
    # -*- coding: utf-8 -*-
    
    import json
    import random
    import odoorpc
    import requests
    
    HOST = 'localhost'
    PORT = 8199
    DB = 'learn_odoo_14'  # s数据库
    USER = 'admin'  # 登录odoo系统的登录名
    PASS = 'admin'  # 登录odoo系统的登录密码
    
    
    def json_rpc_methods_1(url, method, params):
        # 方式1
        data = { 
            "jsonrpc": "2.0",
            "method": method,
            "params": params,
            "id": random.randint(0, 1000000000),
        }
        req = requests.get(url=url, data=json.dumps(data), headers={ 
            "Content-Type": "application/json",
        })
        print(req.content.decode('utf-8'))
        reply = json.loads(req.content.decode('utf-8'))
        if reply.get("error"):
            raise Exception(reply["error"])
        return reply["result"]
    
    
    def call(url, service, method, *args):
        return json_rpc_methods_1(url, "call", { "service": service, "method": method, "args": args})
    
    
    def json_rpc_methods_2(host, port, db ,user, password):
        # 方式2
        odoo = odoorpc.ODOO(host, 'jsonrpc', port)  # 输入odoo的环境
        print(odoo.list())
        odoo.login(db, user, password)  # 想要连接的数据库登陆名和密码
        session_env = odoo.env['myproject.session']  # 想要改的表名
        session_search = session_env.search([('name', '=', "session 1")])  # 想要改的内容通过条件找出
        session_browse = session_env.browse(session_search)  # 浏览找到的内容
        print(session_browse)
        # 创建
        args = { 
            'name': '新课时2',
            'course_id': 3,
            'seats': 23,
        }
        result = odoo.execute('myproject.session', 'create', args)
        print(result)
        course_env = odoo.env['myproject.course']  # 浏览员工信息表
        course_search = course_env.search([('name', 'in', ["英语", "课程"])])  # 通过条件查找相应的员工
        course_browse = course_env.browse(course_search)  # 获取查找的内容
        for course in course_browse:
            print(course)
    
    
    if __name__ == '__main__':
        # 使用方式1
        # url = "http://%s:%s/jsonrpc" % (HOST, PORT)
        # uid = call(url, "common", "login", DB, USER, PASS)
        # # create a new note
        # args = { 
        # 'name': '新课时',
        # 'course_id': 2,
        # 'seats': 5,
        # }
        # note_id = call(url, "object", "execute", DB, uid, PASS, 'myproject.session', 'create', args)
        # 使用方式2
        json_rpc_methods_2(HOST, PORT, DB, USER, PASS)

在不显式地通过XML-RPC或JSON-RPC的情况下，有许多使用各种语言的高级API可以访问Odoo系统，例如：

[https://github.com/akretion/ooor][https_github.com_akretion_ooor]

[https://github.com/syleam/openobject-library][https_github.com_syleam_openobject-library]

[https://github.com/nicolas-van/openerp-client-lib][https_github.com_nicolas-van_openerp-client-lib]

[http://pythonhosted.org/OdooRPC][http_pythonhosted.org_OdooRPC]

[https://github.com/abhishek-jaiswal/php-openerp-lib][https_github.com_abhishek-jaiswal_php-openerp-lib]

\[1 \]可以禁用某些字段的自动创建

\[2\]可以编写原始SQL查询，但是需要注意，因为它绕过了所有Odoo身份验证和安全机制。

[点我下载完整odoo的demo][odoo_demo]

## 后记 ##

【后记】为了让大家能够轻松学编程，我创建了一个公众号【轻松学编程】，里面有让你快速学会编程的文章，当然也有一些干货提高你的编程水平，也有一些编程项目适合做一些课程设计等课题。

也可加我微信【1257309054】，拉你进群，大家一起交流学习。  
如果文章对您有帮助，请我喝杯咖啡吧！

公众号

![公众号][20200317124808234.jpg]

![赞赏码][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xtX2lzX2Rj_size_16_color_FFFFFF_t_70]

关注我，我们一起成长~~

[odoo_demo]: https://download.csdn.net/download/lm_is_dc/16818292
[https_github.com_akretion_ooor]: https://github.com/akretion/ooor
[https_github.com_syleam_openobject-library]: https://github.com/syleam/openobject-library
[https_github.com_nicolas-van_openerp-client-lib]: https://github.com/nicolas-van/openerp-client-lib
[http_pythonhosted.org_OdooRPC]: http://pythonhosted.org/OdooRPC
[https_github.com_abhishek-jaiswal_php-openerp-lib]: https://github.com/abhishek-jaiswal/php-openerp-lib
[20200317124808234.jpg]: /images/20221022/43b760830b0d4632b1324ed669cd8874.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xtX2lzX2Rj_size_16_color_FFFFFF_t_70]: /images/20221022/cdd0e1d32e9341bca56b964ebf274e18.png