I hereby claim:
- I am RhinosF1 on github.
- I am rhinosf1 (https://keybase.io/rhinosf1) on keybase.
- I have a public key whose fingerprint is E3D1 FC13 2076 A938 204F DDD8 2FDA 4C70 85F2 143B
To claim this, I am signing this object:
I hereby claim:
To claim this, I am signing this object:
import requests | |
S = requests.Session() | |
URL = "https://meta.miraheze.org/w/api.php" | |
PARAMS = { | |
"action": "wikidiscover", | |
"format": "json", | |
"wdstate": "public", | |
"wdsiteprop": "url" | |
} | |
R = S.get(url=URL, params=PARAMS) |
CREATE TABLE channel_values (channel STRING, key STRING, value STRING, PRIMARY KEY (channel, key)) | |
CREATE TABLE nick_ids (nick_id INTEGER PRIMARY KEY AUTOINCREMENT) | |
CREATE TABLE nick_values (nick_id INTEGER REFERENCES nick_ids(nick_id), key STRING, value STRING, PRIMARY KEY (nick_id, key)) | |
CREATE TABLE nicknames (nick_id INTEGER REFERENCES nick_ids, slug STRING PRIMARY KEY, canonical string) | |
CREATE TABLE plugin_values ( | |
plugin VARCHAR(255) NOT NULL, | |
"key" VARCHAR(255) NOT NULL, | |
value VARCHAR(255), | |
PRIMARY KEY (plugin, "key") | |
) |