Hello Everybody,
I am very comfortable with SQL and relational databases and I am
trying to wrap my head around GAE. Below is an example of how I would
tackle my problem in SQL and it would be really great if someone could
give me some hints on how to accomplish something similar in GAE. Its
basically a hierarchy of ownership.
The 2 base tables:
table People {
int personId;
string name;
}
table items {
int itemId;
string itemName;
}
The 2 relational tables:
table PeopleOwnPeople {
int ownersId;
int personId;
}
table PeopleOwnItems {
int personId;
int itemId;
}
So now that we have a basic structure I can start to explain the idea
or problem. I want to be able to search for all items owned by me and
the people i own:
select items.* from Items, PeopleOwnPeople, PeopleOwnItems where
(PeopleOwnPeople.ownersId=234 and
PeopleOwnPeople.personId=PeopleownItems.personId) or
PeopleOwnItems.personId = 234 ;
I am looking to use GWT as my frontend to this project so I am likely
going to be using Java for the backend but that isn't set in stone
yet.
Thanks any and all help.
Ben
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
