Skip to Content

Execute Query

by
Odoo
v 13.0 Third Party 2507
Download for v 13.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 96
Technical Name ms_query
LicenseLGPL-3
Websitehttps://blog.miftahussalam.com
Versions 10.0 11.0 12.0 13.0 14.0 15.0 16.0 17.0 18.0 19.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 96
Technical Name ms_query
LicenseLGPL-3
Websitehttps://blog.miftahussalam.com
Versions 10.0 11.0 12.0 13.0 14.0 15.0 16.0 17.0 18.0 19.0

DDL and DML

Operations: SELECT, UPDATE, DELETE, etc.

Backup Query

Type syntax to execute in Syntax query column.

Save executed syntax in Backup query if needed.

Trace All Executed SQL Query

Monitoring user and syntax executed.

Contact

me@miftahussalam.com

https://blog.miftahussalam.com/

Execute Query From Odoo

Installation

Install this module in a usual way

Configuration

Activate Developer Mode

Usage

  • Go to Settings >> Technical >> Execute Query
  • Type query on Syntax query column
  • Click Execute button
  • RESULT: See result on Result column

Uninstallation

Uninstall this module in a usual way

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.
There are no ratings yet!
Doesn't seem to work on V12 C
by
David
on 10/24/20, 4:41 PM

Just installed on V12 Community. 

Executed the example query "select * from res_partner"


and got this error : 


Software Server Error
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/Software/http.py", line 656, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/usr/lib/python3/dist-packages/Software/http.py", line 314, in _handle_exception
    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
  File "/usr/lib/python3/dist-packages/Software/tools/pycompat.py", line 87, in reraise
    raise value
  File "/usr/lib/python3/dist-packages/Software/http.py", line 698, in dispatch
    result = self._call_function(**self.params)
  File "/usr/lib/python3/dist-packages/Software/http.py", line 346, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/Software/service/model.py", line 97, in wrapper
    return f(dbname, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/Software/http.py", line 339, in checked_call
    result = self.endpoint(*a, **kw)
  File "/usr/lib/python3/dist-packages/Software/http.py", line 941, in __call__
    return self.method(*args, **kw)
  File "/usr/lib/python3/dist-packages/Software/http.py", line 519, in response_wrap
    response = f(*args, **kw)
  File "/usr/lib/python3/dist-packages/Software/addons/web/controllers/main.py", line 966, in call_button
    action = self._call_kw(model, method, args, {})
  File "/usr/lib/python3/dist-packages/Software/addons/web/controllers/main.py", line 954, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/usr/lib/python3/dist-packages/Software/api.py", line 759, in call_kw
    return _call_kw_multi(method, model, args, kwargs)
  File "/usr/lib/python3/dist-packages/Software/api.py", line 746, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "/mnt/extra-addons/ms_query/models/ms_query.py", line 43, in execute_query
    self.message_post('%s<br><br>Executed on %s'%(self.name,str(self.get_real_datetime())[:19]))
TypeError: message_post() takes 1 positional argument but 2 were given