[xwiki-devs] [proposal] Begin using database column names which match the names of the object properties and table names which match the class name.
15 Oct
2010
15 Oct
'10
9:41 p.m.
In order to make direct sql queries as similar to hql as possible (and as easy as
possible), I
propose that for any new database columns or tables, we begin using column names which
match the
name of the java object properties, and table names which match the class name.
I would like to put a note at the top of xwiki.hbm.xml which says:
<!--
All new table names should be all lower case versions of the name of the class which they
represent
for example:
XWikiDocument should map to a table called xwikidocument
All new column names should be all lower case versions of the property which they
represent for example:
fullName should map to a column called fullname
-->
WDYT?
Caleb
15 Oct
15 Oct
9:57 p.m.
On 10/15/2010 09:41 PM, Caleb James DeLisle wrote:
In order to make direct sql queries as similar to hql
as possible (and as easy as possible), I
propose that for any new database columns or tables, we begin using column names which
match the
name of the java object properties, and table names which match the class name.
I would like to put a note at the top of xwiki.hbm.xml which says:
<!--
All new table names should be all lower case versions of the name of the class which they
represent
for example:
XWikiDocument should map to a table called xwikidocument
All new column names should be all lower case versions of the property which they
represent for example:
fullName should map to a column called fullname
-->
WDYT?
Well, I doubt that we'll add any more tables or columns. But this rule
is valid, and we should keep it in mind when we re-implement the
hibernate storage.
--
Sergiu Dumitriu
http://purl.org/net/sergiu/
10:29 p.m.
On 10/15/2010 03:57 PM, Sergiu Dumitriu wrote:
On 10/15/2010 09:41 PM, Caleb James DeLisle wrote:
I favor evolution over big rewrites simply because we can improve things now and we
don't have to
scale mountains in a single step.
In order to make direct sql queries as similar to
hql as possible (and as easy as possible), I
propose that for any new database columns or tables, we begin using column names which
match the
name of the java object properties, and table names which match the class name.
I would like to put a note at the top of xwiki.hbm.xml which says:
<!--
All new table names should be all lower case versions of the name of the class which they
represent
for example:
XWikiDocument should map to a table called xwikidocument
All new column names should be all lower case versions of the property which they
represent for example:
fullName should map to a column called fullname
-->
WDYT?
Well, I doubt that we'll add any more tables or columns. But this rule
is valid, and we should keep it in mind when we re-implement the
hibernate storage.
Can I put you down as +1 for adding the note even if it only helps remind us when we do
the "big
rewrite"?
16 Oct
16 Oct
11:48 a.m.
On 10/15/2010 10:29 PM, Caleb James DeLisle wrote:
On 10/15/2010 03:57 PM, Sergiu Dumitriu wrote:
Yes.
--
Sergiu Dumitriu
http://purl.org/net/sergiu/
On 10/15/2010 09:41 PM, Caleb James DeLisle
wrote:
I favor evolution over big rewrites simply because we can improve things now and we
don't have to
scale mountains in a single step.
In order to make direct sql queries as similar to
hql as possible (and as easy as possible), I
propose that for any new database columns or tables, we begin using column names which
match the
name of the java object properties, and table names which match the class name.
I would like to put a note at the top of xwiki.hbm.xml which says:
<!--
All new table names should be all lower case versions of the name of the class which they
represent
for example:
XWikiDocument should map to a table called xwikidocument
All new column names should be all lower case versions of the property which they
represent for example:
fullName should map to a column called fullname
-->
WDYT?
Well, I doubt that we'll add any more tables or columns. But this rule
is valid, and we should keep it in mind when we re-implement the
hibernate storage.
Can I put you down as +1 for adding the note even if it only helps remind us when we do
the "big
rewrite"? 
18 Oct
18 Oct
3:18 p.m.
+1
Alex
On 10/15/2010 09:41 PM, Caleb James DeLisle wrote:
In order to make direct sql queries as similar to hql
as possible (and as easy as possible), I
propose that for any new database columns or tables, we begin using column names which
match the
name of the java object properties, and table names which match the class name.
I would like to put a note at the top of xwiki.hbm.xml which says:
<!--
All new table names should be all lower case versions of the name of the class which they
represent
for example:
XWikiDocument should map to a table called xwikidocument
All new column names should be all lower case versions of the property which they
represent for example:
fullName should map to a column called fullname
-->
WDYT?
Caleb
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs
5082
days inactive
5085
days old
4 comments
3 participants
participants (3)
-
Alex Busenius -
Caleb James DeLisle -
Sergiu Dumitriu