You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
@@ -94,7 +94,7 @@ Verified public keys will be retrieved from https://keys.truestamp.com.
94
94
95
95
HTTP request to third-party blockchain API servers will originate from this local client.
db.query("INSERT INTO items (id, id_json) VALUES (?, json(?))",[
29
+
id,
30
+
JSON.stringify(decodedId),
31
+
])
38
32
39
33
// // Print out data in table
40
34
// for (const [id] of db.query("SELECT id FROM items")) {
@@ -45,34 +39,22 @@ CREATE TABLE IF NOT EXISTS items (
45
39
}
46
40
47
41
// See : https://stackoverflow.com/questions/33432421/sqlite-json1-example-for-json-extract-set
42
+
// e.g. sqlite3 "/Users/glenn/Library/Application Support/com.truestamp.cli.development/db.sqlite3"
48
43
// sqlite> select json_extract(items.id_json, '$.ulid') from items;
49
-
// 01GABY7BPZTMW0J7SA8DGR2JAZ
50
-
51
-
// sqlite> select i.* from items i where json_extract(id_json, '$.ulid') LIKE '01GABY7BPZTMW0J7SA8DGR2JAZ';
0 commit comments