Java CreateOrUpdateStatus类代码示例

import com.j256.ormlite.dao.Dao.CreateOrUpdateStatus; //导入依赖的package包/类
private static <E extends Entity> boolean insertOrUpdate(final Dao<E, ?> dao, final E entity, final Date now) throws SQLException {
	if (LOGGER.isDebugEnabled()) {
		LOGGER.debug("insertOrUpdate: " + ReflectionToStringBuilder.toString(dao) + ", " + entity);
	}
	final Date createdAt = entity.getCreatedAt();
	entity.setCreatedAt(createdAt != null ? createdAt : now);
	final Date updatedAt = entity.getUpdatedAt();
	entity.setUpdatedAt(updatedAt != null ? updatedAt : now);
	final CreateOrUpdateStatus status = dao.createOrUpdate(entity);
	if (LOGGER.isDebugEnabled()) {
		LOGGER.debug("insertOrUpdate: " + ReflectionToStringBuilder.toString(status) + ", " + entity);
	}
	final boolean created = (status != null) && status.isCreated();
	final boolean updated = (status != null) && status.isUpdated();
	entity.setCreatedAt(created ? now : createdAt);
	entity.setUpdatedAt(updated ? now : updatedAt);
	final boolean result = (updated && ((updatedAt == null) || now.equals(updatedAt))) || (dao.update(entity) == 1);
	if (LOGGER.isDebugEnabled()) {
		LOGGER.debug("insertOrUpdate: " + result + ", " + entity);
	}
	return result;
}
 

import com.j256.ormlite.dao.Dao.CreateOrUpdateStatus; //导入依赖的package包/类
public boolean addOrUpdateRace(Race race) {
    try {
        CreateOrUpdateStatus status = mHelper.getRaceDao().createOrUpdate(race);

        for (Rule rule : race.getRules()) {
            rule.setRace(race);

            // Rules could have been added or removed, so remove persisted
            // rules and add current rules
            if (status.isUpdated()) {
                DeleteBuilder<Rule, Long> deleteBuilder = mHelper.getRuleDao().deleteBuilder();
                deleteBuilder.where().eq("ruleId", rule.getRuleId()).and().eq("race_id", race.getRaceId());
                deleteBuilder.delete();
            }

            mHelper.getRuleDao().createOrUpdate(rule);
        }

        return true;
    } catch (SQLException e) {
        Log.e(TAG, "Failed to cache a race", e);
        return false;
    }
}
 

import com.j256.ormlite.dao.Dao.CreateOrUpdateStatus; //导入依赖的package包/类
@Test
public void testCreateOrUpdate() throws Exception {
	Dao<NotQuiteFoo, Integer> dao = createDao(NotQuiteFoo.class, true);
	NotQuiteFoo foo1 = new NotQuiteFoo();
	foo1.stuff = "wow";
	CreateOrUpdateStatus status = dao.createOrUpdate(foo1);
	assertTrue(status.isCreated());
	assertFalse(status.isUpdated());
	assertEquals(1, status.getNumLinesChanged());

	String stuff2 = "4134132";
	foo1.stuff = stuff2;
	status = dao.createOrUpdate(foo1);
	assertFalse(status.isCreated());
	assertTrue(status.isUpdated());
	assertEquals(1, status.getNumLinesChanged());

	NotQuiteFoo result = dao.queryForId(foo1.id);
	assertEquals(stuff2, result.stuff);
}
 

import com.j256.ormlite.dao.Dao.CreateOrUpdateStatus; //导入依赖的package包/类
@Test
public void testCreateOrUpdateNullId() throws Exception {
	Dao<CreateOrUpdateObjectId, Integer> dao = createDao(CreateOrUpdateObjectId.class, true);
	CreateOrUpdateObjectId foo = new CreateOrUpdateObjectId();
	String stuff = "21313";
	foo.stuff = stuff;
	CreateOrUpdateStatus status = dao.createOrUpdate(foo);
	assertTrue(status.isCreated());
	assertFalse(status.isUpdated());
	assertEquals(1, status.getNumLinesChanged());

	CreateOrUpdateObjectId result = dao.queryForId(foo.id);
	assertNotNull(result);
	assertEquals(stuff, result.stuff);

	String stuff2 = "pwojgfwe";
	foo.stuff = stuff2;
	dao.createOrUpdate(foo);

	result = dao.queryForId(foo.id);
	assertNotNull(result);
	assertEquals(stuff2, result.stuff);
}
 

import com.j256.ormlite.dao.Dao.CreateOrUpdateStatus; //导入依赖的package包/类
public void testCreateOrUpdate() throws Exception {
	Dao<NotQuiteFoo, Integer> dao = createDao(NotQuiteFoo.class, true);
	NotQuiteFoo foo1 = new NotQuiteFoo();
	foo1.stuff = "wow";
	CreateOrUpdateStatus status = dao.createOrUpdate(foo1);
	assertTrue(status.isCreated());
	assertFalse(status.isUpdated());
	assertEquals(1, status.getNumLinesChanged());

	String stuff2 = "4134132";
	foo1.stuff = stuff2;
	status = dao.createOrUpdate(foo1);
	assertFalse(status.isCreated());
	assertTrue(status.isUpdated());
	assertEquals(1, status.getNumLinesChanged());

	NotQuiteFoo result = dao.queryForId(foo1.id);
	assertEquals(stuff2, result.stuff);
}
 

import com.j256.ormlite.dao.Dao.CreateOrUpdateStatus; //导入依赖的package包/类
public void testCreateOrUpdateNullId() throws Exception {
	Dao<CreateOrUpdateObjectId, Integer> dao = createDao(CreateOrUpdateObjectId.class, true);
	CreateOrUpdateObjectId foo = new CreateOrUpdateObjectId();
	String stuff = "21313";
	foo.stuff = stuff;
	CreateOrUpdateStatus status = dao.createOrUpdate(foo);
	assertTrue(status.isCreated());
	assertFalse(status.isUpdated());
	assertEquals(1, status.getNumLinesChanged());

	CreateOrUpdateObjectId result = dao.queryForId(foo.id);
	assertNotNull(result);
	assertEquals(stuff, result.stuff);

	String stuff2 = "pwojgfwe";
	foo.stuff = stuff2;
	dao.createOrUpdate(foo);

	result = dao.queryForId(foo.id);
	assertNotNull(result);
	assertEquals(stuff2, result.stuff);
}
 

import com.j256.ormlite.dao.Dao.CreateOrUpdateStatus; //导入依赖的package包/类
@Test
public void testCreateOrUpdate() throws Exception {
	Dao<Foo, Integer> dao = createDao(Foo.class, true);
	Foo foo1 = new Foo();
	int equal1 = 21313;
	foo1.equal = equal1;
	CreateOrUpdateStatus status = dao.createOrUpdate(foo1);
	assertTrue(status.isCreated());
	assertFalse(status.isUpdated());
	assertEquals(1, status.getNumLinesChanged());

	int equal2 = 4134132;
	foo1.equal = equal2;
	status = dao.createOrUpdate(foo1);
	assertFalse(status.isCreated());
	assertTrue(status.isUpdated());
	assertEquals(1, status.getNumLinesChanged());

	Foo fooResult = dao.queryForId(foo1.id);
	assertEquals(equal2, fooResult.equal);
}
 

import com.j256.ormlite.dao.Dao.CreateOrUpdateStatus; //导入依赖的package包/类
public static int createOrUpdateItem(Item item) {
    RuntimeExceptionDao<Item, UUID> itemDao = DsaTabApplication.getInstance().getDBHelper().getItemDao();

    CreateOrUpdateStatus status = itemDao.createOrUpdate(item);
    int result = status.getNumLinesChanged();

    for (ItemSpecification itemSpec : item.getSpecifications()) {
        RuntimeExceptionDao itemSpecDao = DsaTabApplication.getInstance().getDBHelper()
                .getRuntimeDao(itemSpec.getClass());
        itemSpecDao.createOrUpdate(itemSpec);
    }

    DsaTabApplication.getInstance().getContentResolver().notifyChange(ITEMS_URI,null);

    return result;
}
 

import com.j256.ormlite.dao.Dao.CreateOrUpdateStatus; //导入依赖的package包/类
private void confirmAddMobile() {
    if (TextUtils.isEmpty(mPhoneNumInput.getEditableText().toString())) {
        Toast.makeText(getActivity(), "电话号码不能为空", Toast.LENGTH_SHORT).show();
    } else {
        String mobile = mPhoneNumInput.getEditableText().toString();
        BlackList entity = new BlackList();
        entity.setCreateTime(System.currentTimeMillis());
        entity.setIsReplay(mMessageReplayChecked == true ? 1 : 0);
        entity.setMarkMessage(mMessageChecked == true ? 1 : 0);
        entity.setMarkPhone(mPhoneChecked == true ? 1 : 0);
        entity.setMobile(mobile);
        entity.setPhoneName(mNote.getEditableText().toString());
        entity.setReplayMessage(mMessageRelayInput.getEditableText().toString());
        RuntimeExceptionDao<BlackList, Integer> dao = getDBHelper().getBlackListDao();
        try {
            BlackList blackList = dao.queryBuilder().where().eq(BlackList.MOBILE, mobile)
                    .queryForFirst();
            if (blackList != null) {
                entity.setId(blackList.getId());
            }
            CreateOrUpdateStatus status = getDBHelper().getBlackListDao().createOrUpdate(entity);
            if (status.isCreated()) {
                Toast.makeText(getActivity(), "添加号码成功", Toast.LENGTH_SHORT).show();
            } else if (status.isUpdated()) {
                Toast.makeText(getActivity(), "更新号码成功", Toast.LENGTH_SHORT).show();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }
}
 

import com.j256.ormlite.dao.Dao.CreateOrUpdateStatus; //导入依赖的package包/类
@Override
public void onDownloadFileCreated(DownloadFileInfo downloadFileInfo) {

    if (downloadFileInfo != null && downloadFileInfo.getUrl() != null && downloadFileInfo.getUrl().equals
            (mCourseUrl)) {

        // add this CoursePreviewInfo in database download record
        // 
        // the reason why to save this CoursePreviewInfo in course database is 
        // that when the user enter the CourseDownloadFragment,the fragment need to show the course title to the 
        // user,however the DownloadFileInfo in FileDownloader can not provide the course title,also the fragment 
        // need to know how many course items need to show,so it is depends on the size of the course database, 
        // because FileDownloader is just a tool to download, record and manage all the files which were 
        // downloaded from the internet
        try {
            if (mCourseDbHelper == null) {
                return;
            }
            Dao<CoursePreviewInfo, Integer> dao = mCourseDbHelper.getDao(CoursePreviewInfo.class);
            CreateOrUpdateStatus status = dao.createOrUpdate(this);
            if (status.isCreated() || status.isUpdated()) {
                this.mDownloadFileInfo = downloadFileInfo;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

}
 

import com.j256.ormlite.dao.Dao.CreateOrUpdateStatus; //导入依赖的package包/类
@Override
public void onDownloadFileUpdated(DownloadFileInfo downloadFileInfo, Type type) {

    if (downloadFileInfo != null && downloadFileInfo.getUrl() != null && downloadFileInfo.getUrl().equals
            (mCourseUrl)) {
        if (this.mDownloadFileInfo == null) {
            try {
                if (mCourseDbHelper == null) {
                    return;
                }
                UpdateBuilder builder = mCourseDbHelper.getDao(CoursePreviewInfo.class).updateBuilder();
                builder.where().eq(CoursePreviewInfo.COLUMN_NAME_OF_FIELD_COURSE_URL, downloadFileInfo.getUrl());
                int result = builder.update();
                if (result == 1) {
                    this.mDownloadFileInfo = downloadFileInfo;
                } else {
                    Dao<CoursePreviewInfo, Integer> dao = mCourseDbHelper.getDao(CoursePreviewInfo.class);
                    CreateOrUpdateStatus status = dao.createOrUpdate(this);
                    if (status.isCreated() || status.isUpdated()) {
                        this.mDownloadFileInfo = downloadFileInfo;
                    }
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

}
 

import com.j256.ormlite.dao.Dao.CreateOrUpdateStatus; //导入依赖的package包/类
public CreateOrUpdateStatus save( Model model ) {
	updateDate( model );
	try	{
		if( model instanceof CategoryModel ) {
			return getCategoriesDao().createOrUpdate( (CategoryModel) model );
		} else if( model instanceof MaterialModel )	{
			return getMaterialsDao().createOrUpdate( (MaterialModel) model );
		} else if( model instanceof ImageModel )	{
			return getImagesDao().createOrUpdate( (ImageModel) model );
		}
	} catch( SQLException e )	{
		Log.e( TAG, e.getMessage() );
	}
	return new CreateOrUpdateStatus( false, false, 0 );
}
 

import com.j256.ormlite.dao.Dao.CreateOrUpdateStatus; //导入依赖的package包/类
@Test
public void testCreateOrUpdateNull() throws Exception {
	Dao<Foo, String> dao = createDao(Foo.class, true);
	CreateOrUpdateStatus status = dao.createOrUpdate(null);
	assertFalse(status.isCreated());
	assertFalse(status.isUpdated());
	assertEquals(0, status.getNumLinesChanged());
}
 

import com.j256.ormlite.dao.Dao.CreateOrUpdateStatus; //导入依赖的package包/类
@Test
public void testVersionFieldInsertOrUpdate() throws Exception {
	Dao<VersionField, Integer> dao = createDao(VersionField.class, true);

	VersionField foo1 = new VersionField();
	assertEquals(1, dao.create(foo1));

	assertEquals(1, foo1.id);
	assertEquals(0, foo1.version);

	CreateOrUpdateStatus status = dao.createOrUpdate(foo1);
	assertTrue(status.isUpdated());
	assertEquals(1, status.getNumLinesChanged());
	assertEquals(1, foo1.version);

	status = dao.createOrUpdate(foo1);
	assertTrue(status.isUpdated());
	assertEquals(1, status.getNumLinesChanged());
	assertEquals(2, foo1.version);

	VersionField result = dao.queryForId(foo1.id);
	// we update this one to a new version number
	assertEquals(1, dao.update(result));
	assertEquals(3, result.version);

	// the old one doesn't change
	assertEquals(2, foo1.version);
	// but when we try to update the earlier foo, the version doesn't match
	assertEquals(0, dao.update(foo1));
}
 

import com.j256.ormlite.dao.Dao.CreateOrUpdateStatus; //导入依赖的package包/类
public void testCreateOrUpdateNull() throws Exception {
	Dao<Foo, String> dao = createDao(Foo.class, true);
	CreateOrUpdateStatus status = dao.createOrUpdate(null);
	assertFalse(status.isCreated());
	assertFalse(status.isUpdated());
	assertEquals(0, status.getNumLinesChanged());
}