Java Code Examples for android.database.sqlite.SQLiteDatabase#replace()

The following examples show how to use android.database.sqlite.SQLiteDatabase#replace() . 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: UserGroupDao.java From YiBo with Apache License 2.0

6 votes

void save(SQLiteDatabase sqLiteDatabase, UserGroup userGroup) {
	if (isNull(userGroup)) {
		return;
	}
	if(Logger.isDebug()){
		Log.d("Save UserGroup:", userGroup.toString());
	}

	ContentValues values = new ContentValues();
	values.put("Service_Provider", userGroup.getServiceProvider().getSpNo());
	values.put("User_ID", userGroup.getUserId());
	values.put("Group_ID", userGroup.getGroupId());
	values.put("State", userGroup.getState());

	sqLiteDatabase.replace(TABLE, null, values);
}

Example 2

Source File: DatabaseHelper.java From recurrence with GNU General Public License v3.0

6 votes

public void addNotification(Reminder reminder) {
    SQLiteDatabase database = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(COL_ID, reminder.getId());
    values.put(COL_TITLE, reminder.getTitle());
    values.put(COL_CONTENT, reminder.getContent());
    values.put(COL_DATE_AND_TIME, reminder.getDateAndTime());
    values.put(COL_REPEAT_TYPE, reminder.getRepeatType());
    values.put(COL_FOREVER, reminder.getForeverState());
    values.put(COL_NUMBER_TO_SHOW, reminder.getNumberToShow());
    values.put(COL_NUMBER_SHOWN, reminder.getNumberShown());
    values.put(COL_ICON, reminder.getIcon());
    values.put(COL_COLOUR, reminder.getColour());
    values.put(COL_INTERVAL, reminder.getInterval());
    database.replace(NOTIFICATION_TABLE, null, values);
}

Example 3

Source File: UserDao.java From school_shop with MIT License

6 votes

/**
 * 保存好友list
 * 
 * @param contactList
 */
public void saveContactList(List<User> contactList) {
	SQLiteDatabase db = dbHelper.getWritableDatabase();
	if (db.isOpen()) {
		db.delete(TABLE_NAME, null, null);
		for (User user : contactList) {
			ContentValues values = new ContentValues();
			values.put(COLUMN_NAME_ID, user.getUsername());
			if(user.getNick() != null)
				values.put(COLUMN_NAME_NICK, user.getNick());
			if(user.getAvatar() != null)
			    values.put(COLUMN_NAME_AVATAR, user.getAvatar());
			db.replace(TABLE_NAME, null, values);
		}
	}
}

Example 4

Source File: DemoDBManager.java From nono-android with GNU General Public License v3.0

6 votes

/**
 * 保存好友list
 * 
 * @param contactList
 */
synchronized public void saveContactList(List<EaseUser> contactList) {
    SQLiteDatabase db = dbHelper.getWritableDatabase();
    if (db.isOpen()) {
        db.delete(UserDao.TABLE_NAME, null, null);
        for (EaseUser user : contactList) {
            ContentValues values = new ContentValues();
            values.put(UserDao.COLUMN_NAME_ID, user.getUsername());
            if(user.getNick() != null)
                values.put(UserDao.COLUMN_NAME_NICK, user.getNick());
            if(user.getAvatar() != null)
                values.put(UserDao.COLUMN_NAME_AVATAR, user.getAvatar());
            db.replace(UserDao.TABLE_NAME, null, values);
        }
    }
}

Example 5

Source File: Controller.java From Memento with MIT License

5 votes

/**
 * Reads data from json array
 * @param json an array of json objects
 * @throws Exception
 */
public void readBackup(JSONArray json) throws Exception {
	SQLiteDatabase db = helper.getReadableDatabase();

	try {
		int length = json.length();
		for (int i = 0; i < length; i++) {
			JSONObject item = json.getJSONObject(i);

			ContentValues values = new ContentValues();
			values.put(OpenHelper.COLUMN_ID, item.getLong(OpenHelper.COLUMN_ID));
			values.put(OpenHelper.COLUMN_TITLE, item.getString(OpenHelper.COLUMN_TITLE));
			values.put(OpenHelper.COLUMN_BODY, item.getString(OpenHelper.COLUMN_BODY));
			values.put(OpenHelper.COLUMN_TYPE, item.getInt(OpenHelper.COLUMN_TYPE));
			values.put(OpenHelper.COLUMN_DATE, item.getString(OpenHelper.COLUMN_DATE));
			values.put(OpenHelper.COLUMN_ARCHIVED, item.getInt(OpenHelper.COLUMN_ARCHIVED));
			values.put(OpenHelper.COLUMN_THEME, item.getInt(OpenHelper.COLUMN_THEME));
			values.put(OpenHelper.COLUMN_COUNTER, item.getInt(OpenHelper.COLUMN_COUNTER));
			values.put(OpenHelper.COLUMN_PARENT_ID, item.getLong(OpenHelper.COLUMN_PARENT_ID));
			values.put(OpenHelper.COLUMN_EXTRA, item.getString(OpenHelper.COLUMN_EXTRA));

			db.replace(
				OpenHelper.TABLE_NOTES,
				null,
				values
			);
		}
	} finally {
		db.close();
	}
}

Example 6

Source File: PluginSQLiteHelper.java From PluginLoader with Apache License 2.0

5 votes

/**
 * 改
 * 
 * @param db db
 * @param values values
 * @param selectionArgs args
 * @return result
 */
public static long update(SQLiteDatabase db, ContentValues values, String[] selectionArgs) {
       try {
           return db.replace(TABLE_NAME, null,values);
       } catch (Exception e) {
           e.printStackTrace();
       }
       return -1;
}

Example 7

Source File: BaseDao.java From okhttp-OkGo with Apache License 2.0

5 votes

public boolean replace(SQLiteDatabase database, List<T> ts) {
    try {
        for (T t : ts) {
            database.replace(getTableName(), null, getContentValues(t));
        }
        return true;
    } catch (Exception e) {
        OkLogger.printStackTrace(e);
        return false;
    }
}

Example 8

Source File: SocialGraphDao.java From YiBo with Apache License 2.0

5 votes

void save(SQLiteDatabase sqLiteDatabase, User userA, User userB, Relation relation, ServiceProvider sp) {
	ContentValues values = new ContentValues();
	values.put("User_A_ID", userA.getUserId());
	values.put("User_B_ID", userB.getUserId());
	values.put("Service_Provider", sp.getSpNo());
	values.put("Relationship", relation.getType());
	sqLiteDatabase.replace(TABLE, null, values);
}

Example 9

Source File: DatabaseHelper.java From recurrence with GNU General Public License v3.0

5 votes

public void addColour(Colour colour) {
    SQLiteDatabase database = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(COL_PICKER_COLOUR, colour.getColour());
    values.put(COL_PICKER_DATE_AND_TIME, colour.getDateAndTime());
    database.replace(PICKER_COLOUR_TABLE, null, values);
}

Example 10

Source File: ThreeThingsDatabase.java From three-things-today with Apache License 2.0

5 votes

public synchronized boolean writeContentValues(ContentValues values) {
    if (values == null) {
        return false;
    }

    SQLiteDatabase db = mDbHelper.getWritableDatabase();

    Log.d("ThreeThingsDatabase", "writeContentValues: writing: " + values.toString());
    return db.replace(ThreeThingsEntry.TABLE_NAME, null, values) != -1;
}

Example 11

Source File: BreakpointSQLiteHelper.java From okdownload with Apache License 2.0

5 votes

public void updateFilename(@NonNull String url, @NonNull String filename) {
    final SQLiteDatabase db = getWritableDatabase();
    ContentValues values = new ContentValues(2);
    values.put(URL, url);
    values.put(FILENAME, filename);

    Cursor c = null;
    synchronized (url.intern()) {
        try {
            final String query = "SELECT " + FILENAME + " FROM " + RESPONSE_FILENAME_TABLE_NAME
                    + " WHERE " + URL + " = ?";
            c = db.rawQuery(query, new String[]{url});
            if (c.moveToFirst()) {
                // exist
                if (!filename.equals(c.getString(c.getColumnIndex(FILENAME)))) {
                    // replace if not equal
                    db.replace(RESPONSE_FILENAME_TABLE_NAME, null, values);
                }
            } else {
                // insert
                db.insert(RESPONSE_FILENAME_TABLE_NAME, null, values);
            }
        } finally {
            if (c != null) c.close();
        }
    }
}

Example 12

Source File: AtUsersDBTask.java From iBeebo with GNU General Public License v3.0

5 votes

public static void add(SQLiteDatabase db, AtUserBean atUserBean, String accountId) {
    Gson gson = new Gson();
    ContentValues cv = new ContentValues();
    cv.put(AtUsersTable.USERID, atUserBean.getUid());
    cv.put(AtUsersTable.ACCOUNTID, accountId);
    String json = gson.toJson(atUserBean);
    cv.put(AtUsersTable.JSONDATA, json);
    db.replace(AtUsersTable.TABLE_NAME, AtUsersTable.ID, cv);

    reduce(accountId);
}

Example 13

Source File: UserDao.java From FanXin-based-HuanXin with GNU General Public License v2.0

5 votes

/**
 * 保存好友list
 * 
 * @param contactList
 */
public void saveContactList(List<User> contactList) {
	SQLiteDatabase db = dbHelper.getWritableDatabase();
	if (db.isOpen()) {
		db.delete(TABLE_NAME, null, null);
		for (User user : contactList) {
			ContentValues values = new ContentValues();
			values.put(COLUMN_NAME_ID, user.getUsername());
			if (user.getNick() != null) {
                   values.put(COLUMN_NAME_NICK, user.getNick());
               }
               if (user.getBeizhu() != null) {
                   values.put(COLUMN_NAME_BEIZHU, user.getBeizhu());
               }
               if (user.getTel() != null) {
                   values.put(COLUMN_NAME_TEL, user.getTel());
               }
               if (user.getSex() != null) {
                   values.put(COLUMN_NAME_SEX, user.getSex());
               }
               if (user.getAvatar() != null) {
                   values.put(COLUMN_NAME_AVATAR, user.getAvatar());
               }
               if (user.getSign() != null) {
                   values.put(COLUMN_NAME_SIGN, user.getSign());
               }
               if (user.getFxid() != null) {
                   values.put(COLUMN_NAME_FXID, user.getFxid());
               }
               if (user.getRegion()!= null) {
                   values.put(COLUMN_NAME_REGION, user.getRegion());
               }
			db.replace(TABLE_NAME, null, values);
		}
	}
}

Example 14

Source File: BaseDao.java From DoraemonKit with Apache License 2.0

5 votes

public boolean replace(SQLiteDatabase database, List<T> ts) {
    try {
        for (T t : ts) {
            database.replace(getTableName(), null, getContentValues(t));
        }
        return true;
    } catch (Exception e) {
        OkLogger.printStackTrace(e);
        return false;
    }
}

Example 15

Source File: BaseDao.java From BaseProject with Apache License 2.0

5 votes

public boolean replace(SQLiteDatabase database, List<T> ts) {
    try {
        for (T t : ts) {
            database.replace(getTableName(), null, getContentValues(t));
        }
        return true;
    } catch (Exception e) {
        OkLogger.printStackTrace(e);
        return false;
    }
}

Example 16

Source File: UserDao.java From school_shop with MIT License

5 votes

/**
 * 保存一个联系人
 * @param user
 */
public void saveContact(User user){
	SQLiteDatabase db = dbHelper.getWritableDatabase();
	ContentValues values = new ContentValues();
	values.put(COLUMN_NAME_ID, user.getUsername());
	if(user.getNick() != null)
		values.put(COLUMN_NAME_NICK, user.getNick());
	if(user.getAvatar() != null)
	    values.put(COLUMN_NAME_AVATAR, user.getAvatar());
	if(db.isOpen()){
		db.replace(TABLE_NAME, null, values);
	}
}

Example 17

Source File: UserDao.java From FanXin-based-HuanXin with GNU General Public License v2.0

5 votes

/**
 * 保存一个联系人
 * @param user
 */
public void saveContact(User user){
	SQLiteDatabase db = dbHelper.getWritableDatabase();
	ContentValues values = new ContentValues();
	values.put(COLUMN_NAME_ID, user.getUsername());
	if (user.getNick() != null) {
           values.put(COLUMN_NAME_NICK, user.getNick());
       }
       if (user.getBeizhu() != null) {
           values.put(COLUMN_NAME_BEIZHU, user.getBeizhu());
       }
       if (user.getTel() != null) {
           values.put(COLUMN_NAME_TEL, user.getTel());
       }
       if (user.getSex() != null) {
           values.put(COLUMN_NAME_SEX, user.getSex());
       }
       if (user.getAvatar() != null) {
           values.put(COLUMN_NAME_AVATAR, user.getAvatar());
       }
       if (user.getSign() != null) {
           values.put(COLUMN_NAME_SIGN, user.getSign());
       }
       if (user.getFxid() != null) {
           values.put(COLUMN_NAME_FXID, user.getFxid());
       }
       if (user.getRegion()!= null) {
           values.put(COLUMN_NAME_REGION, user.getRegion());
       }
	if(db.isOpen()){
		db.replace(TABLE_NAME, null, values);
	}
}

Example 18

Source File: BaseDao.java From DoraemonKit with Apache License 2.0

4 votes

public long replace(SQLiteDatabase database, ContentValues contentValues) {
    return database.replace(getTableName(), null, contentValues);
}

Example 19

Source File: TaskDao.java From YiBo with Apache License 2.0

4 votes

public Task saveRecentContact(Task task) {
	if (task == null) {
		return null;
	}
	
	SQLiteDatabase sqLiteDatabase = dbHelper.getWritableDatabase();
	sqLiteDatabase.beginTransaction();
	try {
		ContentValues values = new ContentValues();
		//values.put("Task_ID", task.getTaskId());
		values.put("Type", task.getType());
		values.put("Content", task.getContent());
		values.put("Result_ID", task.getResultId());
		if (task.getCreatedAt() == null) {
			task.setCreatedAt(new Date());
		}
		values.put("Created_At", task.getCreatedAt().getTime());
		if (task.getFinishedAt() != null) {
		    values.put("Finished_At", task.getFinishedAt().getTime());
		}
		values.put("State", task.getState());
		values.put("Service_Provider", task.getServiceProvider().getSpNo());
		values.put("Account_ID", task.getAccountId());
		
		int rowsAffected = sqLiteDatabase.update(
			TABLE, values, 
			"Type = " + task.getType() + " and Account_ID = " + task.getAccountId() 
			+ " and Result_ID = '" + task.getResultId() + "'", 
			null);
		if (rowsAffected <= 0) {
			values.put("Task_ID", task.getTaskId());
			long rowId = sqLiteDatabase.replace(TABLE, null, values);
			task.setTaskId(rowId);
		}
		
		sqLiteDatabase.setTransactionSuccessful();
	} finally {
		sqLiteDatabase.endTransaction();
	}
	
	return task;
}

Example 20

Source File: BaseDao.java From DoraemonKit with Apache License 2.0

4 votes

public long replace(SQLiteDatabase database, ContentValues contentValues) {
    return database.replace(getTableName(), null, contentValues);
}