-
Notifications
You must be signed in to change notification settings - Fork 2
Expand file tree
/
Copy pathGitRepositoryDatabase.java
More file actions
216 lines (196 loc) · 7.21 KB
/
Copy pathGitRepositoryDatabase.java
File metadata and controls
216 lines (196 loc) · 7.21 KB
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
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
package com.example.git;
import java.util.Date;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.List;
import java.util.Locale;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
import android.widget.Toast;
/**
* This class handles the storage of the different repositories links.
*/
public final class GitRepositoryDatabase extends SQLiteOpenHelper {
/**
* The tag is used to identify the class while logging.
*/
private final String LOGTAG = getClass().getName();
/**
* Date format used for dates that should be stored within this database.
*/
public final static SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss", Locale.US);
/**
* This is the single instance that is created of this class.
*/
private static GitRepositoryDatabase gitRepositoryDatabaseInstance;
/**
* The Context to access Android related resources.
*/
private static Context currentContext;
/**
* The name of the database that will be created.
*/
private static final String DATABASE_NAME = "Git4Android";
/**
* The version of the database.
*/
private static final int DATABASE_VERSION = 1;
/**
* The name of the table that will be created.
*/
private static final String TABLE_NAME = "Repositories";
/**
* The table that will hold the repositories paths and other attributes.
*/
private static final String TABLE_CREATE = "CREATE TABLE " + TABLE_NAME + " (repoPath VARCHAR UNIQUE NOT NULL, name VARCHAR, date VARCHAR);";
/**
* Creates a new GitRepositoryDatabase
* @param newContext The android context that should be used within this class.
*/
private GitRepositoryDatabase(Context newContext) {
super(newContext, DATABASE_NAME, null, DATABASE_VERSION);
currentContext = newContext;
}
/**
* Returns a new or an already available instance of the GitRepositoryDatabase class.
* @param context The android context that should be used within this class.
* @return The instance.
*/
public synchronized static GitRepositoryDatabase getInstance(Context context) {
if (gitRepositoryDatabaseInstance == null) {
gitRepositoryDatabaseInstance = new GitRepositoryDatabase(context.getApplicationContext());
}
return gitRepositoryDatabaseInstance;
}
@Override
/**
* Called when the database is created for the first time. This is where the creation of tables happens.
* @param database The database.
*/
public void onCreate(SQLiteDatabase database) {
if(database.isOpen()){
try {
database.execSQL(TABLE_CREATE);
} catch (SQLiteException exception) {
Log.d(LOGTAG, currentContext.getResources().getString(R.string.table_create_failed));
exception.printStackTrace();
}
} else {
Log.d(LOGTAG, currentContext.getResources().getString(R.string.database_not_open));
}
}
@Override
/**
* Called when the database needs to be upgraded.
* @param database The database.
* @param oldVersion The old database version.
* @param newVersion The new database version.
*/
public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {
// no update necessary so far
}
/**
* Adds an link to a Git repository to the database.
* @param path The path to the Git repository.
* @param name The name for this Git repository.
* @return True if the action went successfully, otherwise false.
*/
public boolean addGitRepositoryLink(String path, String name) {
Date date = new Date();
return addGitRepositoryLink(path, name, date);
}
/**
* Adds an link to a Git repository to the database.
* @param path The path to the Git repository.
* @param name The name for this Git repository.
* @param date The date that should be stored.
* @return True if the action went successfully, otherwise false.
*/
public boolean addGitRepositoryLink(String path, String name, Date date) {
boolean added = false;
try {
SQLiteDatabase database = getWritableDatabase();
if (database.isOpen()) {
database.execSQL("INSERT INTO " + TABLE_NAME + " ('repoPath', 'name', 'date') VALUES ('" + path + "', '" + name + "', '" + dateFormat.format(date) + "');");
database.close();
added = true;
} else {
Log.e(LOGTAG, currentContext.getResources().getString(R.string.cant_open_database));
}
} catch (SQLiteException exception) {
Log.e(LOGTAG, currentContext.getResources().getString(R.string.sql_insert_git_repo_link_entry_invalid));
exception.printStackTrace();
}
return added;
}
/**
* Removes a given path of a Git repository from the database.
* @param path The path to a Git repository that will be removed.
* @return True if the remove action went successfully, otherwise false.
*/
public boolean removeGitRepositoryLink(String path) {
boolean removed = false;
try {
SQLiteDatabase database = getWritableDatabase();
if (database.isOpen()) {
database.execSQL("DELETE FROM " + TABLE_NAME + " WHERE repoPath = '" + path + "';");
database.close();
removed = true;
} else {
Log.e(LOGTAG, currentContext.getResources().getString(R.string.cant_open_database));
}
} catch (SQLiteException exception) {
Log.e(LOGTAG, currentContext.getResources().getString(R.string.sql_remove_gitrepo_link_entryinvalid));
exception.printStackTrace();
}
return removed;
}
/**
* Loads all links to Git repositories and there additional data.
* @return The data of the Git repositories path, name and date per ArrayList entry.
*/
public ArrayList<List<String>> loadGitRepositoriyLinks() {
ArrayList<List<String>> resultList = new ArrayList<List<String>>();
try {
SQLiteDatabase database = getWritableDatabase();
if (database.isOpen()) {
final String[] columns = new String[]{"repoPath", "name", "date"};
resultList = loadStringsFromDataBaseTable(database, TABLE_NAME, columns);
database.close();
} else {
Log.d(LOGTAG, currentContext.getResources().getString(R.string.cant_open_database));
ToastNotification.makeToast(currentContext.getResources().getString(R.string.cant_open_database), Toast.LENGTH_LONG, currentContext);
}
} catch (SQLiteException exception) {
Log.e(LOGTAG, currentContext.getResources().getString(R.string.database_cannot_opened_for_writing));
exception.printStackTrace();
}
return resultList;
}
/**
* Queries the data from specific columns of an SQLite database table and
* writes them as string in the resultList.
* @param database The database where the data be queried
* @param table The table where the data will be queried
* @param columns The columns of the table where the data will be queried
*/
private ArrayList<List<String>> loadStringsFromDataBaseTable(SQLiteDatabase database, String table, String[] columns) {
ArrayList<List<String>> resultList = new ArrayList<List<String>>();
Cursor cursor = database.query(table, columns, null, null, null, null, null);
if (cursor != null) {
while(cursor.moveToNext()) {
List<String> row = new ArrayList<String>();
for (int i = 0; i < columns.length; i++) {
row.add(new String(cursor.getString(i)));
}
resultList.add(row);
}
cursor.close();
}
return resultList;
}
}