// get calendar Calendar cal = Calendar.getInstance(); Uri EVENTS_URI = Uri.parse(getCalendarUriBase(this) + "events"); ContentResolver cr = getContentResolver(); // event insert ContentValues values = new ContentValues(); values.put("calendar_id", 1); values.put("title", "Reminder Title"); values.put("allDay", 0); values.put("dtstart", cal.getTimeInMillis() + 11*60*1000); // event starts at 11 minutes from now values.put("dtend", cal.getTimeInMillis()+60*60*1000); // ends 60 minutes from now values.put("description", "Reminder description"); values.put("visibility", 0); values.put("hasAlarm", 1); Uri event = cr.insert(EVENTS_URI, values); // reminder insert Uri REMINDERS_URI = Uri.parse(getCalendarUriBase(this) + "reminders"); values = new ContentValues(); values.put( "event_id", Long.parseLong(event.getLastPathSegment())); values.put( "method", 1 ); values.put( "minutes", 10 ); cr.insert( REMINDERS_URI, values );
@Override public Void doDbWork(final SQLiteDatabase db) throws WrappedException, UnavailableStorageException { ContentValues cv = new ContentValues(); cv.put("deleted", 1); cv.put("empty", 1); cv.putNull("subject"); cv.putNull("sender_list"); cv.putNull("date"); cv.putNull("to_list"); cv.putNull("cc_list"); cv.putNull("bcc_list"); cv.putNull("preview"); cv.putNull("reply_to_list"); cv.putNull("message_part_id"); db.update("messages", cv, "id = ?", new String[] { Long.toString(databaseId) }); try { ((LocalFolder) mFolder).deleteMessagePartsAndDataFromDisk(messagePartId); } catch (MessagingException e) { throw new WrappedException(e); } getFolder().deleteFulltextIndexEntry(db, databaseId); return null; } });
@Test public void shouldGetBlobFromString() { ContentValues values = new ContentValues(); values.put("first_column", "this is a string"); database.insert("table_name", null, values); Cursor data = database.query("table_name", new String[]{"first_column"}, null, null, null, null, null); assertThat(data.getCount()).isEqualTo(1); data.moveToFirst(); assertThat(data.getBlob(0)).isEqualTo(values.getAsString("first_column").getBytes(UTF_8)); }
ContentValues cv = new ContentValues(); cv.put("Field1","Bob"); //These Fields should be your String values of actual column names cv.put("Field2","19"); cv.put("Field2","Male");
ContentValues args = new ContentValues(); args.putNull(KEY_RISK_AMOUNT);
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 ); }
@Override public void onClick(View v) { try { if (getExpirationThreshold() > 0 && expire_monitor != null) expire_monitor.cancel(true); SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd Z"); ContentValues rowData = new ContentValues(); rowData.put(ESM_Provider.ESM_Data.ANSWER_TIMESTAMP, System.currentTimeMillis()); rowData.put(ESM_Provider.ESM_Data.ANSWER, dateFormat.format(datePicked.getTime())); rowData.put(ESM_Provider.ESM_Data.STATUS, ESM.STATUS_ANSWERED); getActivity().getContentResolver().update(ESM_Provider.ESM_Data.CONTENT_URI, rowData, ESM_Provider.ESM_Data._ID + "=" + getID(), null); Intent answer = new Intent(ESM.ACTION_AWARE_ESM_ANSWERED); answer.putExtra(ESM.EXTRA_ANSWER, rowData.getAsString(ESM_Provider.ESM_Data.ANSWER)); getActivity().sendBroadcast(answer); if (Aware.DEBUG) Log.d(Aware.TAG, "Answer:" + rowData.toString()); esm_dialog.dismiss(); } catch (JSONException e) { e.printStackTrace(); } } });
for(int i=0;i<=3;i++){ long startMillis = 0; long endMillis = 0; Calendar beginTime = Calendar.getInstance(); beginTime.set(2000, 1, i, 7, 30); startMillis = beginTime.getTimeInMillis(); Calendar endTime = Calendar.getInstance(); endTime.set(2000, 1, i, 8, 45); endMillis = endTime.getTimeInMillis(); ContentResolver cr = getContentResolver(); ContentValues values = new ContentValues(); values.put(Events.DTSTART, startMillis); values.put(Events.DTEND, endMillis); values.put(Events.TITLE, "Jazzercise"); values.put(Events.DESCRIPTION, "Group workout"); values.put(Events.CALENDAR_ID, 1); values.put(Events.EVENT_TIMEZONE, TimeZone.getDefault().getID()); Uri uri = cr.insert(Events.CONTENT_URI, values); // get the event ID that is the last element in the Uri long eventID = Long.parseLong(uri.getLastPathSegment()); }
ContentValues values = new ContentValues(); values.put(CalendarContract.Events.DTSTART, calDate.getTimeInMillis()); values.put(CalendarContract.Events.DTEND, calDate.getTimeInMillis()+60*60*1000); values.put(CalendarContract.Events.TITLE, this._title); values.put(CalendarContract.Events.CALENDAR_ID, 1); values.put(CalendarContract.Events.EVENT_TIMEZONE, Calendar.getInstance() .getTimeZone().getID()); System.out.println(Calendar.getInstance().getTimeZone().getID()); Uri uri = cr.insert(CalendarContract.Events.CONTENT_URI, values); setReminder(cr, this._eventId, 5); setReminder(cr, this._eventId, 60); setReminder(cr, this._eventId, 1440); ContentValues values = new ContentValues(); values.put(CalendarContract.Reminders.MINUTES, timeBefore); values.put(CalendarContract.Reminders.EVENT_ID, eventID); c.close(); GregorianCalendar calDate = new GregorianCalendar(this._year, this._month, this._day, this._hour, this._minute); ContentValues event = new ContentValues(); event.put(CalendarContract.Events.TITLE, this._title); event.put("hasAlarm", 1); // 0 for false, 1 for true event.put(CalendarContract.Events.DTSTART, calDate.getTimeInMillis()); event.put(CalendarContract.Events.DTEND, calDate.getTimeInMillis()+60*60*1000);
ContentResolver cr = ctx.getContentResolver(); ContentValues values = new ContentValues(); values.put(CalendarContract.Events.DTSTART, dtstart); values.put(CalendarContract.Events.TITLE, title); values.put(CalendarContract.Events.DESCRIPTION, comment); TimeZone timeZone = TimeZone.getDefault(); values.put(CalendarContract.Events.EVENT_TIMEZONE, timeZone.getID()); // default calendar values.put(CalendarContract.Events.CALENDAR_ID, 1); values.put(CalendarContract.Events.RRULE, "FREQ=DAILY;UNTIL=" + dtUntill); //for one hour values.put(CalendarContract.Events.DURATION, "+P1H"); values.put(CalendarContract.Events.HAS_ALARM, 1); // insert event to calendar Uri uri = cr.insert(CalendarContract.Events.CONTENT_URI, values);
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(); Cursor taskCursor = mContext.getContentResolver().query( TaskContract.TaskEntry.CONTENT_URI, taskCursor.close();
public Uri getImageContentUri(Context context, String absPath) { KLog.d("getImageContentUri: " + absPath); Cursor cursor = context.getContentResolver().query( MediaStore.Images.Media.EXTERNAL_CONTENT_URI , new String[]{MediaStore.Images.Media._ID} , MediaStore.Images.Media.DATA + "=? " , new String[]{absPath}, null); if (cursor != null && cursor.moveToFirst()) { int id = cursor.getInt(cursor.getColumnIndex(MediaStore.MediaColumns._ID)); cursor.close(); return Uri.withAppendedPath(MediaStore.Images.Media.EXTERNAL_CONTENT_URI, Integer.toString(id)); } else if (!absPath.isEmpty()) { ContentValues values = new ContentValues(); values.put(MediaStore.Images.Media.DATA, absPath); return context.getContentResolver().insert( MediaStore.Images.Media.EXTERNAL_CONTENT_URI, values); } else { return null; } }
Calendar beginTime = Calendar.getInstance(); beginTime.set(2012, 9, 14, 7, 30); startMillis = beginTime.getTimeInMillis(); Calendar endTime = Calendar.getInstance(); endTime.set(2012, 9, 14, 8, 45); endMillis = endTime.getTimeInMillis(); ContentValues values = new ContentValues(); TimeZone timeZone = TimeZone.getDefault(); values.put(CalendarContract.Events.DTSTART, startMillis); values.put(CalendarContract.Events.DTEND, endMillis); values.put(CalendarContract.Events.DESCRIPTION, "My dog is bored, so we're going on a really long walk!"); values.put(CalendarContract.Events.CALENDAR_ID, 3); Uri uri = cr.insert(CalendarContract.Events.CONTENT_URI, values); String eventID = uri.getLastPathSegment();
private void markFirstAsSent(Context context) { Log.v("sent_receiver", "using first message"); Cursor query = context.getContentResolver().query(Uri.parse("content://sms/outbox"), null, null, null, null); // mark message as sent successfully if (query != null && query.moveToFirst()) { String id = query.getString(query.getColumnIndex("_id")); ContentValues values = new ContentValues(); values.put("type", 2); values.put("read", 1); context.getContentResolver().update(Uri.parse("content://sms/outbox"), values, "_id=" + id, null); query.close(); } } }
if (checkReadContacts(activity)) { ContentValues values = new ContentValues(); ContentResolver contentResolver = activity.getContentResolver(); Uri rawContactUri = contentResolver.insert(ContactsContract.RawContacts .CONTENT_URI, values); long rawContactId = ContentUris.parseId(rawContactUri); values.put(ContactsContract.Contacts.Data.MIMETYPE, ContactsContract.CommonDataKinds .StructuredName.CONTENT_ITEM_TYPE); values.put(ContactsContract.Contacts.Data.RAW_CONTACT_ID, rawContactId); values.put(ContactsContract.CommonDataKinds.StructuredName.GIVEN_NAME, TAG); values.put(ContactsContract.CommonDataKinds.Phone.NUMBER, TAG_NUMBER); contentResolver.insert(ContactsContract.Data.CONTENT_URI, values); Uri uri = Uri.parse("content://com.android.contacts/raw_contacts"); ContentResolver resolver = activity.getContentResolver(); Cursor cursor = resolver.query(uri, new String[]{ContactsContract.Contacts.Data._ID}, "display_name=?", new String[]{TAG}, null); if (cursor != null) { if (cursor.moveToFirst()) { int id = cursor.getInt(0); resolver.delete(uri, "display_name=?", new String[]{TAG}); uri = Uri.parse("content://com.android.contacts/data"); resolver.delete(uri, "raw_contact_id=?", new String[]{id + ""}); cursor.close();
public static Uri getImageContentUri(Context context, File imageFile) { String filePath = imageFile.getAbsolutePath(); Cursor cursor = context.getContentResolver().query( MediaStore.Images.Media.EXTERNAL_CONTENT_URI, new String[] { MediaStore.Images.Media._ID }, MediaStore.Images.Media.DATA + "=? ", new String[] { filePath }, null); if (cursor != null && cursor.moveToFirst()) { int id = cursor.getInt(cursor.getColumnIndex(MediaStore.MediaColumns._ID)); cursor.close(); return Uri.withAppendedPath(MediaStore.Images.Media.EXTERNAL_CONTENT_URI, "" + id); } else { if (imageFile.exists()) { ContentValues values = new ContentValues(); values.put(MediaStore.Images.Media.DATA, filePath); return context.getContentResolver().insert( MediaStore.Images.Media.EXTERNAL_CONTENT_URI, values); } else { return null; } } }
public void insertHasRead(String table, String key, int value) { Cursor cursor = mSQLiteDatabase.query(table, null, null, null, null, null, "id asc"); if (cursor.getCount() > 200 && cursor.moveToNext()) { mSQLiteDatabase.delete(table, "id=?", new String[]{String.valueOf(cursor.getInt(cursor.getColumnIndex("id")))}); } cursor.close(); ContentValues contentValues = new ContentValues(); contentValues.put("key", key); contentValues.put("is_read", value); mSQLiteDatabase.insertWithOnConflict(table, null, contentValues, SQLiteDatabase.CONFLICT_REPLACE); }
ContentValues values = new ContentValues(); values.put(MediaStore.Images.Media.TITLE, fileName); mCapturedImageURI = getContentResolver().insert(MediaStore.Images.Media.EXTERNAL_CONTENT_URI, values); Intent cameraIntent = new Intent("android.media.action.IMAGE_CAPTURE"); cameraIntent.putExtra(MediaStore.EXTRA_OUTPUT, mCapturedImageURI); startActivityForResult(cameraIntent, CAMERA_REQUEST);
ContentValues contentValues = new ContentValues(); int media_type = 1; contentValues.put("media_type", media_type); resolver.update(uri, contentValues, null, null); return resolver.delete(uri, null, null) > 0; selectionParams[0] = fullname; String sortOrder = "_id"; cursor=contentResolver.query(uri, projection, selection, selectionParams, sortOrder); if (cursor.getCount() > 0) // file present! cursor.moveToFirst(); int dataColumn=cursor.getColumnIndex("_data"); String s = cursor.getString(dataColumn); if (!s.equals(fullname)) ContentValues contentValues=new ContentValues(); contentValues.put("_data",fullname); uri = MediaStore.Files.getContentUri("external");
private Uri addNoteForContentValues(long deckId, ContentValues values) { Uri newNoteUri = mResolver.insert(Note.CONTENT_URI, values); if (newNoteUri == null) { return null; } // Move cards to specified deck Uri cardsUri = Uri.withAppendedPath(newNoteUri, "cards"); final Cursor cardsCursor = mResolver.query(cardsUri, null, null, null, null); if (cardsCursor == null) { return null; } try { while (cardsCursor.moveToNext()) { String ord = cardsCursor.getString(cardsCursor.getColumnIndex(Card.CARD_ORD)); ContentValues cardValues = new ContentValues(); cardValues.put(Card.DECK_ID, deckId); Uri cardUri = Uri.withAppendedPath(Uri.withAppendedPath(newNoteUri, "cards"), ord); mResolver.update(cardUri, cardValues, null, null); } } finally { cardsCursor.close(); } return newNoteUri; }