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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
|
package it.niedermann.nextcloud.deck.persistence.sync.adapters.db;
import android.content.Context;
import android.os.Build;
import androidx.room.Room;
import androidx.test.core.app.ApplicationProvider;
import com.google.common.util.concurrent.MoreExecutors;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.robolectric.RobolectricTestRunner;
import org.robolectric.annotation.Config;
import java.lang.reflect.Constructor;
import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
import java.lang.reflect.Modifier;
import java.util.ArrayList;
import java.util.List;
import java.util.concurrent.ExecutorService;
import it.niedermann.nextcloud.deck.model.Account;
import it.niedermann.nextcloud.deck.model.Board;
import it.niedermann.nextcloud.deck.model.User;
import it.niedermann.nextcloud.deck.model.full.FullBoard;
import it.niedermann.nextcloud.deck.model.interfaces.AbstractRemoteEntity;
import it.niedermann.nextcloud.deck.model.interfaces.IRemoteEntity;
import static it.niedermann.nextcloud.deck.persistence.sync.adapters.db.DeckDatabaseTestUtil.createAccount;
import static it.niedermann.nextcloud.deck.persistence.sync.adapters.db.DeckDatabaseTestUtil.createBoard;
import static it.niedermann.nextcloud.deck.persistence.sync.adapters.db.DeckDatabaseTestUtil.createUser;
import static org.junit.Assert.assertEquals;
@RunWith(RobolectricTestRunner.class)
@Config(sdk = {Build.VERSION_CODES.P})
public class DataBaseAdapterTest {
private DeckDatabase db;
private DataBaseAdapter adapter;
@Before
public void createAdapter() throws NoSuchMethodException, IllegalAccessException, InvocationTargetException, InstantiationException {
final Constructor<DataBaseAdapter> constructor = DataBaseAdapter.class.getDeclaredConstructor(Context.class, DeckDatabase.class, ExecutorService.class);
if (Modifier.isPrivate(constructor.getModifiers())) {
constructor.setAccessible(true);
db = Room
.inMemoryDatabaseBuilder(ApplicationProvider.getApplicationContext(), DeckDatabase.class)
.allowMainThreadQueries()
.build();
adapter = constructor.newInstance(ApplicationProvider.getApplicationContext(), db, MoreExecutors.newDirectExecutorService());
}
}
@After
public void closeDb() {
if (db != null) {
db.close();
}
}
@Test
public void testCreate() {
final Account account = createAccount(db.getAccountDao());
final User user = createUser(db.getUserDao(), account);
final Board board = createBoard(db.getBoardDao(), account, user);
final FullBoard fetchedBoard = adapter.getFullBoardByLocalIdDirectly(account.getId(), board.getLocalId());
assertEquals(board.getTitle(), fetchedBoard.getBoard().getTitle());
}
@Test
public void testFillSqlWithEntityListValues() throws NoSuchMethodException, InvocationTargetException, IllegalAccessException {
final User user = createUser(db.getUserDao(), createAccount(db.getAccountDao()));
final StringBuilder builder = new StringBuilder();
final List<Object> args = new ArrayList<>(1);
final List<? extends AbstractRemoteEntity> entities = new ArrayList<AbstractRemoteEntity>(1) {{
add(user);
}};
final Method fillSqlWithListValues = DataBaseAdapter.class.getDeclaredMethod("fillSqlWithListValues", StringBuilder.class, List.class, List.class);
fillSqlWithListValues.setAccessible(true);
fillSqlWithListValues.invoke(adapter, builder, args, entities);
assertEquals("?", builder.toString());
assertEquals(user.getLocalId(), ((IRemoteEntity)args.get(0)).getLocalId());
}
@Test
public void testFillSqlWithListValues() throws NoSuchMethodException, InvocationTargetException, IllegalAccessException {
final User user = createUser(db.getUserDao(), createAccount(db.getAccountDao()));
final StringBuilder builder = new StringBuilder();
final List<Object> args = new ArrayList<>(1);
final Long leet = 1337L;
final List<?> entities = new ArrayList<Long>(1) {{
add(leet);
}};
final Method fillSqlWithListValues = DataBaseAdapter.class.getDeclaredMethod("fillSqlWithListValues", StringBuilder.class, List.class, List.class);
fillSqlWithListValues.setAccessible(true);
fillSqlWithListValues.invoke(adapter, builder, args, entities);
assertEquals("?", builder.toString());
assertEquals(leet, args.get(0));
}
@Test
public void testFillSqlWithMultipleListValues() throws NoSuchMethodException, InvocationTargetException, IllegalAccessException {
final User user = createUser(db.getUserDao(), createAccount(db.getAccountDao()));
final StringBuilder builder = new StringBuilder();
final List<Object> args = new ArrayList<>(2);
final Long leet = 1337L;
final List<?> entities = new ArrayList<Long>(2) {{
add(leet);
add(leet+1);
}};
final Method fillSqlWithListValues = DataBaseAdapter.class.getDeclaredMethod("fillSqlWithListValues", StringBuilder.class, List.class, List.class);
fillSqlWithListValues.setAccessible(true);
fillSqlWithListValues.invoke(adapter, builder, args, entities);
assertEquals("?, ?", builder.toString());
assertEquals(leet, args.get(0));
assertEquals(leet+1, args.get(1));
}
}
|