Skip to Content

Contributors

Odoo Show

I have been working for fun on this little tool (https://github.com/chienandalu/odooshow) to facilitate the inspection of the data of a recordset. Any time you're into the Odoo shell either debugging any process or entering the console in a production instance we can import the show method of the library and we will see a table with the default tree fields for that record. Something like this:

image.png

Even more, you'll get links to the records urls so you can inspect them directly in the browser! (only in consoles that support console links).

By adding more attributes we can create more complex views by deciding which fields to show, grouping the records, etc. I'm working on documentation, for the moment you can see the code itself ;)

You can see a demo here -> https://asciinema.org/a/525597

image.png

There's also limited support for OdooRPC, but some special cases need to be covered.

To render the tables, I'm using the fantastic rich (https://github.com/Textualize/rich) which I can't stop recommending to everyone :)

I hope you enjoy it! (PRs and issues are welcome :))

David


by David Vidal - 12:00 - 5 Oct 2022

Follow-Ups

  • Re: Odoo Show
    > Thumbs up for sharing in the OCA and maybe doing a small lightning talk during the OCA event. What do you think?

    I'd wish to! But I'll be joining the Owl course in Brussels those days :( Anyway, I can record a small video if I can find the time...

    El mié, 5 oct 2022 a las 12:01, Frederik Kramer (<notifications@odoo-community.org>) escribió:

    HI David,

    that is pretty useful. Finally we can get rid of PGAdmin then ;-) at least for the report and display part.

    Thumbs up for sharing in the OCA and maybe doing a small lightning talk during the OCA event. What do you think?

    Best Frederik

    Am 05.10.22 um 00:02 schrieb David Vidal:
    I have been working for fun on this little tool (https://github.com/chienandalu/odooshow) to facilitate the inspection of the data of a recordset. Any time you're into the Odoo shell either debugging any process or entering the console in a production instance we can import the show method of the library and we will see a table with the default tree fields for that record. Something like this:

    image.png

    Even more, you'll get links to the records urls so you can inspect them directly in the browser! (only in consoles that support console links).

    By adding more attributes we can create more complex views by deciding which fields to show, grouping the records, etc. I'm working on documentation, for the moment you can see the code itself ;)

    You can see a demo here -> https://asciinema.org/a/525597

    image.png

    There's also limited support for OdooRPC, but some special cases need to be covered.

    To render the tables, I'm using the fantastic rich (https://github.com/Textualize/rich) which I can't stop recommending to everyone :)

    I hope you enjoy it! (PRs and issues are welcome :))

    David

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    -- 
    Dr.-Ing. Frederik Kramer
    Geschäftsführer
    
    initOS GmbH
    Innungsstraße 7
    21244 Buchholz i.d.N.
    
    Phone:  +49 4181 13503-12
    Fax:    +49 4181 13503-10
    Mobil:  +49 179 3901819
    
    Email: frederik.kramer@initos.com
    Web:   www.initos.com
    
    Geschäftsführung:
    Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke
    
    Sitz der Gesellschaft: Buchholz i.d.N.
    Amtsgericht Tostedt, HRB 205226
    Steuer-Nr: 15/200/53247
    USt-IdNr.: DE815580155

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe


    by David Vidal - 02:01 - 5 Oct 2022
  • Re: Odoo Show
    Thanks for the fix, Simon :D

    El mié, 5 oct 2022 a las 10:47, Simon Maillard (<notifications@odoo-community.org>) escribió:
    On 05/10/2022 00:02, David Vidal wrote:
    
    
    > I have been working for fun on this little tool 
    
    
    > (https://github.com/chienandalu/odooshow 
    
    
    > <https://github.com/chienandalu/odooshow>) to facilitate the inspection 
    
    
    > of the data of a recordset.
    
    Hi,
    Tested and adopted, It's awesome.
    I used it from pytest to inspect objects, it will for sure save a lot of 
    time when debugging or writing tests.
    
    Just to share my happiness:
    
    
    add to your test method:
    
    ```
    import ipdb; ipdb.set_trace()
    ```
    
    from your test server/vm/container/python ide:
    ```
    $ pip3 install odooshow ipdb
    $ cd /path/to/my_adddon
    $ export PYTEST_ADDOPTS='--pdb --pdbcls=IPython.terminal.debugger:Pdb'
    $ pytest -s -vv --odoo-database=tests 
    --odoo-config=/var/lib/odoo/tests_odoo.conf --pdb 
    tests/test_hr_timesheet_ovetime.py::TestHrOvertime::test_2_overtime_sheet_is_created_on_overtime
    ```
    
    Let's play with odooshow from ipdb
    
    ```
    ipdb> from odooshow import show
    ipdb> show(self.OvertimePeriod.search([])
    ...
    ```
    
    ps: Got an error if the object don't have URL (The same has Quentin 
    spoke about).
    I made a quick hack for now  but I will submit a clean PR today.
    
    
    Thank you David for odooshow !
    
    Regards,
    Simon
    
    
    
    
    -- 
    Simon Maillard
    simon@ogesta.fr - 0680587358
    
    Parce que sinon ça rend la discussion incompréhensible.
     > Pourquoi ça ?
     >> Je préfère répondre en dessous.
     >>> Que faites-vous à la place ?
     >>>> Non.
     >>>>> Vous n'aimez pas répondre au-dessus ?
    
    

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe


    by David Vidal - 01:55 - 5 Oct 2022
  • Re: Odoo Show
    Thanks!

    > I just have unexepected "object has no attribute 'get_base_url'" but i'm gonna dig a bit to really understand how to use it right (or maybe open a issue) !

    Simon Maillard just contributed with the fix (https://github.com/chienandalu/odooshow/pull/2) so it will be compatible with Odoo v12 (only python >=3.6 thou). It will be available in the next release :)

    El mié, 5 oct 2022 a las 9:17, Quentin Dupont (<notifications@odoo-community.org>) escribió:

    Hello,

    Wow such a nice tool !
    Installation and firsts tests works fine !

    I just have unexepected "object has no attribute 'get_base_url'" but i'm gonna dig a bit to really understand how to use it right (or maybe open a issue) !


    Le 05/10/2022 à 09:02, Jay Vora a écrit :
    Nice one! Thanks

    On Wed, Oct 5, 2022 at 3:32 AM David Vidal <notifications@odoo-community.org> wrote:
    I have been working for fun on this little tool (https://github.com/chienandalu/odooshow) to facilitate the inspection of the data of a recordset. Any time you're into the Odoo shell either debugging any process or entering the console in a production instance we can import the show method of the library and we will see a table with the default tree fields for that record. Something like this:

    image.png

    Even more, you'll get links to the records urls so you can inspect them directly in the browser! (only in consoles that support console links).

    By adding more attributes we can create more complex views by deciding which fields to show, grouping the records, etc. I'm working on documentation, for the moment you can see the code itself ;)

    You can see a demo here -> https://asciinema.org/a/525597

    image.png

    There's also limited support for OdooRPC, but some special cases need to be covered.

    To render the tables, I'm using the fantastic rich (https://github.com/Textualize/rich) which I can't stop recommending to everyone :)

    I hope you enjoy it! (PRs and issues are welcome :))

    David

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe



    --

    Technology Services @ www.serpentcs.com
    Business Solutions @ www.serpentcs.in
    Enterprise Mobile Apps @ www.odooonline.com 
    Quality Assurance @ www.odooqa.com
    Portal & DMS @ www.alfray.in



    Regards,
    ----------------------------------------------------------------------------------------------------------------------------
    Jay Vora
    Managing Director


     
    Direct: +91-9879354457
    Office: +91-9033472982
    Skype: jaynvora
    Twitter : jaynvora

       
    -------------------------------------------------------------------------------------------------
    Visit our website : http://www.serpentcs.com


    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    --

    GRAP
    Quentin DUPONT Informaticien

    Pôle informatique 09 73 79 64 40 - Bureau 09 72 32 33 17

    GRAP - Groupement Régional Alimentaire de Proximité

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe


    by David Vidal - 01:55 - 5 Oct 2022
  • Re: Odoo Show

    HI David,

    that is pretty useful. Finally we can get rid of PGAdmin then ;-) at least for the report and display part.

    Thumbs up for sharing in the OCA and maybe doing a small lightning talk during the OCA event. What do you think?

    Best Frederik

    Am 05.10.22 um 00:02 schrieb David Vidal:
    I have been working for fun on this little tool (https://github.com/chienandalu/odooshow) to facilitate the inspection of the data of a recordset. Any time you're into the Odoo shell either debugging any process or entering the console in a production instance we can import the show method of the library and we will see a table with the default tree fields for that record. Something like this:

    image.png

    Even more, you'll get links to the records urls so you can inspect them directly in the browser! (only in consoles that support console links).

    By adding more attributes we can create more complex views by deciding which fields to show, grouping the records, etc. I'm working on documentation, for the moment you can see the code itself ;)

    You can see a demo here -> https://asciinema.org/a/525597

    image.png

    There's also limited support for OdooRPC, but some special cases need to be covered.

    To render the tables, I'm using the fantastic rich (https://github.com/Textualize/rich) which I can't stop recommending to everyone :)

    I hope you enjoy it! (PRs and issues are welcome :))

    David

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    -- 
    Dr.-Ing. Frederik Kramer
    Geschäftsführer
    
    initOS GmbH
    Innungsstraße 7
    21244 Buchholz i.d.N.
    
    Phone:  +49 4181 13503-12
    Fax:    +49 4181 13503-10
    Mobil:  +49 179 3901819
    
    Email: frederik.kramer@initos.com
    Web:   www.initos.com
    
    Geschäftsführung:
    Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke
    
    Sitz der Gesellschaft: Buchholz i.d.N.
    Amtsgericht Tostedt, HRB 205226
    Steuer-Nr: 15/200/53247
    USt-IdNr.: DE815580155

    by Frederik Kramer - 12:01 - 5 Oct 2022
  • Re: Odoo Show
    Wow! Great!
    Congrats for the great work and thanks for sharing!

    Ing. Juan José Scarafía

    (+54 9 341) 3 278039

    twitter: @jjscarafia

    github: @jjscarafia



    El mié, 5 oct 2022 a la(s) 05:47, Simon Maillard (notifications@odoo-community.org) escribió:
    On 05/10/2022 00:02, David Vidal wrote:
    
    
    > I have been working for fun on this little tool 
    
    
    > (https://github.com/chienandalu/odooshow 
    
    
    > <https://github.com/chienandalu/odooshow>) to facilitate the inspection 
    
    
    > of the data of a recordset.
    
    Hi,
    Tested and adopted, It's awesome.
    I used it from pytest to inspect objects, it will for sure save a lot of 
    time when debugging or writing tests.
    
    Just to share my happiness:
    
    
    add to your test method:
    
    ```
    import ipdb; ipdb.set_trace()
    ```
    
    from your test server/vm/container/python ide:
    ```
    $ pip3 install odooshow ipdb
    $ cd /path/to/my_adddon
    $ export PYTEST_ADDOPTS='--pdb --pdbcls=IPython.terminal.debugger:Pdb'
    $ pytest -s -vv --odoo-database=tests 
    --odoo-config=/var/lib/odoo/tests_odoo.conf --pdb 
    tests/test_hr_timesheet_ovetime.py::TestHrOvertime::test_2_overtime_sheet_is_created_on_overtime
    ```
    
    Let's play with odooshow from ipdb
    
    ```
    ipdb> from odooshow import show
    ipdb> show(self.OvertimePeriod.search([])
    ...
    ```
    
    ps: Got an error if the object don't have URL (The same has Quentin 
    spoke about).
    I made a quick hack for now  but I will submit a clean PR today.
    
    
    Thank you David for odooshow !
    
    Regards,
    Simon
    
    
    
    
    -- 
    Simon Maillard
    simon@ogesta.fr - 0680587358
    
    Parce que sinon ça rend la discussion incompréhensible.
     > Pourquoi ça ?
     >> Je préfère répondre en dessous.
     >>> Que faites-vous à la place ?
     >>>> Non.
     >>>>> Vous n'aimez pas répondre au-dessus ?
    
    

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe


    by Juan José Scarafía - 11:16 - 5 Oct 2022