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") | |
| ) |