Mercurial > 510Connectbot
annotate src/com/five_ten_sg/connectbot/util/HostDatabase.java @ 74:1aff8d06d5ef tn5250
makefile typo
author | Carl Byington <carl@five-ten-sg.com> |
---|---|
date | Sat, 14 Jun 2014 09:04:35 -0700 |
parents | 07c7055cc124 |
children | 446dbcf606eb |
rev | line source |
---|---|
0 | 1 /* |
2 * ConnectBot: simple, powerful, open-source SSH client for Android | |
3 * Copyright 2007 Kenny Root, Jeffrey Sharkey | |
4 * | |
5 * Licensed under the Apache License, Version 2.0 (the "License"); | |
6 * you may not use this file except in compliance with the License. | |
7 * You may obtain a copy of the License at | |
8 * | |
9 * http://www.apache.org/licenses/LICENSE-2.0 | |
10 * | |
11 * Unless required by applicable law or agreed to in writing, software | |
12 * distributed under the License is distributed on an "AS IS" BASIS, | |
13 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. | |
14 * See the License for the specific language governing permissions and | |
15 * limitations under the License. | |
16 */ | |
17 | |
18 package com.five_ten_sg.connectbot.util; | |
19 | |
20 import java.nio.charset.Charset; | |
21 import java.util.Iterator; | |
22 import java.util.LinkedList; | |
23 import java.util.List; | |
24 import java.util.Map; | |
25 import java.util.Map.Entry; | |
26 | |
27 import com.five_ten_sg.connectbot.bean.HostBean; | |
28 import com.five_ten_sg.connectbot.bean.PortForwardBean; | |
29 import android.content.ContentValues; | |
30 import android.content.Context; | |
31 import android.database.Cursor; | |
32 import android.database.sqlite.SQLiteDatabase; | |
33 import android.database.sqlite.SQLiteException; | |
34 import android.util.Log; | |
35 | |
36 import com.trilead.ssh2.KnownHosts; | |
37 | |
38 /** | |
39 * Contains information about various SSH hosts, include public hostkey if known | |
40 * from previous sessions. | |
41 * | |
42 * @author jsharkey | |
43 */ | |
44 public class HostDatabase extends RobustSQLiteOpenHelper { | |
45 | |
46 public final static String TAG = "ConnectBot.HostDatabase"; | |
47 | |
48 public final static String DB_NAME = "hosts"; | |
62
aac8e0496ef9
add 5250 config entries
Carl Byington <carl@five-ten-sg.com>
parents:
61
diff
changeset
|
49 public final static int DB_VERSION = 26; |
0 | 50 |
51 public final static String TABLE_HOSTS = "hosts"; | |
52 public final static String FIELD_HOST_NICKNAME = "nickname"; | |
53 public final static String FIELD_HOST_PROTOCOL = "protocol"; | |
54 public final static String FIELD_HOST_USERNAME = "username"; | |
55 public final static String FIELD_HOST_HOSTNAME = "hostname"; | |
56 public final static String FIELD_HOST_PORT = "port"; | |
57 public final static String FIELD_HOST_HOSTKEYALGO = "hostkeyalgo"; | |
58 public final static String FIELD_HOST_HOSTKEY = "hostkey"; | |
59 public final static String FIELD_HOST_LASTCONNECT = "lastconnect"; | |
60 public final static String FIELD_HOST_COLOR = "color"; | |
61 public final static String FIELD_HOST_USEKEYS = "usekeys"; | |
62 public final static String FIELD_HOST_USEAUTHAGENT = "useauthagent"; | |
63 public final static String FIELD_HOST_POSTLOGIN = "postlogin"; | |
64 public final static String FIELD_HOST_PUBKEYID = "pubkeyid"; | |
65 public final static String FIELD_HOST_WANTSESSION = "wantsession"; | |
66 public final static String FIELD_HOST_DELKEY = "delkey"; | |
67 public final static String FIELD_HOST_FONTSIZE = "fontsize"; | |
68 public final static String FIELD_HOST_COMPRESSION = "compression"; | |
69 public final static String FIELD_HOST_HTTPPROXY = "httpproxy"; | |
70 public final static String FIELD_HOST_ENCODING = "encoding"; | |
71 public final static String FIELD_HOST_STAYCONNECTED = "stayconnected"; | |
72 public final static String FIELD_HOST_WANTX11FORWARD = "wantx11forward"; | |
73 public final static String FIELD_HOST_X11HOST = "x11host"; | |
74 public final static String FIELD_HOST_X11PORT = "x11port"; | |
75 public final static String FIELD_HOST_MONITOR = "monitor"; | |
61 | 76 public final static String FIELD_HOST_EMULATION = "emulation"; |
77 public final static String FIELD_HOST_ENCRYPTION5250 = "encryption5250"; | |
0 | 78 |
79 public final static String TABLE_PORTFORWARDS = "portforwards"; | |
80 public final static String FIELD_PORTFORWARD_HOSTID = "hostid"; | |
81 public final static String FIELD_PORTFORWARD_NICKNAME = "nickname"; | |
82 public final static String FIELD_PORTFORWARD_TYPE = "type"; | |
83 public final static String FIELD_PORTFORWARD_SOURCEPORT = "sourceport"; | |
84 public final static String FIELD_PORTFORWARD_DESTADDR = "destaddr"; | |
85 public final static String FIELD_PORTFORWARD_DESTPORT = "destport"; | |
86 | |
87 public final static String TABLE_COLORS = "colors"; | |
88 public final static String FIELD_COLOR_SCHEME = "scheme"; | |
89 public final static String FIELD_COLOR_NUMBER = "number"; | |
90 public final static String FIELD_COLOR_VALUE = "value"; | |
91 | |
92 public final static String TABLE_COLOR_DEFAULTS = "colorDefaults"; | |
93 public final static String FIELD_COLOR_FG = "fg"; | |
94 public final static String FIELD_COLOR_BG = "bg"; | |
95 | |
96 public final static int DEFAULT_FG_COLOR = 7; | |
97 public final static int DEFAULT_BG_COLOR = 0; | |
98 | |
99 public final static String COLOR_RED = "red"; | |
100 public final static String COLOR_GREEN = "green"; | |
101 public final static String COLOR_BLUE = "blue"; | |
102 public final static String COLOR_GRAY = "gray"; | |
103 | |
104 public final static String PORTFORWARD_LOCAL = "local"; | |
105 public final static String PORTFORWARD_REMOTE = "remote"; | |
106 public final static String PORTFORWARD_DYNAMIC4 = "dynamic4"; | |
107 public final static String PORTFORWARD_DYNAMIC5 = "dynamic5"; | |
108 | |
109 public final static String DELKEY_DEL = "del"; | |
110 public final static String DELKEY_BACKSPACE = "backspace"; | |
111 | |
112 public final static String AUTHAGENT_NO = "no"; | |
113 public final static String AUTHAGENT_CONFIRM = "confirm"; | |
114 public final static String AUTHAGENT_YES = "yes"; | |
115 | |
116 public final static String ENCODING_DEFAULT = Charset.defaultCharset().name(); | |
117 | |
118 public final static String X11HOST_DEFAULT = "localhost"; | |
119 public final static int X11PORT_DEFAULT = 6000; | |
120 | |
121 public final static long PUBKEYID_NEVER = -2; | |
122 public final static long PUBKEYID_ANY = -1; | |
123 | |
124 public static final int DEFAULT_COLOR_SCHEME = 0; | |
125 | |
126 // Table creation strings | |
127 public static final String CREATE_TABLE_COLOR_DEFAULTS = | |
128 "CREATE TABLE " + TABLE_COLOR_DEFAULTS | |
129 + " (" + FIELD_COLOR_SCHEME + " INTEGER NOT NULL, " | |
130 + FIELD_COLOR_FG + " INTEGER NOT NULL DEFAULT " + DEFAULT_FG_COLOR + ", " | |
131 + FIELD_COLOR_BG + " INTEGER NOT NULL DEFAULT " + DEFAULT_BG_COLOR + ")"; | |
132 public static final String CREATE_TABLE_COLOR_DEFAULTS_INDEX = | |
133 "CREATE INDEX " + TABLE_COLOR_DEFAULTS + FIELD_COLOR_SCHEME + "index ON " | |
134 + TABLE_COLOR_DEFAULTS + " (" + FIELD_COLOR_SCHEME + ");"; | |
135 | |
136 private static final String WHERE_SCHEME_AND_COLOR = FIELD_COLOR_SCHEME + " = ? AND " | |
137 + FIELD_COLOR_NUMBER + " = ?"; | |
138 | |
139 static { | |
140 addTableName(TABLE_HOSTS); | |
141 addTableName(TABLE_PORTFORWARDS); | |
142 addIndexName(TABLE_PORTFORWARDS + FIELD_PORTFORWARD_HOSTID + "index"); | |
143 addTableName(TABLE_COLORS); | |
144 addIndexName(TABLE_COLORS + FIELD_COLOR_SCHEME + "index"); | |
145 addTableName(TABLE_COLOR_DEFAULTS); | |
146 addIndexName(TABLE_COLOR_DEFAULTS + FIELD_COLOR_SCHEME + "index"); | |
147 } | |
148 | |
149 public static final Object[] dbLock = new Object[0]; | |
150 | |
151 public HostDatabase(Context context) { | |
152 super(context, DB_NAME, null, DB_VERSION); | |
153 getWritableDatabase().close(); | |
154 } | |
155 | |
156 @Override | |
157 public void onCreate(SQLiteDatabase db) { | |
158 super.onCreate(db); | |
159 db.execSQL("CREATE TABLE " + TABLE_HOSTS | |
160 + " (_id INTEGER PRIMARY KEY, " | |
161 + FIELD_HOST_NICKNAME + " TEXT, " | |
162 + FIELD_HOST_PROTOCOL + " TEXT DEFAULT 'ssh', " | |
163 + FIELD_HOST_USERNAME + " TEXT, " | |
164 + FIELD_HOST_HOSTNAME + " TEXT, " | |
165 + FIELD_HOST_PORT + " INTEGER, " | |
166 + FIELD_HOST_HOSTKEYALGO + " TEXT, " | |
167 + FIELD_HOST_HOSTKEY + " BLOB, " | |
168 + FIELD_HOST_LASTCONNECT + " INTEGER, " | |
169 + FIELD_HOST_COLOR + " TEXT, " | |
170 + FIELD_HOST_USEKEYS + " TEXT, " | |
171 + FIELD_HOST_USEAUTHAGENT + " TEXT, " | |
172 + FIELD_HOST_POSTLOGIN + " TEXT, " | |
173 + FIELD_HOST_PUBKEYID + " INTEGER DEFAULT " + PUBKEYID_ANY + ", " | |
174 + FIELD_HOST_DELKEY + " TEXT DEFAULT '" + DELKEY_DEL + "', " | |
175 + FIELD_HOST_FONTSIZE + " INTEGER, " | |
176 + FIELD_HOST_WANTSESSION + " TEXT DEFAULT '" + Boolean.toString(true) + "', " | |
177 + FIELD_HOST_COMPRESSION + " TEXT DEFAULT '" + Boolean.toString(false) + "', " | |
178 + FIELD_HOST_HTTPPROXY + " TEXT, " | |
179 + FIELD_HOST_ENCODING + " TEXT DEFAULT '" + ENCODING_DEFAULT + "', " | |
180 + FIELD_HOST_STAYCONNECTED + " TEXT, " | |
181 + FIELD_HOST_WANTX11FORWARD + " TEXT DEFAULT '" + Boolean.toString(false) + "', " | |
182 + FIELD_HOST_X11HOST + " TEXT DEFAULT '" + X11HOST_DEFAULT + "', " | |
183 + FIELD_HOST_X11PORT + " INTEGER DEFAULT " + X11PORT_DEFAULT + ", " | |
61 | 184 + FIELD_HOST_MONITOR + " TEXT, " |
185 + FIELD_HOST_EMULATION + " TEXT, " | |
186 + FIELD_HOST_ENCRYPTION5250 + " TEXT)"); | |
0 | 187 db.execSQL("CREATE TABLE " + TABLE_PORTFORWARDS |
188 + " (_id INTEGER PRIMARY KEY, " | |
189 + FIELD_PORTFORWARD_HOSTID + " INTEGER, " | |
190 + FIELD_PORTFORWARD_NICKNAME + " TEXT, " | |
191 + FIELD_PORTFORWARD_TYPE + " TEXT NOT NULL DEFAULT " + PORTFORWARD_LOCAL + ", " | |
192 + FIELD_PORTFORWARD_SOURCEPORT + " INTEGER NOT NULL DEFAULT 8080, " | |
193 + FIELD_PORTFORWARD_DESTADDR + " TEXT, " | |
194 + FIELD_PORTFORWARD_DESTPORT + " TEXT)"); | |
195 db.execSQL("CREATE INDEX " + TABLE_PORTFORWARDS + FIELD_PORTFORWARD_HOSTID + "index ON " | |
196 + TABLE_PORTFORWARDS + " (" + FIELD_PORTFORWARD_HOSTID + ");"); | |
197 db.execSQL("CREATE TABLE " + TABLE_COLORS | |
198 + " (_id INTEGER PRIMARY KEY, " | |
199 + FIELD_COLOR_NUMBER + " INTEGER, " | |
200 + FIELD_COLOR_VALUE + " INTEGER, " | |
201 + FIELD_COLOR_SCHEME + " INTEGER)"); | |
202 db.execSQL("CREATE INDEX " + TABLE_COLORS + FIELD_COLOR_SCHEME + "index ON " | |
203 + TABLE_COLORS + " (" + FIELD_COLOR_SCHEME + ");"); | |
204 db.execSQL(CREATE_TABLE_COLOR_DEFAULTS); | |
205 db.execSQL(CREATE_TABLE_COLOR_DEFAULTS_INDEX); | |
206 } | |
207 | |
208 @Override | |
209 public void onRobustUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) throws SQLiteException { | |
210 // Versions of the database before the Android Market release will be | |
211 // shot without warning. | |
212 if (oldVersion <= 9) { | |
213 db.execSQL("DROP TABLE IF EXISTS " + TABLE_HOSTS); | |
214 onCreate(db); | |
215 return; | |
216 } | |
217 | |
218 switch (oldVersion) { | |
219 case 10: | |
220 db.execSQL("ALTER TABLE " + TABLE_HOSTS | |
221 + " ADD COLUMN " + FIELD_HOST_PUBKEYID + " INTEGER DEFAULT " + PUBKEYID_ANY); | |
222 | |
223 case 11: | |
224 db.execSQL("CREATE TABLE " + TABLE_PORTFORWARDS | |
225 + " (_id INTEGER PRIMARY KEY, " | |
226 + FIELD_PORTFORWARD_HOSTID + " INTEGER, " | |
227 + FIELD_PORTFORWARD_NICKNAME + " TEXT, " | |
228 + FIELD_PORTFORWARD_TYPE + " TEXT NOT NULL DEFAULT " + PORTFORWARD_LOCAL + ", " | |
229 + FIELD_PORTFORWARD_SOURCEPORT + " INTEGER NOT NULL DEFAULT 8080, " | |
230 + FIELD_PORTFORWARD_DESTADDR + " TEXT, " | |
231 + FIELD_PORTFORWARD_DESTPORT + " INTEGER)"); | |
232 | |
233 case 12: | |
234 db.execSQL("ALTER TABLE " + TABLE_HOSTS | |
235 + " ADD COLUMN " + FIELD_HOST_WANTSESSION + " TEXT DEFAULT '" + Boolean.toString(true) + "'"); | |
236 | |
237 case 13: | |
238 db.execSQL("ALTER TABLE " + TABLE_HOSTS | |
239 + " ADD COLUMN " + FIELD_HOST_COMPRESSION + " TEXT DEFAULT '" + Boolean.toString(false) + "'"); | |
240 | |
241 case 14: | |
242 db.execSQL("ALTER TABLE " + TABLE_HOSTS | |
243 + " ADD COLUMN " + FIELD_HOST_ENCODING + " TEXT DEFAULT '" + ENCODING_DEFAULT + "'"); | |
244 | |
245 case 15: | |
246 db.execSQL("ALTER TABLE " + TABLE_HOSTS | |
247 + " ADD COLUMN " + FIELD_HOST_PROTOCOL + " TEXT DEFAULT 'ssh'"); | |
248 | |
249 case 16: | |
250 db.execSQL("ALTER TABLE " + TABLE_HOSTS | |
251 + " ADD COLUMN " + FIELD_HOST_DELKEY + " TEXT DEFAULT '" + DELKEY_DEL + "'"); | |
252 | |
253 case 17: | |
254 db.execSQL("CREATE INDEX " + TABLE_PORTFORWARDS + FIELD_PORTFORWARD_HOSTID + "index ON " | |
255 + TABLE_PORTFORWARDS + " (" + FIELD_PORTFORWARD_HOSTID + ");"); | |
256 // Add colors | |
257 db.execSQL("CREATE TABLE " + TABLE_COLORS | |
258 + " (_id INTEGER PRIMARY KEY, " | |
259 + FIELD_COLOR_NUMBER + " INTEGER, " | |
260 + FIELD_COLOR_VALUE + " INTEGER, " | |
261 + FIELD_COLOR_SCHEME + " INTEGER)"); | |
262 db.execSQL("CREATE INDEX " + TABLE_COLORS + FIELD_COLOR_SCHEME + "index ON " | |
263 + TABLE_COLORS + " (" + FIELD_COLOR_SCHEME + ");"); | |
264 | |
265 case 18: | |
266 db.execSQL("ALTER TABLE " + TABLE_HOSTS | |
267 + " ADD COLUMN " + FIELD_HOST_USEAUTHAGENT + " TEXT DEFAULT '" + AUTHAGENT_NO + "'"); | |
268 | |
269 case 19: | |
270 db.execSQL("ALTER TABLE " + TABLE_HOSTS | |
271 + " ADD COLUMN " + FIELD_HOST_STAYCONNECTED + " TEXT"); | |
272 | |
273 case 20: | |
274 db.execSQL("ALTER TABLE " + TABLE_HOSTS | |
275 + " ADD COLUMN " + FIELD_HOST_FONTSIZE + " INTEGER"); | |
276 | |
277 case 21: | |
278 db.execSQL("DROP TABLE " + TABLE_COLOR_DEFAULTS); | |
279 db.execSQL(CREATE_TABLE_COLOR_DEFAULTS); | |
280 db.execSQL(CREATE_TABLE_COLOR_DEFAULTS_INDEX); | |
281 | |
282 case 22: | |
283 db.execSQL("ALTER TABLE " + TABLE_HOSTS | |
284 + " ADD COLUMN " + FIELD_HOST_WANTX11FORWARD + " TEXT DEFAULT '" + Boolean.toString(false) + "'"); | |
285 db.execSQL("ALTER TABLE " + TABLE_HOSTS | |
286 + " ADD COLUMN " + FIELD_HOST_X11HOST + " TEXT DEFAULT '" + X11HOST_DEFAULT + "'"); | |
287 db.execSQL("ALTER TABLE " + TABLE_HOSTS | |
288 + " ADD COLUMN " + FIELD_HOST_X11PORT + " INTEGER DEFAULT " + X11PORT_DEFAULT); | |
289 | |
290 case 23: | |
291 db.execSQL("ALTER TABLE " + TABLE_HOSTS | |
292 + " ADD COLUMN " + FIELD_HOST_HTTPPROXY + " TEXT"); | |
293 | |
294 case 24: | |
295 db.execSQL("ALTER TABLE " + TABLE_HOSTS | |
296 + " ADD COLUMN " + FIELD_HOST_MONITOR + " TEXT"); | |
61 | 297 |
298 case 25: | |
299 db.execSQL("ALTER TABLE " + TABLE_HOSTS | |
300 + " ADD COLUMN " + FIELD_HOST_EMULATION + " TEXT"); | |
301 db.execSQL("ALTER TABLE " + TABLE_HOSTS | |
302 + " ADD COLUMN " + FIELD_HOST_ENCRYPTION5250 + " TEXT"); | |
0 | 303 } |
304 } | |
305 | |
306 /** | |
307 * Touch a specific host to update its "last connected" field. | |
308 * @param nickname Nickname field of host to update | |
309 */ | |
310 public void touchHost(HostBean host) { | |
311 long now = System.currentTimeMillis() / 1000; | |
312 ContentValues values = new ContentValues(); | |
313 values.put(FIELD_HOST_LASTCONNECT, now); | |
314 | |
315 synchronized (dbLock) { | |
316 SQLiteDatabase db = this.getWritableDatabase(); | |
317 db.update(TABLE_HOSTS, values, "_id = ?", new String[] { String.valueOf(host.getId()) }); | |
318 } | |
319 } | |
320 | |
321 /** | |
322 * Create a new host using the given parameters. | |
323 */ | |
324 public HostBean saveHost(HostBean host) { | |
325 long id; | |
326 | |
327 synchronized (dbLock) { | |
328 SQLiteDatabase db = this.getWritableDatabase(); | |
329 id = db.insert(TABLE_HOSTS, null, host.getValues()); | |
330 } | |
331 | |
332 host.setId(id); | |
333 return host; | |
334 } | |
335 | |
336 /** | |
337 * Update a field in a host record. | |
338 */ | |
339 public boolean updateFontSize(HostBean host) { | |
340 long id = host.getId(); | |
341 | |
342 if (id < 0) | |
343 return false; | |
344 | |
345 ContentValues updates = new ContentValues(); | |
346 updates.put(FIELD_HOST_FONTSIZE, host.getFontSize()); | |
347 | |
348 synchronized (dbLock) { | |
349 SQLiteDatabase db = getWritableDatabase(); | |
350 db.update(TABLE_HOSTS, updates, "_id = ?", | |
351 new String[] { String.valueOf(id) }); | |
352 } | |
353 | |
354 return true; | |
355 } | |
356 | |
357 /** | |
358 * Delete a specific host by its <code>_id</code> value. | |
359 */ | |
360 public void deleteHost(HostBean host) { | |
361 if (host.getId() < 0) | |
362 return; | |
363 | |
364 synchronized (dbLock) { | |
365 SQLiteDatabase db = this.getWritableDatabase(); | |
366 db.delete(TABLE_HOSTS, "_id = ?", new String[] { String.valueOf(host.getId()) }); | |
367 } | |
368 } | |
369 | |
370 /** | |
371 * Return a cursor that contains information about all known hosts. | |
372 * @param sortColors If true, sort by color, otherwise sort by nickname. | |
373 */ | |
374 public List<HostBean> getHosts(boolean sortColors) { | |
375 String sortField = sortColors ? FIELD_HOST_COLOR : FIELD_HOST_NICKNAME; | |
376 List<HostBean> hosts; | |
377 | |
378 synchronized (dbLock) { | |
379 SQLiteDatabase db = this.getReadableDatabase(); | |
380 Cursor c = db.query(TABLE_HOSTS, null, null, null, null, null, sortField + " ASC"); | |
381 hosts = createHostBeans(c); | |
382 c.close(); | |
383 } | |
384 | |
385 return hosts; | |
386 } | |
387 | |
388 /** | |
389 * @param hosts | |
390 * @param c | |
391 */ | |
392 private List<HostBean> createHostBeans(Cursor c) { | |
393 List<HostBean> hosts = new LinkedList<HostBean>(); | |
394 final int COL_ID = c.getColumnIndexOrThrow("_id"), | |
395 COL_NICKNAME = c.getColumnIndexOrThrow(FIELD_HOST_NICKNAME), | |
396 COL_PROTOCOL = c.getColumnIndexOrThrow(FIELD_HOST_PROTOCOL), | |
397 COL_USERNAME = c.getColumnIndexOrThrow(FIELD_HOST_USERNAME), | |
398 COL_HOSTNAME = c.getColumnIndexOrThrow(FIELD_HOST_HOSTNAME), | |
399 COL_PORT = c.getColumnIndexOrThrow(FIELD_HOST_PORT), | |
400 COL_LASTCONNECT = c.getColumnIndexOrThrow(FIELD_HOST_LASTCONNECT), | |
401 COL_COLOR = c.getColumnIndexOrThrow(FIELD_HOST_COLOR), | |
402 COL_USEKEYS = c.getColumnIndexOrThrow(FIELD_HOST_USEKEYS), | |
403 COL_USEAUTHAGENT = c.getColumnIndexOrThrow(FIELD_HOST_USEAUTHAGENT), | |
404 COL_POSTLOGIN = c.getColumnIndexOrThrow(FIELD_HOST_POSTLOGIN), | |
405 COL_PUBKEYID = c.getColumnIndexOrThrow(FIELD_HOST_PUBKEYID), | |
406 COL_WANTSESSION = c.getColumnIndexOrThrow(FIELD_HOST_WANTSESSION), | |
407 COL_DELKEY = c.getColumnIndexOrThrow(FIELD_HOST_DELKEY), | |
408 COL_FONTSIZE = c.getColumnIndexOrThrow(FIELD_HOST_FONTSIZE), | |
409 COL_COMPRESSION = c.getColumnIndexOrThrow(FIELD_HOST_COMPRESSION), | |
410 COL_HTTPPROXY = c.getColumnIndexOrThrow(FIELD_HOST_HTTPPROXY), | |
411 COL_ENCODING = c.getColumnIndexOrThrow(FIELD_HOST_ENCODING), | |
412 COL_STAYCONNECTED = c.getColumnIndexOrThrow(FIELD_HOST_STAYCONNECTED), | |
413 COL_WANTX11FORWARD = c.getColumnIndexOrThrow(FIELD_HOST_WANTX11FORWARD), | |
414 COL_X11HOST = c.getColumnIndexOrThrow(FIELD_HOST_X11HOST), | |
415 COL_X11PORT = c.getColumnIndexOrThrow(FIELD_HOST_X11PORT), | |
61 | 416 COL_MONITOR = c.getColumnIndexOrThrow(FIELD_HOST_MONITOR), |
417 COL_EMULATION = c.getColumnIndexOrThrow(FIELD_HOST_EMULATION), | |
418 COL_ENCRYPTION5250 = c.getColumnIndexOrThrow(FIELD_HOST_ENCRYPTION5250); | |
0 | 419 |
420 while (c.moveToNext()) { | |
421 HostBean host = new HostBean(); | |
422 host.setId(c.getLong(COL_ID)); | |
423 host.setNickname(c.getString(COL_NICKNAME)); | |
424 host.setProtocol(c.getString(COL_PROTOCOL)); | |
425 host.setUsername(c.getString(COL_USERNAME)); | |
426 host.setHostname(c.getString(COL_HOSTNAME)); | |
427 host.setPort(c.getInt(COL_PORT)); | |
428 host.setLastConnect(c.getLong(COL_LASTCONNECT)); | |
429 host.setColor(c.getString(COL_COLOR)); | |
430 host.setUseKeys(Boolean.valueOf(c.getString(COL_USEKEYS))); | |
431 host.setUseAuthAgent(c.getString(COL_USEAUTHAGENT)); | |
432 host.setPostLogin(c.getString(COL_POSTLOGIN)); | |
433 host.setPubkeyId(c.getLong(COL_PUBKEYID)); | |
434 host.setWantSession(Boolean.valueOf(c.getString(COL_WANTSESSION))); | |
435 host.setDelKey(c.getString(COL_DELKEY)); | |
436 host.setFontSize(c.getInt(COL_FONTSIZE)); | |
437 host.setCompression(Boolean.valueOf(c.getString(COL_COMPRESSION))); | |
438 host.setHttpproxy(c.getString(COL_HTTPPROXY)); | |
439 host.setEncoding(c.getString(COL_ENCODING)); | |
440 host.setStayConnected(Boolean.valueOf(c.getString(COL_STAYCONNECTED))); | |
441 host.setWantX11Forward(Boolean.valueOf(c.getString(COL_WANTX11FORWARD))); | |
442 host.setX11Host(c.getString(COL_X11HOST)); | |
443 host.setX11Port(c.getInt(COL_X11PORT)); | |
444 host.setMonitor(c.getString(COL_MONITOR)); | |
63
07c7055cc124
add 5250 config entries
Carl Byington <carl@five-ten-sg.com>
parents:
62
diff
changeset
|
445 host.setHostEmulation(c.getString(COL_EMULATION)); |
61 | 446 host.setEncryption5250(c.getString(COL_ENCRYPTION5250)); |
0 | 447 hosts.add(host); |
448 } | |
449 | |
450 return hosts; | |
451 } | |
452 | |
453 /** | |
454 * @param c | |
455 * @return | |
456 */ | |
457 private HostBean getFirstHostBean(Cursor c) { | |
458 HostBean host = null; | |
459 List<HostBean> hosts = createHostBeans(c); | |
460 | |
461 if (hosts.size() > 0) | |
462 host = hosts.get(0); | |
463 | |
464 c.close(); | |
465 return host; | |
466 } | |
467 | |
468 /** | |
469 * @param nickname | |
470 * @param protocol | |
471 * @param username | |
472 * @param hostname | |
473 * @param hostname2 | |
474 * @param port | |
475 * @return | |
476 */ | |
477 public HostBean findHost(Map<String, String> selection) { | |
478 StringBuilder selectionBuilder = new StringBuilder(); | |
479 Iterator<Entry<String, String>> i = selection.entrySet().iterator(); | |
480 List<String> selectionValuesList = new LinkedList<String>(); | |
481 int n = 0; | |
482 | |
483 while (i.hasNext()) { | |
484 Entry<String, String> entry = i.next(); | |
485 | |
486 if (entry.getValue() == null) | |
487 continue; | |
488 | |
489 if (n++ > 0) | |
490 selectionBuilder.append(" AND "); | |
491 | |
492 selectionBuilder.append(entry.getKey()) | |
493 .append(" = ?"); | |
494 selectionValuesList.add(entry.getValue()); | |
495 } | |
496 | |
497 String selectionValues[] = new String[selectionValuesList.size()]; | |
498 selectionValuesList.toArray(selectionValues); | |
499 selectionValuesList = null; | |
500 HostBean host; | |
501 | |
502 synchronized (dbLock) { | |
503 SQLiteDatabase db = getReadableDatabase(); | |
504 Cursor c = db.query(TABLE_HOSTS, null, | |
505 selectionBuilder.toString(), | |
506 selectionValues, | |
507 null, null, null); | |
508 host = getFirstHostBean(c); | |
509 } | |
510 | |
511 return host; | |
512 } | |
513 | |
514 /** | |
515 * @param hostId | |
516 * @return | |
517 */ | |
518 public HostBean findHostById(long hostId) { | |
519 HostBean host; | |
520 | |
521 synchronized (dbLock) { | |
522 SQLiteDatabase db = getReadableDatabase(); | |
523 Cursor c = db.query(TABLE_HOSTS, null, | |
524 "_id = ?", new String[] { String.valueOf(hostId) }, | |
525 null, null, null); | |
526 host = getFirstHostBean(c); | |
527 } | |
528 | |
529 return host; | |
530 } | |
531 | |
532 /** | |
533 * Record the given hostkey into database under this nickname. | |
534 * @param hostname | |
535 * @param port | |
536 * @param hostkeyalgo | |
537 * @param hostkey | |
538 */ | |
539 public void saveKnownHost(String hostname, int port, String hostkeyalgo, byte[] hostkey) { | |
540 ContentValues values = new ContentValues(); | |
541 values.put(FIELD_HOST_HOSTKEYALGO, hostkeyalgo); | |
542 values.put(FIELD_HOST_HOSTKEY, hostkey); | |
543 | |
544 synchronized (dbLock) { | |
545 SQLiteDatabase db = getReadableDatabase(); | |
546 db.update(TABLE_HOSTS, values, | |
547 FIELD_HOST_HOSTNAME + " = ? AND " + FIELD_HOST_PORT + " = ?", | |
548 new String[] { hostname, String.valueOf(port) }); | |
549 Log.d(TAG, String.format("Finished saving hostkey information for '%s'", hostname)); | |
550 } | |
551 } | |
552 | |
553 /** | |
554 * Build list of known hosts for Trilead library. | |
555 * @return | |
556 */ | |
557 public KnownHosts getKnownHosts() { | |
558 KnownHosts known = new KnownHosts(); | |
559 | |
560 synchronized (dbLock) { | |
561 SQLiteDatabase db = this.getReadableDatabase(); | |
562 Cursor c = db.query(TABLE_HOSTS, new String[] { FIELD_HOST_HOSTNAME, | |
563 FIELD_HOST_PORT, FIELD_HOST_HOSTKEYALGO, FIELD_HOST_HOSTKEY | |
564 }, | |
565 null, null, null, null, null); | |
566 | |
567 if (c != null) { | |
568 int COL_HOSTNAME = c.getColumnIndexOrThrow(FIELD_HOST_HOSTNAME), | |
569 COL_PORT = c.getColumnIndexOrThrow(FIELD_HOST_PORT), | |
570 COL_HOSTKEYALGO = c.getColumnIndexOrThrow(FIELD_HOST_HOSTKEYALGO), | |
571 COL_HOSTKEY = c.getColumnIndexOrThrow(FIELD_HOST_HOSTKEY); | |
572 | |
573 while (c.moveToNext()) { | |
574 String hostname = c.getString(COL_HOSTNAME), | |
575 hostkeyalgo = c.getString(COL_HOSTKEYALGO); | |
576 int port = c.getInt(COL_PORT); | |
577 byte[] hostkey = c.getBlob(COL_HOSTKEY); | |
578 | |
579 if (hostkeyalgo == null || hostkeyalgo.length() == 0) continue; | |
580 | |
581 if (hostkey == null || hostkey.length == 0) continue; | |
582 | |
583 try { | |
584 known.addHostkey(new String[] { String.format("%s:%d", hostname, port) }, hostkeyalgo, hostkey); | |
585 } | |
586 catch (Exception e) { | |
587 Log.e(TAG, "Problem while adding a known host from database", e); | |
588 } | |
589 } | |
590 | |
591 c.close(); | |
592 } | |
593 } | |
594 | |
595 return known; | |
596 } | |
597 | |
598 /** | |
599 * Unset any hosts using a pubkey ID that has been deleted. | |
600 * @param pubkeyId | |
601 */ | |
602 public void stopUsingPubkey(long pubkeyId) { | |
603 if (pubkeyId < 0) return; | |
604 | |
605 ContentValues values = new ContentValues(); | |
606 values.put(FIELD_HOST_PUBKEYID, PUBKEYID_ANY); | |
607 | |
608 synchronized (dbLock) { | |
609 SQLiteDatabase db = this.getWritableDatabase(); | |
610 db.update(TABLE_HOSTS, values, FIELD_HOST_PUBKEYID + " = ?", new String[] { String.valueOf(pubkeyId) }); | |
611 } | |
612 | |
613 Log.d(TAG, String.format("Set all hosts using pubkey id %d to -1", pubkeyId)); | |
614 } | |
615 | |
616 /* | |
617 * Methods for dealing with port forwards attached to hosts | |
618 */ | |
619 | |
620 /** | |
621 * Returns a list of all the port forwards associated with a particular host ID. | |
622 * @param host the host for which we want the port forward list | |
623 * @return port forwards associated with host ID | |
624 */ | |
625 public List<PortForwardBean> getPortForwardsForHost(HostBean host) { | |
626 List<PortForwardBean> portForwards = new LinkedList<PortForwardBean>(); | |
627 | |
628 synchronized (dbLock) { | |
629 SQLiteDatabase db = this.getReadableDatabase(); | |
630 Cursor c = db.query(TABLE_PORTFORWARDS, new String[] { | |
631 "_id", FIELD_PORTFORWARD_NICKNAME, FIELD_PORTFORWARD_TYPE, FIELD_PORTFORWARD_SOURCEPORT, | |
632 FIELD_PORTFORWARD_DESTADDR, FIELD_PORTFORWARD_DESTPORT | |
633 }, | |
634 FIELD_PORTFORWARD_HOSTID + " = ?", new String[] { String.valueOf(host.getId()) }, | |
635 null, null, null); | |
636 | |
637 while (c.moveToNext()) { | |
638 PortForwardBean pfb = new PortForwardBean( | |
639 c.getInt(0), | |
640 host.getId(), | |
641 c.getString(1), | |
642 c.getString(2), | |
643 c.getInt(3), | |
644 c.getString(4), | |
645 c.getInt(5)); | |
646 portForwards.add(pfb); | |
647 } | |
648 | |
649 c.close(); | |
650 } | |
651 | |
652 return portForwards; | |
653 } | |
654 | |
655 /** | |
656 * Update the parameters of a port forward in the database. | |
657 * @param pfb {@link PortForwardBean} to save | |
658 * @return true on success | |
659 */ | |
660 public boolean savePortForward(PortForwardBean pfb) { | |
661 boolean success = false; | |
662 | |
663 synchronized (dbLock) { | |
664 SQLiteDatabase db = getWritableDatabase(); | |
665 | |
666 if (pfb.getId() < 0) { | |
667 long id = db.insert(TABLE_PORTFORWARDS, null, pfb.getValues()); | |
668 pfb.setId(id); | |
669 success = true; | |
670 } | |
671 else { | |
672 if (db.update(TABLE_PORTFORWARDS, pfb.getValues(), "_id = ?", new String[] { String.valueOf(pfb.getId()) }) > 0) | |
673 success = true; | |
674 } | |
675 } | |
676 | |
677 return success; | |
678 } | |
679 | |
680 /** | |
681 * Deletes a port forward from the database. | |
682 * @param pfb {@link PortForwardBean} to delete | |
683 */ | |
684 public void deletePortForward(PortForwardBean pfb) { | |
685 if (pfb.getId() < 0) | |
686 return; | |
687 | |
688 synchronized (dbLock) { | |
689 SQLiteDatabase db = this.getWritableDatabase(); | |
690 db.delete(TABLE_PORTFORWARDS, "_id = ?", new String[] { String.valueOf(pfb.getId()) }); | |
691 } | |
692 } | |
693 | |
694 public Integer[] getColorsForScheme(int scheme) { | |
695 Integer[] colors = Colors.defaults.clone(); | |
696 | |
697 synchronized (dbLock) { | |
698 SQLiteDatabase db = getReadableDatabase(); | |
699 Cursor c = db.query(TABLE_COLORS, new String[] { | |
700 FIELD_COLOR_NUMBER, FIELD_COLOR_VALUE | |
701 }, | |
702 FIELD_COLOR_SCHEME + " = ?", | |
703 new String[] { String.valueOf(scheme) }, | |
704 null, null, null); | |
705 | |
706 while (c.moveToNext()) { | |
707 colors[c.getInt(0)] = Integer.valueOf(c.getInt(1)); | |
708 } | |
709 | |
710 c.close(); | |
711 } | |
712 | |
713 return colors; | |
714 } | |
715 | |
716 public void setColorForScheme(int scheme, int number, int value) { | |
717 final SQLiteDatabase db; | |
718 final String[] whereArgs = new String[] { String.valueOf(scheme), String.valueOf(number) }; | |
719 | |
720 if (value == Colors.defaults[number]) { | |
721 synchronized (dbLock) { | |
722 db = getWritableDatabase(); | |
723 db.delete(TABLE_COLORS, | |
724 WHERE_SCHEME_AND_COLOR, whereArgs); | |
725 } | |
726 } | |
727 else { | |
728 final ContentValues values = new ContentValues(); | |
729 values.put(FIELD_COLOR_VALUE, value); | |
730 | |
731 synchronized (dbLock) { | |
732 db = getWritableDatabase(); | |
733 final int rowsAffected = db.update(TABLE_COLORS, values, | |
734 WHERE_SCHEME_AND_COLOR, whereArgs); | |
735 | |
736 if (rowsAffected == 0) { | |
737 values.put(FIELD_COLOR_SCHEME, scheme); | |
738 values.put(FIELD_COLOR_NUMBER, number); | |
739 db.insert(TABLE_COLORS, null, values); | |
740 } | |
741 } | |
742 } | |
743 } | |
744 | |
745 public void setGlobalColor(int number, int value) { | |
746 setColorForScheme(DEFAULT_COLOR_SCHEME, number, value); | |
747 } | |
748 | |
749 public int[] getDefaultColorsForScheme(int scheme) { | |
750 int[] colors = new int[] { DEFAULT_FG_COLOR, DEFAULT_BG_COLOR }; | |
751 | |
752 synchronized (dbLock) { | |
753 SQLiteDatabase db = getReadableDatabase(); | |
754 Cursor c = db.query(TABLE_COLOR_DEFAULTS, | |
755 new String[] { FIELD_COLOR_FG, FIELD_COLOR_BG }, | |
756 FIELD_COLOR_SCHEME + " = ?", | |
757 new String[] { String.valueOf(scheme) }, | |
758 null, null, null); | |
759 | |
760 if (c.moveToFirst()) { | |
761 colors[0] = c.getInt(0); | |
762 colors[1] = c.getInt(1); | |
763 } | |
764 | |
765 c.close(); | |
766 } | |
767 | |
768 return colors; | |
769 } | |
770 | |
771 public int[] getGlobalDefaultColors() { | |
772 return getDefaultColorsForScheme(DEFAULT_COLOR_SCHEME); | |
773 } | |
774 | |
775 public void setDefaultColorsForScheme(int scheme, int fg, int bg) { | |
776 SQLiteDatabase db; | |
777 String schemeWhere = null; | |
778 String[] whereArgs; | |
779 schemeWhere = FIELD_COLOR_SCHEME + " = ?"; | |
780 whereArgs = new String[] { String.valueOf(scheme) }; | |
781 ContentValues values = new ContentValues(); | |
782 values.put(FIELD_COLOR_FG, fg); | |
783 values.put(FIELD_COLOR_BG, bg); | |
784 | |
785 synchronized (dbLock) { | |
786 db = getWritableDatabase(); | |
787 int rowsAffected = db.update(TABLE_COLOR_DEFAULTS, values, | |
788 schemeWhere, whereArgs); | |
789 | |
790 if (rowsAffected == 0) { | |
791 values.put(FIELD_COLOR_SCHEME, scheme); | |
792 db.insert(TABLE_COLOR_DEFAULTS, null, values); | |
793 } | |
794 } | |
795 } | |
796 } |