Database

/.classpath: Updated with project

/.gitignore: Added ds_store files, ocw.db.

/assets/databases/ocw.zip: Added zip containing test sqlite3 database.

/libs/android-sqlite-asset-helper.jar: Library for facilitating database interactions.

/src/org/osuosl/ocw/DataBaseHandler.java: Class for loading database from assets and methods for retrieving/updating values.

/src/org/osuosl/ocw/DataHandler.java: Object for passing information to/from database.

/src/org/osuosl/ocw/Schedule.java: Added methods for retrieving/updating values of the database. Declared a DataBaseHandler object. Changed track_title to be retrieved from database as first test of working correctly.
Close database after action

/src/org/osuosl/ocw/DataBaseHandler.java: After updating/retrieving database is closed.
Database work

/src/org/osuosl/ocw/DataBaseHandler.java: Added keys for schedule and speakers tables. Added methods for updating a row of the schedule/speakers table.

/src/org/osuosl/ocw/Event.java: Changed some attribute names. Added constructor, setters and getters.

/src/org/osuosl/ocw/ICal.java: Change Id to int.

/src/org/osuosl/ocw/Schedule.java: Added methods for updating a row of the schedule/speakers table.

/src/org/osuosl/ocw/Speaker.java: Added constructors, getters and setters.
Commit to change branches

Nothing substantial completed and working
Row adding to schedule table

assets/databases/ocw.zip: Updated default database.

src/org/osuosl/DataBaseHandler.java: Add row to schedule table.

src/org/osuosl/DataHandler: Removed.

src/org/osuosl/Schedule.java: Add an event to a row of schedule table.
assets/databases/ocw.zip: Updated to have no rows.

src/org/osuosl/ocw/DataBaseHandler.java: event id and track title now added to database.

src/org/osuosl/ocw/Event.java: Removed duplicate variable event_id.

src/org/osuosl/Schedule.java: Commented out method that will be rewritten so as able to compile.
Updating schedule rows working

src/org/osuosl/ocw/DataBaseHandler.java: Added methods to check if row exists in schedule or speakers table.

src/org/osuosl/ocw/Schedule.java: If event already exists in database it is updated otherwise it as added as a new row. Methods to check if row exists in schedule or speakers table. DataBaseHandler now instantiated in onCreate rather than every time a helper method is called. Code commented out to support just one day conference to match with current sample json.
Load from database when offline

/assets/databases/ocw.zip: Updated to latest version with empty schedule and speakers tables.

/src/org/osuosl/ocw/DataBaseHandler.java: Added a method that returns the number of rows of a table.
When retrieving an event a new method is called Event.EventFromDatabase() to bypass date formatting problems from the Event constructor.

/src/org/osuosl/ocw/Event.java: Method EventFromDatabase that uses a different date formatter to match what is stored in the database.

/src/org/osuosl/ocw/Schedule.java: Changed speaker uri to testing host. Swapped out loading from cached file to loading from database. Some method name changes for consistency.
More database and .apk added

assets/databases/ocw.zip: Added speaker ids column.

ocw-android.apk: installable apk for testing.

src/org/osuosl/ocw/DataBaseHandler.java: Methods to handle speaker ids.

src/org/osuosl/ocw/Event.java: Methods to handles speaker ids.

src/org/osuosl/ocw/Schedule.java: Retrieve speakers from database when no internet.
Fixed not retrieving speaker from database and changed conference strings

/res/layout/loading.xml: Commented out osbridge logo from being displayed.

/res/values/strings.xml: Changed strings to match sample json for WDCNZ conference instead of osbridge.

/src/org/osuosl/ocw/DataBaseHandler.java: Changed to raw query for getting a speaker row, don't know why normal query wasn't working yet.

/src/org/osuosl/ocw/Schedule.java: Wasn't correctly getting the row for speaker "id".

/src/org/osuosl/ocw/Speaker.java: Changed from declaring variables to instantiating global variables in constructor.
Update README.md
Commented methods in DataBaseHandler, added transactions to improve performance

/src/org/osuosl/ocw/DataBaseHandler.java: Commented methods, all database work is performed inside a transaction to improve performance.
Events with no speakers null pointer fix, speakers in memory hash map fix.

/src/org/osuosl/ocw/DataBaseHandler.java: Fixed null pointer when an event with no speakers is updated.

/src/org/osuosl/ocw/Schedule.java: Moved adding speakers to the hash map to after they have had all their values assigned.
New .apk with recent changes

/ocw-android.apk: Updated to latest version.
Removed osbridge icon in bio view

/res/layout/eventdetail.xml; Commented out loading of osbridge logo on bio view
Moved query to final string

/src/org/osuosl/ocw/DataBaseHandler.java: Moved the query from getting a schedule row to a final string to improve performance.
Merge pull request #1 from markholland/feature-81

Feature 81