Android Open Source - android-sqlite-helper Select Test






From Project

Back to project page android-sqlite-helper.

License

The source code is released under:

Apache License

If you think the Android project android-sqlite-helper 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

package net.ichigotake.sqlitehelper.dml;
//ww  w .j  a v  a2s .c om
import android.database.sqlite.SQLiteDatabase;

import junit.framework.Assert;

import net.ichigotake.sqlitehelper.DatabaseHelper;
import net.ichigotake.sqlitehelper.MockConfiguration;
import net.ichigotake.sqlitehelper.MockTable;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.robolectric.Robolectric;
import org.robolectric.RobolectricTestRunner;
import org.robolectric.annotation.Config;

@Config(emulateSdk = 18)
@RunWith(RobolectricTestRunner.class)
public class SelectTest {
    
    private SQLiteDatabase database() {
        return new DatabaseHelper(Robolectric.application, new MockConfiguration())
                .getReadableDatabase();
    }

    @Test
    public void testOrder() {
        {
            String expected = "SELECT * FROM mock";
            String got = new Select(database(), new MockTable()).buildQuery();
            Assert.assertEquals(expected, got);
        }
        {
            String expected = "SELECT * FROM mock ORDER BY _id ASC";
            String got = new Select(database(), new MockTable())
                    .orderBy(new Order(MockTable.Field.ID))
                    .buildQuery();
            Assert.assertEquals(expected, got);
        }
        {
            String expected = "SELECT * FROM mock ORDER BY _id ASC";
            String got = new Select(database(), new MockTable())
                    .orderBy(new Order(MockTable.Field.ID, Order.Sequence.ASC))
                    .buildQuery();
            Assert.assertEquals(expected, got);
        }
        {
            String expected = "SELECT * FROM mock ORDER BY _id DESC";
            String got = new Select(database(), new MockTable())
                    .orderBy(new Order(MockTable.Field.ID, Order.Sequence.DESC))
                    .buildQuery();
            Assert.assertEquals(expected, got);
        }
    }

    @Test
    public void textBuildQuery() {
        Select query = new Select(database(), new MockTable());
        {
            String expected = "SELECT * FROM mock";
            Assert.assertEquals(expected, query.buildQuery());
        }
        {
            String expected = "SELECT * FROM mock ORDER BY _id DESC";
            query.orderBy(new Order(MockTable.Field.ID, Order.Sequence.DESC));
            Assert.assertEquals(expected, query.buildQuery());
        }
        {
            String expected = "SELECT * FROM mock ORDER BY _id DESC";
            query.where(new Where()).buildQuery();
            Assert.assertEquals(expected, query.buildQuery());
        }
        {
            String expected = "SELECT * FROM mock WHERE ((_id = ?)) ORDER BY _id DESC";
            String condition = MockTable.Field.ID.getFieldName() + " = ?";
            query.where(new Where(condition, 1));
            Assert.assertEquals(expected, query.buildQuery());
        }
    }
}




Java Source Code List

net.ichigotake.sqlitehelper.Configuration.java
net.ichigotake.sqlitehelper.DatabaseHelperTest.java
net.ichigotake.sqlitehelper.DatabaseHelper.java
net.ichigotake.sqlitehelper.MigrationCallback.java
net.ichigotake.sqlitehelper.MigrationHelper.java
net.ichigotake.sqlitehelper.MockConfiguration.java
net.ichigotake.sqlitehelper.MockTable.java
net.ichigotake.sqlitehelper.NoMigrationCallback.java
net.ichigotake.sqlitehelper.TableCursor.java
net.ichigotake.sqlitehelper.ddl.AlterTableTest.java
net.ichigotake.sqlitehelper.ddl.AlterTable.java
net.ichigotake.sqlitehelper.ddl.CreateIndexTest.java
net.ichigotake.sqlitehelper.ddl.CreateIndex.java
net.ichigotake.sqlitehelper.ddl.CreateTableTest.java
net.ichigotake.sqlitehelper.ddl.CreateTable.java
net.ichigotake.sqlitehelper.dml.Order.java
net.ichigotake.sqlitehelper.dml.SelectTest.java
net.ichigotake.sqlitehelper.dml.Select.java
net.ichigotake.sqlitehelper.dml.WhereTest.java
net.ichigotake.sqlitehelper.dml.Where.java
net.ichigotake.sqlitehelper.schema.DeletableTable.java
net.ichigotake.sqlitehelper.schema.FieldAttribute.java
net.ichigotake.sqlitehelper.schema.Index.java
net.ichigotake.sqlitehelper.schema.InsertableTable.java
net.ichigotake.sqlitehelper.schema.TableFieldType.java
net.ichigotake.sqlitehelper.schema.TableField.java
net.ichigotake.sqlitehelper.schema.TableSchemaBuilder.java
net.ichigotake.sqlitehelper.schema.TableSchema.java
net.ichigotake.sqlitehelper.schema.Table.java
net.ichigotake.sqlitehelper.schema.UniqueField.java
net.ichigotake.sqlitehelper.schema.UpdatableTable.java