# NOTE: I have *NOT* tested the following code
# because this is greatly simplified from my actual code,
# so some debugging may be necessary to get it to work
#
# The following assumes that gql.py has been modified to add a
statement to method
# insert():
# add a new statemtent before the final return statement as
follows:
# self._last_reference = tmp # <==== Add this new statement,
as per Massimo's mod in the trunk ====
# return rid
# Here are the sample tables to create:
db.define_table('ParentTable',
# NOTE: web2py provides the 'id' column
automatically
db.Field('name','text')
)
db.define_table('ChildTable',
# NOTE: web2py provides the 'id' column
automatically
db.Field('idParentFolder','reference
ParentTable'),
db.Field('age','integer'),
db.Field('name','text'),
db.Field('parentLink',
gae.ReferenceProperty(ParentTable, required=True,
collection_name='ChildCollection') #
native link to parent
)
# Here is the code to insert a parent and a child
myParent = db.ParentTable.insert(name='Bill')
myParentNativeRef = myParent._last_reference # This uses
Massimo's mod in the trunk...
myParentid = myParent.id
# NOTE: if myParentNativeRef is not available, then instead you
can
# use the technique in my previous forum msg to query for
the native ref and id of the Parent
myChild = db.ChildTable.insert(age = 9, name = 'Johnny',
idParent = myParentid,
parentLink = myParentNativeRef)
# -------- End of code to insert data
------------------------------------------------------------
#
-------------------------------------------------------------------------------------------------
# Here is the code to retrieve the parent and children using the
native references
# Performance is very fast because GAE does this in a single call
to the Datastore:
myParent = db(db.ParentTable.name=='Bill').select() # This is a
web2py query on steroids...
for child in myParent.ChildCollection:
myChildName = child.name
myChildAge = child.age
# ---------------------- End of Sample code
-------------------------------------------------------------------
