1 |
|
package com.loopback.androidapps.saveapp; |
2 |
|
|
3 |
|
import java.util.ArrayList; |
4 |
|
|
5 |
|
import android.content.ContentValues; |
6 |
|
import android.database.Cursor; |
7 |
|
import android.util.Log; |
8 |
|
|
|
|
| 78,9% |
Uncovered Elements: 23 (109) |
Complexity: 28 |
Complexity Density: 0,37 |
|
9 |
|
public class Account implements SaveAppTable { |
10 |
|
|
11 |
|
private static DBManager dbManager; |
12 |
|
private int id; |
13 |
|
private String description; |
14 |
|
private String startDate; |
15 |
|
private String endDate; |
16 |
|
private int budget; |
17 |
|
private String period; |
18 |
|
private int currencyId; |
19 |
|
private Cursor cursor; |
20 |
|
public static SaveApp saveApp; |
21 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (8) |
Complexity: 1 |
Complexity Density: 0,12 |
|
22 |
18
|
public Account() {... |
23 |
18
|
dbManager = saveApp.getDbManager(); |
24 |
18
|
description = null; |
25 |
18
|
id = 0; |
26 |
18
|
startDate = null; |
27 |
18
|
endDate = null; |
28 |
18
|
budget = 0; |
29 |
18
|
period = null; |
30 |
18
|
currencyId = 0; |
31 |
|
} |
|
|
| 100% |
Uncovered Elements: 0 (9) |
Complexity: 1 |
Complexity Density: 0,11 |
|
32 |
5
|
public Account(int _id) {... |
33 |
5
|
dbManager = saveApp.getDbManager(); |
34 |
5
|
description = null; |
35 |
5
|
id = _id; |
36 |
5
|
startDate = null; |
37 |
5
|
endDate = null; |
38 |
5
|
budget = 0; |
39 |
5
|
period = null; |
40 |
5
|
currencyId = 0; |
41 |
5
|
inflate(id); |
42 |
|
} |
43 |
|
|
|
|
| 0% |
Uncovered Elements: 1 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
44 |
0
|
public void setId(int id) {... |
45 |
0
|
this.id = id; |
46 |
|
} |
47 |
|
|
|
|
| 0% |
Uncovered Elements: 1 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
48 |
0
|
public int getId() {... |
49 |
0
|
return id; |
50 |
|
} |
51 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
52 |
1
|
public void setDescription(String description) {... |
53 |
1
|
this.description = description; |
54 |
|
} |
55 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
56 |
11
|
public String getDescription() {... |
57 |
11
|
return description; |
58 |
|
} |
59 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
60 |
1
|
public void setBudget(int budget) {... |
61 |
1
|
this.budget = budget; |
62 |
|
} |
63 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
64 |
13
|
public int getBudget() {... |
65 |
13
|
return budget; |
66 |
|
} |
67 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
68 |
1
|
public void setPeriod(String period) {... |
69 |
1
|
this.period = period; |
70 |
|
} |
71 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
72 |
5
|
public String getPeriod() {... |
73 |
5
|
return period; |
74 |
|
} |
75 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
76 |
3
|
public void setStartDate(String startDate) {... |
77 |
3
|
this.startDate = startDate; |
78 |
|
} |
79 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
80 |
24
|
public String getStartDate() {... |
81 |
24
|
return startDate; |
82 |
|
} |
83 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
84 |
3
|
public void setEndDate(String endDate) {... |
85 |
3
|
this.endDate = endDate; |
86 |
|
} |
87 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
88 |
8
|
public String getEndDate() {... |
89 |
8
|
return endDate; |
90 |
|
} |
91 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
92 |
1
|
public void setCurrencyId(int currencyId) {... |
93 |
1
|
this.currencyId = currencyId; |
94 |
|
} |
95 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
96 |
9
|
public int getCurrencyId() {... |
97 |
9
|
return currencyId; |
98 |
|
} |
99 |
|
|
|
|
| 0% |
Uncovered Elements: 8 (8) |
Complexity: 1 |
Complexity Density: 0,12 |
|
100 |
0
|
public int insert() {... |
101 |
|
|
102 |
0
|
ContentValues cv = new ContentValues(); |
103 |
0
|
cv.put(DBManager.ACCOUNT_COLUMN_BUDGET, budget); |
104 |
0
|
cv.put(DBManager.ACCOUNT_COLUMN_PERIOD, period); |
105 |
0
|
cv.put(DBManager.ACCOUNT_COLUMN_DESC, description); |
106 |
0
|
cv.put(DBManager.ACCOUNT_COLUMN_START_DATE, startDate); |
107 |
0
|
cv.put(DBManager.ACCOUNT_COLUMN_END_DATE, endDate); |
108 |
0
|
cv.put(DBManager.ACCOUNT_COLUMN_DESC, currencyId); |
109 |
0
|
return dbManager.insert(DBManager.ACCOUNT_TABLE, cv); |
110 |
|
} |
111 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (8) |
Complexity: 1 |
Complexity Density: 0,12 |
|
112 |
1
|
public void update() {... |
113 |
1
|
ContentValues cv = new ContentValues(); |
114 |
1
|
cv.put(DBManager.ACCOUNT_COLUMN_BUDGET, budget); |
115 |
1
|
cv.put(DBManager.ACCOUNT_COLUMN_PERIOD, period); |
116 |
1
|
cv.put(DBManager.ACCOUNT_COLUMN_DESC, description); |
117 |
1
|
cv.put(DBManager.ACCOUNT_COLUMN_START_DATE, startDate); |
118 |
1
|
cv.put(DBManager.ACCOUNT_COLUMN_END_DATE, endDate); |
119 |
1
|
cv.put(DBManager.ACCOUNT_COLUMN_CURRENCY, currencyId); |
120 |
1
|
dbManager.update(id, DBManager.ACCOUNT_TABLE, cv); |
121 |
|
} |
122 |
|
|
|
|
| 0% |
Uncovered Elements: 1 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
123 |
0
|
public void delete() {... |
124 |
0
|
dbManager.delete(id, DBManager.ACCOUNT_TABLE); |
125 |
|
} |
126 |
|
|
|
|
| 88,2% |
Uncovered Elements: 2 (17) |
Complexity: 3 |
Complexity Density: 0,23 |
|
127 |
21
|
public void inflate(int _id) {... |
128 |
21
|
id=_id; |
129 |
21
|
cursor = dbManager.select(id, DBManager.ACCOUNT_TABLE_ID); |
130 |
21
|
int i = 0; |
131 |
21
|
Log.i("AC", "Read Cursor"); |
132 |
21
|
if (cursor.moveToFirst()) |
133 |
21
|
do { |
134 |
21
|
description = cursor.getString(cursor |
135 |
|
.getColumnIndexOrThrow(DBManager.ACCOUNT_COLUMN_DESC)); |
136 |
21
|
startDate = cursor |
137 |
|
.getString(cursor |
138 |
|
.getColumnIndexOrThrow(DBManager.ACCOUNT_COLUMN_START_DATE)); |
139 |
21
|
endDate = cursor |
140 |
|
.getString(cursor |
141 |
|
.getColumnIndexOrThrow(DBManager.ACCOUNT_COLUMN_END_DATE)); |
142 |
21
|
budget = Utilities.stringToInt(cursor.getString(cursor |
143 |
|
.getColumnIndexOrThrow(DBManager.ACCOUNT_COLUMN_BUDGET))); |
144 |
21
|
period = cursor |
145 |
|
.getString(cursor |
146 |
|
.getColumnIndexOrThrow(DBManager.ACCOUNT_COLUMN_PERIOD)); |
147 |
21
|
currencyId = Utilities.stringToInt(cursor.getString(cursor |
148 |
|
.getColumnIndexOrThrow(DBManager.ACCOUNT_COLUMN_CURRENCY))); |
149 |
21
|
i++; |
150 |
21
|
} while (cursor.moveToNext()); |
151 |
|
} |
152 |
|
|
|
|
| 0% |
Uncovered Elements: 1 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
153 |
0
|
public boolean existId(String value) {... |
154 |
0
|
return dbManager.exist(DBManager.ACCOUNT_TABLE, |
155 |
|
DBManager.KEY_ID, value); |
156 |
|
} |
157 |
|
|
|
|
| 0% |
Uncovered Elements: 1 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
158 |
0
|
public boolean existDescription(String value) {... |
159 |
0
|
return dbManager.exist(DBManager.ACCOUNT_TABLE, |
160 |
|
DBManager.ACCOUNT_COLUMN_DESC, value); |
161 |
|
} |
162 |
|
|
|
|
| 89,5% |
Uncovered Elements: 2 (19) |
Complexity: 4 |
Complexity Density: 0,31 |
|
163 |
2
|
public CharSequence[] selectAccounts() {... |
164 |
2
|
ArrayList<String> accounts = new ArrayList<String>(); |
165 |
2
|
cursor = dbManager.selectFilter(DBManager.ACCOUNT_TABLE,DBManager.ACCOUNT_COLUMN_DESC,1,"1"); |
166 |
2
|
int i = 0; |
167 |
2
|
Log.i("AC", "Read Cursor"); |
168 |
2
|
if (cursor.moveToFirst()) |
169 |
2
|
do { |
170 |
2
|
description = cursor.getString(cursor |
171 |
|
.getColumnIndexOrThrow(DBManager.ACCOUNT_COLUMN_DESC)); |
172 |
2
|
accounts.add(description); |
173 |
2
|
i++; |
174 |
2
|
} while (cursor.moveToNext()); |
175 |
2
|
CharSequence[] accountsChars = new CharSequence[accounts.size()]; |
176 |
4
|
for (int j = 0; j< accounts.size();j++) { |
177 |
2
|
accountsChars[j]=accounts.get(j); |
178 |
|
} |
179 |
|
|
180 |
2
|
return accountsChars; |
181 |
|
} |
182 |
|
|
183 |
|
} |