Java tutorial
/** * Copyright 2016-2018 The Thingsboard Authors * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package org.thingsboard.server.dao.asset; import com.datastax.driver.core.ResultSet; import com.datastax.driver.core.ResultSetFuture; import com.datastax.driver.core.Statement; import com.datastax.driver.core.querybuilder.Select; import com.datastax.driver.mapping.Result; import com.google.common.base.Function; import com.google.common.util.concurrent.Futures; import com.google.common.util.concurrent.ListenableFuture; import lombok.extern.slf4j.Slf4j; import org.springframework.stereotype.Component; import org.thingsboard.server.common.data.EntitySubtype; import org.thingsboard.server.common.data.EntityType; import org.thingsboard.server.common.data.asset.Asset; import org.thingsboard.server.common.data.id.TenantId; import org.thingsboard.server.common.data.page.TextPageLink; import org.thingsboard.server.dao.DaoUtil; import org.thingsboard.server.dao.model.EntitySubtypeEntity; import org.thingsboard.server.dao.model.nosql.AssetEntity; import org.thingsboard.server.dao.nosql.CassandraAbstractSearchTextDao; import org.thingsboard.server.dao.util.NoSqlDao; import javax.annotation.Nullable; import java.util.ArrayList; import java.util.Arrays; import java.util.Collections; import java.util.List; import java.util.Optional; import java.util.UUID; import static com.datastax.driver.core.querybuilder.QueryBuilder.eq; import static com.datastax.driver.core.querybuilder.QueryBuilder.in; import static com.datastax.driver.core.querybuilder.QueryBuilder.select; import static org.thingsboard.server.dao.model.ModelConstants.ASSET_BY_CUSTOMER_AND_SEARCH_TEXT_COLUMN_FAMILY_NAME; import static org.thingsboard.server.dao.model.ModelConstants.ASSET_BY_CUSTOMER_BY_TYPE_AND_SEARCH_TEXT_COLUMN_FAMILY_NAME; import static org.thingsboard.server.dao.model.ModelConstants.ASSET_BY_TENANT_AND_NAME_VIEW_NAME; import static org.thingsboard.server.dao.model.ModelConstants.ASSET_BY_TENANT_AND_SEARCH_TEXT_COLUMN_FAMILY_NAME; import static org.thingsboard.server.dao.model.ModelConstants.ASSET_BY_TENANT_BY_TYPE_AND_SEARCH_TEXT_COLUMN_FAMILY_NAME; import static org.thingsboard.server.dao.model.ModelConstants.ASSET_COLUMN_FAMILY_NAME; import static org.thingsboard.server.dao.model.ModelConstants.ASSET_CUSTOMER_ID_PROPERTY; import static org.thingsboard.server.dao.model.ModelConstants.ASSET_NAME_PROPERTY; import static org.thingsboard.server.dao.model.ModelConstants.ASSET_TENANT_ID_PROPERTY; import static org.thingsboard.server.dao.model.ModelConstants.ASSET_TYPE_PROPERTY; import static org.thingsboard.server.dao.model.ModelConstants.ENTITY_SUBTYPE_COLUMN_FAMILY_NAME; import static org.thingsboard.server.dao.model.ModelConstants.ENTITY_SUBTYPE_ENTITY_TYPE_PROPERTY; import static org.thingsboard.server.dao.model.ModelConstants.ENTITY_SUBTYPE_TENANT_ID_PROPERTY; import static org.thingsboard.server.dao.model.ModelConstants.ID_PROPERTY; @Component @Slf4j @NoSqlDao public class CassandraAssetDao extends CassandraAbstractSearchTextDao<AssetEntity, Asset> implements AssetDao { @Override protected Class<AssetEntity> getColumnFamilyClass() { return AssetEntity.class; } @Override protected String getColumnFamilyName() { return ASSET_COLUMN_FAMILY_NAME; } @Override public Asset save(TenantId tenantId, Asset domain) { Asset savedAsset = super.save(tenantId, domain); EntitySubtype entitySubtype = new EntitySubtype(savedAsset.getTenantId(), EntityType.ASSET, savedAsset.getType()); EntitySubtypeEntity entitySubtypeEntity = new EntitySubtypeEntity(entitySubtype); Statement saveStatement = cluster.getMapper(EntitySubtypeEntity.class).saveQuery(entitySubtypeEntity); executeWrite(tenantId, saveStatement); return savedAsset; } @Override public List<Asset> findAssetsByTenantId(UUID tenantId, TextPageLink pageLink) { log.debug("Try to find assets by tenantId [{}] and pageLink [{}]", tenantId, pageLink); List<AssetEntity> assetEntities = findPageWithTextSearch(new TenantId(tenantId), ASSET_BY_TENANT_AND_SEARCH_TEXT_COLUMN_FAMILY_NAME, Collections.singletonList(eq(ASSET_TENANT_ID_PROPERTY, tenantId)), pageLink); log.trace("Found assets [{}] by tenantId [{}] and pageLink [{}]", assetEntities, tenantId, pageLink); return DaoUtil.convertDataList(assetEntities); } @Override public List<Asset> findAssetsByTenantIdAndType(UUID tenantId, String type, TextPageLink pageLink) { log.debug("Try to find assets by tenantId [{}], type [{}] and pageLink [{}]", tenantId, type, pageLink); List<AssetEntity> assetEntities = findPageWithTextSearch(new TenantId(tenantId), ASSET_BY_TENANT_BY_TYPE_AND_SEARCH_TEXT_COLUMN_FAMILY_NAME, Arrays.asList(eq(ASSET_TYPE_PROPERTY, type), eq(ASSET_TENANT_ID_PROPERTY, tenantId)), pageLink); log.trace("Found assets [{}] by tenantId [{}], type [{}] and pageLink [{}]", assetEntities, tenantId, type, pageLink); return DaoUtil.convertDataList(assetEntities); } public ListenableFuture<List<Asset>> findAssetsByTenantIdAndIdsAsync(UUID tenantId, List<UUID> assetIds) { log.debug("Try to find assets by tenantId [{}] and asset Ids [{}]", tenantId, assetIds); Select select = select().from(getColumnFamilyName()); Select.Where query = select.where(); query.and(eq(ASSET_TENANT_ID_PROPERTY, tenantId)); query.and(in(ID_PROPERTY, assetIds)); return findListByStatementAsync(new TenantId(tenantId), query); } @Override public List<Asset> findAssetsByTenantIdAndCustomerId(UUID tenantId, UUID customerId, TextPageLink pageLink) { log.debug("Try to find assets by tenantId [{}], customerId[{}] and pageLink [{}]", tenantId, customerId, pageLink); List<AssetEntity> assetEntities = findPageWithTextSearch(new TenantId(tenantId), ASSET_BY_CUSTOMER_AND_SEARCH_TEXT_COLUMN_FAMILY_NAME, Arrays.asList(eq(ASSET_CUSTOMER_ID_PROPERTY, customerId), eq(ASSET_TENANT_ID_PROPERTY, tenantId)), pageLink); log.trace("Found assets [{}] by tenantId [{}], customerId [{}] and pageLink [{}]", assetEntities, tenantId, customerId, pageLink); return DaoUtil.convertDataList(assetEntities); } @Override public List<Asset> findAssetsByTenantIdAndCustomerIdAndType(UUID tenantId, UUID customerId, String type, TextPageLink pageLink) { log.debug("Try to find assets by tenantId [{}], customerId [{}], type [{}] and pageLink [{}]", tenantId, customerId, type, pageLink); List<AssetEntity> assetEntities = findPageWithTextSearch(new TenantId(tenantId), ASSET_BY_CUSTOMER_BY_TYPE_AND_SEARCH_TEXT_COLUMN_FAMILY_NAME, Arrays.asList(eq(ASSET_TYPE_PROPERTY, type), eq(ASSET_CUSTOMER_ID_PROPERTY, customerId), eq(ASSET_TENANT_ID_PROPERTY, tenantId)), pageLink); log.trace("Found assets [{}] by tenantId [{}], customerId [{}], type [{}] and pageLink [{}]", assetEntities, tenantId, customerId, type, pageLink); return DaoUtil.convertDataList(assetEntities); } @Override public ListenableFuture<List<Asset>> findAssetsByTenantIdAndCustomerIdAndIdsAsync(UUID tenantId, UUID customerId, List<UUID> assetIds) { log.debug("Try to find assets by tenantId [{}], customerId [{}] and asset Ids [{}]", tenantId, customerId, assetIds); Select select = select().from(getColumnFamilyName()); Select.Where query = select.where(); query.and(eq(ASSET_TENANT_ID_PROPERTY, tenantId)); query.and(eq(ASSET_CUSTOMER_ID_PROPERTY, customerId)); query.and(in(ID_PROPERTY, assetIds)); return findListByStatementAsync(new TenantId(tenantId), query); } @Override public Optional<Asset> findAssetsByTenantIdAndName(UUID tenantId, String assetName) { Select select = select().from(ASSET_BY_TENANT_AND_NAME_VIEW_NAME); Select.Where query = select.where(); query.and(eq(ASSET_TENANT_ID_PROPERTY, tenantId)); query.and(eq(ASSET_NAME_PROPERTY, assetName)); AssetEntity assetEntity = (AssetEntity) findOneByStatement(new TenantId(tenantId), query); return Optional.ofNullable(DaoUtil.getData(assetEntity)); } @Override public ListenableFuture<List<EntitySubtype>> findTenantAssetTypesAsync(UUID tenantId) { Select select = select().from(ENTITY_SUBTYPE_COLUMN_FAMILY_NAME); Select.Where query = select.where(); query.and(eq(ENTITY_SUBTYPE_TENANT_ID_PROPERTY, tenantId)); query.and(eq(ENTITY_SUBTYPE_ENTITY_TYPE_PROPERTY, EntityType.ASSET)); query.setConsistencyLevel(cluster.getDefaultReadConsistencyLevel()); ResultSetFuture resultSetFuture = executeAsyncRead(new TenantId(tenantId), query); return Futures.transform(resultSetFuture, new Function<ResultSet, List<EntitySubtype>>() { @Nullable @Override public List<EntitySubtype> apply(@Nullable ResultSet resultSet) { Result<EntitySubtypeEntity> result = cluster.getMapper(EntitySubtypeEntity.class).map(resultSet); if (result != null) { List<EntitySubtype> entitySubtypes = new ArrayList<>(); result.all().forEach( (entitySubtypeEntity) -> entitySubtypes.add(entitySubtypeEntity.toEntitySubtype())); return entitySubtypes; } else { return Collections.emptyList(); } } }); } }