Jaxer ORM Project

[p1ilmaker]

Thanks for creating this forum. Davey, URI and I started discussing ORM for Jaxer in a thread last week. Uriel Katz has written GearsORM. I started adapting GearsORM to run within Jaxer. There may be some better ORM projects going on for Jaxer but I'm posting what I have adapted so far. Feel free to contribute or point me to some other cool Jaxer ORM project.

I have all of the unit tests run in Jaxer with runat=server. I recently started trying to get the GearsORM example to run in Jaxer using runat=server and runat=server-proxy. I'm having a little trouble now with the server-proxy part. I believe I understand correctly that I will want to be using oncallback() to prepare the ORM library for server-proxy and I also understand that data does not persist between callback and that I must use functions to recreate any data which I may need to access. I have tried these things but no go yet. So if anyone would like to get example.html working based on the code in the unit tests, be my guest.

Thanks URI and Daver for your assistance!

I uploaded the adaptation here:
http://code.google.com/p/js-orm/source/checkout
It doesn't have to live here however this project should support Jaxer and Gears; SQLite and MySql, etc.

Notes:
I stripped the api comments from the files temporarily for my own benefit.
I have done some significant code formatting changes to improve readability such as: brackets everywhere, spaces around colons, spelling corrections, moving actual comments to the same line.
I may have introduced a defect which causes one of the unit tests to fail - I need to go back and look at that.

These changes are based on Uriel's work with GearsORM. I am actually seeking a project which I can own but it doesn't have to be ORM. Recently I have also been interested in being able to store data using JSONPath so maybe I'll continue on that path. It can be on top of this or not. Thanks for reading.

Philip

[davey]

Dion from Ajaxian, has been working on making google gears work with Jaxer.

http://ajaxian.com/archives/server-side ... ses-access

You may be able to leverage some of his stuff.

[p1ilmaker]

I simplified the Gears example for Jaxer as I was getting the Jaxer example.html to work. I did get a simple Jaxer example working with callback and have posted that example. A little later I'll add to it and investigate an issue with ResultIterator.toArray().

I basically just attached the API to the window object as it loads. I don't really understand the Jaxer.load() parameters but I'll fiddle. If anyone can point out whether I'm doing anything too silly in example.html, I'd love to hear about it.

http://code.google.com/p/js-orm/source/ ... ample.html
http://code.google.com/p/js-orm/source/browse

[p1ilmaker]

BTW, I emailed Uriel that I tweaked GearsORM to work with Jaxer. He and others might be working on this as well but I just wanted to get some sort of ORM working now with Jaxer. So WOOT!

Anybody feel free to chime in.

[davey]

Phil,

been kind of pegged with 0.9.3 recently, i'll take make some time to look at your stuff and let you know if I find anything that looks fragile from an ongoing platform support perspective.

[urielka]

hi,
i am the creator of GearsORM.
i am working on changing GearsORM to JsORM,basically my plan is to enable the flowing back-ends:
*Jaxer
*Flash(not sure about this)
*Adobe AIR
*Classic ASP(need this for some work i am doing)

[davey]

urielka. (welcome back from boot camp)

I would like to be involved in this effort (and likely philmaker too), do you have a breakdown of tasks to be done that might be handled by mutiple developers.

one of the things I may be able to help with is doc and get the code sdoc'd so it works with content assist in Studio. And we could use the unit test framework from jaxer to build regression tests.

I've also been building a backend sql abstaction layer to support externalized sql, to make supporting multiple databases as close to a simple sql-sql dialect translation as possible. which we could look at building on top of.

[urielka]

thanks,bootcamp was really fun

i welcome any help,the first task to be done is to move Google Gears specific code into a "engine" and make JsORM to be able to work with many engines(back-ends) and many sql dialects(Sqlite,MySql,Access).

for this first tasks i think the best will be to do it only one developer but i want to hear ideas on how to do this,then i will do all the dirty work.

next step after that is writing specific engines,so each one of us can write one or more in parallel.

what you think?

[davey]

sounds good to me.

what development environment are you using? Obviously i'm using Aptana studio, and it would be cool for us to use the same toolset. so we use the same scriptdoc, unit test framework, and build tool.

and as studio has jaxer built in working with it is a breeeze.

[urielka]

i use aptana studio community edition.

[davey]

sweet,

How should we progress? is there a google group, i see phil started a code project on google.

I'd like to start a discussion on the general architecture, with some thoughts on serializing and conventions. Let me know how you'd like to move forward.

this'll be a really neat project.

[urielka]

there is no google group,but that will be a good idea.
about svn/trac i have one hosted on my server,to tell the truth i preffer having the code on my server,i like trac better than google code system

i also want to talk about the general architecture,since next version should be a total architectural rewrite(supporting various back-ends and various SQL dialects).

how do i open a google group?

[davey]

http://groups.google.com/ I think as long as you have a gmail account you can open one.

[urielka]

ok i opened two groups:
js-orm-dev - for JsORM developers
js-orm-users - for JsORM users

[urielka]

ok i a opened a discussion on js-orm-dev to discuss about the new architecture for JsORM:

http://groups.google.com/group/js-orm-d ... 5c56e924b8

i want to start coding soon