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
|
/* Copyright 2016 Software Freedom Conservancy Inc.
*
* This software is licensed under the GNU Lesser General Public License
* (version 2.1 or later). See the COPYING file in this distribution.
*/
namespace DataImports.FSpot.Db {
/**
* The value object for the "meta" table, representing a single database row.
*/
public class FSpotMetaRow : Object {
// ignore the ID
public string name;
public string data;
}
/**
* This class represents the F-Spot meta table, which stores some essential
* meta-data for the whole database. It is implemented as a simple dictionary
* where each row in the table is a key/value pair.
*
* The meta table implementation is the only one that throws a database error
* if something goes wrong because:
* * it is essential to read the content of that table in order to identify
* the version of the database and select the correct behavior,
* * this table is read at the very beginning of the process so any failure
* will occur immediately,
* * failing to read this table means that there is no point in reading the
* attempting to read the rest of the database so we might as well abort.
*/
public class FSpotMetaTable : FSpotDatabaseTable<FSpotMetaRow> {
public FSpotMetaTable(Sqlite.Database db) {
base(db);
set_behavior(FSpotMetaBehavior.get_instance());
}
public string? get_data(string name) throws DatabaseError {
string[] columns = behavior.list_columns();
string column_list = string.joinv(", ", columns);
string sql = "SELECT %s FROM %s WHERE name=?".printf(column_list, table_name);
Sqlite.Statement stmt;
int res = fspot_db.prepare_v2(sql, -1, out stmt);
if (res != Sqlite.OK)
throw_error("Statement failed: %s".printf(sql), res);
res = stmt.bind_text(1, name);
if (res != Sqlite.OK)
throw_error("Bind failed for name %s".printf(name), res);
res = stmt.step();
if (res != Sqlite.ROW) {
if (res != Sqlite.DONE)
throw_error("FSpotMetaTable.get_data", res);
return null;
}
FSpotMetaRow row;
behavior.build_row(stmt, out row);
return row.data;
}
public string? get_app_version() throws DatabaseError {
return get_data("F-Spot Version");
}
public string? get_db_version() throws DatabaseError {
return get_data("F-Spot Database Version");
}
public int64 get_hidden_tag_id() throws DatabaseError {
string id_str = get_data("Hidden Tag Id");
if(id_str != null) {
return int64.parse(id_str);
} else {
return -1;
}
}
}
public class FSpotMetaBehavior : FSpotTableBehavior<FSpotMetaRow>, Object {
public static const string TABLE_NAME = "Meta";
private static FSpotMetaBehavior instance;
private FSpotMetaBehavior() {
}
public static FSpotMetaBehavior get_instance() {
if (instance == null)
instance = new FSpotMetaBehavior();
return instance;
}
public string get_table_name() {
return TABLE_NAME;
}
public string[] list_columns() {
return { "name", "data" };
}
public void build_row(Sqlite.Statement stmt, out FSpotMetaRow row, int offset = 0) {
row = new FSpotMetaRow();
row.name = stmt.column_text(offset + 0);
row.data = stmt.column_text(offset + 1);
}
}
}
|
