Java Code Examples for android.database.sqlite.SQLiteStatement#bindBlob()

The following examples show how to use android.database.sqlite.SQLiteStatement#bindBlob() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source File: WeatherEntityDao.java From easyweather with MIT License

6 votes

@Override
protected final void bindValues(SQLiteStatement stmt, WeatherEntity entity) {
    stmt.clearBindings();
 
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id);
    }
 
    String cityName = entity.getCityName();
    if (cityName != null) {
        stmt.bindString(2, cityName);
    }
 
    byte[] weather = entity.getWeather();
    if (weather != null) {
        stmt.bindBlob(3, weather);
    }
 
    java.util.Date updateTime = entity.getUpdateTime();
    if (updateTime != null) {
        stmt.bindLong(4, updateTime.getTime());
    }
}

Example 2

Source File: LuaZipFileDao.java From MiBandDecompiled with Apache License 2.0

6 votes

protected void bindValues(SQLiteStatement sqlitestatement, LuaZipFile luazipfile)
{
    sqlitestatement.clearBindings();
    Long long1 = luazipfile.getId();
    if (long1 != null)
    {
        sqlitestatement.bindLong(1, long1.longValue());
    }
    String s = luazipfile.getVersion();
    if (s != null)
    {
        sqlitestatement.bindString(2, s);
    }
    String s1 = luazipfile.getDate();
    if (s1 != null)
    {
        sqlitestatement.bindString(3, s1);
    }
    byte abyte0[] = luazipfile.getZipFile();
    if (abyte0 != null)
    {
        sqlitestatement.bindBlob(4, abyte0);
    }
}

Example 3

Source File: SqliteJobQueue.java From Mover with Apache License 2.0

6 votes

private void bindValues(SQLiteStatement stmt, JobHolder jobHolder) {
    if (jobHolder.getId() != null) {
        stmt.bindLong(DbOpenHelper.ID_COLUMN.columnIndex + 1, jobHolder.getId());
    }
    stmt.bindLong(DbOpenHelper.PRIORITY_COLUMN.columnIndex + 1, jobHolder.getPriority());
    if(jobHolder.getGroupId() != null) {
        stmt.bindString(DbOpenHelper.GROUP_ID_COLUMN.columnIndex + 1, jobHolder.getGroupId());
    }
    stmt.bindLong(DbOpenHelper.RUN_COUNT_COLUMN.columnIndex + 1, jobHolder.getRunCount());
    byte[] baseJob = getSerializeBaseJob(jobHolder);
    if (baseJob != null) {
        stmt.bindBlob(DbOpenHelper.BASE_JOB_COLUMN.columnIndex + 1, baseJob);
    }
    stmt.bindLong(DbOpenHelper.CREATED_NS_COLUMN.columnIndex + 1, jobHolder.getCreatedNs());
    stmt.bindLong(DbOpenHelper.DELAY_UNTIL_NS_COLUMN.columnIndex + 1, jobHolder.getDelayUntilNs());
    stmt.bindLong(DbOpenHelper.RUNNING_SESSION_ID_COLUMN.columnIndex + 1, jobHolder.getRunningSessionId());
    stmt.bindLong(DbOpenHelper.REQUIRES_NETWORK_COLUMN.columnIndex + 1, jobHolder.requiresNetwork() ? 1L : 0L);
}

Example 4

Source File: GroupsDao.java From Yahala-Messenger with MIT License

6 votes

/**
 * @inheritdoc
 */
@Override
protected void bindValues(SQLiteStatement stmt, Groups entity) {
    stmt.clearBindings();

    String jid = entity.getJid();
    if (jid != null) {
        stmt.bindString(1, jid);
    }

    String name = entity.getName();
    if (name != null) {
        stmt.bindString(2, name);
    }

    byte[] participants = entity.getParticipants();
    if (participants != null) {
        stmt.bindBlob(3, participants);
    }
}

Example 5

Source File: DbHelper.java From SQLite-Performance with The Unlicense

6 votes

private void createFiles(SQLiteDatabase db) {
    mFileNames = new String[mFiles];
    byte[] rawData = new byte[mFileSize+mFiles];
    Random random = new Random();
    random.nextBytes(rawData);

    ByteArrayOutputStream[] streams = new ByteArrayOutputStream[mFiles];
    for (int i = 0; i < mFiles; i++) {
        streams[i] = new ByteArrayOutputStream(mFileSize);
        streams[i].write(rawData, i, mFileSize);
        mFileNames[i] = String.valueOf(i);
    }

    SQLiteStatement insert = db.compileStatement("INSERT INTO files (filename, data) VALUES (?, ?)");
    for (int i = 0; i < mFiles; i++) {
        insert.bindString(1, mFileNames[i]);
        insert.bindBlob(2, streams[i].toByteArray());

        insert.execute();
    }
}

Example 6

Source File: SimpleMetaDataManager.java From science-journal with Apache License 2.0

6 votes

@Nullable
private String getExternalSensorId(ExternalSensorSpec sensor, SQLiteDatabase db) {
  String sql =
      "SELECT IFNULL(MIN("
          + SensorColumns.SENSOR_ID
          + "), '') FROM "
          + Tables.EXTERNAL_SENSORS
          + " WHERE "
          + SensorColumns.CONFIG
          + "=? AND "
          + SensorColumns.TYPE
          + "=?";
  SQLiteStatement statement = db.compileStatement(sql);
  statement.bindBlob(1, sensor.getConfig());
  statement.bindString(2, sensor.getType());
  String sensorId = statement.simpleQueryForString();
  if (!sensorId.isEmpty()) {
    return sensorId;
  }
  return null;
}

Example 7

Source File: WallpapersDao.java From Yahala-Messenger with MIT License

5 votes

/**
 * @inheritdoc
 */
@Override
protected void bindValues(SQLiteStatement stmt, Wallpapers entity) {
    stmt.clearBindings();

    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id);
    }

    byte[] data = entity.getData();
    if (data != null) {
        stmt.bindBlob(2, data);
    }
}

Example 8

Source File: Storage.java From beacons-android with Apache License 2.0

4 votes

private void migrateEddystoneItems(SQLiteDatabase db) {
    SQLiteStatement updateStatement = createUpdater(db, "d0", "d1", "d2", "d3", "kind", "flags");
    Cursor cursor = db.rawQuery("SELECT e.rowid, url, domain, lockKey, flags" +
            " FROM " + EDDYSTONE_TABLE + " e" +
            " LEFT OUTER JOIN " + ITEMS_TABLE + " i ON e.rowid=i.rowid", null);
    while (cursor.moveToNext()) {
        updateStatement.clearBindings();

        updateStatement.bindLong(1, cursor.getLong(0));

        int flags = cursor.getInt(4);
        int type = flags >>> 4;

        if (!cursor.isNull(3)) {
            updateStatement.bindBlob(2, cursor.getBlob(3));   // lock key
        }
        updateStatement.bindLong(7, 0);

        String payload = cursor.getString(1);
        String domain = cursor.getString(2);

        switch (type) {
            case 0:         // EDDYSTONE_URL
                bindStringOrNull(updateStatement, 3, payload);
                updateStatement.bindLong(6, KIND_EDDYSTONE_URL);
                break;
            case 1:         // EDDYSTONE_UID
                updateStatement.bindBlob(3, Base64.decode(payload, Base64.DEFAULT));
                bindStringOrNull(updateStatement, 4, domain);
                updateStatement.bindLong(6, KIND_EDDYSTONE_UID);
                break;
            case 2:         // EDDYSTONE_EID
                byte[] eidRaw = Base64.decode(payload, Base64.DEFAULT);
                int eidTimeOffset = ByteBuffer.wrap(eidRaw, 16, 4).getInt();

                // sanitize time offset to match range; see EIDUtils.register()
                eidTimeOffset = Math.min(255, Math.max(-65280, eidTimeOffset));

                // sanitize rotation exponent to [0, 15] range
                byte rotationExponent = (byte) (eidRaw[20] & 0x0f);

                updateStatement.bindBlob(3, Arrays.copyOfRange(eidRaw, 0, 16));
                updateStatement.bindLong(4, rotationExponent);
                updateStatement.bindLong(5, eidTimeOffset);
                updateStatement.bindLong(6, KIND_EDDYSTONE_EID);
                break;
        }

        executeSafeUpdateOrDelete(updateStatement);
    }
    cursor.close();
    updateStatement.close();

    db.execSQL("DROP TABLE " + EDDYSTONE_TABLE);
}

Example 9

Source File: LauncherProvider.java From LB-Launcher with Apache License 2.0

4 votes

private void normalizeIcons(SQLiteDatabase db) {
    Log.d(TAG, "normalizing icons");

    db.beginTransaction();
    Cursor c = null;
    SQLiteStatement update = null;
    try {
        boolean logged = false;
        update = db.compileStatement("UPDATE favorites "
                + "SET icon=? WHERE _id=?");

        c = db.rawQuery("SELECT _id, icon FROM favorites WHERE iconType=" +
                Favorites.ICON_TYPE_BITMAP, null);

        final int idIndex = c.getColumnIndexOrThrow(Favorites._ID);
        final int iconIndex = c.getColumnIndexOrThrow(Favorites.ICON);

        while (c.moveToNext()) {
            long id = c.getLong(idIndex);
            byte[] data = c.getBlob(iconIndex);
            try {
                Bitmap bitmap = Utilities.createIconBitmap(
                        BitmapFactory.decodeByteArray(data, 0, data.length),
                        mContext);
                if (bitmap != null) {
                    update.bindLong(1, id);
                    data = ItemInfo.flattenBitmap(bitmap);
                    if (data != null) {
                        update.bindBlob(2, data);
                        update.execute();
                    }
                    bitmap.recycle();
                }
            } catch (Exception e) {
                if (!logged) {
                    Log.e(TAG, "Failed normalizing icon " + id, e);
                } else {
                    Log.e(TAG, "Also failed normalizing icon " + id);
                }
                logged = true;
            }
        }
        db.setTransactionSuccessful();
    } catch (SQLException ex) {
        Log.w(TAG, "Problem while allocating appWidgetIds for existing widgets", ex);
    } finally {
        db.endTransaction();
        if (update != null) {
            update.close();
        }
        if (c != null) {
            c.close();
        }
    }
}

Example 10

Source File: MessagesDao.java From Yahala-Messenger with MIT License

4 votes

/**
 * @inheritdoc
 */
@Override
protected void bindValues(SQLiteStatement stmt, Messages entity) {
    stmt.clearBindings();

    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id);
    }

    String jid = entity.getJid();
    if (jid != null) {
        stmt.bindString(2, jid);
    }

    String message = entity.getMessage();
    if (message != null) {
        stmt.bindString(3, message);
    }

    Integer read_state = entity.getRead_state();
    if (read_state != null) {
        stmt.bindLong(4, read_state);
    }

    Integer send_state = entity.getSend_state();
    if (send_state != null) {
        stmt.bindLong(5, send_state);
    }

    java.util.Date date = entity.getDate();
    if (date != null) {
        stmt.bindLong(6, date.getTime());
    }

    Integer out = entity.getOut();
    if (out != null) {
        stmt.bindLong(7, out);
    }

    Integer type = entity.getType();
    if (type != null) {
        stmt.bindLong(8, type);
    }

    Integer ttl = entity.getTtl();
    if (ttl != null) {
        stmt.bindLong(9, ttl);
    }

    byte[] data = entity.getData();
    if (data != null) {
        stmt.bindBlob(10, data);
    }
}

Example 11

Source File: AndroidDatabaseConnection.java From ormlite-android with ISC License

4 votes

private void bindArgs(SQLiteStatement stmt, Object[] args, FieldType[] argFieldTypes) throws SQLException {
	if (args == null) {
		return;
	}
	for (int i = 0; i < args.length; i++) {
		Object arg = args[i];
		if (arg == null) {
			stmt.bindNull(i + 1);
		} else {
			SqlType sqlType = argFieldTypes[i].getSqlType();
			switch (sqlType) {
				case STRING:
				case LONG_STRING:
				case CHAR:
					stmt.bindString(i + 1, arg.toString());
					break;
				case BOOLEAN:
				case BYTE:
				case SHORT:
				case INTEGER:
				case LONG:
					stmt.bindLong(i + 1, ((Number) arg).longValue());
					break;
				case FLOAT:
				case DOUBLE:
					stmt.bindDouble(i + 1, ((Number) arg).doubleValue());
					break;
				case BYTE_ARRAY:
				case SERIALIZABLE:
					stmt.bindBlob(i + 1, (byte[]) arg);
					break;
				case DATE:
					// this is mapped to a STRING under Android
				case BLOB:
					// this is only for derby serializable
				case BIG_DECIMAL:
					// this should be handled as a STRING
					throw new SQLException("Invalid Android type: " + sqlType);
				case UNKNOWN:
				default:
					throw new SQLException("Unknown sql argument type: " + sqlType);
			}
		}
	}
}

Example 12