Package org.apache.hadoop.hbase.hbql

Source Code of org.apache.hadoop.hbase.hbql.AnnotationAllTypesTest

/*
* Copyright (c) 2011.  The Apache Software Foundation
*
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements.  See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership.  The ASF licenses this file
* to you 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.apache.hadoop.hbase.hbql;

import org.apache.hadoop.hbase.hbql.client.HBatch;
import org.apache.hadoop.hbase.hbql.client.HBqlException;
import org.apache.hadoop.hbase.hbql.client.HConnection;
import org.apache.hadoop.hbase.hbql.client.HConnectionManager;
import org.apache.hadoop.hbase.hbql.client.HPreparedStatement;
import org.apache.hadoop.hbase.hbql.client.HResultSet;
import org.apache.hadoop.hbase.hbql.client.HStatement;
import org.apache.hadoop.hbase.hbql.util.Lists;
import org.apache.hadoop.hbase.hbql.util.TestSupport;
import org.junit.BeforeClass;
import org.junit.Test;

import java.util.List;

public class AnnotationAllTypesTest extends TestSupport {

    static HConnection conn = null;

    static int cnt = 10;

    @BeforeClass
    public static void beforeClass() throws HBqlException {
        conn = HConnectionManager.newConnection();
        setupMapping(conn);
    }

    public static void setupMapping(HConnection connection) throws HBqlException {

        if (connection.mappingExists("alltypes2"))
            connection.execute("DROP MAPPING alltypes2");

        connection.execute("CREATE MAPPING alltypes2 FOR TABLE example2"
                           + "("
                           + "keyval KEY, "
                           + "f1 ("
                           + "  val1 boolean ALIAS booleanValue, "
                           + "  val2 boolean[] ALIAS booleanArrayValue, "
                           + "  val3 byte ALIAS byteValue, "
                           + "  val4 byte[] ALIAS byteArrayValue, "
                           + "  val5 char ALIAS charValue, "
                           + "  val6 char[] ALIAS charArrayValue, "
                           + "  val7 short ALIAS shortValue, "
                           + "  val8 short[] ALIAS shortArrayValue, "
                           + "  val9 int ALIAS intValue, "
                           + "  val10 int[] ALIAS intArrayValue, "
                           + "  val11 long ALIAS longValue, "
                           + "  val12 long[] ALIAS longArrayValue, "
                           + "  val13 float ALIAS floatValue, "
                           + "  val14 float[] ALIAS floatArrayValue, "
                           + "  val15 double ALIAS doubleValue, "
                           + "  val16 double[] ALIAS doubleArrayValue, "
                           + "  val17 string ALIAS stringValue, "
                           + "  val18 string[] ALIAS stringArrayValue, "
                           + "  val19 date ALIAS dateValue, "
                           + "  val20 date[] ALIAS dateArrayValue, "
                           + "  val21 object ALIAS mapValue, "
                           + "  val22 object[] ALIAS mapArrayValue, "
                           + "  val23 object ALIAS objectValue, "
                           + "  val24 object[] ALIAS objectArrayValue "
                           + "))");

        if (!connection.tableExists("example2"))
            System.out.println(connection.execute("create table example2 (f1())"));
        else {
            System.out.println(connection.execute("delete from alltypes2"));
        }
    }

    public static List<AnnotatedAllTypes> insertSomeData(int cnt, boolean noRandomData) throws HBqlException {

        List<AnnotatedAllTypes> retval = Lists.newArrayList();
        final HBatch<AnnotatedAllTypes> batch = conn.newHBatch();

        for (int i = 0; i < cnt; i++) {

            AnnotatedAllTypes aat = new AnnotatedAllTypes();
            aat.setSomeValues(i, noRandomData, cnt);

            retval.add(aat);

            batch.insert(aat);
        }

        batch.apply();

        return retval;
    }


    @Test
    public void simpleSelect() throws HBqlException {

        List<AnnotatedAllTypes> vals = insertSomeData(cnt, true);

        assertTrue(vals.size() == cnt);

        HStatement stmt = conn.createStatement();
        HResultSet<AnnotatedAllTypes> recs = stmt.executeQuery("select * from alltypes2", AnnotatedAllTypes.class);

        int reccnt = 0;
        for (final AnnotatedAllTypes rec : recs)
            assertTrue(rec.equals(vals.get(reccnt++)));

        assertTrue(reccnt == cnt);
    }

    @Test
    public void simpleSparseSelect() throws HBqlException {

        List<AnnotatedAllTypes> vals = insertSomeData(cnt, false);

        assertTrue(vals.size() == cnt);

        HStatement stmt = conn.createStatement();
        HResultSet<AnnotatedAllTypes> recs = stmt.executeQuery("select * from alltypes2", AnnotatedAllTypes.class);

        int reccnt = 0;
        for (final AnnotatedAllTypes rec : recs)
            assertTrue(rec.equals(vals.get(reccnt++)));

        assertTrue(reccnt == cnt);
    }

    @Test
    public void simpleLimitSelect() throws HBqlException {

        List<AnnotatedAllTypes> vals = insertSomeData(cnt, true);

        assertTrue(vals.size() == cnt);

        HPreparedStatement pstmt = conn.prepareStatement("select * from alltypes2 WITH LIMIT :limit");

        pstmt.setParameter("limit", cnt / 2);

        HResultSet<AnnotatedAllTypes> recs = pstmt.executeQuery(AnnotatedAllTypes.class);

        int reccnt = 0;
        for (final AnnotatedAllTypes rec : recs)
            assertTrue(rec.equals(vals.get(reccnt++)));

        assertTrue(reccnt == cnt / 2);
    }
}
TOP

Related Classes of org.apache.hadoop.hbase.hbql.AnnotationAllTypesTest

TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.