JpaBaseRuleDaoTest.java

/**
 * 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.sql.rule;

import com.datastax.driver.core.utils.UUIDs;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.github.springtestdbunit.annotation.DatabaseSetup;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.thingsboard.server.common.data.id.RuleId;
import org.thingsboard.server.common.data.id.TenantId;
import org.thingsboard.server.common.data.page.TextPageLink;
import org.thingsboard.server.common.data.rule.RuleMetaData;
import org.thingsboard.server.dao.AbstractJpaDaoTest;
import org.thingsboard.server.dao.rule.RuleDao;

import java.io.IOException;
import java.util.List;
import java.util.UUID;

import static org.junit.Assert.*;

/**
 * Created by Valerii Sosliuk on 4/30/2017.
 */
public class JpaBaseRuleDaoTest extends AbstractJpaDaoTest {

    @Autowired
    private RuleDao ruleDao;

    @Test
    @DatabaseSetup("classpath:dbunit/empty_dataset.xml")
    public void testSave() throws IOException {
        UUID id = UUIDs.timeBased();
        RuleMetaData ruleMetaData = getRuleMetaData(id);
        String filters = "{\"filters\":\"value-1\"}";
        String processor = "{\"processor\":\"value-2\"}";
        String action = "{\"action\":\"value-3\"}";
        String additionalInfo = "{\"additionalInfo\":\"value-4\"}";
        ObjectMapper mapper = new ObjectMapper();
        ruleMetaData.setFilters(mapper.readTree(filters));
        ruleMetaData.setProcessor(mapper.readTree(processor));
        ruleMetaData.setAction(mapper.readTree(action));
        ruleMetaData.setAdditionalInfo(mapper.readTree(additionalInfo));
        ruleDao.save(ruleMetaData);
        RuleMetaData savedRule = ruleDao.findById(id);
        assertNotNull(savedRule);
        assertEquals(filters, savedRule.getFilters().toString());
        assertEquals(processor, savedRule.getProcessor().toString());
        assertEquals(action, savedRule.getAction().toString());
        assertEquals(additionalInfo, savedRule.getAdditionalInfo().toString());
    }

    @Test
    @DatabaseSetup("classpath:dbunit/empty_dataset.xml")
    public void testDelete() throws IOException {
        UUID id = UUIDs.timeBased();
        RuleMetaData ruleMetaData = getRuleMetaData(id);
        ruleDao.save(ruleMetaData);
        RuleMetaData savedRule = ruleDao.findById(id);
        assertNotNull(savedRule);
        assertTrue(ruleDao.removeById(id));
        RuleMetaData afterDelete = ruleDao.findById(id);
        assertNull(afterDelete);
    }

    @Test
    @DatabaseSetup("classpath:dbunit/rule.xml")
    public void testFindRulesByPlugin() {
        assertEquals(3, ruleDao.findRulesByPlugin("token_1").size());
    }

    @Test
    @DatabaseSetup("classpath:dbunit/empty_dataset.xml")
    public void testFindByTenantIdAndPageLink() {
        UUID tenantId1 = UUIDs.timeBased();
        UUID tenantId2 = UUIDs.timeBased();
        createRulesTwoTenants(tenantId1, tenantId2, "name_", "token");
        List<RuleMetaData> rules1 = ruleDao.findByTenantIdAndPageLink(
                new TenantId(tenantId1), new TextPageLink(20, "name_"));
        assertEquals(20, rules1.size());

        List<RuleMetaData> rules2 = ruleDao.findByTenantIdAndPageLink(new TenantId(tenantId1),
                new TextPageLink(20, "name_", rules1.get(19).getId().getId(), null));
        assertEquals(10, rules2.size());

        List<RuleMetaData> rules3 = ruleDao.findByTenantIdAndPageLink(new TenantId(tenantId1),
                new TextPageLink(20, "name_", rules2.get(9).getId().getId(), null));
        assertEquals(0, rules3.size());
    }

    @Test
    @DatabaseSetup("classpath:dbunit/empty_dataset.xml")
    public void testFindAllTenantRulesByTenantId() {
        UUID tenantId1 = UUIDs.timeBased();
        UUID tenantId2 = UUIDs.timeBased();
        createTenantsAndSystemRules(tenantId1, tenantId2, "name_", "token");
        List<RuleMetaData> rules1 = ruleDao.findAllTenantRulesByTenantId(
                tenantId1, new TextPageLink(40, "name_"));
        assertEquals(40, rules1.size());

        List<RuleMetaData> rules2 = ruleDao.findAllTenantRulesByTenantId(tenantId1,
                new TextPageLink(40, "name_", rules1.get(19).getId().getId(), null));
        assertEquals(20, rules2.size());

        List<RuleMetaData> rules3 = ruleDao.findAllTenantRulesByTenantId(tenantId1,
                new TextPageLink(40, "name_", rules2.get(19).getId().getId(), null));
        assertEquals(0, rules3.size());
    }

    private void createRulesTwoTenants(UUID tenantId1, UUID tenantId2, String namePrefix, String pluginToken) {
        for (int i = 0; i < 30; i++) {
            createRule(tenantId1, namePrefix, pluginToken, i);
            createRule(tenantId2, namePrefix, pluginToken, i);
        }
    }

    private void createTenantsAndSystemRules(UUID tenantId1, UUID tenantId2, String namePrefix, String pluginToken) {
        for (int i = 0; i < 40; i++) {
            createRule(tenantId1, namePrefix, pluginToken, i);
            createRule(tenantId2, namePrefix, pluginToken, i);
            createRule(null, namePrefix, pluginToken, i);
        }
    }

    private void createRule(UUID tenantId, String namePrefix, String pluginToken, int i) {
        RuleMetaData ruleMetaData = new RuleMetaData();
        ruleMetaData.setId(new RuleId(UUIDs.timeBased()));
        ruleMetaData.setTenantId(new TenantId(tenantId));
        ruleMetaData.setName(namePrefix + i);
        ruleMetaData.setPluginToken(pluginToken);
        ruleDao.save(ruleMetaData);
    }

    private RuleMetaData getRuleMetaData(UUID id) throws IOException {
        RuleMetaData ruleMetaData = new RuleMetaData();
        ruleMetaData.setId(new RuleId(id));
        ruleMetaData.setTenantId(new TenantId(UUIDs.timeBased()));
        ruleMetaData.setName("test");

        return ruleMetaData;
    }
}