예제 #1
0
  /**
   * @param Id
   * @return
   */
  public CategoryEntry fetchCategory(long Id) {
    CategoryEntry row = new CategoryEntry();
    try {
      Cursor c =
          db.query(
              true,
              TABLE_CATEGORIES,
              new String[] {"id", "name"},
              "id=" + Id,
              null,
              null,
              null,
              null,
              null);
      if (c.getCount() > 0) {
        c.moveToFirst();
        row.id = c.getLong(0);

        row.name = c.getString(1);
      } else {
        row.id = -1;
        row.name = null;
      }
      c.close();
    } catch (SQLException e) {
      Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
    }
    return row;
  }
예제 #2
0
 /** Close database connection */
 public void close() {
   try {
     db.close();
   } catch (SQLException e) {
     Log.d(TAG, "close exception: " + e.getLocalizedMessage());
   }
 }
예제 #3
0
 /** @param Id */
 public void deletePassword(long Id) {
   try {
     db.delete(TABLE_PASSWORDS, "id=" + Id, null);
   } catch (SQLException e) {
     Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
   }
 }
예제 #4
0
 /** Commit all changes since the begin transaction on an open database. */
 public void commit() {
   try {
     db.execSQL("commit;");
   } catch (SQLException e) {
     Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
   }
 }
예제 #5
0
 /** Rollback all changes since the begin transaction on an open database. */
 public void rollback() {
   try {
     db.execSQL("rollback;");
   } catch (SQLException e) {
     Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
   }
 }
예제 #6
0
 /** @param Id */
 public void deleteCategory(long Id) {
   try {
     db.delete(TABLE_CATEGORIES, "id=" + Id, null);
   } catch (SQLException e) {
     Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
   }
 }
  @SuppressWarnings("nls")
  public void onCreate(Bundle icicle) {
    super.onCreate(icicle);
    setContentView(R.layout.database_list);

    Bundle extras = getIntent().getExtras();
    String query = extras.getString(LibraryConstants.PREFS_KEY_QUERY);

    SQLiteDatabase database = null;
    try {
      database = ADbHelper.getInstance().getDatabase();
    } catch (IOException e) {
      e.printStackTrace();
    }

    try {
      if (database != null && query != null) {
        cursor = database.rawQuery(query, null);
        startManagingCursor(cursor);

        DbCursorAdapter data = new DbCursorAdapter(this, cursor);
        setListAdapter(data);
      }
    } catch (SQLException e) {
      Utilities.messageDialog(
          this,
          "An error occurred while launching the query: " + e.getLocalizedMessage(),
          new Runnable() {
            public void run() {
              finish();
            }
          });
    }
  }
예제 #8
0
 /**
  * Begin a transaction on an open database.
  *
  * @return true if successful
  */
 public boolean beginTransaction() {
   try {
     db.execSQL("begin transaction;");
   } catch (SQLException e) {
     Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
     return false;
   }
   return true;
 }
예제 #9
0
 /** @param PBEKey */
 public void storeMasterKey(String MasterKey) {
   ContentValues args = new ContentValues();
   try {
     db.delete(TABLE_MASTER_KEY, "1=1", null);
     args.put("encryptedkey", MasterKey);
     db.insert(TABLE_MASTER_KEY, null, args);
   } catch (SQLException e) {
     Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
   }
 }
예제 #10
0
  /**
   * @param Id
   * @param entry
   */
  public void updateCategory(long Id, CategoryEntry entry) {
    ContentValues args = new ContentValues();
    args.put("name", entry.name);

    try {
      db.update(TABLE_CATEGORIES, args, "id=" + Id, null);
    } catch (SQLException e) {
      Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
    }
  }
예제 #11
0
  public void deleteDatabase() {
    try {
      db.execSQL(PASSWORDS_DROP);
      db.execSQL(PASSWORDS_CREATE);

      db.execSQL(CATEGORIES_DROP);
      db.execSQL(CATEGORIES_CREATE);
    } catch (SQLException e) {
      Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
    }
  }
예제 #12
0
  /**
   * No se borrará sobre SCORE
   *
   * @see mx.v1ctor.android.bd.BDObject#delete()
   */
  public boolean delete() {

    try {

      sqldb.delete(pbd.getTA_NOTES(), pbd.getID() + "=" + id, null);

    } catch (SQLException sql) {
      Log.e("ERROR", sql.getLocalizedMessage());
      return false;
    }
    return true;
  }
예제 #13
0
  /** @param entry */
  public long addCategory(CategoryEntry entry) {
    ContentValues initialValues = new ContentValues();
    initialValues.put("name", entry.name);

    long ret = -1;
    try {
      ret = db.insert(TABLE_CATEGORIES, null, initialValues);
    } catch (SQLException e) {
      Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
    }
    return ret;
  }
예제 #14
0
  /** @return */
  public List<PassEntry> fetchAllRows(Long CategoryId) {
    ArrayList<PassEntry> ret = new ArrayList<PassEntry>();
    try {
      Cursor c;
      if (CategoryId == 0) {
        c =
            db.query(
                TABLE_PASSWORDS,
                new String[] {
                  "id", "password", "description", "username", "website", "note", "category"
                },
                null,
                null,
                null,
                null,
                null);
      } else {
        c =
            db.query(
                TABLE_PASSWORDS,
                new String[] {
                  "id", "password", "description", "username", "website", "note", "category"
                },
                "category=" + CategoryId,
                null,
                null,
                null,
                null);
      }
      int numRows = c.getCount();
      c.moveToFirst();
      for (int i = 0; i < numRows; ++i) {
        PassEntry row = new PassEntry();
        row.id = c.getLong(0);

        row.password = c.getString(1);
        row.description = c.getString(2);
        row.username = c.getString(3);
        row.website = c.getString(4);
        row.note = c.getString(5);

        row.category = c.getLong(6);

        ret.add(row);
        c.moveToNext();
      }
      c.close();
    } catch (SQLException e) {
      Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
    }
    return ret;
  }
예제 #15
0
  /**
   * Only update the category field of the password entry.
   *
   * @param Id the id of the password entry
   * @param newCategoryId the updated category id
   */
  public void updatePasswordCategory(long Id, long newCategoryId) {
    if (Id < 0 || newCategoryId < 0) {
      // make sure values appear valid
      return;
    }
    ContentValues args = new ContentValues();
    args.put("category", newCategoryId);

    try {
      db.update(TABLE_PASSWORDS, args, "id=" + Id, null);
    } catch (SQLException e) {
      Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
    }
  }
예제 #16
0
  /**
   * @param Id
   * @param entry
   */
  public void updatePassword(long Id, PassEntry entry) {
    ContentValues args = new ContentValues();
    args.put("description", entry.description);
    args.put("username", entry.username);
    args.put("password", entry.password);
    args.put("website", entry.website);
    args.put("note", entry.note);

    try {
      db.update(TABLE_PASSWORDS, args, "id=" + Id, null);
    } catch (SQLException e) {
      Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
    }
  }
예제 #17
0
  /** @param ctx */
  public DBHelper(Context ctx) {
    myCtx = ctx;
    try {
      db = myCtx.openOrCreateDatabase(DATABASE_NAME, 0, null);

      // Check for the existence of the DBVERSION table
      // If it doesn't exist than create the overall data,
      // otherwise double check the version
      Cursor c =
          db.query(
              "sqlite_master",
              new String[] {"name"},
              "type='table' and name='" + TABLE_DBVERSION + "'",
              null,
              null,
              null,
              null);
      int numRows = c.getCount();
      if (numRows < 1) {
        CreateDatabase(db);
      } else {
        int version = 0;
        Cursor vc =
            db.query(
                true,
                TABLE_DBVERSION,
                new String[] {"version"},
                null,
                null,
                null,
                null,
                null,
                null);
        if (vc.getCount() > 0) {
          vc.moveToFirst();
          version = vc.getInt(0);
        }
        vc.close();
        if (version != DATABASE_VERSION) {
          needsUpgrade = true;
          Log.e(TAG, "database version mismatch");
        }
      }
      c.close();

    } catch (SQLException e) {
      Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
    }
  }
예제 #18
0
  /** @param entry */
  public void addPassword(PassEntry entry) {
    ContentValues initialValues = new ContentValues();
    initialValues.put("category", entry.category);
    initialValues.put("password", entry.password);
    initialValues.put("description", entry.description);
    initialValues.put("username", entry.username);
    initialValues.put("website", entry.website);
    initialValues.put("note", entry.note);

    try {
      db.insert(TABLE_PASSWORDS, null, initialValues);
    } catch (SQLException e) {
      Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
    }
  }
예제 #19
0
  /** @see mx.v1ctor.android.bd.BDObject#create() */
  public boolean create() {

    try {

      ContentValues values = new ContentValues();
      // values.put(pbd.getID(), id);
      values.put(pbd.getTEXT(), note);

      sqldb.insert(pbd.getTA_NOTES(), null, values);

    } catch (SQLException sql) {
      Log.e("ERROR", sql.getLocalizedMessage());
      return false;
    }
    return true;
  }
예제 #20
0
  private void CreateDatabase(SQLiteDatabase db) {
    try {
      db.execSQL(DBVERSION_CREATE);
      ContentValues args = new ContentValues();
      args.put("version", DATABASE_VERSION);
      db.insert(TABLE_DBVERSION, null, args);

      db.execSQL(CATEGORIES_CREATE);
      needsPrePopulation = true;

      db.execSQL(PASSWORDS_CREATE);
      db.execSQL(MASTER_KEY_CREATE);
    } catch (SQLException e) {
      Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
    }
  }
예제 #21
0
 public int fetchVersion() {
   int version = 0;
   try {
     Cursor c =
         db.query(
             true, TABLE_DBVERSION, new String[] {"version"}, null, null, null, null, null, null);
     if (c.getCount() > 0) {
       c.moveToFirst();
       version = c.getInt(0);
     }
     c.close();
   } catch (SQLException e) {
     Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
   }
   return version;
 }
예제 #22
0
 public String fetchOldConfirm() {
   String key = "";
   try {
     Cursor c =
         db.query(
             true, TABLE_VERIFY, new String[] {"confirm"}, null, null, null, null, null, null);
     if (c.getCount() > 0) {
       c.moveToFirst();
       key = c.getString(0);
     }
     c.close();
   } catch (SQLException e) {
     Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
   }
   return key;
 }
예제 #23
0
 /** @return */
 public List<CategoryEntry> fetchAllCategoryRows() {
   ArrayList<CategoryEntry> ret = new ArrayList<CategoryEntry>();
   try {
     Cursor c =
         db.query(TABLE_CATEGORIES, new String[] {"id", "name"}, null, null, null, null, null);
     int numRows = c.getCount();
     c.moveToFirst();
     for (int i = 0; i < numRows; ++i) {
       CategoryEntry row = new CategoryEntry();
       row.id = c.getLong(0);
       row.name = c.getString(1);
       ret.add(row);
       c.moveToNext();
     }
     c.close();
   } catch (SQLException e) {
     Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
   }
   return ret;
 }
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

      Log.w(
          TAG
              + "Upgrading database from version "
              + oldVersion
              + " to "
              + newVersion
              + ", which will destroy all old data");
      try {
        db.execSQL("DROP TABLE IF EXISTS profiles");
        db.execSQL("DROP TABLE IF EXISTS contacts");
        db.execSQL("DROP TABLE IF EXISTS notifications");
        onCreate(db);

      } catch (SQLException e) {
        Log.e(TAG + "getting exception " + e.getLocalizedMessage().toString());
      }
    }
예제 #25
0
 /** @param categoryId */
 public int countPasswords(long categoryId) {
   int count = 0;
   try {
     Cursor c =
         db.query(
             TABLE_PASSWORDS,
             new String[] {"count(*)"},
             "category=" + categoryId,
             null,
             null,
             null,
             null);
     c.moveToFirst();
     count = c.getInt(0);
     c.close();
   } catch (SQLException e) {
     Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
   }
   Log.i(TAG, "count=" + count);
   return count;
 }
예제 #26
0
  /**
   * @param Id
   * @return
   */
  public PassEntry fetchPassword(long Id) {
    PassEntry row = new PassEntry();
    try {
      Cursor c =
          db.query(
              true,
              TABLE_PASSWORDS,
              new String[] {
                "id", "password", "description", "username", "website", "note", "category"
              },
              "id=" + Id,
              null,
              null,
              null,
              null,
              null);
      if (c.getCount() > 0) {
        c.moveToFirst();
        row.id = c.getLong(0);

        row.password = c.getString(1);
        row.description = c.getString(2);
        row.username = c.getString(3);
        row.website = c.getString(4);
        row.note = c.getString(5);

        row.category = c.getLong(6);
      } else {
        row.id = -1;
        row.description = row.password = null;
      }
      c.close();
    } catch (SQLException e) {
      Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
    }
    return row;
  }
예제 #27
0
 /** @return */
 public String fetchMasterKey() {
   String key = "";
   try {
     Cursor c =
         db.query(
             true,
             TABLE_MASTER_KEY,
             new String[] {"encryptedkey"},
             null,
             null,
             null,
             null,
             null,
             null);
     if (c.getCount() > 0) {
       c.moveToFirst();
       key = c.getString(0);
     }
     c.close();
   } catch (SQLException e) {
     Log.d(TAG, "SQLite exception: " + e.getLocalizedMessage());
   }
   return key;
 }