Android Open Source - Flippy-Radio Flippy Database Adapter

• Back to App/podcast  ↑

From Project

Back to project page Flippy-Radio.

License

The source code is released under:

Apache License

Java Source Code

package com.bitflippersanonymous.flippy.db;
//from   w w w.j av a 2s. co  m
import java.sql.Time;
import java.util.ArrayList;
import java.util.HashMap;

import com.bitflippersanonymous.flippy.domain.PlsEntry;
import com.bitflippersanonymous.flippy.domain.PlsEntry.Tags;
import com.bitflippersanonymous.flippy.util.Util;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.DatabaseUtils;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;

public class FlippyDatabaseAdapter {
  
  // Database fields
  public static final String KEY_ROWID = "_id";
  public static final String TABLE_ENTRY = "entry";
  public static final String TABLE_KEYWORDS = "keywords";
  private static final String LIKE = "LIKE";

  private FlippyDatabaseHelper mDbHelper = null;
  private HashMap<String, Long> mKeywordIds = null;

  public FlippyDatabaseAdapter(Context context) {
    mDbHelper = new FlippyDatabaseHelper(context);
  }

  public FlippyDatabaseAdapter recreate() throws SQLException {
    mDbHelper.onUpgrade(mDbHelper.getWritableDatabase(), 1, 1); // Purge database on open
    return this;
  }

  public void close() {
    if ( mDbHelper != null )
    mDbHelper.close();
    mDbHelper = null;
  }
  
  public long insertEntry(PlsEntry entry) {
    SQLiteDatabase database = mDbHelper.getWritableDatabase();
    ArrayList<Long> keywordIds = new ArrayList<Long>();

    // Return -1 on entry already exists
    ContentValues values = entry.createEntryContentValues();
    if ( lookupEntry(values) != -1 )
      return -1;
    
    long idEntry = database.insert(TABLE_ENTRY, null, values);
    
    for ( String keyword : entry.get(Tags.keywords).split(", ") ) {
      long keywordId = lookupKeyword(keyword);
      if ( keywordId != -1 )
        keywordIds.add(keywordId);
    }
    
    for ( long keywordId : keywordIds ) {
      values.clear();
      values.put(TABLE_ENTRY, idEntry);
      values.put(TABLE_KEYWORDS, keywordId);
      database.insert(TABLE_ENTRY+TABLE_KEYWORDS, null, values);
    }
        
    return idEntry;
  }
  
  //Will escape keyword.  Also could use DatabaseUtils.sqlEscapeString()
  public long lookupKeyword(String keyword) throws SQLException {
    long id = -1;
    if ( mKeywordIds == null )
      mKeywordIds = new HashMap<String, Long>();

    keyword = keyword.toLowerCase();
    Long iId = mKeywordIds.get(keyword);
    if ( iId != null )
      return iId.longValue();
    
    Cursor cursor = mDbHelper.getReadableDatabase().query(true, TABLE_KEYWORDS, 
        new String[] { KEY_ROWID },
        Tags.keywords.name() + "=?", new String[] {keyword}, null, null, null, null);
    
    if ( cursor != null && cursor.getCount() > 0) {
      cursor.moveToFirst();
      id = cursor.getLong(0);
    } else {
      ContentValues values = new ContentValues();
      values.put(Tags.keywords.name(), keyword);
      id = mDbHelper.getWritableDatabase().insert(TABLE_KEYWORDS, null, values);
    }
    cursor.close();
    mKeywordIds.put(keyword, id);
    return id;
  }
  
  // Lookup by pubdate, add more later if needed
  private long lookupEntry(ContentValues values) throws SQLException {
    long id = -1;
    Cursor cursor = mDbHelper.getReadableDatabase().query(true, TABLE_ENTRY, 
        new String[] {KEY_ROWID, Tags.pubDate.name()},
        Tags.pubDate.name() + "=" + "?", 
        new String[]{values.getAsString(Tags.pubDate.name())}, 
        null, null, null, null);
    if ( cursor == null )
      return id;
    if ( cursor.getCount() > 0 )
      id = cursor.getLong(0);
    cursor.close();
    return id;  //-1 on not found
  }
  
  public Cursor fetchEntry(long rowId, int offset) throws SQLException {
    final String dir = offset > 0 ? ">" : offset < 0 ? "<" : "=";
    Cursor cursor = mDbHelper.getReadableDatabase().query(true, TABLE_ENTRY, 
        null,
        KEY_ROWID + dir + "?", new String[]{String.valueOf(rowId)}, null, null, null, null);
    if (cursor != null) {
      cursor.moveToFirst();
    }
    return cursor;
  }

  public Cursor fetchQueue() throws SQLException {
    Cursor cursor = mDbHelper.getReadableDatabase().query(true, TABLE_ENTRY,
        null, Tags.enqueue.name() + "=?", new String[]{"1"}, null, null, null, null);
    if (cursor != null) {
      cursor.moveToFirst();
    }
    return cursor;
  }
  
  //TODO: trimdown select to speedup
  public Cursor fetchAllEntries() throws SQLException {
    Cursor cursor = mDbHelper.getReadableDatabase().query(true, TABLE_ENTRY,
        new String[] {KEY_ROWID, Tags.enqueue.name(), Tags.title.name(), Tags.verses.name(), Tags.pubDate.name()}, 
        null, null, null, null, null, null);
    if (cursor != null) {
      cursor.moveToFirst();
    }
    return cursor;
  }

  public void enqueue(long rowId, boolean value) throws SQLException {
    ContentValues values = new ContentValues();
    values.put(Tags.enqueue.name(), value?"1":"0");
    int update = mDbHelper.getWritableDatabase().update(TABLE_ENTRY, values, 
        KEY_ROWID + "=?", new String[]{String.valueOf(rowId)});
  }

  public Cursor fetchAllKeywords(String partialKeyword) throws SQLException {
    //DatabaseUtils.sqlEscapeString
    String where = null;
    String[] binder = null;
    if ( partialKeyword != null && partialKeyword.length() > 0 ) {
      partialKeyword = partialKeyword+"%";
      where = Tags.keywords.name() + " " + LIKE + " ?";
      binder = new String[] {partialKeyword};
    }
    
    Cursor cursor = mDbHelper.getReadableDatabase().query(true, TABLE_KEYWORDS,
        new String[] {KEY_ROWID, Tags.keywords.name()},
        where, binder,
        null, null, Tags.keywords.name(), null);
    if (cursor != null) {
      cursor.moveToFirst();
    }
    return cursor;
  }

}

Java Source Code List

• Back to App/podcast  ↑