Implement and showing many to many relations?

Next topic

Author	Message
Adolfo Barragán	Tuesday 25 March 2003 2:37:38 am I'm newbie in ez publish, and I don't know how to implement many to many relations. In a database model, I make the following but, how can I do in ez publish? I the conceptual model Ihave 3 classes (Countries, Packs, Species) and 3 relations: Countries--Packs (1:M); Countries--Species (M:M) and Packs--Species (M:M). In addition, the relation Countries-Species have their owns attributes and also the relation Packs-Species. So, In the physical model I have 5 classes (tables): Countries, Packs, Species, Countries_Species, Packs_Species and their relations are: Countries--Packs (1:M) Countries--Country_Species (1:M) Species--Country_Species (1:M) Packs--Pack_Species (1:M) Species--Pack_Species (1:M) When an user click on "content/view/full/Country_Id" I need show the attributes of Country_Id plus a list of Species of that country (and attributes of relation) plus a list of Packs of that country. Similary with "content/view/full/Pack_Id", I need show Pack's attributes plus a list of Pack's Species (and attributes of relation). And finally, when the user click on "content/view/full/Specie_Id I need show Specie's attributes plus a list of Packs and Countries where Specie is assigned to. I'm sorry the extension of question but I'm weeks to battle with this and I don't find a solution. Thanks in advance

Author

Message

Tuesday 25 March 2003 2:37:38 am

I'm newbie in ez publish, and I don't know how to implement many to many relations. In a database model, I make the following but, how can I do in ez publish?

I the conceptual model Ihave 3 classes (Countries, Packs, Species) and 3 relations: Countries--Packs (1:M); Countries--Species (M:M) and Packs--Species (M:M). In addition, the relation Countries-Species have their owns attributes and also the relation Packs-Species.

So, In the physical model I have 5 classes (tables): Countries, Packs, Species, Countries_Species, Packs_Species and their relations are:
Countries--Packs (1:M)
Countries--Country_Species (1:M)
Species--Country_Species (1:M)
Packs--Pack_Species (1:M)
Species--Pack_Species (1:M)

When an user click on "content/view/full/Country_Id" I need show the attributes of Country_Id plus a list of Species of that country (and attributes of relation) plus a list of Packs of that country.

Similary with "content/view/full/Pack_Id", I need show Pack's attributes plus a list of Pack's Species (and attributes of relation).

And finally, when the user click on "content/view/full/Specie_Id I need show Specie's attributes plus a list of Packs and Countries where Specie is assigned to.

I'm sorry the extension of question but I'm weeks to battle with this and I don't find a solution.

Thanks in advance

eZ debug

Timing:	Jan 18 2025 11:37:43
Script start
Timing:	Jan 18 2025 11:37:43
Module start 'layout'
Timing:	Jan 18 2025 11:37:43
Module start 'content'
Timing:	Jan 18 2025 11:37:44
Module end 'content'
Timing:	Jan 18 2025 11:37:44
Script end

Main resources:

Total runtime	0.5711 sec
Peak memory usage	4,096.0000 KB
Database Queries	46

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0052	589.2969	152.6563
Module start 'layout'	0.0052	0.0034	741.9531	39.5078
Module start 'content'	0.0086	0.5608	781.4609	406.3516
Module end 'content'	0.5694	0.0016	1,187.8125	8.1094
Script end	0.5711		1,195.9219

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0033	0.5747	16	0.0002
Check MTime	0.0013	0.2284	16	0.0001
Mysql Total
Database connection	0.0006	0.1047	1	0.0006
Mysqli_queries	0.5334	93.3930	46	0.0116
Looping result	0.0004	0.0724	44	0.0000
Template Total	0.5443	95.3	2	0.2722
Template load	0.0024	0.4127	2	0.0012
Template processing	0.5420	94.8987	2	0.2710
Template load and register function	0.0002	0.0345	1	0.0002
states
state_id_array	0.0008	0.1333	1	0.0008
state_identifier_array	0.0012	0.2101	2	0.0006
Override
Cache load	0.0020	0.3463	16	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0004	0.0743	1	0.0004
Fetch class attribute name	0.0006	0.1094	1	0.0006
XML
Image XML parsing	0.0001	0.0245	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0007	1	0.0000
General
dbfile	0.0006	0.1007	10	0.0001
String conversion	0.0000	0.0017	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
1	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 6 Number of unique templates used: 5

Time used to render debug report: 0.0002 secs