Odoo Framework Unwrap

Description

Converts an Odoo module into non framework code such as PHP and MySQL
*IMPORTANT* This module is designed for developers, do not use it to convert Odoo module or other community modules without permission
*IMPORTANT* The module only converts content within the selected module and skips content that inherits other modules

What this modules currently does

• Connects to MySQL database via odbc
• Creates MySQL tables from models created by the selected module
• Converts Odoo char fields to MySQL varchar datatype

What this modules currently does not do

• Everthing else

Install PyODBC Ubuntu

• sudo apt install python3-pip
• sudo apt install unixodbc-dev
• sudo pip3 install pyodbc

Setup MySQL connection

• Download driver from offical website https://dev.mysql.com/downloads/connector/odbc/
• Extract and copy files under lib folder to /usr/lib/x86_64-linux-gnu/odbc/
• Edit /etc/odbcinst.ini file and specify driver path

MySQL 5 example

[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc5a.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
FileUsage = 1

• Edit the /etc/odbc.ini file, actual connection details are provided inside Odoo

[my-connector]
Description           = MySQL connection to  database
Driver                = MySQL

• In Odoo hit the "Check Data Sources" button so the newly setup driver can be selected
• Finally hit the "Test Connection" button to make sure everything works, you may need to specify that the MySQL user can connect from the Odoo server host IP