SQL Request Abstract

Implemented features

• Add some restrictions in the sql request:
  • you can only read datas. No update, deletion or creation are possible.
  • some tables are not allowed, because they could contains clear password or keys. For the time being (‘ir_config_parameter’).
• The request can be in a ‘draft’ or a ‘SQL Valid’ status. To be valid, the request has to be cleaned, checked and tested. All of this operations can be disabled in the inherited modules.
• This module adds two new groups:
  • SQL Request / User : Can see all the sql requests by default and execute them, if they are valid.
  • SQL Request / Manager : has full access on sql requests.

Table of contents

from odoo import models
class MyModel(models.model)
    _name = 'my.model'
    _inherit = ['sql.request.mixin']
    _sql_request_groups_relation = 'my_model_groups_rel'
    _sql_request_users_relation = 'my_model_users_rel'

Authors

• GRAP
• Akretion

Contributors

• Florian da Costa <florian.dacosta@akretion.com>
• Sylvain LE GAL (https://twitter.com/legalsylvain)
• Alfadil Tabar (alfadil.tabar@gmail.com)
• Helly kapatel <helly.kapatel@initos.com>
• Nguyen Minh Chien <chien@trobz.com>
• Vo Hong Thien <thienvh@trobz.com>

Maintainers

This module is maintained by the OCA.

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

Current maintainer:

This module is part of the OCA/reporting-engine project on GitHub.

You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.