Re: [Health-dev] Diagram of GNU Health postgresql tables

[Dr. Axel Braun]

Hi Gents,
 
I checked this on my installation, python310-pydot 1.4.2 is installed, 
graphviz 2.49 and python310-pygraphviz but it still breaks:

ERROR:gnuhealth.common.common:Traceback (most recent call last):
  File "/trytond/wsgi.py", line 117, in dispatch_request
    return endpoint(request, **request.view_args)
  File "/trytond/protocols/dispatcher.py", line 46, in rpc
    return methods.get(request.rpc_method, _dispatch)(
  File "/trytond/wsgi.py", line 84, in auth_required
    return wrapped(*args, **kwargs)
  File "/trytond/protocols/wrappers.py", line 159, in wrapper
    return func(request, pool, *args, **kwargs)
  File "/trytond/protocols/dispatcher.py", line 180, in _dispatch
    result = rpc.result(meth(*c_args, **c_kwargs))
  File "/trytond/ir/model.py", line 1499, in execute
    import pydot
ModuleNotFoundError: No module named 'pydot'

Cheers
Axel

Am Dienstag, 11. Oktober 2022, 14:47:54 CEST schrieb Gerald Wiese:
> Hi Luis,
> 
> Yannick and me had a look at this and we had to resolve missing
> dependencies.
> 
> After installing pydot using pip and graphviz as a system package it was
> working. On Ubuntu simply "pip install pydot" & "sudo apt install graphviz".
> 
> Not sure if this is a problem in every installation method. He used my
> ansible scripts and PyPI package gnuhealth-all-modules. In mercurial
> repos I can't find "pydot" or "graphviz" either.
> 
> Best
> 
> Gerald
> 
> On 29.09.22 21:16, Luis Falcon wrote:
> > Dear Yannick
> > On Thu, 29 Sep 2022 20:37:29 +0200
> > 
> > Yannick Busse <yannick.busse@stud.uni-hannover.de> wrote:
> >> Hello,
> >> 
> >> I am currently working on a project for my university for which I
> >> need to build queries for the postgresql of GNU Health. While looking
> >> through I've seen there to be around 160+ public tables and I was
> >> wondering, if there would happen to be a diagram of the postgresql
> >> database that would show the dependencies and references between the
> >> tables? For example what tables all contain information for patients,
> >> etc.
> >> 
> >> To get a better overview over the database would help my work a lot.
> > 
> > Thanks for reaching out! The models UML diagrams are accessible from the
> > GH client (Administration -> Models and use the Graph Report action).
> > 
> > I'm attaching one example here of a Level 1 graph of the patient as an
> > example.
> > 
> > Best regards
> > Luis


-- 
Dr.-Ing. Axel K. Braun 
M: +49.173.7003.154
T: @coogor
Matrix/Elements: @docb:matrix.org
PGP Fingerprint: 2E7F 3A19 A4A4 844A 3D09 7656 822D EB64 A3BA 290D
Public Key available at http://www.axxite.com/axel.braun@gmx.de.asc

Meet GNU Health at the GNUHealthCon 2022 in GranCanaria, 17-19 Nov 2022
https://www.gnuhealthcon.org/2022/