A very simple NATIVE BlackBerry DEMO App to download Dummy Contact Records

We are after a very, very simple Native BlackBerry demo App only that can download a feed from an external source and insert it into a local SQLite database. Native code,no HTML/ PhoneGap. The feed contains 2,500 dummy Contact records The BlackBerry App shoul work on OS6 and above and it needs to be as fast as possible to download 2,500 records and insert them into a SQLite database. We understand that the downloading of the 2,500 records will be determined by the connection, **our main focus is on the speed of inserting the records**. An example of one record would be "ID": "2997", "FirstName": "FirstName2997", "LastName": "LastName2997", "Title": "Title 2997", "Email": "Person2997@[login to view URL]", "Telephone1": "12345678890", "ShortProfile": "Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.", "Territory": "Territory", "Ignore": "" }, On startup the App will check a feed at <[login to view URL]> The App would then read the ServiceURL and Version fields in the json feed. In that feed is just one Contact feed - <[login to view URL]> Internally the App would keep track of the Version number, so the first time the App would have a version of 0 but the feed would have a version number of 1. As the local version number is less than the feed version number it would ask the user 'New data exists, would you like to download?' **It is important you read the additional details of this project post (below) to have a full understanding of the brief. ** ## Deliverables **A very simple BlackBerry DEMO App to download Dummy Contact Records** We are after a very, very simple BlackBerry demo App only that can download a feed from an external source and insert it into a local SQLite database. The feed contains 2,500 dummy Contact records The BlackBerry App should ideally work on OS6 and above and it needs to be as fast as possible to download 2,500 records and insert them into a SQLite database. We understand that the downloading of the 2,500 records will be determined by the connection, **our main focus is on the speed of inserting the records.** An example of one record would be "ID": "2997", "FirstName": "FirstName2997", "LastName": "LastName2997", "Title": "Title 2997", "Email": "Person2997@[login to view URL]", "Telephone1": "12345678890", "ShortProfile": "Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.", "Territory": "Territory", "Ignore": "" }, On startup the App will check a feed at <[login to view URL]> The App would then read the ServiceURL and Version fields in the json feed. In that feed is just one Contact feed - <[login to view URL]> Internally the App would keep track of the Version number, so the first time the App would have a version of 0 but the feed would have a version number of 1. As the local version number is less than the feed version number it would ask the user 'New data exists, would you like to download?' If the user says 'YES' it should download the data from the ServiceURL and insert it into a local SQLite database. Once the database has been updated it should update the local version number. For the demo App you will need to time the database update. So start a timer at the start of the database update and then stop it when the database has been updated. Please then show a simple Message box saying 'Inserted (number of records) in (time)' I guess you would use the same database table structure for as the feed for the table but that's up to you, as long as it's fast in inserting and retrieval. Once downloaded it should display a very simple screen that will allow the user to search by FirstName, LastName or Title It should then simply display in a list all of the results from the search by FirstName, LastName. So if you search on 'LastName29' it will give you all of the records that contain LastName29 in the demo data, i.e. LastName2996,LastName2297 etc .. If you tap on one of the rows you will go to a simple Contact details screen which would show; FirstName LastName Title Email ShortProfile If you open up the App again it should again check the <[login to view URL]> feed again. If the version number in the feed is higher than the previously downloaded version it should download the json again and if downloaded OK perform an update to the SQLite database by deleting all of the contact rows and inserting the new lot again. This should be in a transaction so if there are any problems the user hasn't lost the data. To test the version increments i.e. setting the version to say 2 in the data-header file, you will have to download the header file [login to view URL] to a local test server. Then point your BlackBerry code to your local server, update the Version number and the when you open the App it should ask if you want to download the new set of data (as the version number is now higher, the data is actually the same still as it's only a demo). You will have to do it this way as you won't have ftp access to the test server, so you will have to test it locally first. We will need the full source code as part of the project together with test builds so we can sign off the project. Before you send us the test build can you make sure you point to our test feed [login to view URL] As part of our testing we will: ? Add some extra records to the Contact test feed and then update the version number in the [login to view URL] feed. ? We will open the App, it should check the [login to view URL] file and see that the version number is now higher (I guess in the BB for the first time it will be 0). ? The data then should download and we will then perform a simple search to see if our new records are present.