com.splicemachine.derby.utils.TimestampAdminIT.java Source code

Introduction

Here is the source code for com.splicemachine.derby.utils.TimestampAdminIT.java

Source

/*
 * Copyright 2012 - 2016 Splice Machine, Inc.
 *
 * 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 com.splicemachine.derby.utils;

import java.sql.CallableStatement;
import java.sql.ResultSet;

import com.splicemachine.test.SerialTest;
import org.apache.commons.dbutils.DbUtils;
import org.junit.*;
import org.junit.rules.RuleChain;
import org.junit.rules.TestRule;

import com.splicemachine.derby.test.framework.SpliceSchemaWatcher;
import com.splicemachine.derby.test.framework.SpliceTableWatcher;
import com.splicemachine.derby.test.framework.SpliceWatcher;

/**
 * Integration tests for TimestampAdmin.
 */
@Ignore("-sf- needs to be re-implemented in an architecture-independent way, but I don't want to let that stop merging")
public class TimestampAdminIT {
    protected static SpliceWatcher spliceClassWatcher = new SpliceWatcher();
    public static final String CLASS_NAME = TimestampAdminIT.class.getSimpleName().toUpperCase();
    protected static SpliceTableWatcher spliceTableWatcher = new SpliceTableWatcher("TEST1", CLASS_NAME, "(a int)");
    protected static SpliceSchemaWatcher spliceSchemaWatcher = new SpliceSchemaWatcher(CLASS_NAME);

    @ClassRule
    public static TestRule chain = RuleChain.outerRule(spliceClassWatcher).around(spliceSchemaWatcher)
            .around(spliceTableWatcher);

    @Rule
    public SpliceWatcher methodWatcher = new SpliceWatcher();

    /*
    private List<List<String>> resultSetToList(ResultSet resultset) throws Exception {
    int numcols = resultset.getMetaData().getColumnCount();
    List<List<String>> result = new ArrayList<List<String>>();
       while (resultset.next()) {
       List<String> row = new ArrayList<String>(numcols);
       for (int i = 1; i <= numcols; i++) {
           row.add(resultset.getString(i));
       }
       result.add(row);
       }
       return result;
    }
    */

    /**
     * Tests SYSCS_GET_TIMESTAMP_GENERATOR_INFO system procedure.
     */
    @Test
    public void testGetTimestampGeneratorInfo() throws Exception {
        String template = "call SYSCS_UTIL.SYSCS_GET_TIMESTAMP_GENERATOR_INFO()";
        CallableStatement cs = methodWatcher.prepareCall(template);
        ResultSet rs = cs.executeQuery();
        int rowCount = 0;
        while (rs.next()) {
            rowCount++;
            long num = rs.getLong(1);
            Assert.assertTrue("Unexpected number of timestamps", num > 0);
        }
        Assert.assertTrue(rowCount == 1);
        DbUtils.closeQuietly(rs);
    }

    /**
     * Tests SYSCS_GET_TIMESTAMP_REQUEST_INFO system procedure.
     */
    @Test
    public void testGetTimestampRequestInfo() throws Exception {
        String template = "call SYSCS_UTIL.SYSCS_GET_TIMESTAMP_REQUEST_INFO()";
        CallableStatement cs = methodWatcher.prepareCall(template);
        ResultSet rs = cs.executeQuery();
        int rowCount = 0;
        while (rs.next()) {
            rowCount++;
            long num = rs.getLong(2);
            Assert.assertTrue("Unexpected number of requests", num > 0);
        }
        Assert.assertTrue(rowCount > 0);
        DbUtils.closeQuietly(rs);
    }

}