TIP: You can type at any time to perform a new search.
SQL Export
sql_export · OCA/reporting-engine
Security findings
Migration considerations
- Raw `cr.execute()` INSERT/UPDATE/DELETE bypasses the ORM (no compute/constrains/tracking/mail): `UPDATE sql_export SET last_execution_date = %s, last_execution_uid = %s WHERE id = %s` - re-check the table/column names still match after upgrading. migration-raw-sql-write · source
Migration review checklist, not a compatibility verdict. No target version is selected: apply version-specific advice only when migrating to that version or later.
- Repository
- OCA/reporting-engine · module folder · Try on Runboat
- Module version
- 1.1.1
- Category
- Generic Modules/Others
- Folder size
- 0.89 MB
- License
- AGPL-3
- Application
- No
- Auto-installable
- No
- Website
- https://github.com/OCA/reporting-engine
- Last tracking update
- 2026-08-07 08:43:02
- Authors
- Akretion, Odoo Community Association (OCA), GRAP
- Maintainers
- Akretion, Odoo Community Association (OCA), GRAP
- Committers
- Miquel Raïch, Florian da Costa, David Beal, Weblate, OCA-git-bot, oca-ci
- Odoo dependencies
- Python dependencies
- None
- System dependencies
- None
- Required by
- sql_export_delta, sql_export_excel, sql_export_mail
- Description
Allow to export data in csv files FROM sql requests. There are some restrictions in the sql query, you can only read datas. No update, deletion or creation are possible. A new sub menu named Sql Export is available in the Dashboard main menu.
Code Analysis
Views touched (3)
| XML ID | Name | Model | Type | Status |
|---|---|---|---|---|
sql_export_view_form |
sql.export | form | Inherits sql_request_abstract.view_sql_request_mixin_form | |
sql_export_view_tree |
sql.export | tree | Inherits sql_request_abstract.view_sql_request_mixin_tree | |
sql_file_wizard_view_form |
sql.file.wizard.view.form | sql.file.wizard | form | New |
HTTP endpoints (0)
No HTTP endpoints found for this module.
Models touched (2)
New fields (7)
-
copy_optionsChardefault="CSV HEADER DELIMITER ';'"required=False -
encodingSelectiondefault='utf-8'required=True args: [('utf-8', 'utf-8'), ('utf-16', 'utf-16'), ('windows-1252', 'windows-1252'), ('latin1', 'latin1'), ('latin2', 'latin2'), ('big5', 'big5'), ('gb18030', 'gb18030'), ('shift_jis', 'shift_jis'), ('windows-1251', 'windows-1251'), ('koir8_r', 'koir8_r')] -
file_formatSelectiondefault='csv'required=True args: [('csv', 'CSV')] -
last_execution_dateDatetimereadonly=True -
last_execution_uidMany2one → res.usersreadonly=Truestring='Last execution User' args: 'res.users' -
query_properties_definitionPropertiesDefinitionargs: 'Query Properties' -
use_propertiesBooleancompute='_compute_use_properties'
-
configure_properties(self) -
csv_get_data_from_query(self, variable_dict) -
export_sql_query(self)
New fields (4)
-
binary_fileBinaryreadonly=True args: 'File' -
file_nameCharreadonly=True -
query_propertiesPropertiescopy=Falsedefinition='sql_export_id.query_properties_definition'string='Properties' -
sql_export_idMany2one → sql.exportcomodel_name='sql.export'required=True
-
export_sql(self)
Loading…
Loading…
Loading…
Loading…
Loading…
Loading…
Loading…
Loading…
Loading…
- Status
- Open migration PR — not merged yet for this version
- CI status
- green — ready to merge
- Open since
- 75 days ago
- Last activity
- 75 days ago
- Repository
- OCA/reporting-engine
- Pull request
- [19.0][MIG] sql_export: Migration to 19.0 (#1180)
- Status
- Open migration PR — not merged yet for this version
- CI status
- green — ready to merge
- Open since
- 239 days ago
- Last activity
- 103 days ago
- Repository
- OCA/reporting-engine
- Pull request
- [19.0][MIG] sql export: Migration to 19.0 (#1128)