/** New attachment insertion */
public Attachment updateAttachment(long noteId, Attachment attachment, SQLiteDatabase db) {
ContentValues valuesAttachments = new ContentValues();
valuesAttachments.put(
KEY_ATTACHMENT_ID,
attachment.getId() != null ? attachment.getId() : Calendar.getInstance().getTimeInMillis());
valuesAttachments.put(KEY_ATTACHMENT_NOTE_ID, noteId);
valuesAttachments.put(KEY_ATTACHMENT_URI, attachment.getUri().toString());
valuesAttachments.put(KEY_ATTACHMENT_MIME_TYPE, attachment.getMime_type());
valuesAttachments.put(KEY_ATTACHMENT_NAME, attachment.getName());
valuesAttachments.put(KEY_ATTACHMENT_SIZE, attachment.getSize());
valuesAttachments.put(KEY_ATTACHMENT_LENGTH, attachment.getLength());
db.insertWithOnConflict(
TABLE_ATTACHMENTS, KEY_ATTACHMENT_ID, valuesAttachments, SQLiteDatabase.CONFLICT_REPLACE);
return attachment;
}
