
import requests

S = requests.Session()

URL = "https://de.wikipedia.org/w/api.php"

def query(params):
    R = S.post(url=URL, params=params)
    print()
    return R.json()['query']


PARAMS = {
	"action": "query",
	"format": "json",
	"list": "categorymembers",
	"cmlimit": "max",
	"cmtitle": "Kategorie:Mitgliedstaat der Vereinten Nationen",
    "cmnamespace": "0"
}

DATA = query(PARAMS)['categorymembers']
staaten_in_un = [page['title'] for page in DATA]
del staaten_in_un[0]


PARAMS = {
	"action": "query",
	"format": "json",
	"list": "categorymembers",
	"cmlimit": "max",
	"cmtitle": "Kategorie:Vorlage:Wartungsbaustein"
}

DATA = query(PARAMS)['categorymembers']
wartungsbausteine = [page['title'][8:] for page in DATA]


def get_data(land):
    PARAMS = {
	"action": "query",
	"format": "json",
	"prop": "templates|info|images",
	"titles": land,
	"tlnamespace": "10",
	"tllimit": "max",
    "imlimit": "max"
    }

    DATA = query(PARAMS)['pages']
    return next(iter(DATA.values()))


nr_lesenswert = 0
nr_exzellent = 0
wartungs_frei = 0
all_templates = []
print("{| class=\"sortable\"", end="")
print("! Land !! auszeichnung !! Größe (kb) !! letzte Änderung !! Bilder !! Fotos !! Wartungsbausteine", end="")
for land in map(get_data, staaten_in_un):
    print("|-")
    title = land['title']
    try:
        # Get all templates without "Vorlage:" prefix
        templates = [t['title'][8:] for t in land['templates']]
        all_templates += templates
        if 'Exzellent' in templates:
            auszeichnung = "{{BE|e}}"
            nr_exzellent += 1
        elif 'Lesenswert' in templates:
            auszeichnung = "{{BE|l}}"
            nr_lesenswert += 1
        else:
            auszeichnung = '-'
        # check if a 'wartungsbaustein is used'
        bausteine = [baustein for baustein in wartungsbausteine if baustein in templates]
        if len(bausteine) == 0:
            wartungs_frei += 1
        s_bausteine = ", ".join(bausteine)
        length = land['length']
        touched = land['touched'][:10]
        images = land['images']
        nr_images = len(images)
        # Search for jpg images, since those are mostly photographies,
        # while others are usually flags, maps, diagramms, ...
        nr_jpg = len([img for img in images if img['title'][-3:].lower() == "jpg" or img['title'][-3:].lower() == "jpeg"])
        print(f"| [[{title}]] || {auszeichnung} || {round(length/1024)} || {touched} || {nr_images} || {nr_jpg} || {s_bausteine}", end="")
    except Exception as e:
        print("ERROR", title, e, land.keys())
print("\n|}")

{| class="sortable"! Land !! auszeichnung !! Größe (kb) !! letzte Änderung !! Bilder !! Fotos !! Wartungsbausteine
|-
| [[Afghanistan]] || {{BE|l}} || 166 || 2020-06-19 || 54 || 25 || 
|-
| [[Ägypten]] || - || 140 || 2020-06-22 || 61 || 21 || 
|-
| [[Albanien]] || - || 154 || 2020-06-22 || 57 || 31 || 
|-
| [[Algerien]] || - || 124 || 2020-06-22 || 42 || 9 || Veraltet
|-
| [[Andorra]] || - || 90 || 2020-06-22 || 38 || 14 || Belege fehlen, Toter Link
|-
| [[Angola]] || - || 139 || 2020-06-22 || 38 || 15 || Toter Link
|-
| [[Antigua und Barbuda]] || - || 27 || 2020-06-18 || 19 || 2 || 
|-
| [[Äquatorialguinea]] || - || 52 || 2020-06-23 || 19 || 2 || Belege fehlen, Veraltet
|-
| [[Argentinien]] || {{BE|e}} || 173 || 2020-06-22 || 83 || 36 || Veraltet
|-
| [[Armenien]] || - || 155 || 2020-06-22 || 83 || 46 || Belege fehlen
|-
| [[Aserbaidschan]] || - || 94 || 2020-06-22 || 30 || 5 || 
|-
| [[Äthiopien]] || - || 140 || 2020-06-22 || 41 || 17 || Veraltet
|-
| [[Australien]] || {{BE|e}} || 171 || 2020-06-22 || 100 || 38 || 
|-
| [[Bahamas]] || - || 35 || 2020-06-22 || 23 || 6 || 
|-
| [[Bahrain]] || - || 51 || 2020-06-22 || 20 || 6 || 
|-
| [[Bangladesch]] || - || 109 || 2020-06-15 || 42 || 16 || 
|-
| [[Barbados]] || - || 25 || 2020-06-22 || 20 || 2 || 
|-
| [[Belgien]] || - || 117 || 2020-06-21 || 88 || 35 || 
|-
| [[Belize]] || - || 65 || 2020-06-22 || 30 || 9 || Belege fehlen
|-
| [[Benin]] || - || 48 || 2020-06-22 || 27 || 10 || 
|-
| [[Bhutan]] || - || 72 || 2020-06-22 || 26 || 9 || Veraltet
|-
| [[Bolivien]] || - || 104 || 2020-06-15 || 51 || 15 || 
|-
| [[Bosnien und Herzegowina]] || - || 103 || 2020-06-22 || 52 || 22 || 
|-
| [[Botswana]] || - || 79 || 2020-06-15 || 27 || 8 || 
|-
| [[Brasilien]] || {{BE|l}} || 209 || 2020-06-23 || 118 || 64 || Belege fehlen
|-
| [[Brunei]] || - || 52 || 2020-06-22 || 21 || 3 || Belege fehlen
|-
| [[Bulgarien]] || - || 144 || 2020-06-23 || 58 || 25 || 
|-
| [[Burkina Faso]] || - || 124 || 2020-06-15 || 75 || 39 || 
|-
| [[Burundi]] || - || 43 || 2020-06-18 || 17 || 3 || 
|-
| [[Chile]] || - || 209 || 2020-06-22 || 112 || 53 || 
|-
| [[Costa Rica]] || - || 78 || 2020-06-22 || 39 || 16 || Toter Link
|-
| [[Dänemark]] || - || 145 || 2020-06-22 || 84 || 38 || 
|-
| [[Deutschland]] || - || 235 || 2020-06-23 || 148 || 56 || Toter Link
|-
| [[Dominica]] || - || 37 || 2020-06-22 || 25 || 8 || 
|-
| [[Dominikanische Republik]] || - || 76 || 2020-06-15 || 26 || 12 || 
|-
| [[Dschibuti]] || - || 52 || 2020-06-22 || 18 || 4 || 
|-
| [[Ecuador]] || - || 109 || 2020-06-22 || 87 || 34 || Redundanztext, Toter Link
|-
| [[El Salvador]] || - || 69 || 2020-06-22 || 27 || 8 || 
|-
| [[Elfenbeinküste]] || {{BE|l}} || 131 || 2020-06-15 || 38 || 21 || Toter Link
|-
| [[Eritrea]] || - || 63 || 2020-06-22 || 24 || 5 || Toter Link
|-
| [[Estland]] || - || 97 || 2020-06-22 || 46 || 20 || Überarbeiten
|-
| [[Fidschi]] || - || 60 || 2020-06-22 || 28 || 5 || Belege fehlen
|-
| [[Finnland]] || {{BE|e}} || 177 || 2020-06-15 || 88 || 43 || Toter Link
|-
| [[Frankreich]] || - || 194 || 2020-06-22 || 95 || 39 || Toter Link
|-
| [[Gabun]] || - || 45 || 2020-06-22 || 25 || 7 || 
|-
| [[Gambia]] || {{BE|l}} || 95 || 2020-06-22 || 60 || 38 || Überarbeiten
|-
| [[Georgien]] || {{BE|l}} || 109 || 2020-06-15 || 57 || 22 || 
|-
| [[Ghana]] || {{BE|e}} || 154 || 2020-06-22 || 55 || 33 || Belege fehlen, Veraltet
|-
| [[Grenada]] || - || 29 || 2020-06-22 || 22 || 4 || 
|-
| [[Griechenland]] || - || 219 || 2020-06-23 || 94 || 40 || Belege fehlen, Überarbeiten
|-
| [[Guatemala]] || - || 76 || 2020-06-22 || 21 || 4 || Toter Link
|-
| [[Guinea]] || - || 63 || 2020-06-22 || 19 || 2 || Belege fehlen
|-
| [[Guinea-Bissau]] || - || 53 || 2020-06-21 || 19 || 4 || 
|-
| [[Guyana]] || - || 39 || 2020-06-22 || 21 || 2 || 
|-
| [[Haiti]] || - || 81 || 2020-06-15 || 36 || 19 || 
|-
| [[Honduras]] || - || 86 || 2020-06-22 || 32 || 8 || Belege fehlen
|-
| [[Indien]] || {{BE|e}} || 250 || 2020-06-22 || 93 || 33 || 
|-
| [[Indonesien]] || - || 104 || 2020-06-15 || 45 || 13 || Toter Link
|-
| [[Irak]] || - || 111 || 2020-06-22 || 34 || 13 || Überarbeiten
|-
| [[Iran]] || - || 347 || 2020-06-22 || 88 || 43 || Redundanztext, Toter Link, Überarbeiten
|-
| [[Irland]] || - || 87 || 2020-06-23 || 57 || 22 || 
|-
| [[Island]] || {{BE|l}} || 141 || 2020-06-22 || 64 || 34 || 
|-
| [[Israel]] || {{BE|l}} || 218 || 2020-06-22 || 92 || 54 || 
|-
| [[Italien]] || - || 209 || 2020-06-23 || 150 || 65 || 
|-
| [[Jamaika]] || {{BE|l}} || 122 || 2020-06-22 || 41 || 15 || Belege fehlen
|-
| [[Japan]] || {{BE|l}} || 159 || 2020-06-22 || 83 || 37 || Toter Link
|-
| [[Jemen]] || - || 111 || 2020-06-22 || 35 || 16 || 
|-
| [[Jordanien]] || - || 55 || 2020-06-15 || 27 || 8 || 
|-
| [[Kambodscha]] || - || 175 || 2020-06-15 || 55 || 33 || 
|-
| [[Kamerun]] || - || 83 || 2020-06-22 || 34 || 9 || Überarbeiten
|-
| [[Kanada]] || {{BE|e}} || 210 || 2020-06-22 || 128 || 68 || 
|-
| [[Kap Verde]] || - || 56 || 2020-06-22 || 20 || 4 || 
|-
| [[Kasachstan]] || - || 129 || 2020-06-22 || 85 || 29 || Toter Link, Veraltet, Überarbeiten
|-
| [[Katar]] || - || 81 || 2020-06-22 || 34 || 8 || Belege fehlen, Veraltet
|-
| [[Kenia]] || - || 99 || 2020-06-22 || 41 || 7 || 
|-
| [[Kirgisistan]] || - || 76 || 2020-06-22 || 41 || 15 || Überarbeiten
|-
| [[Kiribati]] || - || 44 || 2020-06-17 || 33 || 12 || 
|-
| [[Kolumbien]] || - || 164 || 2020-06-23 || 75 || 26 || Belege fehlen, Redundanztext, Veraltet
|-
| [[Komoren]] || - || 30 || 2020-06-23 || 27 || 1 || Lückenhaft, Veraltet
|-
| [[Demokratische Republik Kongo]] || - || 166 || 2020-06-22 || 68 || 35 || 
|-
| [[Republik Kongo]] || - || 41 || 2020-06-22 || 28 || 5 || 
|-
| [[Kroatien]] || - || 130 || 2020-06-22 || 88 || 34 || Toter Link, Veraltet
|-
| [[Kuba]] || - || 247 || 2020-06-22 || 63 || 28 || Toter Link, Veraltet
|-
| [[Kuwait]] || - || 54 || 2020-06-22 || 18 || 3 || Belege fehlen
|-
| [[Laos]] || {{BE|l}} || 96 || 2020-06-22 || 37 || 20 || 
|-
| [[Lesotho]] || {{BE|e}} || 77 || 2020-06-19 || 32 || 15 || 
|-
| [[Lettland]] || - || 90 || 2020-06-15 || 32 || 5 || 
|-
| [[Libanon]] || - || 71 || 2020-06-22 || 25 || 7 || Toter Link
|-
| [[Liberia]] || - || 156 || 2020-06-22 || 50 || 26 || Toter Link
|-
| [[Libyen]] || - || 112 || 2020-06-22 || 37 || 9 || Toter Link
|-
| [[Liechtenstein]] || - || 160 || 2020-06-23 || 98 || 41 || 
|-
| [[Litauen]] || - || 86 || 2020-06-22 || 45 || 14 || 
|-
| [[Luxemburg]] || - || 212 || 2020-06-22 || 111 || 28 || Toter Link
|-
| [[Madagaskar]] || - || 89 || 2020-06-22 || 36 || 15 || 
|-
| [[Malawi]] || - || 71 || 2020-06-22 || 25 || 10 || Belege fehlen
|-
| [[Malaysia]] || - || 82 || 2020-06-22 || 48 || 12 || Redundanztext, Toter Link
|-
| [[Malediven]] || - || 57 || 2020-06-22 || 30 || 17 || 
|-
| [[Mali]] || - || 192 || 2020-06-22 || 45 || 23 || Toter Link
|-
| [[Malta]] || - || 183 || 2020-06-22 || 45 || 26 || Toter Link
|-
| [[Marokko]] || - || 115 || 2020-06-22 || 36 || 14 || Toter Link
|-
| [[Marshallinseln]] || - || 37 || 2020-06-15 || 16 || 3 || 
|-
| [[Mauretanien]] || - || 62 || 2020-06-22 || 22 || 5 || 
|-
| [[Mauritius]] || - || 54 || 2020-06-22 || 34 || 16 || Lückenhaft
|-
| [[Mexiko]] || - || 175 || 2020-06-22 || 131 || 53 || Toter Link, Veraltet, Überarbeiten
|-
| [[Föderierte Staaten von Mikronesien]] || - || 21 || 2020-06-15 || 21 || 2 || 
|-
| [[Republik Moldau]] || - || 100 || 2020-06-22 || 45 || 17 || 
|-
| [[Monaco]] || - || 67 || 2020-06-23 || 42 || 19 || 
|-
| [[Mongolei]] || - || 122 || 2020-06-22 || 63 || 40 || Belege fehlen, Toter Link, Überarbeiten
|-
| [[Montenegro]] || - || 65 || 2020-06-22 || 39 || 13 || 
|-
| [[Mosambik]] || - || 73 || 2020-06-22 || 25 || 6 || 
|-
| [[Myanmar]] || - || 111 || 2020-06-22 || 46 || 22 || Belege fehlen, Überarbeiten
|-
| [[Namibia]] || - || 78 || 2020-06-22 || 45 || 21 || Belege fehlen
|-
| [[Nauru]] || {{BE|l}} || 88 || 2020-06-17 || 32 || 8 || 
|-
| [[Nepal]] || - || 84 || 2020-06-22 || 43 || 19 || 
|-
| [[Neuseeland]] || {{BE|l}} || 192 || 2020-06-22 || 70 || 45 || 
|-
| [[Nicaragua]] || - || 91 || 2020-06-17 || 49 || 15 || Toter Link
|-
| [[Königreich der Niederlande]] || - || 23 || 2020-06-22 || 27 || 2 || 
|-
| [[Niger]] || - || 79 || 2020-06-22 || 39 || 13 || 
|-
| [[Nigeria]] || - || 116 || 2020-06-22 || 48 || 12 || Belege fehlen, Toter Link
|-
| [[Nordkorea]] || - || 163 || 2020-06-15 || 39 || 19 || 
|-
| [[Nordmazedonien]] || - || 108 || 2020-06-15 || 39 || 16 || 
|-
| [[Norwegen]] || - || 144 || 2020-06-23 || 115 || 63 || 
|-
| [[Oman]] || - || 60 || 2020-06-23 || 23 || 8 || 
|-
| [[Österreich]] || {{BE|l}} || 257 || 2020-06-22 || 134 || 77 || Veraltet
|-
| [[Osttimor]] || {{BE|e}} || 240 || 2020-06-22 || 138 || 99 || 
|-
| [[Pakistan]] || {{BE|l}} || 196 || 2020-06-22 || 81 || 24 || Toter Link, Veraltet
|-
| [[Palau]] || - || 37 || 2020-06-22 || 36 || 6 || Überarbeiten
|-
| [[Panama]] || - || 51 || 2020-06-22 || 27 || 10 || 
|-
| [[Papua-Neuguinea]] || - || 50 || 2020-06-15 || 17 || 2 || 
|-
| [[Paraguay]] || - || 80 || 2020-06-22 || 42 || 16 || 
|-
| [[Peru]] || - || 147 || 2020-06-22 || 44 || 22 || 
|-
| [[Philippinen]] || - || 172 || 2020-06-23 || 51 || 14 || Toter Link
|-
| [[Polen]] || - || 389 || 2020-06-22 || 332 || 198 || Toter Link
|-
| [[Portugal]] || - || 153 || 2020-06-22 || 85 || 38 || 
|-
| [[Ruanda]] || - || 101 || 2020-06-15 || 36 || 16 || Toter Link
|-
| [[Rumänien]] || - || 137 || 2020-06-22 || 91 || 32 || Toter Link
|-
| [[Russland]] || - || 381 || 2020-06-23 || 155 || 97 || Belege fehlen, Veraltet
|-
| [[Salomonen]] || - || 48 || 2020-06-22 || 32 || 15 || Toter Link
|-
| [[Sambia]] || - || 51 || 2020-06-22 || 25 || 7 || 
|-
| [[Samoa]] || - || 40 || 2020-06-22 || 38 || 10 || 
|-
| [[San Marino]] || - || 73 || 2020-06-22 || 36 || 18 || Belege fehlen
|-
| [[São Tomé und Príncipe]] || - || 34 || 2020-06-15 || 25 || 4 || 
|-
| [[Saudi-Arabien]] || - || 181 || 2020-06-22 || 64 || 20 || Belege fehlen, Toter Link, Überarbeiten
|-
| [[Schweden]] || - || 137 || 2020-06-23 || 71 || 29 || 
|-
| [[Schweiz]] || - || 340 || 2020-06-22 || 158 || 67 || 
|-
| [[Senegal]] || - || 107 || 2020-06-22 || 34 || 15 || 
|-
| [[Serbien]] || - || 268 || 2020-06-22 || 86 || 54 || 
|-
| [[Seychellen]] || - || 43 || 2020-06-22 || 32 || 18 || 
|-
| [[Sierra Leone]] || - || 75 || 2020-06-15 || 38 || 19 || 
|-
| [[Simbabwe]] || - || 102 || 2020-06-23 || 42 || 9 || 
|-
| [[Singapur]] || - || 116 || 2020-06-22 || 58 || 30 || 
|-
| [[Slowakei]] || {{BE|l}} || 287 || 2020-06-22 || 115 || 66 || 
|-
| [[Slowenien]] || - || 71 || 2020-06-15 || 52 || 25 || 
|-
| [[Somalia]] || - || 77 || 2020-06-23 || 62 || 19 || Toter Link, Veraltet
|-
| [[Spanien]] || - || 151 || 2020-06-21 || 117 || 31 || 
|-
| [[Sri Lanka]] || - || 110 || 2020-06-22 || 60 || 26 || Überarbeiten
|-
| [[St. Lucia]] || - || 29 || 2020-06-22 || 21 || 4 || 
|-
| [[St. Kitts und Nevis]] || - || 23 || 2020-06-22 || 17 || 1 || Lückenhaft
|-
| [[St. Vincent und die Grenadinen]] || - || 18 || 2020-06-15 || 23 || 7 || 
|-
| [[Südafrika]] || {{BE|e}} || 205 || 2020-06-23 || 101 || 44 || Veraltet
|-
| [[Sudan]] || - || 86 || 2020-06-22 || 33 || 12 || Belege fehlen, Toter Link, Überarbeiten
|-
| [[Südkorea]] || {{BE|l}} || 206 || 2020-06-23 || 62 || 28 || 
|-
| [[Südsudan]] || - || 64 || 2020-06-15 || 30 || 3 || 
|-
| [[Suriname]] || - || 65 || 2020-06-22 || 24 || 7 || 
|-
| [[Swasiland]] || - || 49 || 2020-06-20 || 29 || 8 || 
|-
| [[Syrien]] || - || 100 || 2020-06-22 || 40 || 22 || Toter Link
|-
| [[Tadschikistan]] || - || 59 || 2020-06-22 || 30 || 4 || Veraltet
|-
| [[Tansania]] || - || 111 || 2020-06-22 || 29 || 5 || Belege fehlen
|-
| [[Thailand]] || - || 168 || 2020-06-22 || 52 || 26 || 
|-
| [[Togo]] || - || 44 || 2020-06-22 || 20 || 3 || 
|-
| [[Tonga]] || - || 42 || 2020-06-22 || 26 || 9 || Belege fehlen, Toter Link, Überarbeiten
|-
| [[Trinidad und Tobago]] || - || 48 || 2020-06-15 || 24 || 5 || 
|-
| [[Tschad]] || - || 77 || 2020-06-15 || 19 || 4 || 
|-
| [[Tschechien]] || - || 130 || 2020-06-23 || 86 || 53 || 
|-
| [[Tunesien]] || - || 140 || 2020-06-22 || 60 || 24 || Belege fehlen
|-
| [[Türkei]] || - || 227 || 2020-06-22 || 77 || 34 || Toter Link, Veraltet
|-
| [[Turkmenistan]] || - || 95 || 2020-06-22 || 31 || 9 || 
|-
| [[Tuvalu]] || - || 32 || 2020-06-22 || 16 || 2 || Toter Link
|-
| [[Uganda]] || - || 70 || 2020-06-22 || 33 || 10 || 
|-
| [[Ukraine]] || - || 187 || 2020-06-23 || 102 || 40 || Lückenhaft, Toter Link
|-
| [[Ungarn]] || {{BE|l}} || 153 || 2020-06-23 || 84 || 34 || Belege fehlen
|-
| [[Uruguay]] || {{BE|l}} || 128 || 2020-06-22 || 60 || 27 || 
|-
| [[Usbekistan]] || - || 115 || 2020-06-23 || 55 || 24 || Toter Link, Veraltet
|-
| [[Vanuatu]] || - || 33 || 2020-06-16 || 37 || 11 || 
|-
| [[Venezuela]] || - || 351 || 2020-06-22 || 58 || 18 || Toter Link
|-
| [[Vereinigte Arabische Emirate]] || - || 127 || 2020-06-22 || 78 || 30 || 
|-
| [[Vereinigte Staaten]] || - || 257 || 2020-06-22 || 113 || 54 || Lückenhaft
|-
| [[Vereinigtes Königreich]] || - || 167 || 2020-06-22 || 97 || 38 || Belege fehlen, Toter Link
|-
| [[Vietnam]] || - || 129 || 2020-06-22 || 70 || 36 || 
|-
| [[Volksrepublik China]] || - || 210 || 2020-06-23 || 84 || 48 || Belege fehlen
|-
| [[Weißrussland]] || - || 106 || 2020-06-23 || 57 || 16 || Überarbeiten
|-
| [[Zentralafrikanische Republik]] || - || 44 || 2020-06-22 || 17 || 1 || Überarbeiten
|-
| [[Republik Zypern]] || - || 55 || 2020-06-21 || 38 || 16 || 
|}


rate_exzellent = nr_exzellent / len(staaten_in_un) * 100
rate_lesenswert = nr_lesenswert / len(staaten_in_un) * 100
rate_ausgezeichnet = (nr_exzellent + nr_lesenswert) / len(staaten_in_un) * 100
rate_wartungs_frei = wartungs_frei / len(staaten_in_un) * 100

print("Exzellent: %0.2f%%" % rate_exzellent)
print("Lesenswert: %0.2f%%" % rate_lesenswert)
print("Exzellent/Lesenswert: %0.2f%%" % rate_ausgezeichnet)
print("Keine Wartungsbausteine: %0.2f%%" % rate_wartungs_frei)

Exzellent: 4.66%
Lesenswert: 9.33%
Exzellent/Lesenswert: 13.99%
Keine Wartungsbausteine: 54.40%

Wikipedia Artikel zu allen Staaten der Vereinten Nationen¶

Alle Mitglieder der Vereinten Nationen abfragen¶

Alle Wartungsbausteine abfragen¶

Informationen zu einem Land abrufen¶

Daten für alle Länder abfragen und Tabelle generieren¶

Statistik¶