Modify AppGen to work with iBATIS

Details

  • Type: New Feature New Feature
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 1.8
  • Fix Version/s: 1.9.1
  • Component/s: Tools - AppGen
  • Labels:
    None

Description

From Bobby Diaz (Bobby - AT - magiconsoftware.com) via e-mail:

I have only been using AppFuse for about a month now but have made several modifications to accommodate the requirements of a couple of projects that I am currently working on. I wanted to take this time to give back some of the knowledge I have acquired. Before I spend too much time writing tutorials or diffs of everything I have changed, please take a look at the list below and let me know if any of you would be interested in any of these subjects:

My Configuration for AppFuse - Spring MVC / iBATIS / Oracle 9i

iBATIS
            Added AppGen template for DAOiBatis implementation
            Added AppGen template for SQL.xml (required changes to FormTagsHandler and MethodExTagsHandler)
            getXyxs() method in SQL.xml will use POJO properties to define search criteria.

DisplayTag
            Added ability for custom searching / sorting / paging / exporting using custom List implementation to optimize search queries and still report total record count
            Extended ELColumnTag to allow for custom sorting (DisplayTagColumnTag.java)
            Added DateColumnDecorator and DateTimeColumnDecorator classes.

POJO's
            Added AppGen template to extend POJO functionality for use with custom searching (e.g. PersonSearch.java)
            Added SearchStringBuilder class to generate generic search queries using POJO methods.
            Modified BaseObject.java to support custom searching using a toSearchString() method and pageNum / pageSize properties.

Controllers
            Added GenericSearchController.java to handle all xyxList.jsp actions and allow for custom searching.
            Modifed AppGen template for action-servlet.xml to initialize a GenericSearchController with specific properties for each page.
            Added code to StartupListener.java to register data type converters to be used during BeanUtils.populate() so that all POJO properties do not have to be strings.
            Added ContollerUtil.java for use with custom searching / sorting / paging / exporting.

Middlegen
            Added extras/middlegen to be able to auto-generate POJO's if database tables already exist.
            Configured middlegen to generate all hibernate specific xdoclet attributes so table and column names and properties are available to AppGen.
            Configured middlegen to generate equals(), hashCode(), and toString() methods.

JSP's
            Added AppGen template to generate xyzListFiters.jsp to be used as search criteria and included in xyzList.jsp
            Modifed AppGen template for xyzList.jsp to include custom search functions and criteria form.
            Added AppGen template to generate @spring.validator xdoclet attributes for required (not-null) fields.
            Added SearchFiltersTag.java for use with custom searching (collapsible div to show / hide filters after a search)
            Added CustomSortingTag.java for use with custom searching / sorting / paging / exporting.

AppGen
            Added hooks for all new templates and their respective merge functionality
            Added ability to specify sub-package name (i.e. org.appfuse.admin or org.appfuse.common) for model and generated code.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Matt Raible added a comment -
More comments from Bobby on the mailing list:

Here is the project I was using to set up the demo (minus the lib folder).
I figured it might be easier for you to setup and/or modify if you had all
of the code. I am also attaching my extras folder from another project
where I made all of the modifications. I tried to clean up as much as I
could, but let me know if you have any questions or comments about any of
it.

One last thing, after reading your message about using Annotations in the
next major release of AppGen, I slapped together a rough example to generate
the ibatis SQL.xml file to see what it would take. I was able to generate
the exact output I got from using xdoclet templates in no time. I would
definitely be interested in helping with that project!
Show
Matt Raible added a comment - More comments from Bobby on the mailing list: Here is the project I was using to set up the demo (minus the lib folder). I figured it might be easier for you to setup and/or modify if you had all of the code. I am also attaching my extras folder from another project where I made all of the modifications. I tried to clean up as much as I could, but let me know if you have any questions or comments about any of it. One last thing, after reading your message about using Annotations in the next major release of AppGen, I slapped together a rough example to generate the ibatis SQL.xml file to see what it would take. I was able to generate the exact output I got from using xdoclet templates in no time. I would definitely be interested in helping with that project!
Hide
Permalink
Matt Raible added a comment -
Also, see: https://appfuse.dev.java.net/issues/show_bug.cgi?id=177
Show
Matt Raible added a comment - Also, see: https://appfuse.dev.java.net/issues/show_bug.cgi?id=177
Hide
Permalink
Matt Raible added a comment -
I'd love to get this into 1.9, particularly the iBATIS stuff - but it's probably better that I wait. I'm leaving on vacation in a couple of days and I'd like to do 1.9 before that. The hard part is going to be making sure the other installers work well with the iBATIS installer.
Show
Matt Raible added a comment - I'd love to get this into 1.9, particularly the iBATIS stuff - but it's probably better that I wait. I'm leaving on vacation in a couple of days and I'd like to do 1.9 before that. The hard part is going to be making sure the other installers work well with the iBATIS installer.
Hide
Permalink
Matt Raible added a comment -
Finished integrating Middlegen. Now AppGen prompts you to generate from "pojo" or "table". I've updated AppGen's documentation accordingly.

http://raibledesigns.com/wiki/AppGen.html
Show
Matt Raible added a comment - Finished integrating Middlegen. Now AppGen prompts you to generate from "pojo" or "table". I've updated AppGen's documentation accordingly. http://raibledesigns.com/wiki/AppGen.html
Hide
Permalink
Matt Raible added a comment -
I've finished integrating AppGen support for iBATIS - thanks to Bobby Diaz for writing it. A nice clean implementation to boot!

One change I made vs. the patch here is that there are no bean registrations required for the generic DAO and manager. Rather, it works similar to the Hibernate implementation (generic "dao" and "manager" beans).

As far as search, the solution posted here is good - but I'd rather wait and use something like Lucene.

Feature for 2.1: Search (using Lucene) and allow all objects in application to be searched from a single screen (google style). Also, integrating paging with the displaytag, dataTable (JSF) and contrib:Table (Tapestry).
Show
Matt Raible added a comment - I've finished integrating AppGen support for iBATIS - thanks to Bobby Diaz for writing it. A nice clean implementation to boot! One change I made vs. the patch here is that there are no bean registrations required for the generic DAO and manager. Rather, it works similar to the Hibernate implementation (generic "dao" and "manager" beans). As far as search, the solution posted here is good - but I'd rather wait and use something like Lucene. Feature for 2.1: Search (using Lucene) and allow all objects in application to be searched from a single screen (google style). Also, integrating paging with the displaytag, dataTable (JSF) and contrib:Table (Tapestry).
Hide
Permalink
Matt Raible added a comment -
iBATIS AppGen support, as well as Middlegen support now in CVS.
Show
Matt Raible added a comment - iBATIS AppGen support, as well as Middlegen support now in CVS.

People

  • Assignee:
    Matt Raible
    Reporter:
    Matt Raible
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: