tracker issue : CF-3040778

Problem:

When you have ManyToOne and ManyToMany relationships and fetch the parent entity from the server you get back from the server the parent entity and all of the child entity data (verifiable by debugging in FB).   However, when you perform the saveUpdateCache() method it does not save the data for all joined entities. Here's my observations on what it does:

Parent entity =  Creates SQLite table and inserts all data
OneToOne entities = Creates SQLite table and inserts all data
ManyToOne = Creates SQLite table and does not insert any data
ManyToMany = Creates SQLite table and inserts all data on the "linktable" but no data is inserted on the joined table

(Note: I have not tested OneToMany relationships)
Method:

1.  Create a parent entity that has OneToOne, ManyToOne and ManyToMany relationships on both the Air and the CF side (also create the tables on the server).  
2.  Create a fetch CFC that returns the parent entity.
3.  Perform a SyncManager.fetch for the parent entity.
4.  Verify that the data returned from the CFC has all related entity data.
5.  Perform a saveUpdateCache on the results.
6.  Using a tool like SQLite Manager for FireFox inspect the local DB and you will see the results described in the problem detail.
Result:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3040778

External Customer Info:
External Company:  
External Customer Name: Abram Adams
External Customer Email: 2C58192A446E406799201549
External Test Config: 01/13/2010

Attachments:

Comments: