Helma Logo
main list history

Version 11 by anton on 08. May 2008, 19:59

43
44The Backslash "\" is only necessary when you have a filter that continues in the next line.

Version 10 by anton on 08. May 2008, 18:31

40  tags.filter                  = ${image_id} = tags2images.images_image_id ANDAND

Version 9 by anton on 08. May 2008, 18:29

40  tags.filter                  = ${image_id} = tags2images.images_image_id AND tags2images.tags_tag_id = tags.tag_idAND
41                                  tags2images.tags_tag_id = tags.tag_id

Version 8 by anton on 08. May 2008, 18:29

22
39  tags                          = Collection(Tag)
40  tags.filter                  = ${image_id} = tags2images.images_image_id AND tags2images.tags_tag_id = tags.tag_id
41  tags.filter.additionalTables  = tags2images

Version 7 by anton on 08. May 2008, 18:03

22

Version 6 by anton on 08. May 2008, 18:03

1<b>Naming conventions</b>
2
3All 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.)
4
5Tablenames are plural.
6
7Prototype names start with upper case and are camel case. Prototype names are singular.
8
9Property- Object- and Collection-Mapping start with lower case and are also camel case.
10
11Foreign keys are prefixed with the name of the table they are referring to.
12
13
4<b>DB schema</b>
5
8<b>Mapping</b>
9
17<b>DB schema</b>
18
19
20
21<b>Mapping</b>

Version 5 by anton on 08. May 2008, 17:57

5

Version 4 by anton on 08. May 2008, 17:57

5<b>Gallery/type.properties</b>
6  images        = Collection(Image)
7  images.local  = gallery_id
8  images.foreign = galleries_gallery_id
7
11
12<b>Image/type.properties</b>

Version 3 by anton on 08. May 2008, 17:36

3test<% this.image name="1-to-n-relation.jpg" %>
8test<% this.image name="m-to-n-relation.jpg" %>
9

Version 2 by anton on 08. May 2008, 17:34

1<h2>1:n relation</h2>
2
3test
4
5
6<h2>m:n relation</h2>
7

Version 1 by anton on 08. May 2008, 17:23

1test