Back to project page android-sqlite-helper.
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.
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()); } } }