helma.org » wiki » Object Reference Mapping (1:1 relation)

1	### under construction ###
2
22	Lets map the image_data to our image.!
29	This code is in the type.properties file of our Image prototype. We specify which prototype should be mapped with the Object() instruction. You have to specify the name of the prototype here. To the properties.local and .foreign you must assign the names of database columns.

3	<b>Naming-Conventions:Naming conventions</b>
15

15	<b>DB schema</b>
17	<b>Mapping</b>
20
21	<b>Mapping</b>
22
24	imageData = collectionObject(ImageData)
25	imageData.local = image_id
26	imageData.foreign = images_image_id

17	<% this.image name="1-to-1-relation.jpg" %>

17	<% this.image name="1-to-1.jpg" prefix="#" suffix="#" %>
18	<!-- <img src="http://dev.helma.org/static/files/2657/1-to-1.jpg" alt="Helma 1:1 Relation" /> -->

17	<% this.image name="1-to-1.jpg" prefix="#" suffix="#" %>
18	<!-- <img src="http://dev.helma.org/static/files/2657/1-to-1.jpg" alt="Helma 1:1 Relation" /> -->

18	<img src="http://dev.helma.org/static/files/2657/1-to-1.jpg" alt="Helma 1:1 Relation" />

9	Prototype names start with upper case and are camel case. Prototype names are singular.
11	Prototype names are singular.
12
24	imageData.foreign = image_idimages_image_id

7	Prototype names start with upper case and Tablenames are camel caseplural.
9	Prototype names start with upper case and are camel case.
10
11	Prototype names are singular.
12

3	<% image b>Naming-Conventions:%</b>
4	<% image "1-to-1.jpg" %>
5	<% image image="1-to-1.jpg" %>
5	All the tables and columns in the database are all lowercase. (Which is quite handy with an Mysql database because the names are case-sensitive if the underlying file system is also case-sensitive. So Mysql Names are case sensitive on Linux but not on Windows.)
6
7	Prototype names start with upper case and are camel case.
8
9	Property- Object- and Collection-Mapping start with lower case and are also camel case.
10
11	Foreign keys are prefixed with the name of the table they are referring to.
12
13
14	<b>Mapping</b>
15
16	Lets map the image_data to our image.
17
18	<b>Image/type.properties</b>
19	imageData = collection(ImageData)
20	imageData.local = image_id
21	imageData.foreign = image_id
22

1	### under construction ###

Tags