Excel Modeler for Cayenne Web Application

From: AFSIN BUYUKSARAC (afsin..mail.com)
Date: Tue Nov 28 2006 - 12:16:47 EST

  • Next message: Adrian Wiesmann: "Re: [JIRA] Created: (CAY-710) XMLDecoder decodes Dates wrong"

    Hello guys,

    I want to tell about a new idea of cayenne modeling. I have changed modeling
    with excel. Let me explain what it means.

    Just like cayenneModeler, excel modeler collects information of db tables.
    Each excel sheet has each table info. After that program can read excel
    sheet by sheet.

    Some information must be entered like sheet names,
    But construction of sheet could be dynamic. For example I have a property of
    "Class Name" , which holds entity name, it is just a property and excel
    reader doesn't know where this information is written in sheet. Reader has
    action based FireProperty classes.

    For "Class Name" property, There exists a FireClassProperty class.

    If there is a property, there is a xml file which includes this property and
    points the acual place in the sheet, "model.mapping.xml " file shows the way
    of reading sheet.

    I calles this xml as "Meta Model of Model".

    Any one can add an extra property and write its FireProperty action easily.
    Program could detect some extra information is added.

    There is a "excelAction.properties" config file. This simple text file hold
    data about property-action couples.

    Like :

       Class=excel.actions.FireClassProperty

    So excel reader don't need to know what property exists what it works as. It
    is just a reader. That's all.

    At Secon stage, generating code process is startins.

    Program has text templates like , beans, autoBeans, actions, jsps,
    struts-config,web-xml..

    For each template action based Generator is used.

    generated application uses : jdbc-conn ,cayenne, struts, ajax-tags,
    display-tags.

    Each table has 3 jsp resource. Edit, search , display

    some sort of technology is used like ajax display, autocomplete in search
    texts.

    As a future task I decided to put GWT (Google Web Toolkit) support. My
    friend search this.

    So this information is insufficient I know,

    Please wait for this week.

    But I am happy to say that after generating code, there is no other
    information required to run the application. That's it.

    You can find attachment as a zip file that includes images.





    This archive was generated by hypermail 2.0.0 : Tue Nov 28 2006 - 12:17:26 EST