60 likes | 197 Views
Purdue Pride 4.14.10 Joe Gutierrez Tung Ho Janam Jhaveri. Timeline. 7 weeks March 10 th : Widget, RSS tutorials March 24 th : RSS Feed April 7 th : SQL Lite Database (currently working on) April 21 st : Widget April 28 th : Work off any loose ends. Milestones.
E N D
Purdue Pride4.14.10Joe GutierrezTung HoJanam Jhaveri Purdue Pride
Timeline • 7 weeks • March 10th: Widget, RSS tutorials • March 24th: RSS Feed • April 7th: SQL LiteDatabase (currently working on) • April 21st: Widget • April 28th: Work off any loose ends Purdue Pride
Milestones • Website with RSS feed is set up (3.3.10) • Basic widget displays hard-coded text (3.10.10) • Successfully store and recall data from SQL Lite with an application (3.24.10) (Need to add fixes) • Successfully retrieve and display RSS feed onto view (4.1.10) • RSS Application fully working (no database) (4.14.10) Purdue Pride
Demo http://www.purdue.edu/newsroom/rss/engineering.xml Purdue Pride
Database • database works (kinda) • to access database in shell • go to androids tool directory • cd data/data • cdpurdue.pride (project name) • cd databases • sqlite3 pride (pride is database’s name) • .tables • feed is stored, but messed up • title and descriptions are being appended to each other • Changed code in RSSHandler => should work now • need to rewrite database class • used code from online tutorial, however it’s an older API • can’t detect when to create new table in database • DbAdapter class • public class PrideDB { • private static final String FEEDS_TABLE = "feeds"; • private static final String DATABASE_NAME = "pride"; • private static SQLiteDatabase db; • public PrideDB(Context ctx) { • db = ctx.openOrCreateDatabase(DATABASE_NAME, 0, null); //API change • } Purdue Pride
Next Task • April 21th: Have Database working • April 28th: RSS Feed interacting with Database Purdue Pride