public void addEntry( String name, byte[] image) throws SQLiteException{ SQLiteDatabase database = this.getWritableDatabase(); ContentValues cv = new ContentValues(); cv.put(KEY_NAME, name); cv.put(KEY_IMAGE, image); database.insert( DB_TABLE, null, cv ); }
db.close(); ContentValues initialValues = new ContentValues(); initialValues.put("code", code); initialValues.put("name", name); db.insert(DATABASE_TABLE, null, initialValues); ContentValues args = new ContentValues(); args.put("code", code); args.put("name", name); db.update(DATABASE_TABLE, args, "_id=" + rowId, null);
@Test public void testInsertWithException() { ContentValues values = new ContentValues(); assertEquals(-1, database.insert("table_that_doesnt_exist", null, values)); }
@Test public void shouldCorrectlyReturnNullValues() { database.execSQL("CREATE TABLE null_test (col_int INTEGER, col_text TEXT, col_real REAL, col_blob BLOB)"); ContentValues data = new ContentValues(); data.putNull("col_int"); data.putNull("col_text"); data.putNull("col_real"); data.putNull("col_blob"); assertThat(database.insert("null_test", null, data)).isAtLeast(0L); Cursor nullValuesCursor = database.query("null_test", null, null, null, null, null, null); nullValuesCursor.moveToFirst(); final int colsCount = 4; for (int i = 0; i < colsCount; i++) { assertThat(nullValuesCursor.getType(i)).isEqualTo(Cursor.FIELD_TYPE_NULL); assertThat(nullValuesCursor.getString(i)).isNull(); } assertThat(nullValuesCursor.getBlob(3)).isNull(); }
@Override public void onCreate(@NonNull final SQLiteDatabase sqLiteDatabase) { sqLiteDatabase.execSQL(CREATE_TABLE); for (final String value : VALUES) { final ContentValues contentValues = new ContentValues(); contentValues.put(NOTES_NOTE_COLUMN, value); sqLiteDatabase.insert(NOTES_TABLE, null, contentValues); } }
@Test public void testDataInMemoryDatabaseIsPersistentAfterClose() throws Exception { SQLiteDatabase db1 = openOrCreateDatabase("db1"); db1.execSQL("CREATE TABLE foo(id INTEGER PRIMARY KEY AUTOINCREMENT, data TEXT);"); ContentValues d1 = new ContentValues(); d1.put("data", "d1"); db1.insert("foo", null, d1); db1.close(); SQLiteDatabase db2 = openOrCreateDatabase("db1"); Cursor c = db2.rawQuery("select * from foo", null); assertThat(c).isNotNull(); assertThat(c.getCount()).isEqualTo(1); assertThat(c.moveToNext()).isTrue(); assertThat(c.getString(c.getColumnIndex("data"))).isEqualTo("d1"); }
@Test public void shouldAlwaysReturnCorrectIdFromInsert() throws Exception { database.execSQL("CREATE TABLE table_A (\n" + " _id INTEGER PRIMARY KEY AUTOINCREMENT,\n" + " id INTEGER DEFAULT 0\n" + ");"); database.execSQL("CREATE VIRTUAL TABLE new_search USING fts3 (id);"); database.execSQL("CREATE TRIGGER t1 AFTER INSERT ON table_A WHEN new.id=0 BEGIN UPDATE table_A SET id=-new._id WHERE _id=new._id AND id=0; END;"); database.execSQL("CREATE TRIGGER t2 AFTER INSERT ON table_A BEGIN INSERT INTO new_search (id) VALUES (new._id); END;"); database.execSQL("CREATE TRIGGER t3 BEFORE UPDATE ON table_A BEGIN DELETE FROM new_search WHERE id MATCH old._id; END;"); database.execSQL("CREATE TRIGGER t4 AFTER UPDATE ON table_A BEGIN INSERT INTO new_search (id) VALUES (new._id); END;"); long[] returnedIds = new long[]{ database.insert("table_A", "id", new ContentValues()), database.insert("table_A", "id", new ContentValues()) }; Cursor c = database.query("table_A", new String[]{"_id"}, null, null, null, null, null); assertThat(c).isNotNull(); long[] actualIds = new long[c.getCount()]; for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()) { actualIds[c.getPosition()] = c.getLong(c.getColumnIndexOrThrow("_id")); } c.close(); assertThat(returnedIds).isEqualTo(actualIds); }
/** * Adds a new guest to the mDb including the party count and the current timestamp * * @param name Guest's name * @param partySize Number in party * @return id of new record added */ private long addNewGuest(String name, int partySize) { ContentValues cv = new ContentValues(); cv.put(WaitlistContract.WaitlistEntry.COLUMN_GUEST_NAME, name); cv.put(WaitlistContract.WaitlistEntry.COLUMN_PARTY_SIZE, partySize); return mDb.insert(WaitlistContract.WaitlistEntry.TABLE_NAME, null, cv); }
ContentValues testTaskValues = new ContentValues(); testTaskValues.put(TaskContract.TaskEntry.COLUMN_DESCRIPTION, "Test description"); testTaskValues.put(TaskContract.TaskEntry.COLUMN_PRIORITY, 1); long taskRowId = database.insert( database.close();
public boolean insertContact(String name, String phone, String email, String street, String place) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues contentValues = new ContentValues(); contentValues.put("name", name); contentValues.put("phone", phone); contentValues.put("email", email); contentValues.put("street", street); contentValues.put("place", place); contentValues.put(CONTACTS_CREATED_AT, Calendar.getInstance().getTimeInMillis()); db.insert("contacts", null, contentValues); return true; }
ContentValues testTaskValues = new ContentValues(); testTaskValues.put(TaskContract.TaskEntry.COLUMN_DESCRIPTION, "Test description"); testTaskValues.put(TaskContract.TaskEntry.COLUMN_PRIORITY, 1); long taskRowId = database.insert( database.close();
public boolean add(String channelId, String channelName, int isEnable, int position) { ContentValues values = new ContentValues(); values.put(NewsChannelTable.ID, channelId); values.put(NewsChannelTable.NAME, channelName); values.put(NewsChannelTable.IS_ENABLE, isEnable); values.put(NewsChannelTable.POSITION, position); long result = db.insert(NewsChannelTable.TABLENAME, null, values); return result != -1; }
ContentValues testTaskValues = new ContentValues(); testTaskValues.put(TaskContract.TaskEntry.COLUMN_DESCRIPTION, "Test description"); testTaskValues.put(TaskContract.TaskEntry.COLUMN_PRIORITY, 1); long taskRowId = database.insert( database.close();
public boolean insertCar(String name, String color, float mileage) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues contentValues = new ContentValues(); contentValues.put("name", name); contentValues.put("color", color); contentValues.put("mileage", mileage); db.insert("cars", null, contentValues); return true; }
ContentValues testTaskValues = new ContentValues(); testTaskValues.put(TaskContract.TaskEntry.COLUMN_DESCRIPTION, "Test description"); testTaskValues.put(TaskContract.TaskEntry.COLUMN_PRIORITY, 1); long taskRowId = database.insert( database.close();