[Dojo-interest] DataGrid, QueryReadStore, and Java

[Arlo White]

Looks pretty interesting but it's quiet a paradigm shift from what I'm 
doing. I'd rather stick with Spring and JPA for querying and managing 
entities. I'm not sure how difficult it would be to implement a 
Persevere JPA data store.

I'll try to use the JSONQuery language in the same way though, that way 
any front end filter gui I create can be used by people using Persevere.



On 06/09/2010 12:53 PM, Dustin Machi wrote:
> Persevere, http://persvr.org can handle much if not all of this, and I believe you can incorprate that along with what you have described or in place of in some cases.
>
> In any case, we're always happy to have additional demos and docs to add to our collection :)
>
> Thanks,
> Dustin
>
> On Jun 9, 2010, at 3:31 PM, Arlo White wrote:
>
>    
>> I work for Cal Poly's ITS department and develop various web
>> applications. We're a pretty Java heavy shop, making extensive use of
>> tools/frameworks like Maven, Spring, JPA, etc.
>>
>> I've been working on a new portlet and wanted to do some cool things
>> with the DataGrid. I've got the basics working (Annotate Spring
>> Controller using AJAX that feeds data back to the QueryReadStore)
>>
>> I've been playing with a few cool ideas. Using Java reflection you can
>> examine a JPA entity and automatically generate the grid structure JSON
>> and turn a List<MyJpaEntity>  into the JSON QueryReadStore needs. My goal
>> is to create an API/Library that makes it much easier for Java
>> developers to get a Dojo DataGrid connected to their Java objects.
>>
>> My next step is to come up with a basic query language for
>> QueryReadStore and Java that can be translated to JPA queries or SQL. I
>> think I'm going to keep it basic at first (no AND or OR clauses), but
>> it's still fairly complicated. For example, if the user wants to query
>> on a column that is a String, they should be able to choose (contains,
>> startswith, endswith, matches regex?), if it's a date (<,>,<=,>=) etc.
>>
>> Anyway, one component is a Dijit widget that takes the column definition
>> information and creates an interface for the user to create filters,
>> then calls setQuery on the grid. Has anyone else worked on this kind of
>> thing?
>> Alternatively, I was thinking you could specify filter conditions Java
>> side and just feed this filter interface information from the Java
>> entities. Possibly creating a form and then just shoving the form into
>> the query. There are a few ways to approach this problem...any thoughts
>> on this would be appreciated.
>>
>> Also, I'd like to automatically generate a headerMenu for the grid that
>> lets you toggle columns. I'd be surprised if such a thing doesn't
>> already exist somewhere. Has anyone worked on this?
>>
>>
>> Are there any existing Java-Dojo libraries/frameworks? Are there any
>> query APIs that I might be able to adapt to the QueryReadStore and Java?
>>
>> I would appreciate a list of any projects that sound applicable to this
>> work. I'd prefer not re-inventing the wheel.
>>
>> Also, if there aren't any Dojo Java libraries let me know and I can look
>> into releasing the code I'm working on. Also, I think it would be useful
>> for me to write a guide on hooking up a Java Spring web application with
>> Dojo's DataGrid, xhrPost, etc. Should I just blog about this somewhere,
>> or would Dojo be interested in hosting such documentation on their website?
>>
>>
>> -- 
>> Arlo White
>> Application Management / ITS
>> awhite at calpoly.edu
>>
>>
>> _______________________________________________
>> FAQ: http://dojotoolkit.org/support/faq
>> Book: http://docs.dojocampus.org
>> Dojo-interest at mail.dojotoolkit.org
>> http://mail.dojotoolkit.org/mailman/listinfo/dojo-interest
>>      
> _______________________________________________
> FAQ: http://dojotoolkit.org/support/faq
> Book: http://docs.dojocampus.org
> Dojo-interest at mail.dojotoolkit.org
> http://mail.dojotoolkit.org/mailman/listinfo/dojo-interest
>