Re: HQL queries and other short examples
Posted: Tue Oct 02, 2018 12:38 pm
Hi Manics,
is this HQL magic or is this OMERO specific magic? Any documentation for this?
I'm still in the dark as how to join two tables.
The documentation here
https://docs.openmicroscopy.org/omero/5.4.0/developers/GettingStarted.html
suggests that the OMERO model from here
https://docs.openmicroscopy.org/omero/5.4.0/developers/Model/EveryObject.html
is enough to get started - but I'm finding this quite a leap.
How does one navigate around around the HQL entity mappings when building stringy queries in python?
I made an ERD of the psql database with DbVisualizer but it wasn't very useful. Is there some hibernate tool that maps the relationships?
Thanks,
Chris
is this HQL magic or is this OMERO specific magic? Any documentation for this?
I'm still in the dark as how to join two tables.
The documentation here
https://docs.openmicroscopy.org/omero/5.4.0/developers/GettingStarted.html
suggests that the OMERO model from here
https://docs.openmicroscopy.org/omero/5.4.0/developers/Model/EveryObject.html
is enough to get started - but I'm finding this quite a leap.
How does one navigate around around the HQL entity mappings when building stringy queries in python?
I made an ERD of the psql database with DbVisualizer but it wasn't very useful. Is there some hibernate tool that maps the relationships?
Thanks,
Chris