Execute Query

by
Odoo
v 13.0 Third Party 1826
Download for v 13.0 Deploy on Odoo.sh
Lines of code 96
Technical Name ms_query
LicenseLGPL-3
Websitehttps://blog.miftahussalam.com
Also available in version v 15.0 v 10.0 v 11.0 v 14.0 v 12.0
You bought this module and need support? Click here!
Lines of code 96
Technical Name ms_query
LicenseLGPL-3
Websitehttps://blog.miftahussalam.com
Also available in version v 15.0 v 10.0 v 11.0 v 14.0 v 12.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