Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Apr 17th, 2012  |  syntax: None  |  size: 0.95 KB  |  hits: 12  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Run a query in Buzzbox SDK Task
  2. public class MyRssReaderTask implements Task {
  3.  
  4. private String messageId = some_value;
  5. private String messageText = some_value;
  6. private String messageDate = some_value;
  7. private MessagesDB savedMessages;
  8.        
  9. @Override
  10. public TaskResult doWork(ContextWrapper ctx) {
  11.     TaskResult res = new TaskResult();
  12.  
  13.     // TODO implement your business logic here
  14.  
  15.     //check against DB
  16.  
  17.     String queryString = "select * from messages where message_key = " + messageId;
  18.     SQLiteDatabase db = savedMessages.getReadableDatabase();
  19.     Cursor cursor = db.rawQuery(queryString, null);
  20.  
  21.     if (cursor.getCount() == 0) {
  22.  
  23.         res.addMessage(
  24.                 new NotificationMessage(null, "Weather Forecast!", "Bad weather Alert!", R.drawable.icon_notification_cards_clubs)
  25.         .setNotificationSettings(true, false, false)
  26.         .setNotificationClickIntentClass(ReadMessages.class)); // <--  your Activity here
  27.     }
  28.  
  29.     return res;
  30. }