author | Michael Krelin <hacker@klever.net> | 2008-01-20 21:10:23 (UTC) |
---|---|---|
committer | Michael Krelin <hacker@klever.net> | 2008-01-20 21:10:23 (UTC) |
commit | d16e79b1c792352eade736e7080c401a6c7ace03 (patch) (unidiff) | |
tree | 545a905ab8ef5c2a2135c17d2f949556b354b842 /test/RP-db.sql | |
parent | 9bfb6fadf71c46bf4cb5adabba0c96c32e84c1bc (diff) | |
download | libopkele-d16e79b1c792352eade736e7080c401a6c7ace03.zip libopkele-d16e79b1c792352eade736e7080c401a6c7ace03.tar.gz libopkele-d16e79b1c792352eade736e7080c401a6c7ace03.tar.bz2 |
test part rewritten
* cut down test.cc to only test rfc uri normalization
* redone idiscover to only list discovered endpoints
* added test RP cgi
Signed-off-by: Michael Krelin <hacker@klever.net>
-rw-r--r-- | test/RP-db.sql | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/test/RP-db.sql b/test/RP-db.sql new file mode 100644 index 0000000..71a82d4 --- a/dev/null +++ b/test/RP-db.sql | |||
@@ -0,0 +1,37 @@ | |||
1 | CREATE TABLE assoc ( | ||
2 | a_op text, | ||
3 | a_handle text NOT NULL, | ||
4 | a_type text DEFAULT 'HMAC-SHA1', | ||
5 | a_ctime text NOT NULL, | ||
6 | a_etime text NOT NULL, | ||
7 | a_secret text NOT NULL, | ||
8 | a_stateless integer NOT NULL DEFAULT 0, | ||
9 | a_itime integer, | ||
10 | UNIQUE(a_op,a_handle) | ||
11 | ); | ||
12 | |||
13 | CREATE TABLE nonces ( | ||
14 | n_op text NOT NULL, | ||
15 | n_once text NOT NULL, | ||
16 | PRIMARY KEY (n_op,n_once) | ||
17 | ); | ||
18 | |||
19 | CREATE TABLE ht_sessions ( | ||
20 | hts_id text NOT NULL PRIMARY KEY | ||
21 | ); | ||
22 | |||
23 | CREATE TABLE auth_sessions ( | ||
24 | as_id integer PRIMARY KEY AUTOINCREMENT, | ||
25 | hts_id text NOT NULL REFERENCES ht_sessions(hts_id), | ||
26 | as_normalized_id text, | ||
27 | UNIQUE (hts_id,as_id) | ||
28 | ); | ||
29 | |||
30 | CREATE TABLE endpoints_queue ( | ||
31 | as_id integer NOT NULL REFERENCES auth_sessions (as_id), | ||
32 | eq_ctime integer NOT NULL, | ||
33 | eq_ordinal integer NOT NULL, | ||
34 | eq_uri text, | ||
35 | eq_claimed_id text, | ||
36 | eq_local_id text | ||
37 | ); | ||