Difference between revisions of "GOCDB/Doctrine"
< GOCDB
Jump to navigation
Jump to search
Line 11: | Line 11: | ||
[[File:Get_Site_PROM.png|200px|thumb|left|PROM SQL]] | [[File:Get_Site_PROM.png|200px|thumb|left|PROM SQL]] | ||
[[File:Get_Site_Doctrine.png|200px|thumb|right|Doctrine SQL]] | [[File:Get_Site_Doctrine.png|200px|thumb|right|Doctrine SQL]] | ||
= Changes = | |||
The move to Doctrine will introduce changes to the GOCDB portal URLs and to the PRIMARY KEY, ID and GOCDB_PORTAL_URL fields of the GOCDB PI. | |||
== Portal URLs == | |||
In PROM, each "entity" (site, service endpoint, downtime) was assigned an ID from a global pool. There is only one object 123, it is the GRIDOPS-GOCDB site. The following URL is used to access an entity regardless of type: https://goc.egi.eu/portal/index.php?Page_Type=View_Object&object_id=123&grid_id=0 | |||
In Doctrine, each entity receives an ID unique only to that entity type. There is a site with ID 123, a service endpoint with ID 123 and a downtime with ID 123. |
Revision as of 13:46, 17 December 2012
<< Back to GOCDB/Release4/Development
Introduction
By replacing the PROM model with the Doctrine ORM GOCDB will support RDBMSs other than Oracle.
Benefits
- Write code once, deploy to Oracle, MySQL, Postgres, SQLite.
- Much simpler than the GOCDB/PROM model e.g.:
Changes
The move to Doctrine will introduce changes to the GOCDB portal URLs and to the PRIMARY KEY, ID and GOCDB_PORTAL_URL fields of the GOCDB PI.
Portal URLs
In PROM, each "entity" (site, service endpoint, downtime) was assigned an ID from a global pool. There is only one object 123, it is the GRIDOPS-GOCDB site. The following URL is used to access an entity regardless of type: https://goc.egi.eu/portal/index.php?Page_Type=View_Object&object_id=123&grid_id=0
In Doctrine, each entity receives an ID unique only to that entity type. There is a site with ID 123, a service endpoint with ID 123 and a downtime with ID 123.