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
|
[MAIN] -------------- Preparing database -------------
[SQL] Connecting to sqlite database test.db ()
[SQL.SQLITE] Create empty db file
[SQL] PRAGMA foreign_keys=ON
[SQL] BEGIN
[SQL] CREATE TABLE "data" (
_SQL_ "id" Integer NOT NULL,
_SQL_ "name" Text DEFAULT 'default',
_SQL_ "value" Integer DEFAULT 1,
_SQL_ "amount" Integer DEFAULT -1111, PRIMARY KEY ("id"))
[SQL] CREATE TABLE "pairs" (
_SQL_ "id" Integer NOT NULL,
_SQL_ "end1" Integer,
_SQL_ "end2" Integer,
_SQL_ "value" Text, PRIMARY KEY ("id"),
_SQL_ FOREIGN KEY ("end1") REFERENCES "data" ("id"),
_SQL_ FOREIGN KEY ("end2") REFERENCES "data" ("id"))
[SQL] CREATE INDEX "pairs_end1_idx" ON "pairs" ("end1")
[SQL] CREATE INDEX "pairs_end2_idx" ON "pairs" ("end2")
[SQL] COMMIT
[SQL.INSPECT] Loading data from initialdata.txt into database
[SQL] PRAGMA foreign_keys=OFF
[SQL] compute (insertval): INSERT INTO "data"(id,"name","value",amount) VALUES (?1,?2,?3,?4)
[SQL.SQLITE] PREPARE insertval
[SQL] BEGIN
[SQL] (insertval), 1, aaa, 1, 110
[SQL] (insertval), 2, bbb, 2, -2569
[SQL] (insertval), 3, acc, 2, 153698
[SQL] compute (insertval): INSERT INTO "pairs"(id,end1,end2,"value") VALUES (?1,?2,?3,?4)
[SQL] Finalize stmt on server: insertval
[SQL] compute (insertv): INSERT INTO "pairs"(id,end1,end2,"value") SELECT ?1,t2.id,t3.id,?4 FROM data t2,data t3 WHERE t2.name=?2 and t3.name=?3
[SQL.SQLITE] PREPARE insertv
[SQL] (insertv), 10, aaa, bbb, With 'quote
[SQL] (insertv), 11, bbb, acc, With "quote
[SQL] Finalize stmt on server: insertv
[SQL] COMMIT
[MAIN] -------------- Simple queries -------------
[SQL.SELECT] SELECT "data".id FROM "data" WHERE "data"."value"=2 (2 tuples)
[SQL.SELECT] SELECT "data".id FROM "data" WHERE "data"."value"=2
[MAIN] -------------- preparation on client -------------
[SQL] compute (stmt4): SELECT "data".id FROM "data" WHERE "data"."value"=2
[SQL.SELECT] (stmt4) (2 tuples)
[SQL.SELECT] (stmt4) (2 tuples)
[SQL] Prepared statement was freed, can't execute
[MAIN] -------------- caching on client -------------
[SQL] compute (stmt5): SELECT "data".id FROM "data" WHERE "data"."value"=2
[SQL.SELECT] (stmt5) (2 tuples)
[SQL.CACHE] (stmt5): from cache
[SQL] Unset cache for stmt5
[MAIN] -------------- preparation on server -------------
[SQL] compute (query2): SELECT "data".id FROM "data" WHERE "data"."value"=2
[SQL.SQLITE] PREPARE query2
[SQL.SELECT] (query2) (2 tuples)
[SQL.SELECT] (query2) (2 tuples)
[MAIN] ----------- same prepared stmt, on second connection --
[SQL] Connecting to sqlite database test.db ()
[SQL] PRAGMA foreign_keys=ON
[SQL.SQLITE] PREPARE query2
[SQL.SELECT] (query2) (2 tuples)
[MAIN] -------------- using parameters -------------
[SQL] Finalize stmt on server: query2 (for 2 connections)
[SQL] compute (stmt7): SELECT "data".id FROM "data" WHERE "data"."value"=?1 AND "data".amount<?2
[SQL.SQLITE] PREPARE stmt7
[SQL.SELECT] (stmt7), 2, 1000456 (2 tuples)
[SQL.SELECT] (stmt7), 3, 5476 (0 tuples)
[MAIN] -------------- test money value -------------
[SQL.SELECT] SELECT "data".id, "data".amount FROM "data" WHERE "data".amount<153699
[MAIN] result 1.10
[MAIN] result -25.69
[MAIN] result 1536.98
[SQL] Finalize stmt on server: stmt7
[SQL.SQLITE] Closing connection to sqlite
[SQL.SQLITE] Closing connection to sqlite
|
