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) (side-by-side diff) | |
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 @@ +CREATE TABLE assoc ( + a_op text, + a_handle text NOT NULL, + a_type text DEFAULT 'HMAC-SHA1', + a_ctime text NOT NULL, + a_etime text NOT NULL, + a_secret text NOT NULL, + a_stateless integer NOT NULL DEFAULT 0, + a_itime integer, + UNIQUE(a_op,a_handle) +); + +CREATE TABLE nonces ( + n_op text NOT NULL, + n_once text NOT NULL, + PRIMARY KEY (n_op,n_once) +); + +CREATE TABLE ht_sessions ( + hts_id text NOT NULL PRIMARY KEY +); + +CREATE TABLE auth_sessions ( + as_id integer PRIMARY KEY AUTOINCREMENT, + hts_id text NOT NULL REFERENCES ht_sessions(hts_id), + as_normalized_id text, + UNIQUE (hts_id,as_id) +); + +CREATE TABLE endpoints_queue ( + as_id integer NOT NULL REFERENCES auth_sessions (as_id), + eq_ctime integer NOT NULL, + eq_ordinal integer NOT NULL, + eq_uri text, + eq_claimed_id text, + eq_local_id text +); |