1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
|
package com.xtremelabs.robolectric.util;
import android.content.ContentValues;
import android.database.sqlite.SQLiteDatabase;
import com.xtremelabs.robolectric.WithTestDefaultsRunner;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import static com.xtremelabs.robolectric.util.SQLite.*;
import static org.hamcrest.CoreMatchers.equalTo;
import static org.junit.Assert.assertThat;
@RunWith(WithTestDefaultsRunner.class)
public class SQLite_Test {
ContentValues values;
@Before
public void setUp() throws Exception {
String byteString = "byte_string";
byte[] byteData = byteString.getBytes();
values = new ContentValues();
values.put("name", "Chuck");
values.put("int_value", 33);
values.put("float_value", (float) 1.5);
values.put("byte_data", byteData);
}
@Test
public void testBuildInsertString() throws Exception {
SQLite.SQLStringAndBindings insertString = buildInsertString("table_name", values, SQLiteDatabase.CONFLICT_NONE);
assertThat(insertString.sql, equalTo("INSERT INTO table_name (float_value, byte_data, name, int_value) VALUES (?, ?, ?, ?);"));
SQLiteTestHelper.verifyColumnValues(insertString.columnValues);
}
@Test
public void testBuildUpdateString() {
SQLite.SQLStringAndBindings insertString = buildUpdateString("table_name", values, "id=?", new String[]{"1234"});
assertThat(insertString.sql, equalTo("UPDATE table_name SET float_value=?, byte_data=?, name=?, int_value=? WHERE id='1234';"));
SQLiteTestHelper.verifyColumnValues(insertString.columnValues);
}
@Test
public void testBuildDeleteString() {
String deleteString = buildDeleteString("table_name", "id=?", new String[]{"1234"});
assertThat(deleteString, equalTo("DELETE FROM table_name WHERE id='1234';"));
}
@Test
public void testBuildWhereClause() {
String whereClause = buildWhereClause("id=? AND name=? AND int_value=?", new String[]{"1234", "Chuck", "33"});
assertThat(whereClause, equalTo("id='1234' AND name='Chuck' AND int_value='33'"));
}
@Test
public void testBuildColumnValuesClause() {
SQLStringAndBindings columnValuesClause = buildColumnValuesClause(values);
assertThat(columnValuesClause.sql, equalTo("(float_value, byte_data, name, int_value) VALUES (?, ?, ?, ?)"));
SQLiteTestHelper.verifyColumnValues(columnValuesClause.columnValues);
}
@Test
public void testBuildColumnAssignmentsClause() {
SQLStringAndBindings columnAssignmentsClause = buildColumnAssignmentsClause(values);
assertThat(columnAssignmentsClause.sql, equalTo("float_value=?, byte_data=?, name=?, int_value=?"));
SQLiteTestHelper.verifyColumnValues(columnAssignmentsClause.columnValues);
}
}
|
