@Override public void bindString(int index, String value) { delegate.bindString(index, value); }
@Override protected final void bindValues(SQLiteStatement stmt, StringKeyValueEntity entity) { stmt.clearBindings(); String key = entity.getKey(); if (key != null) { stmt.bindString(1, key); } String value = entity.getValue(); if (value != null) { stmt.bindString(2, value); } }
void put(String key, String value) { insertStatement.bindString(1, key); insertStatement.bindString(2, value); insertStatement.execute(); insertStatement.clearBindings(); workingStorage.put(key, value); }
String value = "one's self"; StringBuilder query= StringBuilder(); query.append("insert into tname(foo) values (?)"); SQLiteStatement stmt= db.compileStatement(query.toString()); stmt.bindString(1, value); long rowId= stmt.executeInsert(); // do logic check for > -1 on success
void remove(String key) { deleteStatement.bindString(1, key); deleteStatement.executeUpdateDelete(); deleteStatement.clearBindings(); workingStorage.remove(key); }
String sql = "INSERT INTO table_name (column_1, column_2) VALUES (?, ?)"; SQLiteStatement statement = db.compileStatement(sql); int intValue = 57; String stringValue = "hello"; statement.bindLong(1, intValue); // These match to the two question marks in the sql string statement.bindString(2, stringValue); long rowId = statement.executeInsert();
String sql = "UPDATE table_name SET column_2=? WHERE column_1=?"; SQLiteStatement statement = db.compileStatement(sql); int id = 7; String stringValue = "hi there"; statement.bindString(1, stringValue); statement.bindLong(2, id); int numberOfRowsAffected = statement.executeUpdateDelete();
@Override protected final void bindValues(SQLiteStatement stmt, SqliteMaster entity) { stmt.clearBindings(); String type = entity.getType(); if (type != null) { stmt.bindString(1, type); } String name = entity.getName(); if (name != null) { stmt.bindString(2, name); } String tableName = entity.getTableName(); if (tableName != null) { stmt.bindString(3, tableName); } Long rootpage = entity.getRootpage(); if (rootpage != null) { stmt.bindLong(4, rootpage); } String sql = entity.getSql(); if (sql != null) { stmt.bindString(5, sql); } }
@Override protected final void bindValues(SQLiteStatement stmt, ExtendsImplementsEntity entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } String text = entity.getText(); if (text != null) { stmt.bindString(2, text); } }
@Override protected final void bindValues(SQLiteStatement stmt, ToManyEntity entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } String sourceJoinProperty = entity.getSourceJoinProperty(); if (sourceJoinProperty != null) { stmt.bindString(2, sourceJoinProperty); } }
@Override protected final void bindValues(SQLiteStatement stmt, IndexedStringEntity entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } String indexedString = entity.getIndexedString(); if (indexedString != null) { stmt.bindString(2, indexedString); } }
@Override protected final void bindValues(SQLiteStatement stmt, AnActiveEntity entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } String text = entity.getText(); if (text != null) { stmt.bindString(2, text); } }
protected void updateInsideSynchronized(T entity, SQLiteStatement stmt, boolean lock) { // To do? Check if it's worth not to bind PKs here (performance). bindValues(stmt, entity); int index = config.allColumns.length + 1; K key = getKey(entity); if (key instanceof Long) { stmt.bindLong(index, (Long) key); } else if (key == null) { throw new DaoException("Cannot update entity without key - was it inserted before?"); } else { stmt.bindString(index, key.toString()); } stmt.execute(); attachEntity(key, entity, lock); }
@Override public void onJobCancelled(JobHolder jobHolder) { SQLiteStatement stmt = sqlHelper.getMarkAsCancelledStatement(); stmt.clearBindings(); stmt.bindString(1, jobHolder.getId()); stmt.execute(); }
@Test public void testExecuteUpdateDelete() throws Exception { SQLiteStatement insertStatement = database.compileStatement("INSERT INTO `routine` (`name`) VALUES (?)"); insertStatement.bindString(1, "Hand Press"); long pkeyOne = insertStatement.executeInsert(); assertThat(pkeyOne).isEqualTo(1); SQLiteStatement updateStatement = database.compileStatement("UPDATE `routine` SET `name`=? WHERE `id`=?"); updateStatement.bindString(1, "Head Press"); updateStatement.bindLong(2, pkeyOne); assertThat(updateStatement.executeUpdateDelete()).isEqualTo(1); Cursor dataCursor = database.rawQuery("SELECT `name` FROM `routine`", null); assertThat(dataCursor.moveToNext()).isTrue(); assertThat(dataCursor.getString(0)).isEqualTo("Head Press"); }
@Override protected final void bindValues(SQLiteStatement stmt, ToManyTargetEntity entity) { stmt.clearBindings(); Long toManyId = entity.getToManyId(); if (toManyId != null) { stmt.bindLong(1, toManyId); } Long toManyIdDesc = entity.getToManyIdDesc(); if (toManyIdDesc != null) { stmt.bindLong(2, toManyIdDesc); } Long id = entity.getId(); if (id != null) { stmt.bindLong(3, id); } String targetJoinProperty = entity.getTargetJoinProperty(); if (targetJoinProperty != null) { stmt.bindString(4, targetJoinProperty); } }
@Test public void testCloseShouldCloseUnderlyingPreparedStatement() throws Exception { SQLiteStatement insertStatement = database.compileStatement("INSERT INTO `routine` (`name`) VALUES (?)"); insertStatement.bindString(1, "Hand Press"); insertStatement.close(); try { insertStatement.executeInsert(); fail(); } catch (Exception e) { assertThat(e).isInstanceOf(IllegalStateException.class); } } }
@Override protected final void bindValues(SQLiteStatement stmt, RelationEntity entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } Long parentId = entity.getParentId(); if (parentId != null) { stmt.bindLong(2, parentId); } Long testId = entity.getTestId(); if (testId != null) { stmt.bindLong(3, testId); } stmt.bindLong(4, entity.getTestIdNotNull()); String simpleString = entity.getSimpleString(); if (simpleString != null) { stmt.bindString(5, simpleString); } }
@Test public void simpleQueryTest() throws Exception { SQLiteStatement stmt = database.compileStatement("SELECT count(*) FROM `countme`"); assertThat(stmt.simpleQueryForLong()).isEqualTo(0L); assertThat(stmt.simpleQueryForString()).isEqualTo("0"); SQLiteStatement insertStatement = database.compileStatement("INSERT INTO `countme` (`name` ,`lastUsed` ) VALUES (?,?)"); insertStatement.bindString(1, "Leg Press"); insertStatement.bindLong(2, 0); insertStatement.executeInsert(); assertThat(stmt.simpleQueryForLong()).isEqualTo(1L); assertThat(stmt.simpleQueryForString()).isEqualTo("1"); insertStatement.bindString(1, "Bench Press"); insertStatement.bindLong(2, 1); insertStatement.executeInsert(); assertThat(stmt.simpleQueryForLong()).isEqualTo(2L); assertThat(stmt.simpleQueryForString()).isEqualTo("2"); }
@Override protected final void bindValues(SQLiteStatement stmt, SimpleEntityNotNull entity) { stmt.clearBindings(); stmt.bindLong(1, entity.getId()); stmt.bindLong(2, entity.getSimpleBoolean() ? 1L: 0L); stmt.bindLong(3, entity.getSimpleByte()); stmt.bindLong(4, entity.getSimpleShort()); stmt.bindLong(5, entity.getSimpleInt()); stmt.bindLong(6, entity.getSimpleLong()); stmt.bindDouble(7, entity.getSimpleFloat()); stmt.bindDouble(8, entity.getSimpleDouble()); stmt.bindString(9, entity.getSimpleString()); stmt.bindBlob(10, entity.getSimpleByteArray()); }