User:Damian Yerrick/crosswick worksheet: Difference between revisions
User:Damian Yerrick/crosswick worksheet (view source)
Revision as of 23:02, 12 August 2014
, 9 years agogetting regexp into SQLite
No edit summary |
(getting regexp into SQLite) |
||
Line 6:
<!-- sql
/* show relevant parts of schema */
select sql from sqlite_master where tbl_name in ('pages', 'links');
Line 14 ⟶ 15:
select '*[['||pages.title||']]' from pages inner join links on pages.pageid = links.from_pageid
where links.manner = 'wick' and links.to_title = 'Cracked' and pages.title like '%/%';
/* I did a few hundred manually by going down SP:WLH/Cracked. Then I did research on how to get regexps working in Python sqlite
https://stackoverflow.com/a/5365533/2738262
and now I continue with the queries */
/* potholed quotations */
select '*[['||title||']]' from pages
where lower(markup) like '[[cracked|'
-->
The other is that a lot of trope pages link to ''[[Cracked]]'' Mazagine when ''[[Cracked.com]]'' was intended.
Go down the list at [[Special:WhatLinksHere/Cracked]] until I can think of some new queries to run on my partial database dump.
*[[Broke NCYDE]]
*[[Hitman (video game series)]]
*[[Badass Mustache]]
*[[The Problem with Pen Island/Just for Fun]]
*[[Convenient Misfire]]
*[[Painting the Medium]]
*[[There Will Be Blood]]
*[[John F. Kennedy]]
*[[Mastermind World Conqueror]]
*[[No Sell]]
*[[Incestuous Casting]]
*[[The Aggressive Drug Dealer]]
*[[George Washington]]
*[[Magazine Decay]]
*[[Ultimate Evil]]
*[[Major Injury Underreaction]]
*[[Made of Iron]]
| |||