I have data stored in a tree-like structure. There is a single main trunk with branches. The data is in sqlite. I already wrote a very basic empty gui in android. I will write the web app which provides XML content updates.
I need you to:
Show the 5 or 6 data elements from from each object in the gui.
Show the tree “branches” as a ListView
Allow comments (no log in required, stored locally in some settings file, changeable in settings)
Show comments in a TextView (no editing, deleting, etc required.)
Make the thing work without using huge gobs of memory.
Show clickable breadcrumbs, back button should work.
Web site communication (I will make the website work and provide data as xml):
1. myCommentsTbl should be uploaded as xml when a comment is submitted. If it fails, it just sends it next time they try to submit another comment.
2. On load, it should ask the server for updates to commentTbl and pageTbl, as defined by date of update being after last sync.
3. Reload clean database option in settings. (this will download the full database from the internet as an sqlite file.
4. On close: send a log file of usageTbl
There are the tables
pageTbl
commentTbl
myCommentTbl
syncAttemptTbl
usageTbl(usageID,StartDateTime,EndDateTime,pageID)
Only needs to work with Android 2.2 and above, but if you do make it more compatible that is fine.
I will sign it and post to android market.
See the basic gui and stripped sql database attached.
The code will be my property.
We can discuss details as much as you like.
