MySQLStoreTest.java

/*
 * Copyright 2010 Ning, Inc.
 *
 * Ning 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 com.ning.metrics.goodwill.store;

import com.ning.metrics.goodwill.access.GoodwillSchema;
import com.ning.metrics.goodwill.access.GoodwillSchemaField;
import com.ning.metrics.goodwill.dao.DAOBoneCPAccess;
import org.testng.Assert;
import org.testng.annotations.AfterTest;
import org.testng.annotations.BeforeTest;
import org.testng.annotations.Test;

import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collection;

//CREATE TABLE `thrift_types_tests` (
//   `event_type` varchar(255) DEFAULT NULL,
//   `field_id` int(11) DEFAULT NULL,
//   `field_type` varchar(255) DEFAULT NULL,
//   `field_name` varchar(255) DEFAULT NULL,
//   `sql_type` varchar(255) DEFAULT NULL,
//   `sql_length` int(11) DEFAULT NULL,
//   `sql_scale` int(11) DEFAULT NULL,
//   `sql_precision` int(11) DEFAULT NULL,
//   `description` varchar(255) DEFAULT NULL,
//   `id` int(11) NOT NULL AUTO_INCREMENT,
//   PRIMARY KEY (`id`),
//   UNIQUE KEY `unique_fields` (`event_type`,`field_id`)
//) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8

public class MySQLStoreTest
{
    private MySQLStore store;
    private DAOBoneCPAccess access;

    private static final String TYPE2_NAME = "Indiana Jones and the Last Crusade";
    private GoodwillSchema type1;
    private GoodwillSchema type2;
    private static final String TYPE1_NAME = "The Shawshank Redemption";

    @BeforeTest(alwaysRun = false, enabled = false)
    public void setUp() throws SQLException, IOException, ClassNotFoundException
    {
        access = new DAOBoneCPAccess("localhost", 3306, "goodwill", "root", "");
        store = new MySQLStore("thrift_types_tests", access);

        type1 = new GoodwillSchema(TYPE1_NAME, new ArrayList<GoodwillSchemaField>());
        type1.addThriftField(new GoodwillSchemaField("chair", "i32", (short) 0, null, null, null, null, null));
        type1.addThriftField(new GoodwillSchemaField("deal", "string", (short) 1, null, null, null, null, null));
        type1.addThriftField(new GoodwillSchemaField("continent", "string", (short) 2, null, null, null, null, null));
        type1.addThriftField(new GoodwillSchemaField("egg", "string", (short) 3, null, null, null, null, null));
        type1.addThriftField(new GoodwillSchemaField("car", "i32", (short) 4, null, null, null, null, null));
        type1.addThriftField(new GoodwillSchemaField("bear", "string", (short) 5, null, null, null, null, null));

        type2 = new GoodwillSchema(TYPE2_NAME, new ArrayList<GoodwillSchemaField>());
        type2.addThriftField(new GoodwillSchemaField("arm", "bool", (short) 0, null, null, null, null, null));
        type2.addThriftField(new GoodwillSchemaField("consonent", "i16", (short) 1, null, null, null, null, null));
        type2.addThriftField(new GoodwillSchemaField("bank", "bool", (short) 2, null, null, null, null, null));
        type2.addThriftField(new GoodwillSchemaField("cover", "string", (short) 3, null, null, null, null, null));
        type2.addThriftField(new GoodwillSchemaField("century", "string", (short) 4, null, null, null, null, null));
        type2.addThriftField(new GoodwillSchemaField("city", "string", (short) 5, null, null, null, null, null));
    }

    @AfterTest(alwaysRun = false, enabled = false)
    public void tearDown() throws SQLException
    {
    }

    @Test(enabled = false)
    public void testInvalidThriftField()
    {
        try {
            new GoodwillSchemaField("test", "string", (short) 1, "", null, 2, 23, 5);
            Assert.fail();
        }
        catch (IllegalArgumentException e) {
            Assert.assertTrue(true);

        }
    }


    @Test(enabled = false)
    public void testAddUpdateType() throws Exception
    {
        Collection<GoodwillSchema> types = store.getTypes();
        Assert.assertEquals(types.size(), 0, "You need to cleanup your test db");

        // Inserts

        addThriftType1();

        types = store.getTypes();
        Assert.assertEquals(types.size(), 1);

        addThriftType2();

        types = store.getTypes();
        Assert.assertEquals(types.size(), 2);

        Assert.assertNull(store.findByName("Frenchies won 1998 world cup"));

        runAssertsOnFields();

        // Updates

        type1.addThriftField(new GoodwillSchemaField("foo", "string", (short) 6, null, null, null, null, null));

        Assert.assertEquals(store.findByName(TYPE1_NAME).getSchema().size(), 6);
        Assert.assertTrue(store.updateType(type1));
        types = store.getTypes();
        Assert.assertEquals(store.findByName(TYPE1_NAME).getSchema().size(), 7);
        Assert.assertEquals(types.size(), 2);

        runAssertsOnFields();

        // TODO Test for dups
    }

    private void runAssertsOnFields()
    {
        GoodwillSchema shouldBeType1 = store.findByName(TYPE1_NAME);
        for (GoodwillSchemaField field : shouldBeType1.getSchema()) {
            Assert.assertEquals(field.getName(), type1.getFieldByPosition(field.getId()).getName());
            Assert.assertEquals(field.getType(), type1.getFieldByPosition(field.getId()).getType());
            Assert.assertEquals(field.getDescription(), type1.getFieldByPosition(field.getId()).getDescription());
            Assert.assertEquals(field.getSql().getType(), type1.getFieldByPosition(field.getId()).getSql().getType());
            Assert.assertEquals(field.getSql().getLength(), type1.getFieldByPosition(field.getId()).getSql().getLength());
            Assert.assertEquals(field.getId(), type1.getFieldByPosition(field.getId()).getId());
        }
    }

    private void addThriftType2()
    {
        store.addType(type2);
    }

    private void addThriftType1()
    {
        store.addType(type1);
    }
}