com.freerdp.freerdpcore.services.QuickConnectHistoryGateway Class Reference

Public Member Functions
	QuickConnectHistoryGateway (SQLiteOpenHelper historyDB)
ArrayList< BookmarkBase >	findHistory (String filter)
void	addHistoryItem (String item)
boolean	historyItemExists (String item)
void	removeHistoryItem (String hostname)

Detailed Description

Definition at line 25 of file QuickConnectHistoryGateway.java.

Constructor & Destructor Documentation

QuickConnectHistoryGateway()

com.freerdp.freerdpcore.services.QuickConnectHistoryGateway.QuickConnectHistoryGateway ( SQLiteOpenHelper  historyDB )

inline

Definition at line 30 of file QuickConnectHistoryGateway.java.

  {
    this.historyDB = historyDB;
  }

Member Function Documentation

addHistoryItem()

void com.freerdp.freerdpcore.services.QuickConnectHistoryGateway.addHistoryItem ( String  item )

inline

Definition at line 64 of file QuickConnectHistoryGateway.java.

  {
    String insertHistoryItem = "INSERT OR REPLACE INTO " + HistoryDB.QUICK_CONNECT_TABLE_NAME +
                               " (" + HistoryDB.QUICK_CONNECT_TABLE_COL_ITEM + ", " +
                               HistoryDB.QUICK_CONNECT_TABLE_COL_TIMESTAMP + ") VALUES('" +
                               item + "', datetime('now'))";
    SQLiteDatabase db = getWritableDatabase();
    try
    {
      db.execSQL(insertHistoryItem);
    }
    catch (SQLException e)
    {
      Log.v(TAG, e.toString());
    }
  }

findHistory()

ArrayList< BookmarkBase > com.freerdp.freerdpcore.services.QuickConnectHistoryGateway.findHistory ( String  filter )

inline

Definition at line 35 of file QuickConnectHistoryGateway.java.

  {
    String[] column = { HistoryDB.QUICK_CONNECT_TABLE_COL_ITEM };
 
    SQLiteDatabase db = getReadableDatabase();
    String selection =
        (filter.length() > 0)
            ? (HistoryDB.QUICK_CONNECT_TABLE_COL_ITEM + " LIKE '%" + filter + "%'")
            : null;
    Cursor cursor = db.query(HistoryDB.QUICK_CONNECT_TABLE_NAME, column, selection, null, null,
                             null, HistoryDB.QUICK_CONNECT_TABLE_COL_TIMESTAMP);
 
    ArrayList<BookmarkBase> result = new ArrayList<>(cursor.getCount());
    if (cursor.moveToFirst())
    {
      do
      {
        String hostname =
            cursor.getString(cursor.getColumnIndex(HistoryDB.QUICK_CONNECT_TABLE_COL_ITEM));
        QuickConnectBookmark bookmark = new QuickConnectBookmark();
        bookmark.setLabel(hostname);
        bookmark.setHostname(hostname);
        result.add(bookmark);
      } while (cursor.moveToNext());
    }
    cursor.close();
    return result;
  }

historyItemExists()

boolean com.freerdp.freerdpcore.services.QuickConnectHistoryGateway.historyItemExists ( String  item )

inline

Definition at line 81 of file QuickConnectHistoryGateway.java.

  {
    String[] column = { HistoryDB.QUICK_CONNECT_TABLE_COL_ITEM };
    SQLiteDatabase db = getReadableDatabase();
    Cursor cursor = db.query(HistoryDB.QUICK_CONNECT_TABLE_NAME, column,
                             HistoryDB.QUICK_CONNECT_TABLE_COL_ITEM + " = '" + item + "'", null,
                             null, null, null);
    boolean exists = (cursor.getCount() == 1);
    cursor.close();
    return exists;
  }

removeHistoryItem()

void com.freerdp.freerdpcore.services.QuickConnectHistoryGateway.removeHistoryItem ( String  hostname )

inline

Definition at line 93 of file QuickConnectHistoryGateway.java.

  {
    SQLiteDatabase db = getWritableDatabase();
    db.delete(HistoryDB.QUICK_CONNECT_TABLE_NAME,
              HistoryDB.QUICK_CONNECT_TABLE_COL_ITEM + " = '" + hostname + "'", null);
  }

---

The documentation for this class was generated from the following file:

• QuickConnectHistoryGateway.java