[xwiki-devs] [proposal] Begin using database column names which match the names of the object properties and table names which match the class name.
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
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/
On 10/15/2010 03:57 PM, Sergiu Dumitriu wrote:
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.
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.
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"?
On 10/15/2010 10:29 PM, Caleb James DeLisle wrote:
On 10/15/2010 03:57 PM, Sergiu Dumitriu wrote:
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.
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.
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"?
Yes. -- Sergiu Dumitriu http://purl.org/net/sergiu/
+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 [email protected] http://lists.xwiki.org/mailman/listinfo/devs
participants (3)
-
Alex Busenius -
Caleb James DeLisle -
Sergiu Dumitriu