Skip to content

Instantly share code, notes, and snippets.

Keybase proof

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:

@RhinosF1
RhinosF1 / wikidiscoverparser.py
Last active June 9, 2020 22:57
This script will create a list of apis for all public miraheze.org wikis.
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")
)