Module: sql_request_abstract - Odoo Module Metadata

TIP: You can type at any time to perform a new search.

SQL Request Abstract

sql_request_abstract

REPOSITORY
REPOSITORY	OCA/reporting-engine
GIT
GIT	https://github.com/OCA/reporting-engine.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/reporting-engine/tree/19.0/sql_request_abstract
VERSION
VERSION	1.0.0
CATEGORY
CATEGORY	Tools
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	Weblate, OCA-git-bot, oca-ci, Franco Leyes
WEBSITE
WEBSITE	https://github.com/OCA/reporting-engine
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 19:40:46
ODOO DEPENDENCIES
ODOO DEPENDENCIES	odoo/odoo: - mail - base - base_setup - web - bus - web_tour - html_editor
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION	This module provides an abstract model to manage SQL Select requests on database. It is not usefull for itself. You can see an example of implementation in the 'sql_export' module. (same repository). ## 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.

Code Analysis ⓘ

Views touched (2)

XML ID	Name	Model	Type	Status
`view_sql_request_mixin_form`		sql.request.mixin	form	New
`view_sql_request_mixin_tree`		sql.request.mixin	list	New

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (8)

group_ids Many2many → res.groups
column1='sql_id' column2='group_id' comodel_name='res.groups' default=<expr> relation=_sql_request_groups_relation string='Allowed Groups'
has_group_changed Boolean
copy=False help='Technical fields, used in modules that depends on this one to know if groups has changed, and that according access should be updated.'
name Char
required=True
note Html
query Text
help="You can't use the following words: DELETE, DROP, CREATE, INSERT, ALTER, TRUNCATE, EXECUTE, UPDATE." required=True
state Selection
default='draft' help="State of the Request:\n * 'Draft': Not tested\n * 'SQL Valid': SQL Request has been checked and is valid" selection=STATE_SELECTION
use_external_database Boolean
help='If filled, the query will be executed against an external database, configured in Odoo main configuration file. '
user_ids Many2many → res.users
column1='sql_id' column2='user_id' comodel_name='res.users' default=<expr> relation=_sql_request_users_relation string='Allowed Users'

Public methods (5)

button_preview_sql_expression(self)
button_set_draft(self)
button_validate_sql_expression(self)
check_external_config(self)
@api.constrains('use_external_database')
onchange_group_ids(self)
@api.onchange('group_ids')

REPOSITORY
REPOSITORY	OCA/reporting-engine
GIT
GIT	https://github.com/OCA/reporting-engine.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/reporting-engine/tree/18.0/sql_request_abstract
VERSION
VERSION	1.0.0
CATEGORY
CATEGORY	Tools
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	Weblate, OCA-git-bot, oca-ci, thien
WEBSITE
WEBSITE	https://github.com/OCA/reporting-engine
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 19:30:07
ODOO DEPENDENCIES
ODOO DEPENDENCIES	odoo/odoo: - mail - base - base_setup - web - bus - web_tour - html_editor
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION	This module provides an abstract model to manage SQL Select requests on database. It is not usefull for itself. You can see an exemple of implementation in the 'sql_export' module. (same repository). ## 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 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.

Code Analysis ⓘ

Views touched (2)

XML ID	Name	Model	Type	Status
`view_sql_request_mixin_form`		sql.request.mixin	form	New
`view_sql_request_mixin_tree`		sql.request.mixin	list	New

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (8)

group_ids Many2many → res.groups
column1='sql_id' column2='group_id' comodel_name='res.groups' default=_default_group_ids relation=_sql_request_groups_relation string='Allowed Groups'
has_group_changed Boolean
copy=False help='Technical fields, used in modules that depends on this one to know if groups has changed, and that according access should be updated.'
name Char
required=True
note Html
query Text
help="You can't use the following words: DELETE, DROP, CREATE, INSERT, ALTER, TRUNCATE, EXECUTE, UPDATE." required=True
state Selection
default='draft' help="State of the Request:\n * 'Draft': Not tested\n * 'SQL Valid': SQL Request has been checked and is valid" selection=STATE_SELECTION
use_external_database Boolean
help='If filled, the query will be executed against an external database, configured in Odoo main configuration file. '
user_ids Many2many → res.users
column1='sql_id' column2='user_id' comodel_name='res.users' default=_default_user_ids relation=_sql_request_users_relation string='Allowed Users'

Public methods (5)

button_preview_sql_expression(self)
button_set_draft(self)
button_validate_sql_expression(self)
check_external_config(self)
@api.constrains('use_external_database')
onchange_group_ids(self)
@api.onchange('group_ids')

REPOSITORY
REPOSITORY	OCA/reporting-engine
GIT
GIT	https://github.com/OCA/reporting-engine.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/reporting-engine/tree/17.0/sql_request_abstract
VERSION
VERSION	1.0.1
CATEGORY
CATEGORY	Tools
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	Weblate, OCA-git-bot, oca-ci, chien
WEBSITE
WEBSITE	https://github.com/OCA/reporting-engine
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 19:20:00
ODOO DEPENDENCIES
ODOO DEPENDENCIES	odoo/odoo: - mail - base - base_setup - web - bus - web_tour
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION	This module provides an abstract model to manage SQL Select requests on database. It is not usefull for itself. You can see an exemple of implementation in the 'sql_export' module. (same repository). ## 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 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.

Code Analysis ⓘ

Views touched (2)

XML ID	Name	Model	Type	Status
`view_sql_request_mixin_form`		sql.request.mixin	form	New
`view_sql_request_mixin_tree`		sql.request.mixin	tree	New

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (7)

group_ids Many2many → res.groups
column1='sql_id' column2='group_id' comodel_name='res.groups' default=_default_group_ids relation=_sql_request_groups_relation string='Allowed Groups'
has_group_changed Boolean
copy=False help='Technical fields, used in modules that depends on this one to know if groups has changed, and that according access should be updated.'
name Char
required=True
note Html
query Text
help="You can't use the following words: DELETE, DROP, CREATE, INSERT, ALTER, TRUNCATE, EXECUTE, UPDATE." required=True
state Selection
default='draft' help="State of the Request:\n * 'Draft': Not tested\n * 'SQL Valid': SQL Request has been checked and is valid" selection=STATE_SELECTION
user_ids Many2many → res.users
column1='sql_id' column2='user_id' comodel_name='res.users' default=_default_user_ids relation=_sql_request_users_relation string='Allowed Users'

Public methods (4)

button_preview_sql_expression(self)
button_set_draft(self)
button_validate_sql_expression(self)
onchange_group_ids(self)
@api.onchange('group_ids')

REPOSITORY
REPOSITORY	OCA/reporting-engine
GIT
GIT	https://github.com/OCA/reporting-engine.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/reporting-engine/tree/16.0/sql_request_abstract
VERSION
VERSION	1.0.0
CATEGORY
CATEGORY	Tools
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	Sylvain LE GAL, Weblate, OCA-git-bot, oca-ci
WEBSITE
WEBSITE	https://github.com/OCA/reporting-engine
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:53:57
ODOO DEPENDENCIES
ODOO DEPENDENCIES	odoo/odoo: - mail - base - base_setup - web - bus - web_tour
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (2)

XML ID	Name	Model	Type	Status
`view_sql_request_mixin_form`		sql.request.mixin	form	New
`view_sql_request_mixin_tree`		sql.request.mixin	tree	New

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (7)

group_ids Many2many → res.groups
column1='sql_id' column2='group_id' comodel_name='res.groups' default=_default_group_ids relation=_sql_request_groups_relation string='Allowed Groups'
has_group_changed Boolean
copy=False help='Technical fields, used in modules that depends on this one to know if groups has changed, and that according access should be updated.'
name Char
required=True
note Html
query Text
help="You can't use the following words: DELETE, DROP, CREATE, INSERT, ALTER, TRUNCATE, EXECUTE, UPDATE." required=True
state Selection
default='draft' help="State of the Request:\n * 'Draft': Not tested\n * 'SQL Valid': SQL Request has been checked and is valid" selection=STATE_SELECTION
user_ids Many2many → res.users
column1='sql_id' column2='user_id' comodel_name='res.users' default=_default_user_ids relation=_sql_request_users_relation string='Allowed Users'

Public methods (4)

button_preview_sql_expression(self)
button_set_draft(self)
button_validate_sql_expression(self)
onchange_group_ids(self)
@api.onchange('group_ids')

REPOSITORY
REPOSITORY	OCA/reporting-engine
GIT
GIT	https://github.com/OCA/reporting-engine.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/reporting-engine/tree/15.0/sql_request_abstract
VERSION
VERSION	1.0.0
CATEGORY
CATEGORY	Tools
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	OCA Transbot, Weblate, OCA-git-bot, oca-ci, mariadforgeflow
WEBSITE
WEBSITE	https://github.com/OCA/reporting-engine
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:46:42
ODOO DEPENDENCIES
ODOO DEPENDENCIES	odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (0)

No views found for this module.

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (5)

group_ids Many2many → res.groups
column1='sql_id' column2='group_id' comodel_name='res.groups' default=_default_group_ids relation=_sql_request_groups_relation string='Allowed Groups'
name Char
required=True
query Text
help="You can't use the following words: DELETE, DROP, CREATE, INSERT, ALTER, TRUNCATE, EXECUTE, UPDATE." required=True
state Selection
default='draft' help="State of the Request:\n * 'Draft': Not tested\n * 'SQL Valid': SQL Request has been checked and is valid" selection=STATE_SELECTION
user_ids Many2many → res.users
column1='sql_id' column2='user_id' comodel_name='res.users' default=_default_user_ids relation=_sql_request_users_relation string='Allowed Users'

Public methods (3)

button_preview_sql_expression(self)
button_set_draft(self)
button_validate_sql_expression(self)

REPOSITORY
REPOSITORY	OCA/server-tools
GIT
GIT	https://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/server-tools/tree/14.0/sql_request_abstract
VERSION
VERSION	1.3.0
CATEGORY
CATEGORY	Tools
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	Sylvain LE GAL, OCA Transbot, Florian da Costa, oca-travis, Weblate, OCA-git-bot, Tom Blauwendraat, Mourad, oca-ci, hkpatel
WEBSITE
WEBSITE	https://github.com/OCA/server-tools
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:41:05
ODOO DEPENDENCIES
ODOO DEPENDENCIES	odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (0)

No views found for this module.

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (6)

group_ids Many2many → res.groups
column1='sql_id' column2='group_id' comodel_name='res.groups' default=_default_group_ids relation=_sql_request_groups_relation string='Allowed Groups'
name Char
required=True args: 'Name'
query Text
help="You can't use the following words: DELETE, DROP, CREATE, INSERT, ALTER, TRUNCATE, EXECUTE, UPDATE." required=True string='Query'
state Selection
default='draft' help="State of the Request:\n * 'Draft': Not tested\n * 'SQL Valid': SQL Request has been checked and is valid" selection=STATE_SELECTION string='State'
use_external_database Boolean
help='If filled, the query will be executed against an external database, configured in Odoo main configuration file. '
user_ids Many2many → res.users
column1='sql_id' column2='user_id' comodel_name='res.users' default=_default_user_ids relation=_sql_request_users_relation string='Allowed Users'

Public methods (4)

button_preview_sql_expression(self)
button_set_draft(self)
button_validate_sql_expression(self)
check_external_config(self)
@api.constrains('use_external_database')

REPOSITORY
REPOSITORY	OCA/server-tools
GIT
GIT	https://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/server-tools/tree/13.0/sql_request_abstract
VERSION
VERSION	1.0.2
CATEGORY
CATEGORY	Tools
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	Stefan Rijnhart, Lois Rilo, OCA Transbot, oca-travis, Weblate, OCA-git-bot
WEBSITE
WEBSITE	https://github.com/OCA/server-tools
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:34:16
ODOO DEPENDENCIES
ODOO DEPENDENCIES	odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (0)

No views found for this module.

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (5)

group_ids Many2many → res.groups
column1='sql_id' column2='group_id' comodel_name='res.groups' default=_default_group_ids relation=_sql_request_groups_relation string='Allowed Groups'
name Char
required=True args: 'Name'
query Text
help="You can't use the following words: DELETE, DROP, CREATE, INSERT, ALTER, TRUNCATE, EXECUTE, UPDATE." required=True string='Query'
state Selection
default='draft' help="State of the Request:\n * 'Draft': Not tested\n * 'SQL Valid': SQL Request has been checked and is valid" selection=STATE_SELECTION string='State'
user_ids Many2many → res.users
column1='sql_id' column2='user_id' comodel_name='res.users' default=_default_user_ids relation=_sql_request_users_relation string='Allowed Users'

Public methods (2)

button_set_draft(self)
button_validate_sql_expression(self)

REPOSITORY
REPOSITORY	OCA/server-tools
GIT
GIT	https://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/server-tools/tree/12.0/sql_request_abstract
VERSION
VERSION	1.2.2
CATEGORY
CATEGORY	Tools
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	Sylvain LE GAL, OCA Transbot, Florian da Costa, David Beal, oca-travis, Weblate, OCA-git-bot, Tom Blauwendraat, Adrià Gil Sorribes
WEBSITE
WEBSITE	https://github.com/OCA/server-tools
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:29:22
ODOO DEPENDENCIES
ODOO DEPENDENCIES	odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (0)

No views found for this module.

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (5)

group_ids Many2many → res.groups
column1='sql_id' column2='group_id' comodel_name='res.groups' default=_default_group_ids relation=_sql_request_groups_relation string='Allowed Groups'
name Char
required=True args: 'Name'
query Text
help="You can't use the following words: DELETE, DROP, CREATE, INSERT, ALTER, TRUNCATE, EXECUTE, UPDATE." required=True string='Query'
state Selection
default='draft' help="State of the Request:\n * 'Draft': Not tested\n * 'SQL Valid': SQL Request has been checked and is valid" selection=STATE_SELECTION string='State'
user_ids Many2many → res.users
column1='sql_id' column2='user_id' comodel_name='res.users' default=_default_user_ids relation=_sql_request_users_relation string='Allowed Users'

Public methods (3)

button_preview_sql_expression(self)
@api.multi
button_set_draft(self)
@api.multi
button_validate_sql_expression(self)
@api.multi

REPOSITORY
REPOSITORY	OCA/server-tools
GIT
GIT	https://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/server-tools/tree/11.0/sql_request_abstract
VERSION
VERSION	1.0.1
CATEGORY
CATEGORY	Tools
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	OCA Transbot, oca-travis, Weblate, Tom Blauwendraat, hveficent
WEBSITE
WEBSITE	https://github.com/OCA/server-tools
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:23:59
ODOO DEPENDENCIES
ODOO DEPENDENCIES	odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (0)

No views found for this module.

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (5)

group_ids Many2many → res.groups
column1='sql_id' column2='group_id' comodel_name='res.groups' default=_default_group_ids relation=_sql_request_groups_relation string='Allowed Groups'
name Char
required=True args: 'Name'
query Text
help="You can't use the following words: DELETE, DROP, CREATE, INSERT, ALTER, TRUNCATE, EXECUTE, UPDATE." required=True string='Query'
state Selection
default='draft' help="State of the Request:\n * 'Draft': Not tested\n * 'SQL Valid': SQL Request has been checked and is valid" selection=STATE_SELECTION string='State'
user_ids Many2many → res.users
column1='sql_id' column2='user_id' comodel_name='res.users' default=_default_user_ids relation=_sql_request_users_relation string='Allowed Users'

Public methods (2)

button_set_draft(self)
@api.multi
button_validate_sql_expression(self)
@api.multi

REPOSITORY
REPOSITORY	OCA/server-tools
GIT
GIT	https://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/server-tools/tree/10.0/sql_request_abstract
VERSION
VERSION	1.0.1
CATEGORY
CATEGORY	Tools
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	Sylvain LE GAL, GitHub, mreficent, Stéphane Bidoul (ACSONE), OCA Transbot, oca-travis, Weblate
WEBSITE
WEBSITE	https://www.odoo-community.org
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:19:59
ODOO DEPENDENCIES
ODOO DEPENDENCIES	odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (0)

No views found for this module.

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (5)

group_ids Many2many → res.groups
column1='sql_id' column2='group_id' comodel_name='res.groups' default=_default_group_ids relation=_sql_request_groups_relation string='Allowed Groups'
name Char
required=True args: 'Name'
query Text
help="You can't use the following words: DELETE, DROP, CREATE, INSERT, ALTER, TRUNCATE, EXECUTE, UPDATE." required=True string='Query'
state Selection
default='draft' help="State of the Request:\n * 'Draft': Not tested\n * 'SQL Valid': SQL Request has been checked and is valid" selection=STATE_SELECTION string='State'
user_ids Many2many → res.users
column1='sql_id' column2='user_id' comodel_name='res.users' default=_default_user_ids relation=_sql_request_users_relation string='Allowed Users'

Public methods (2)

button_set_draft(self)
@api.multi
button_validate_sql_expression(self)
@api.multi

REPOSITORY
REPOSITORY	OCA/server-tools
GIT
GIT	https://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/server-tools/tree/9.0/sql_request_abstract
VERSION
VERSION	1.0.1
CATEGORY
CATEGORY	Tools
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	mreficent, Stéphane Bidoul (ACSONE), OCA Transbot, Florian da Costa, oca-travis, Weblate
WEBSITE
WEBSITE	https://www.odoo-community.org
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:15:22
ODOO DEPENDENCIES
ODOO DEPENDENCIES	odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (0)

No views found for this module.

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (5)

group_ids Many2many → res.groups
column1='sql_id' column2='group_id' comodel_name='res.groups' default=_default_group_ids relation=_sql_request_groups_relation string='Allowed Groups'
name Char
required=True args: 'Name'
query Text
help="You can't use the following words: DELETE, DROP, CREATE, INSERT, ALTER, TRUNCATE, EXECUTE, UPDATE." required=True string='Query'
state Selection
default='draft' help="State of the Request:\n * 'Draft': Not tested\n * 'SQL Valid': SQL Request has been checked and is valid" selection=STATE_SELECTION string='State'
user_ids Many2many → res.users
column1='sql_id' column2='user_id' comodel_name='res.users' default=_default_user_ids relation=_sql_request_users_relation string='Allowed Users'

Public methods (2)

button_set_draft(self)
@api.multi
button_validate_sql_expression(self)
@api.multi

REPOSITORY
REPOSITORY	OCA/server-tools
GIT
GIT	https://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/server-tools/tree/8.0/sql_request_abstract
VERSION
VERSION	1.0.1
CATEGORY
CATEGORY	Tools
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	Holger Brunn, Sylvain LE GAL, mreficent, Stéphane Bidoul (ACSONE), OCA Transbot, oca-travis, Weblate
WEBSITE
WEBSITE	https://www.odoo-community.org
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:11:25
ODOO DEPENDENCIES
ODOO DEPENDENCIES	odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (0)

No views found for this module.

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (5)

group_ids Many2many → res.groups
column1='sql_id' column2='group_id' comodel_name='res.groups' default=_default_group_ids relation=_sql_request_groups_relation string='Allowed Groups'
name Char
required=True args: 'Name'
query Text
help="You can't use the following words: DELETE, DROP, CREATE, INSERT, ALTER, TRUNCATE, EXECUTE, UPDATE." required=True string='Query'
state Selection
default='draft' help="State of the Request:\n * 'Draft': Not tested\n * 'SQL Valid': SQL Request has been checked and is valid" selection=STATE_SELECTION string='State'
user_ids Many2many → res.users
column1='sql_id' column2='user_id' comodel_name='res.users' default=_default_user_ids relation=_sql_request_users_relation string='Allowed Users'

Public methods (2)

button_set_draft(self)
@api.multi
button_validate_sql_expression(self)
@api.multi

SQL Request Abstract

Code Analysis ⓘ

Views touched (2)

HTTP endpoints (0)

Models touched (1)

sql.request.mixin New model AbstractModel 8 fields 5 methods SQLRequestMixin · inherits mail.thread · SQL Request Mixin

Code Analysis ⓘ

Views touched (2)

HTTP endpoints (0)

Models touched (1)

sql.request.mixin New model AbstractModel 8 fields 5 methods SQLRequestMixin · inherits mail.thread · SQL Request Mixin

Code Analysis ⓘ

Views touched (2)

HTTP endpoints (0)

Models touched (1)

sql.request.mixin New model AbstractModel 7 fields 4 methods SQLRequestMixin · inherits mail.thread · SQL Request Mixin

Code Analysis ⓘ

Views touched (2)

HTTP endpoints (0)

Models touched (1)

sql.request.mixin New model AbstractModel 7 fields 4 methods SQLRequestMixin · inherits mail.thread · SQL Request Mixin

Code Analysis ⓘ

Views touched (0)

HTTP endpoints (0)

Models touched (1)

sql.request.mixin New model AbstractModel 5 fields 3 methods SQLRequestMixin · SQL Request Mixin

Code Analysis ⓘ

Views touched (0)

HTTP endpoints (0)

Models touched (1)

sql.request.mixin New model AbstractModel 6 fields 4 methods SQLRequestMixin · SQL Request Mixin

Code Analysis ⓘ

Views touched (0)

HTTP endpoints (0)

Models touched (1)

sql.request.mixin New model AbstractModel 5 fields 2 methods SQLRequestMixin · SQL Request Mixin

Code Analysis ⓘ

Views touched (0)

HTTP endpoints (0)

Models touched (1)

sql.request.mixin New model AbstractModel 5 fields 3 methods SQLRequestMixin · SQL Request Mixin

Code Analysis ⓘ

Views touched (0)

HTTP endpoints (0)

Models touched (1)

sql.request.mixin New model AbstractModel 5 fields 2 methods SQLRequestMixin

Code Analysis ⓘ

Views touched (0)

HTTP endpoints (0)

Models touched (1)

sql.request.mixin New model AbstractModel 5 fields 2 methods SQLRequestMixin

Code Analysis ⓘ

Views touched (0)

HTTP endpoints (0)

Models touched (1)

sql.request.mixin New model AbstractModel 5 fields 2 methods SQLRequestMixin

Code Analysis ⓘ

Views touched (0)

HTTP endpoints (0)

Models touched (1)

sql.request.mixin New model AbstractModel 5 fields 2 methods SQLRequestMixin