1 ! Copyright (C) 2005 Chris Double.
2 ! See http://factorcode.org/license.txt for BSD license.
5 USING: io kernel sequences namespaces
6 hashtables sqlite errors math words generic test ;
8 TUPLE: testdata one two ;
10 testdata default-mapping set-mapping
12 "libs/sqlite/test.db" resource-path [
14 db get testdata create-tuple-table
17 db get "one" "two" <testdata> insert-tuple
18 db get "one" f <testdata> find-tuples
19 first [ testdata-two ] keep
20 db get swap delete-tuple
21 db get "one" f <testdata> find-tuples
25 db get "one" "two" <testdata> insert-tuple
26 db get "one" f <testdata> find-tuples
28 "junk" over set-testdata-two
29 db get swap update-tuple
30 db get "one" f <testdata> find-tuples
31 first [ testdata-two ] keep
32 db get swap delete-tuple
35 db get testdata drop-tuple-table