Hi,

You can use SQLAlchemy with odoo, an open source SQL toolkit and object-relational mapper (ORM) for Python.

# -*- coding: utf-8 -*- 
from odoo import fields, models, api
from sqlalchemy import *

class ResPartner(models.Model): 
    _inherit = 'res.partner'
     
     def mysql_connect():
     
        mysql_cnx_info = { 'host': 'mysql_hots', 'login': 'login', 'password': 'password', 'db_name': 'db_name', } 
        param = "{login}:{password}@{host}/{db_name}".format(login=mysql_cnx_info['login'], password=mysql_cnx_info['password'], host=mysql_cnx_info['host'], db_name=mysql_cnx_info['db_name']) 
        mysql_engine = create_engine('mysql+mysqldb://{param}'.format(param=param)) 
        
        return mysql_engine.connect()
     
     # insert case
     @api.model
     def create(vals):
         request = "Insert request based on vals and you mysql table"
         connection = mysql_connect()
         connection.execute(request)
         connection.close()
         return super(ResPartner, self).create(vals)
     
     # update case
     @api.multi 
     def write(vals):
         connection = mysql_connect()
         for partner in self:
            request = "update request based on vals, partner.id and your mysql table" 
            connection.execute(request) 
         connection.close()
         return super(ResPartner, self).write(vals)

Best regards

Hi Bejaoui, I have tried your Script and it's working when I use INSERT and DELETE Query. How if I want to use SELECT Query ? How do I use data from Query Result ?