/* * Copyright 2015 Realm 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 io.realm.internal; import android.support.test.InstrumentationRegistry; import junit.framework.TestCase; import io.realm.Realm; import io.realm.RealmFieldType; import io.realm.internal.Table.PivotType; public class PivotTest extends TestCase { Table t; long colIndexSex; long colIndexAge; long colIndexHired; @Override public void setUp() { Realm.init(InstrumentationRegistry.getInstrumentation().getContext()); t = new Table(); colIndexSex = t.addColumn(RealmFieldType.STRING, "sex"); colIndexAge = t.addColumn(RealmFieldType.INTEGER, "age"); colIndexHired = t.addColumn(RealmFieldType.BOOLEAN, "hired"); for (long i=0;i<50000;i++){ String sex = i % 2 == 0 ? "Male" : "Female"; t.add(sex, 20 + (i%20), true); } } public void testPivotTable(){ Table resultCount = t.pivot(colIndexSex, colIndexAge, PivotType.COUNT); assertEquals(2, resultCount.size()); assertEquals(25000, resultCount.getLong(1, 0)); assertEquals(25000, resultCount.getLong(1, 1)); Table resultMin = t.pivot(colIndexSex, colIndexAge, PivotType.MIN); assertEquals(20, resultMin.getLong(1, 0)); assertEquals(21, resultMin.getLong(1, 1)); Table resultMax = t.pivot(colIndexSex, colIndexAge, PivotType.MAX); assertEquals(38, resultMax.getLong(1, 0)); assertEquals(39, resultMax.getLong(1, 1)); try { t.pivot(colIndexHired, colIndexAge, PivotType.SUM); fail("Group by not a String column"); } catch (UnsupportedOperationException e) { } try { t.pivot(colIndexSex, colIndexHired, PivotType.SUM); fail("Aggregation not an int column"); } catch (UnsupportedOperationException e) { } } }