protected void saveBookSeriesInfo(long bookId, SeriesInfo seriesInfo) { if (myGetSeriesIdStatement == null) { myGetSeriesIdStatement = myDatabase.compileStatement("SELECT series_id FROM Series WHERE name = ?"); myInsertSeriesStatement = myDatabase.compileStatement("INSERT OR IGNORE INTO Series (name) VALUES (?)"); myInsertBookSeriesStatement = myDatabase.compileStatement( "INSERT OR REPLACE INTO BookSeries (book_id,series_id,book_index) VALUES (?,?,?)"); myDeleteBookSeriesStatement = myDatabase.compileStatement("DELETE FROM BookSeries WHERE book_id = ?"); } if (seriesInfo == null) { myDeleteBookSeriesStatement.bindLong(1, bookId); myDeleteBookSeriesStatement.execute(); } else { long seriesId; try { myGetSeriesIdStatement.bindString(1, seriesInfo.Name); seriesId = myGetSeriesIdStatement.simpleQueryForLong(); } catch (SQLException e) { myInsertSeriesStatement.bindString(1, seriesInfo.Name); seriesId = myInsertSeriesStatement.executeInsert(); } myInsertBookSeriesStatement.bindLong(1, bookId); myInsertBookSeriesStatement.bindLong(2, seriesId); SQLiteUtil.bindString( myInsertBookSeriesStatement, 3, seriesInfo.Index != null ? seriesInfo.Index.toString() : null); myInsertBookSeriesStatement.execute(); } }
protected void saveBookAuthorInfo(long bookId, long index, Author author) { if (myGetAuthorIdStatement == null) { myGetAuthorIdStatement = myDatabase.compileStatement( "SELECT author_id FROM Authors WHERE name = ? AND sort_key = ?"); myInsertAuthorStatement = myDatabase.compileStatement("INSERT OR IGNORE INTO Authors (name,sort_key) VALUES (?,?)"); myInsertBookAuthorStatement = myDatabase.compileStatement( "INSERT OR REPLACE INTO BookAuthor (book_id,author_id,author_index) VALUES (?,?,?)"); } long authorId; try { myGetAuthorIdStatement.bindString(1, author.DisplayName); myGetAuthorIdStatement.bindString(2, author.SortKey); authorId = myGetAuthorIdStatement.simpleQueryForLong(); } catch (SQLException e) { myInsertAuthorStatement.bindString(1, author.DisplayName); myInsertAuthorStatement.bindString(2, author.SortKey); authorId = myInsertAuthorStatement.executeInsert(); } myInsertBookAuthorStatement.bindLong(1, bookId); myInsertBookAuthorStatement.bindLong(2, authorId); myInsertBookAuthorStatement.bindLong(3, index); myInsertBookAuthorStatement.execute(); }
private long getTagId(Tag tag) { if (myGetTagIdStatement == null) { myGetTagIdStatement = myDatabase.compileStatement("SELECT tag_id FROM Tags WHERE parent_id = ? AND name = ?"); myCreateTagIdStatement = myDatabase.compileStatement("INSERT OR IGNORE INTO Tags (parent_id,name) VALUES (?,?)"); } { final Long id = myIdByTag.get(tag); if (id != null) { return id; } } if (tag.Parent != null) { myGetTagIdStatement.bindLong(1, getTagId(tag.Parent)); } else { myGetTagIdStatement.bindNull(1); } myGetTagIdStatement.bindString(2, tag.Name); long id; try { id = myGetTagIdStatement.simpleQueryForLong(); } catch (SQLException e) { if (tag.Parent != null) { myCreateTagIdStatement.bindLong(1, getTagId(tag.Parent)); } else { myCreateTagIdStatement.bindNull(1); } myCreateTagIdStatement.bindString(2, tag.Name); id = myCreateTagIdStatement.executeInsert(); } myIdByTag.put(tag, id); myTagById.put(id, tag); return id; }
private void insertPhone( Cursor c, SQLiteStatement phoneInsert, SQLiteStatement phoneLookupInsert, SQLiteStatement hasPhoneUpdate) { long lastUpdatedContact = -1; long id = c.getLong(PhonesQuery.PERSON); String number = c.getString(PhonesQuery.NUMBER); String normalizedNumber = null; if (number != null) { normalizedNumber = PhoneNumberUtils.getStrippedReversed(number); } phoneInsert.bindLong(PhoneInsert.RAW_CONTACT_ID, id); phoneInsert.bindLong(PhoneInsert.MIMETYPE_ID, mPhoneMimetypeId); bindString(phoneInsert, PhoneInsert.IS_PRIMARY, c.getString(PhonesQuery.ISPRIMARY)); bindString(phoneInsert, PhoneInsert.NUMBER, number); bindString(phoneInsert, PhoneInsert.TYPE, c.getString(PhonesQuery.TYPE)); bindString(phoneInsert, PhoneInsert.LABEL, c.getString(PhonesQuery.LABEL)); bindString(phoneInsert, PhoneInsert.NORMALIZED_NUMBER, normalizedNumber); long dataId = insert(phoneInsert); if (normalizedNumber != null) { phoneLookupInsert.bindLong(PhoneLookupInsert.RAW_CONTACT_ID, id); phoneLookupInsert.bindLong(PhoneLookupInsert.DATA_ID, dataId); phoneLookupInsert.bindString(PhoneLookupInsert.NORMALIZED_NUMBER, normalizedNumber); insert(phoneLookupInsert); if (lastUpdatedContact != id) { lastUpdatedContact = id; hasPhoneUpdate.bindLong(HasPhoneNumberUpdate.CONTACT_ID, id); hasPhoneUpdate.execute(); } } }
protected void bindValues(SQLiteStatement sqlitestatement, FoodLocale foodlocale) { long l1 = 1L; sqlitestatement.clearBindings(); Object obj = foodlocale.getId(); if (obj != null) { sqlitestatement.bindLong(1, ((Long) (obj)).longValue()); } obj = foodlocale.getValue(); if (obj != null) { sqlitestatement.bindString(2, ((String) (obj))); } obj = foodlocale.getLabel(); if (obj != null) { sqlitestatement.bindString(3, ((String) (obj))); } obj = foodlocale.getSupportsLookupByBarCode(); long l; if (obj != null) { if (((Boolean) (obj)).booleanValue()) { l = 1L; } else { l = 0L; } sqlitestatement.bindLong(4, l); } foodlocale = foodlocale.getImageUpload(); if (foodlocale != null) { if (foodlocale.booleanValue()) { l = l1; } else { l = 0L; } sqlitestatement.bindLong(5, l); } }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, ConquestMoveDisplacements entity) { stmt.clearBindings(); stmt.bindLong(1, entity.getId()); stmt.bindString(2, entity.getIdentifier()); stmt.bindLong(3, entity.getAffectsTarget() ? 1L : 0L); }
private void insertStructuredName(Cursor c, SQLiteStatement insert) { String name = c.getString(PeopleQuery.NAME); if (TextUtils.isEmpty(name)) { return; } long id = c.getLong(PeopleQuery._ID); insert.bindLong(StructuredNameInsert.RAW_CONTACT_ID, id); insert.bindLong(StructuredNameInsert.MIMETYPE_ID, mStructuredNameMimetypeId); bindString(insert, StructuredNameInsert.DISPLAY_NAME, name); NameSplitter.Name splitName = new NameSplitter.Name(); mNameSplitter.split(splitName, name); bindString(insert, StructuredNameInsert.PREFIX, splitName.getPrefix()); bindString(insert, StructuredNameInsert.GIVEN_NAME, splitName.getGivenNames()); bindString(insert, StructuredNameInsert.MIDDLE_NAME, splitName.getMiddleName()); bindString(insert, StructuredNameInsert.FAMILY_NAME, splitName.getFamilyName()); bindString(insert, StructuredNameInsert.SUFFIX, splitName.getSuffix()); if (mPhoneticNameAvailable) { // TODO: add the ability to insert an unstructured phonetic name String phoneticName = c.getString(PeopleQuery.PHONETIC_NAME); } long dataId = insert(insert); mContactsProvider.insertNameLookupForStructuredName(id, dataId, name); }
@Override protected final void bindValues(SQLiteStatement stmt, TestData entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } String testString = entity.getTestString(); if (testString != null) { stmt.bindString(2, testString); } Long testLong = entity.getTestLong(); if (testLong != null) { stmt.bindLong(3, testLong); } java.util.Date testDate = entity.getTestDate(); if (testDate != null) { stmt.bindLong(4, testDate.getTime()); } Integer testInt = entity.getTestInt(); if (testInt != null) { stmt.bindLong(5, testInt); } Boolean testBoolean = entity.getTestBoolean(); if (testBoolean != null) { stmt.bindLong(6, testBoolean ? 1L : 0L); } }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, DBCover entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } String urlSmall = entity.getUrlSmall(); if (urlSmall != null) { stmt.bindString(2, urlSmall); } Integer height = entity.getHeight(); if (height != null) { stmt.bindLong(3, height); } String url = entity.getUrl(); if (url != null) { stmt.bindString(4, url); } Integer width = entity.getWidth(); if (width != null) { stmt.bindLong(5, width); } }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, stepbean entity) { stmt.clearBindings(); String day = entity.getDay(); if (day != null) { stmt.bindString(1, day); } Long bengin = entity.getBengin(); if (bengin != null) { stmt.bindLong(2, bengin); } Long end = entity.getEnd(); if (end != null) { stmt.bindLong(3, end); } Integer stepcount = entity.getStepcount(); if (stepcount != null) { stmt.bindLong(4, stepcount); } Integer source = entity.getSource(); if (source != null) { stmt.bindLong(5, source); } }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, Person entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } stmt.bindString(2, entity.getName()); Integer age = entity.getAge(); if (age != null) { stmt.bindLong(3, age); } Integer height = entity.getHeight(); if (height != null) { stmt.bindLong(4, height); } String introduction = entity.getIntroduction(); if (introduction != null) { stmt.bindString(5, introduction); } }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, Feeling entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } String content = entity.getContent(); if (content != null) { stmt.bindString(2, content); } Long serverId = entity.getServerId(); if (serverId != null) { stmt.bindLong(3, serverId); } Integer statusFlag = entity.getStatusFlag(); if (statusFlag != null) { stmt.bindLong(4, statusFlag); } stmt.bindLong(5, entity.getLocationId()); }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, ConquestWarriorNames entity) { stmt.clearBindings(); stmt.bindLong(1, entity.getWarriorId()); stmt.bindLong(2, entity.getLocalLanguageId()); stmt.bindString(3, entity.getName()); }
@Override public void addGBActivitySamples(ActivitySample[] activitySamples) { try (SQLiteDatabase db = this.getWritableDatabase()) { String sql = "INSERT INTO " + TABLE_GBACTIVITYSAMPLES + " (" + KEY_TIMESTAMP + "," + KEY_PROVIDER + "," + KEY_INTENSITY + "," + KEY_STEPS + "," + KEY_TYPE + ")" + " VALUES (?,?,?,?,?);"; SQLiteStatement statement = db.compileStatement(sql); db.beginTransaction(); for (ActivitySample activitySample : activitySamples) { statement.clearBindings(); statement.bindLong(1, activitySample.getTimestamp()); statement.bindLong(2, activitySample.getProvider().getID()); statement.bindLong(3, activitySample.getRawIntensity()); statement.bindLong(4, activitySample.getSteps()); statement.bindLong(5, activitySample.getRawKind()); statement.execute(); } db.setTransactionSuccessful(); db.endTransaction(); } }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, Comment entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } String content = entity.getContent(); if (content != null) { stmt.bindString(2, content); } String userId = entity.getUserId(); if (userId != null) { stmt.bindString(3, userId); } String postId = entity.getPostId(); if (postId != null) { stmt.bindString(4, postId); } Long idCatPost = entity.getIdCatPost(); if (idCatPost != null) { stmt.bindLong(5, idCatPost); } }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, TokensBD entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } Long expiresIn = entity.getExpiresIn(); if (expiresIn != null) { stmt.bindLong(2, expiresIn); } Long expiresAt = entity.getExpiresAt(); if (expiresAt != null) { stmt.bindLong(3, expiresAt); } String tokenType = entity.getTokenType(); if (tokenType != null) { stmt.bindString(4, tokenType); } String refreshToken = entity.getRefreshToken(); if (refreshToken != null) { stmt.bindString(5, refreshToken); } String accessToken = entity.getAccessToken(); if (accessToken != null) { stmt.bindString(6, accessToken); } }
@MediumTest public void testSimpleQuery() throws Exception { mDatabase.execSQL("CREATE TABLE test (num INTEGER NOT NULL, str TEXT NOT NULL);"); mDatabase.execSQL("INSERT INTO test VALUES (1234, 'hello');"); SQLiteStatement statement1 = mDatabase.compileStatement("SELECT num FROM test WHERE str = ?"); SQLiteStatement statement2 = mDatabase.compileStatement("SELECT str FROM test WHERE num = ?"); try { statement1.bindString(1, "hello"); long value = statement1.simpleQueryForLong(); assertEquals(1234, value); statement1.bindString(1, "world"); statement1.simpleQueryForLong(); fail("shouldn't get here"); } catch (SQLiteDoneException e) { // expected } try { statement2.bindLong(1, 1234); String value = statement1.simpleQueryForString(); assertEquals("hello", value); statement2.bindLong(1, 5678); statement1.simpleQueryForString(); fail("shouldn't get here"); } catch (SQLiteDoneException e) { // expected } statement1.close(); statement2.close(); }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, MunkaKep entity) { stmt.clearBindings(); Long munkaKepID = entity.getMunkaKepID(); if (munkaKepID != null) { stmt.bindLong(1, munkaKepID); } String munkaKepPath = entity.getMunkaKepPath(); if (munkaKepPath != null) { stmt.bindString(2, munkaKepPath); } String munkaKepDate = entity.getMunkaKepDate(); if (munkaKepDate != null) { stmt.bindString(3, munkaKepDate); } Boolean munkaKepIsUploaded = entity.getMunkaKepIsUploaded(); if (munkaKepIsUploaded != null) { stmt.bindLong(4, munkaKepIsUploaded ? 1l : 0l); } Boolean munkaKepIsActive = entity.getMunkaKepIsActive(); if (munkaKepIsActive != null) { stmt.bindLong(5, munkaKepIsActive ? 1l : 0l); } Long munkaID = entity.getMunkaID(); if (munkaID != null) { stmt.bindLong(6, munkaID); } }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, ConquestWarriorSpecialties entity) { stmt.clearBindings(); stmt.bindLong(1, entity.getWarriorId()); stmt.bindLong(2, entity.getTypeId()); stmt.bindLong(3, entity.getSlot()); }
public void updateHomeWork(HomeWork hw) { try { mDb.beginTransaction(); if (hw != null) { mUpdateHomeWorkStatement.clearBindings(); if (hw.isComplite()) { mUpdateHomeWorkStatement.bindLong(1, 1); NotificationManager.getInstance().removeNotification(hw); } else { mUpdateHomeWorkStatement.bindLong(1, 0); NotificationManager.getInstance().addNewNotification(hw); } if (hw.getMessage() != null) { mUpdateHomeWorkStatement.bindString(2, hw.getMessage()); } if (hw.getMessage() != null) { mUpdateHomeWorkStatement.bindBlob(3, Slipper.serializeObject(hw.getImages())); } mUpdateHomeWorkStatement.bindLong(4, hw.getId()); mUpdateHomeWorkStatement.execute(); } mDb.setTransactionSuccessful(); } catch (Exception e) { e.printStackTrace(); } finally { mDb.endTransaction(); } }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, ThirdGameDownInfo entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } String gameURLId = entity.getGameURLId(); if (gameURLId != null) { stmt.bindString(2, gameURLId); } String url = entity.getUrl(); if (url != null) { stmt.bindString(3, url); } Integer downToken = entity.getDownToken(); if (downToken != null) { stmt.bindLong(4, downToken); } String remark = entity.getRemark(); if (remark != null) { stmt.bindString(5, remark); } String logoUrl = entity.getLogoUrl(); if (logoUrl != null) { stmt.bindString(6, logoUrl); } stmt.bindString(7, entity.getGameId()); }
public void saveTile(Tile tile, ByteArrayOutputStream data, boolean success) { byte[] bytes = null; if (success) bytes = data.toByteArray(); synchronized (mCacheBuffers) { data.reset(); mCacheBuffers.add(data); } if (dbg) log.debug("store tile {} {}", tile, Boolean.valueOf(success)); if (!success) return; synchronized (mStmtPutTile) { mStmtPutTile.bindLong(1, tile.tileX); mStmtPutTile.bindLong(2, tile.tileY); mStmtPutTile.bindLong(3, tile.zoomLevel); mStmtPutTile.bindLong(4, 0); mStmtPutTile.bindLong(5, 0); mStmtPutTile.bindBlob(6, bytes); mStmtPutTile.execute(); mStmtPutTile.clearBindings(); } }
/** update the level and count for the given flashcard in the database. */ private void updateFlashcard(Flashcard fc) { openDB(); _curDB.beginTransaction(); try { // Delete old entry if any. SQLiteStatement dStmt = getCompiledStatement(SQL_DELETE_FCS); dStmt.bindString(1, fc.getLang1Str()); dStmt.execute(); // insert new state entry. SQLiteStatement iStmt = getCompiledStatement(SQL_INSERT_FCS); iStmt.bindString(1, fc.getLang1Str()); iStmt.bindLong(2, fc.getLevel()); iStmt.bindLong(3, fc.getRightGuessCount()); iStmt.execute(); _curDB.setTransactionSuccessful(); } catch (SQLException e) { MsgDispatcher.sendMessageToUI( MsgType.MSG_SHOW_ERROR_MSG, 0, 0, "unable to update id=" + fc.getID()); } finally { _curDB.endTransaction(); } // this flashcard is no longer used by anyone so release it. fc.release(); }
public void insertFiles(File[] files) { SQLiteDatabase database = dbHelper.getWritableDatabase(); SQLiteStatement statement = database.compileStatement( "INSERT INTO " + TABLE_NAME + " (" + COL_FILENAME + ", " + COL_FILESIZE + ", " + COL_TIMESTAMP + ") VALUES (?, ?, ?)"); database.beginTransaction(); try { for (File file : files) { statement.bindString(1, file.getName()); statement.bindLong(2, file.length()); statement.bindLong(3, file.lastModified()); statement.executeInsert(); } database.setTransactionSuccessful(); } finally { database.endTransaction(); } }
public void hapusBukmakByAri(int ari, int jenis) { SQLiteDatabase db = helper.getWritableDatabase(); db.beginTransaction(); try { long _id; SQLiteStatement stmt = db.compileStatement( "select _id from " + Db.TABEL_Bukmak2 + " where " + Db.Bukmak2.jenis + "=? and " + Db.Bukmak2.ari + "=?"); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$ try { stmt.bindLong(1, jenis); stmt.bindLong(2, ari); _id = stmt.simpleQueryForLong(); } finally { stmt.close(); } String[] params = {String.valueOf(_id)}; db.delete(Db.TABEL_Bukmak2_Label, Db.Bukmak2_Label.bukmak2_id + "=?", params); // $NON-NLS-1$ db.delete(Db.TABEL_Bukmak2, "_id=?", params); // $NON-NLS-1$ db.setTransactionSuccessful(); } finally { db.endTransaction(); } }
@Override public void changeStoredSamplesType( int timestampFrom, int timestampTo, byte kind, SampleProvider provider) { try (SQLiteDatabase db = this.getReadableDatabase()) { String sql = "UPDATE " + TABLE_GBACTIVITYSAMPLES + " SET " + KEY_TYPE + "= ? WHERE " + KEY_PROVIDER + " = ? AND " + KEY_TIMESTAMP + " >= ? AND " + KEY_TIMESTAMP + " < ? ;"; // do not use BETWEEN because the range is inclusive in that case! SQLiteStatement statement = db.compileStatement(sql); statement.bindLong(1, kind); statement.bindLong(2, provider.getID()); statement.bindLong(3, timestampFrom); statement.bindLong(4, timestampTo); statement.execute(); } }
private void insertStructuredName(Cursor c, SQLiteStatement insert) { String name = c.getString(PeopleQuery.NAME); if (TextUtils.isEmpty(name)) { return; } long id = c.getLong(PeopleQuery._ID); insert.bindLong(StructuredNameInsert.RAW_CONTACT_ID, id); insert.bindLong(StructuredNameInsert.MIMETYPE_ID, mStructuredNameMimetypeId); bindString(insert, StructuredNameInsert.DISPLAY_NAME, name); NameSplitter.Name splitName = new NameSplitter.Name(); mNameSplitter.split(splitName, name); bindString(insert, StructuredNameInsert.PREFIX, splitName.getPrefix()); bindString(insert, StructuredNameInsert.GIVEN_NAME, splitName.getGivenNames()); bindString(insert, StructuredNameInsert.MIDDLE_NAME, splitName.getMiddleName()); bindString(insert, StructuredNameInsert.FAMILY_NAME, splitName.getFamilyName()); bindString(insert, StructuredNameInsert.SUFFIX, splitName.getSuffix()); final String joined = mNameSplitter.join(splitName, true); bindString(insert, StructuredNameInsert.DISPLAY_NAME, joined); if (mPhoneticNameAvailable) { String phoneticName = c.getString(PeopleQuery.PHONETIC_NAME); if (phoneticName != null) { int index = phoneticName.indexOf(' '); if (index == -1) { splitName.phoneticFamilyName = phoneticName; } else { splitName.phoneticFamilyName = phoneticName.substring(0, index).trim(); splitName.phoneticGivenName = phoneticName.substring(index + 1).trim(); } } } mNameSplitter.guessNameStyle(splitName); int fullNameStyle = splitName.getFullNameStyle(); insert.bindLong(StructuredNameInsert.FULL_NAME_STYLE, fullNameStyle); bindString(insert, StructuredNameInsert.PHONETIC_FAMILY_NAME, splitName.phoneticFamilyName); bindString(insert, StructuredNameInsert.PHONETIC_MIDDLE_NAME, splitName.phoneticMiddleName); bindString(insert, StructuredNameInsert.PHONETIC_GIVEN_NAME, splitName.phoneticGivenName); insert.bindLong(StructuredNameInsert.PHONETIC_NAME_STYLE, splitName.phoneticNameStyle); long dataId = insert(insert); mContactsProvider.insertNameLookupForStructuredName( id, dataId, name, mNameSplitter.getAdjustedFullNameStyle(fullNameStyle)); if (splitName.phoneticFamilyName != null || splitName.phoneticMiddleName != null || splitName.phoneticGivenName != null) { mContactsProvider.insertNameLookupForPhoneticName( id, dataId, splitName.phoneticFamilyName, splitName.phoneticMiddleName, splitName.phoneticGivenName); } }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, p2p9 entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } Integer flipc = entity.getFlipc(); if (flipc != null) { stmt.bindLong(2, flipc); } Integer cpmr = entity.getCpmr(); if (cpmr != null) { stmt.bindLong(3, cpmr); } Integer encd = entity.getEncd(); if (encd != null) { stmt.bindLong(4, encd); } Integer adp = entity.getAdp(); if (adp != null) { stmt.bindLong(5, adp); } Integer sbv = entity.getSbv(); if (sbv != null) { stmt.bindLong(6, sbv); } Integer adc = entity.getAdc(); if (adc != null) { stmt.bindLong(7, adc); } Integer pex = entity.getPex(); if (pex != null) { stmt.bindLong(8, pex); } Integer origen = entity.getOrigen(); if (origen != null) { stmt.bindLong(9, origen); } String obser = entity.getObser(); if (obser != null) { stmt.bindString(10, obser); } Integer id_formulario = entity.getId_formulario(); if (id_formulario != null) { stmt.bindLong(11, id_formulario); } }
private void insertNormalizedNameLookup( SQLiteStatement stmt, long rawContactId, long dataId, int lookupType, String normalizedName) { stmt.bindLong(1, rawContactId); stmt.bindLong(2, dataId); stmt.bindLong(3, lookupType); stmt.bindString(4, normalizedName); stmt.executeInsert(); }
/** * This method is called when a job is pulled to run. It is properly marked so that it won't be * returned from next job queries. * * <p>Same mechanism is also used for cancelled jobs. * * @param jobHolder The job holder to update session id */ private void setSessionIdOnJob(JobHolder jobHolder) { SQLiteStatement stmt = sqlHelper.getOnJobFetchedForRunningStatement(); jobHolder.setRunCount(jobHolder.getRunCount() + 1); jobHolder.setRunningSessionId(sessionId); stmt.clearBindings(); stmt.bindLong(1, jobHolder.getRunCount()); stmt.bindLong(2, sessionId); stmt.bindString(3, jobHolder.getId()); stmt.execute(); }