org.litepal.LitePal#deleteAll

Source File: DeleteTest.java From LitePal with Apache License 2.0

6 votes

@Test
public void testMarkAsDeleted() {
    List<Student> students = new ArrayList<>();
    for (int i = 0; i < 5; i++) {
        Student s = new Student();
        s.setName("Dusting");
        s.setAge(i + 10);
        students.add(s);
    }
    LitePal.saveAll(students);
    List<Student> list = LitePal.where("name=?", "Dusting").find(Student.class);
    assertTrue(list.size() >= 5);
    LitePal.deleteAll(Student.class, "name=?", "Dusting");
    list = LitePal.where("name=?", "Dusting").find(Student.class);
    assertEquals(0, list.size());
    LitePal.saveAll(students);
    list = LitePal.where("name=?", "Dusting").find(Student.class);
    assertEquals(0, list.size());
    LitePal.markAsDeleted(students);
    LitePal.saveAll(students);
    list = LitePal.where("name=?", "Dusting").find(Student.class);
    assertEquals(5, list.size());
}

Source File: DeleteTest.java From LitePal with Apache License 2.0

6 votes

@Test
public void testDeleteAllRows() {
	createStudentsTeachersWithIdCard();
	int rowsCount = getRowsCount(teacherTable);
	int affectedRows = 0;
	affectedRows = LitePal.deleteAll(Teacher.class);
	assertTrue(rowsCount <= affectedRows);
	rowsCount = getRowsCount(studentTable);
	affectedRows = LitePal.deleteAll(Student.class);
	assertTrue(rowsCount<= affectedRows);
	rowsCount = getRowsCount(DBUtility.getTableNameByClassName(IdCard.class.getName()));
	affectedRows = LitePal.deleteAll(IdCard.class);
	assertTrue(rowsCount<=affectedRows);
	createStudentsTeachersWithAssociations();
	rowsCount = getRowsCount(teacherTable);
	affectedRows = LitePal.deleteAll(Teacher.class);
	assertTrue(rowsCount<=affectedRows);
	rowsCount = getRowsCount(studentTable);
	affectedRows = LitePal.deleteAll(Student.class);
	assertTrue(rowsCount<=affectedRows);
	rowsCount = getRowsCount(DBUtility.getIntermediateTableName(studentTable, teacherTable));
	affectedRows = LitePal.deleteAll(DBUtility.getIntermediateTableName(studentTable, teacherTable));
	assertTrue(rowsCount<=affectedRows);
}

Source File: AddCountyActivity.java From DongWeather with Apache License 2.0

6 votes

/**
 * Called when a view has been clicked.
 *
 * @param v The view that was clicked.
 */
@Override
public void onClick(View v) {
    switch (v.getId()) {
        case R.id.clear_database_btn:
            LitePal.deleteAll(Province.class);
            LitePal.deleteAll(City.class);
            LitePal.deleteAll(County.class);
            LitePal.deleteAll(SelectedCounty.class);
            break;
        case R.id.back_btn:
            if (currentLevel == LEVEL_COUNTY) {
                queryCity();
            } else if (currentLevel == LEVEL_CITY) {
                backButton.setVisibility(View.GONE);
                queryProvinces();
            }
            break;
        default:
            break;
    }
}

Source File: DeleteTest.java From LitePal with Apache License 2.0

6 votes

@Test
public void testDeleteAll() {
	Student s;
	int[] ids = new int[5];
	for (int i = 0; i < 5; i++) {
		s = new Student();
		s.setName("Dusting");
		s.setAge(i + 10086);
		s.save();
		ids[i] = s.getId();
	}
	int affectedRows = LitePal.deleteAll(Student.class, "name = ? and age = ?", "Dusting",
			"10088");
	assertEquals(1, affectedRows);
	assertNull(getStudent(ids[2]));
	affectedRows = LitePal.deleteAll(Student.class, "name = ? and age > ? and age < ?", "Dusting", "10085", "10092");
	assertEquals(4, affectedRows);
}

Source File: DbHelperImpl.java From Yuan-SxMusic with Apache License 2.0

6 votes

@Override
public void insertAllAlbumSong(List<AlbumSong.DataBean.ListBean> songList) {
    LitePal.deleteAll(OnlineSong.class);
    for (int i = 0; i < songList.size(); i++) {
        AlbumSong.DataBean.ListBean song = songList.get(i);
        OnlineSong onlineSong = new OnlineSong();
        onlineSong.setId(i + 1);
        onlineSong.setName(song.getSongname());
        onlineSong.setSinger(song.getSinger().get(0).getName());
        onlineSong.setSongId(song.getSongmid());
        onlineSong.setDuration(song.getInterval());
        onlineSong.setPic(Api.ALBUM_PIC + song.getAlbummid()+Api.JPG);
        onlineSong.setUrl(null);
        onlineSong.setLrc(null);
        onlineSong.save();
    }
}

Source File: DeleteTest.java From LitePal with Apache License 2.0

6 votes

@Test
public void testDeleteAllCascadeM2MAssociations() {
	createStudentsTeachersWithAssociations();
	int rowsAffected = LitePal.deleteAll(Teacher.class, "id=?", "" + john.getId());
	assertEquals(2, rowsAffected);
	assertNull(getTeacher(john.getId()));
	assertM2MFalse(studentTable, teacherTable, rose.getId(), john.getId());
	assertM2M(studentTable, teacherTable, rose.getId(), mike.getId());
	assertM2M(studentTable, teacherTable, jude.getId(), mike.getId());
	createStudentsTeachersWithAssociations();
	rowsAffected = LitePal.deleteAll(Teacher.class, "id=?", "" + mike.getId());
	assertEquals(3, rowsAffected);
	assertNull(getTeacher(mike.getId()));
	assertM2MFalse(studentTable, teacherTable, rose.getId(), mike.getId());
	assertM2MFalse(studentTable, teacherTable, jude.getId(), mike.getId());
	assertM2M(studentTable, teacherTable, rose.getId(), john.getId());
}

Source File: DeleteTest.java From LitePal with Apache License 2.0

6 votes

@Test
public void testDeleteAllCascadeM2OAssociationsOnOSide() {
	createClassroomStudentsTeachers();
	int rowsAffected = LitePal.deleteAll(Student.class, "id = ?", String.valueOf(jude.getId()));
	assertEquals(1, rowsAffected);
	assertNull(getStudent(jude.getId()));
	rowsAffected = LitePal.deleteAll(Student.class, "id = ?", String.valueOf(rose.getId()));
	assertEquals(1, rowsAffected);
	assertNull(getStudent(rose.getId()));
	rowsAffected = LitePal.deleteAll(Teacher.class, "id = ?", String.valueOf(john.getId()));
	assertEquals(1, rowsAffected);
	assertNull(getTeacher(john.getId()));
	rowsAffected = LitePal.deleteAll(Teacher.class, "id = ?", String.valueOf(mike.getId()));
	assertEquals(1, rowsAffected);
	assertNull(getTeacher(mike.getId()));
}

Source File: DeleteTest.java From LitePal with Apache License 2.0

6 votes

@Test
public void testDeleteAllCascadeO2OAssociations() {
	createStudentsTeachersWithIdCard();
	int affectedRows = LitePal.deleteAll(Student.class, "id = ?", String.valueOf(jude.getId()));
	assertEquals(2, affectedRows);
	assertNull(getStudent(jude.getId()));
	assertNull(getIdCard(judeCard.getId()));
	affectedRows = LitePal.deleteAll(IdCard.class, "id = ?", roseCard.getId() + "");
	assertEquals(2, affectedRows);
	assertNull(getStudent(rose.getId()));
	assertNull(getIdCard(roseCard.getId()));
	affectedRows = LitePal.deleteAll(Teacher.class, "id = ?", "" + john.getId());
	assertEquals(2, affectedRows);
	assertNull(getTeacher(john.getId()));
	assertNull(getIdCard(johnCard.getId()));
	affectedRows = LitePal.deleteAll(IdCard.class, "id=?", "" + mikeCard.getId());
	assertEquals(1, affectedRows);
	assertNull(getIdCard(mikeCard.getId()));
}

Source File: MainActivity.java From PoetryWeather with Apache License 2.0

5 votes

/**
 * 同步list中数据到本地数据库
 */
private void updateDatabases() {
    LitePal.deleteAll(CityDb.class);
    for (CityDb cityDb : cityDbList) {
        Log.d(TAG, "updateDatabases: "+cityDbList.size());
        CityDb updateCityDb = new CityDb();
        updateCityDb.setCityDb_cid(cityDb.getCityDb_cid());
        updateCityDb.setCityDb_cityName(cityDb.getCityDb_cityName());
        updateCityDb.setCityDb_txt(cityDb.getCityDb_txt());
        updateCityDb.setCityDb_temperature(cityDb.getCityDb_temperature());
        updateCityDb.setCityDb_imageId(cityDb.getCityDb_imageId());
        updateCityDb.save();
    }
}

Source File: DeleteTest.java From LitePal with Apache License 2.0

5 votes

@Test
public void testDeleteAllCascadeWithConditions() {
	Classroom classroom = new Classroom();
	classroom.setName("1"+System.currentTimeMillis());
	classroom.save();
	Classroom classroom2 = new Classroom();
	classroom2.setName("2"+ System.currentTimeMillis());
	classroom2.save();
	Student s1 = new Student();
	s1.setClassroom(classroom);
	s1.save();
	Student s2 = new Student();
	s2.setClassroom(classroom);
	s2.save();
	Student s3 = new Student();
	s3.setClassroom(classroom2);
	s3.save();
	int rows = LitePal.deleteAll(Classroom.class, "name = ?", classroom.getName());
	assertEquals(3, rows);
	assertNull(getClassroom(classroom.get_id()));
	assertNull(getStudent(s1.getId()));
	assertNull(getStudent(s2.getId()));
	assertNotNull(getClassroom(classroom2.get_id()));
	assertNotNull(getStudent(s3.getId()));
	rows = LitePal.deleteAll(Classroom.class, "name = ?", classroom2.getName());
	assertEquals(2, rows);
	assertNull(getClassroom(classroom2.get_id()));
	assertNull(getStudent(s3.getId()));
}

Source File: DbHelperImpl.java From Yuan-SxMusic with Apache License 2.0

5 votes

@Override
public boolean saveSong(List<LocalSong> localSongs) {
    LitePal.deleteAll(LocalSong.class);
    for (LocalSong localSong : localSongs) {
        LocalSong song = new LocalSong();
        song.setName(localSong.getName());
        song.setSinger(localSong.getSinger());
        song.setUrl(localSong.getUrl());
        song.setSongId(localSong.getSongId());
        song.setDuration(localSong.getDuration());
        if(!song.save()) return false;
    }
    return true;
}

Source File: DeleteTest.java From LitePal with Apache License 2.0

5 votes

@Test
public void testDeleteWithGenericData() {
    Classroom classroom = new Classroom();
    classroom.setName("classroom1");
    classroom.getNews().add("news1");
    classroom.getNews().add("news2");
    classroom.getNews().add("news3");
    classroom.save();
    int id = classroom.get_id();
    String tableName = DBUtility.getGenericTableName(Classroom.class.getName(), "news");
    String column = DBUtility.getGenericValueIdColumnName(Classroom.class.getName());
    Cursor c = LitePal.findBySQL("select * from " + tableName + " where " + column + " = ?", String.valueOf(id));
    assertEquals(3, c.getCount());
    c.close();
    classroom.delete();
    c = LitePal.findBySQL("select * from " + tableName + " where " + column + " = ?", String.valueOf(id));
    assertEquals(0, c.getCount());
    c.close();
    assertFalse(classroom.isSaved());
    classroom.save();
    assertTrue(classroom.isSaved());
    c = LitePal.findBySQL("select * from " + tableName + " where " + column + " = ?", String.valueOf(classroom.get_id()));
    assertEquals(3, c.getCount());
    c.close();
    LitePal.deleteAll(Classroom.class, "id = ?", String.valueOf(classroom.get_id()));
    c = LitePal.findBySQL("select * from " + tableName + " where " + column + " = ?", String.valueOf(classroom.get_id()));
    assertEquals(0, c.getCount());
    c.close();
}

Source File: QueryEagerTest.java From LitePal with Apache License 2.0

5 votes

public void resetData() {
       LitePal.deleteAll(Student.class);
       LitePal.deleteAll(Classroom.class);
       LitePal.deleteAll(Teacher.class);
       LitePal.deleteAll(IdCard.class);
	setUp();
}

Source File: DeleteTest.java From LitePal with Apache License 2.0

5 votes

@Test
public void testDeleteAllCascadeM2OAssociationsOnMSide() {
	createClassroomStudentsTeachers();
	int rowsAffected = LitePal.deleteAll(Classroom.class, "id = ?", gameRoom.get_id() + "");
	assertEquals(5, rowsAffected);
	assertNull(getClassroom(gameRoom.get_id()));
	assertNull(getStudent(jude.getId()));
	assertNull(getStudent(rose.getId()));
	assertNull(getTeacher(john.getId()));
	assertNull(getTeacher(mike.getId()));
}

Source File: DownloadService.java From Yuan-SxMusic with Apache License 2.0

4 votes

private void deleteDb(String songId) {
    LitePal.deleteAll(DownloadInfo.class, "songId=?", songId);//删除已下载歌曲的相关列
}

Source File: DbHelperImpl.java From Yuan-WanAndroid with Apache License 2.0

4 votes

@Override
public int deleteOneHistory(String key) {
    return LitePal.deleteAll(History.class,"key=?",key);
}

Source File: DbHelperImp.java From WanAndroid with Apache License 2.0

4 votes

@Override
public int deleteAllHistoryRecord() {
   return LitePal.deleteAll(HistoryRecord.class);
}

Source File: DbHelperImp.java From WanAndroid with Apache License 2.0

4 votes

@Override
public int deleteOneHistoryRecord(String record) {
    return  LitePal.deleteAll(HistoryRecord.class, "record = ?", record);
}

Source File: WidgetListviewContentProvider.java From DongWeather with Apache License 2.0

4 votes

@Override
public int delete(Uri uri, String selection, String[] selectionArgs) {
    // Implement this to handle requests to delete one or more rows.
    LitePal.deleteAll(CountyChanged.class);
    return 0;
}

Source File: DbHelperImpl.java From Yuan-WanAndroid with Apache License 2.0

4 votes

@Override
public int deleteAllHistory() {
    return LitePal.deleteAll(History.class);
}

Java Code Examples for org.litepal.LitePal#deleteAll()