Hi everyone,
I think this is an important improvement of the code generator that we should implement. I have created a Jira Issue for this: https://issues.apache.org/jira/browse/EMPIREDB-110 Matt, if you feel you can and want to do It, then we would certainly appreciate this. You may create a patch file and attach it to the JIRA ticket. Then we can apply the patch and commit the code to svn. For further discussion I would recommend to move to the dev-mailing list: [email protected] Thanks, Rainer Von: Benjamin Venditti [mailto:[email protected]] Gesendet: Mittwoch, 29. Juni 2011 01:47 An: [email protected] Cc: Matt DeHoust Betreff: Re: Relationships Hi Matt, thanks for your interest in empire-db. regarding your request ... unfortunately the codegen does not set up the relation of the database model. At the moment the codegen will only set up views and tables. We thought these are the most important for the most people as they are usually sufficient for simple data access. However i think there are two occasions where the relations are important: - database creation - deletion of records with cascading deletion enabled At the moment we have not planned to add "relationship generation" to the codegen component, but I am glad to hear that you consider to extend it on your own. The right place to start with that would be: CodeGenParser.populateDatabase(..) : 131 : This is the point where the DatabaseMetaData is querried and used to populate empire-db's model CodeGenWriter.generateCodeFiles(..) : 125 : Is used to serialize the populated model as java code src/main/resources/Database.vm : 70 : This is the velocity template we use to create the java class for the database. In its default constructor you'd need to add a line for each relationship similar to this: addRelation( EMPLOYEES.DEPARTMENT_ID.referenceOn( DEPARTMENTS.DEPARTMENT_ID )); I hope this is of some help to you. Feel free to ask if you have further questions! Cherio Benjamin Am 28.06.2011 19:37, schrieb Matt DeHoust: Hello, I see that the empire-db model supports relationships (for example DBDatabase.getRelations()), but it doesn't seem that the codegen component sets them up. Am I missing something? (I am using MySQL if that matters.) If not, are there plans to introduce relationship setup in the codegen component? If not, where should I look to add them myself? CodeGenParser? Thanks, Matt P.S. I apologize if I posted this question twice by mitake.
