diff options
author | Yorhel <git@yorhel.nl> | 2019-08-24 15:29:48 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-08-24 15:47:54 +0200 |
commit | 2f80723a876c1a865dd529be6642a7b5b6d420f0 (patch) | |
tree | c604abcfd426db19e058d47e3b905cfc4632c4c9 /util | |
parent | 9de176a9234b56870ba175f7261d8fed9800beec (diff) |
Add J-List price info crawler
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/perms.sql | 1 | ||||
-rw-r--r-- | util/sql/schema.sql | 9 | ||||
-rw-r--r-- | util/updates/update_20190824.sql | 9 |
3 files changed, 19 insertions, 0 deletions
diff --git a/util/sql/perms.sql b/util/sql/perms.sql index 93c8e241..4feed316 100644 --- a/util/sql/perms.sql +++ b/util/sql/perms.sql @@ -121,6 +121,7 @@ GRANT SELECT, INSERT, UPDATE, DELETE ON rlists TO vndb_multi; GRANT SELECT ON screenshots TO vndb_multi; GRANT SELECT (lastused) ON sessions TO vndb_multi; GRANT DELETE ON sessions TO vndb_multi; +GRANT SELECT, INSERT, UPDATE, DELETE ON shop_jlist TO vndb_multi; GRANT SELECT ON staff TO vndb_multi; GRANT SELECT ON staff_alias TO vndb_multi; GRANT SELECT ON staff_alias_hist TO vndb_multi; diff --git a/util/sql/schema.sql b/util/sql/schema.sql index ca843309..0dd8b3f5 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -468,6 +468,15 @@ CREATE TABLE sessions ( PRIMARY KEY (uid, token) ); +-- shop_jlist +CREATE TABLE shop_jlist ( + id text NOT NULL PRIMARY KEY, + lastfetch timestamptz, + found boolean NOT NULL DEFAULT false, + jbox boolean NOT NULL DEFAULT false, + price text NOT NULL DEFAULT '' -- empty when unknown or not in stock +); + -- staff CREATE TABLE staff ( -- dbentry_type=s id SERIAL PRIMARY KEY, -- [pub] diff --git a/util/updates/update_20190824.sql b/util/updates/update_20190824.sql new file mode 100644 index 00000000..31930604 --- /dev/null +++ b/util/updates/update_20190824.sql @@ -0,0 +1,9 @@ +CREATE TABLE shop_jlist ( + id text NOT NULL PRIMARY KEY, + lastfetch timestamptz, + found boolean NOT NULL DEFAULT false, + jbox boolean NOT NULL DEFAULT false, + price text NOT NULL DEFAULT '' +); + +GRANT SELECT, INSERT, UPDATE, DELETE ON shop_jlist TO vndb_multi; |