Overleg gebruiker:Valhallasw/subsect

saus \\o

pages = {}
for i in range(20):
  pages[i] = []

pages[14] = [u"Politieke_partij_naar_land"]

for cat in pages[14]:
  wikipedia.output(cat)
  res = Q.do("select page_namespace, page_title from nlwiki_p.categorylinks left join nlwiki_p.page on cl_from = page_id where cl_to=%s", cat);
  for page in res:
    page['page_title'] = page['page_title'].decode('utf-8')
    if page['page_title'] not in pages[page['page_namespace']]:
      pages[page['page_namespace']].append(page['page_title'])

id = {}
for i in range(20):
  id[i] = []

id[14] = [u"Politieke_partij_naar_ideologie"]

for cat in id[14]:
  wikipedia.output(cat)
  res = Q.do("select page_namespace, page_title from nlwiki_p.categorylinks left join nlwiki_p.page on cl_from = page_id where cl_to=%s", cat);
  for page in res:
    page['page_title'] = page['page_title'].decode('utf-8')
    if page['page_title'] not in id[page['page_namespace']]:
      id[page['page_namespace']].append(page['page_title'])

up = {}
for i in range(15):
  up[i] = []

for ns in range(15):
  nsname = F.namespaces[ns]['_default']
  for diff in (set(id[ns]) ^ set(pages[ns])):
    if nsname:
      diff = nsname + ':' + diff
    up[ns].append(wikipedia.Page(wikipedia.getSite(), diff))

ustr = u''
for ns in range(15):
  if 'nl' in F.namespaces[ns]:
    nsname = F.namespaces[ns]['nl']
  else:
    nsname = F.namespaces[ns]['_default']
  if nsname:
    ustr = ustr + '\n\n=Namespace %i (%r)=' % (ns, F.namespaces[ns]['_default'])
  else:
    ustr = ustr + '\n\n=Namespace %i=' % (ns)
  for page in up[ns]:
    ustr=ustr+'\n*[['+page.title()+']]'