Android Open Source - android-memento Sqlite Column Builder Test

From Project

License

The source code is released under:
Apache License
If you think the Android project android-memento listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.
Java Source Code

/*
 * android-memento-lib https://github.com/twofortyfouram/android-memento
 * Copyright 2014 two forty four a.m. LLC
 */*from  w  ww.j a  va  2  s  .c  o  m*/
 * 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.twofortyfouram.memento.provider.sqlite;

import junit.framework.TestCase;

import android.test.suitebuilder.annotation.SmallTest;

/**
 * Tests {@link SqliteColumnBuilder}.
 */
public final class SqliteColumnBuilderTest extends TestCase {

    @SmallTest
    public static void testBuildBasic_blob() {
        final SqliteColumnBuilder builder = new SqliteColumnBuilder();

        assertSame(builder, builder.setName("test_column")); //$NON-NLS-1$
        assertSame(builder, builder.setType(SqliteStorageClass.BLOB));

        assertEquals("test_column BLOB", builder.build()); //$NON-NLS-1$
    }

    @SmallTest
    public static void testBuildBasic_integer() {
        final SqliteColumnBuilder builder = new SqliteColumnBuilder();

        assertSame(builder, builder.setName("test_column")); //$NON-NLS-1$
        assertSame(builder, builder.setType(SqliteStorageClass.INTEGER));

        assertEquals("test_column INTEGER", builder.build()); //$NON-NLS-1$
    }

    @SmallTest
    public static void testBuildBasic_null() {
        final SqliteColumnBuilder builder = new SqliteColumnBuilder();

        assertSame(builder, builder.setName("test_column")); //$NON-NLS-1$
        assertSame(builder, builder.setType(SqliteStorageClass.NULL));

        assertEquals("test_column NULL", builder.build()); //$NON-NLS-1$
    }

    @SmallTest
    public static void testBuildBasic_real() {
        final SqliteColumnBuilder builder = new SqliteColumnBuilder();

        assertSame(builder, builder.setName("test_column")); //$NON-NLS-1$
        assertSame(builder, builder.setType(SqliteStorageClass.REAL));

        assertEquals("test_column REAL", builder.build()); //$NON-NLS-1$
    }

    @SmallTest
    public static void testBuildBasic_replace() {
        final SqliteColumnBuilder builder = new SqliteColumnBuilder();

        assertSame(builder, builder.setName("test_column")); //$NON-NLS-1$
        assertSame(builder, builder.setType(SqliteStorageClass.REAL));

        assertSame(builder, builder.setName("test_column_two")); //$NON-NLS-1$
        assertSame(builder, builder.setType(SqliteStorageClass.TEXT));

        assertEquals("test_column_two TEXT", builder.build()); //$NON-NLS-1$
    }

    @SmallTest
    public static void testBuildBasic_unique() {
        final SqliteColumnBuilder builder = new SqliteColumnBuilder();

        assertSame(builder, builder.setName("test_column")); //$NON-NLS-1$
        assertSame(builder, builder.setType(SqliteStorageClass.INTEGER));
        assertSame(builder, builder.setConstraintUnique());

        assertEquals("test_column INTEGER UNIQUE", builder.build()); //$NON-NLS-1$
    }

    @SmallTest
    public static void testBuildBasic_not_null() {
        final SqliteColumnBuilder builder = new SqliteColumnBuilder();

        assertSame(builder, builder.setName("test_column")); //$NON-NLS-1$
        assertSame(builder, builder.setType(SqliteStorageClass.INTEGER));
        assertSame(builder, builder.setConstraintNotNull());

        assertEquals("test_column INTEGER NOT NULL", builder.build()); //$NON-NLS-1$
    }

    @SmallTest
    public static void testBuildBasic_primary_key() {
        final SqliteColumnBuilder builder = new SqliteColumnBuilder();

        assertSame(builder, builder.setName("test_column")); //$NON-NLS-1$
        assertSame(builder, builder.setType(SqliteStorageClass.INTEGER));
        assertSame(builder, builder.setAutoincrementPrimaryKey());

        assertEquals("test_column INTEGER PRIMARY KEY AUTOINCREMENT",
                builder.build()); //$NON-NLS-1$
    }

    @SmallTest
    public static void testBuildBasic_foreign_key() {
        final SqliteColumnBuilder builder = new SqliteColumnBuilder();

        assertSame(builder, builder.setName("test_column")); //$NON-NLS-1$
        assertSame(builder, builder.setType(SqliteStorageClass.INTEGER));
        assertSame(builder, builder.setForeignKey("foreign_table",
                "foreign_column")); //$NON-NLS-1$//$NON-NLS-2$

        assertEquals(
                "test_column INTEGER REFERENCES foreign_table(foreign_column)",
                builder.build()); //$NON-NLS-1$
    }

    @SmallTest
    public static void testBuildBasic_range() {
        final SqliteColumnBuilder builder = new SqliteColumnBuilder();

        assertSame(builder, builder.setName("test_column")); //$NON-NLS-1$
        assertSame(builder, builder.setType(SqliteStorageClass.INTEGER));
        assertSame(builder, builder.setConstraintRange(52, 77));

        assertEquals(
                "test_column INTEGER CHECK(test_column >= 52 AND test_column <= 77)",
                builder.build()); //$NON-NLS-1$
    }

    @SmallTest
    public static void testBuildBasic_set() {
        final SqliteColumnBuilder builder = new SqliteColumnBuilder();

        assertSame(builder, builder.setName("test_column")); //$NON-NLS-1$
        assertSame(builder, builder.setType(SqliteStorageClass.INTEGER));
        assertSame(builder, builder.setConstraintSet("0", "1")); //$NON-NLS-1$//$NON-NLS-2$

        assertEquals("test_column INTEGER CHECK(test_column IN(\"0\", \"1\"))",
                builder.build()); //$NON-NLS-1$
    }
}
Java Source Code List
