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
|
/**
* Using SQLite in Vala Sample Code
* Port of an example found on the SQLite site.
* http://www.sqlite.org/quickstart.html
*/
using GLib;
using Sqlite;
public class SqliteSample : GLib.Object {
public static int callback (int n_columns, string[] values,
string[] column_names)
{
for (int i = 0; i < n_columns; i++) {
stdout.printf ("%s = %s\n", column_names[i], values[i]);
}
stdout.printf ("\n");
return 0;
}
public static int main (string[] args) {
Database db;
int rc;
if (args.length != 3) {
stderr.printf ("Usage: %s DATABASE SQL-STATEMENT\n", args[0]);
return 1;
}
if (!FileUtils.test (args[1], FileTest.IS_REGULAR)) {
stderr.printf ("Database %s does not exist or is directory\n", args[1]);
return 1;
}
rc = Database.open (args[1], out db);
if (rc != Sqlite.OK) {
stderr.printf ("Can't open database: %d, %s\n", rc, db.errmsg ());
return 1;
}
rc = db.exec (args[2], callback, null);
/* maybe it is better to use closures, so you can access local variables, eg: */
/*rc = db.exec(args[2], (n_columns, values, column_names) => {
for (int i = 0; i < n_columns; i++) {
stdout.printf ("%s = %s\n", column_names[i], values[i]);
}
stdout.printf ("\n");
return 0;
}, null);
*/
if (rc != Sqlite.OK) {
stderr.printf ("SQL error: %d, %s\n", rc, db.errmsg ());
return 1;
}
return 0;
}
}
|
