Skip to content

Instantly share code, notes, and snippets.

View filbertkm's full-sized avatar
😺

Katie Filbert filbertkm

😺
View GitHub Profile
{"enwiki_content_first":{"mappings":{"page":{"dynamic":"false","_all":{"enabled":false},"properties":{"all":{"type":"string","term_vector":"with_positions_offsets","similarity":"default","fields":{"plain":{"type":"string","term_vector":"with_positions_offsets","similarity":"default","analyzer":"plain","search_analyzer":"plain_search","position_increment_gap":10}},"analyzer":"text","search_analyzer":"text_search","position_increment_gap":10},"all_near_match":{"type":"string","norms":{"enabled":false},"index_options":"freqs","similarity":"default","fields":{"asciifolding":{"type":"string","norms":{"enabled":false},"index_options":"freqs","similarity":"default","analyzer":"near_match_asciifolding","position_increment_gap":10}},"analyzer":"near_match","position_increment_gap":10},"auxiliary_text":{"type":"string","term_vector":"with_positions_offsets","similarity":"default","fields":{"plain":{"type":"string","term_vector":"with_positions_offsets","similarity":"default","analyzer":"plain","search_analyzer":"plain_
{"enwiki_content_first":{"mappings":{"page":{"dynamic":"false","_all":{"enabled":false},"properties":{"all":{"type":"string","term_vector":"with_positions_offsets","similarity":"default","fields":{"plain":{"type":"string","term_vector":"with_positions_offsets","similarity":"default","analyzer":"plain","search_analyzer":"plain_search","position_increment_gap":10}},"analyzer":"text","search_analyzer":"text_search","position_increment_gap":10},"all_near_match":{"type":"string","norms":{"enabled":false},"index_options":"freqs","similarity":"default","fields":{"asciifolding":{"type":"string","norms":{"enabled":false},"index_options":"freqs","similarity":"default","analyzer":"near_match_asciifolding","position_increment_gap":10}},"analyzer":"near_match","position_increment_gap":10},"auxiliary_text":{"type":"string","term_vector":"with_positions_offsets","similarity":"default","fields":{"plain":{"type":"string","term_vector":"with_positions_offsets","similarity":"default","analyzer":"plain","search_analyzer":"plain_
Uncaught TypeError: Cannot read property 'id' of undefined
(anonymous function) @ airlock.bundle-0ec4ca10a970193d94dbfd1ab560bdad.js:formatted:3094
e @ airlock.bundle-0ec4ca10a970193d94dbfd1ab560bdad.js:formatted:3093
e @ airlock.bundle-0ec4ca10a970193d94dbfd1ab560bdad.js:formatted:3084
e @ airlock.bundle-0ec4ca10a970193d94dbfd1ab560bdad.js:formatted:3201
e @ airlock.bundle-0ec4ca10a970193d94dbfd1ab560bdad.js:formatted:3170
e @ airlock.bundle-0ec4ca10a970193d94dbfd1ab560bdad.js:formatted:3071
(anonymous function) @ airlock.bundle-0ec4ca10a970193d94dbfd1ab560bdad.js:formatted:4905
(anonymous function) @ airlock.bundle-0ec4ca10a970193d94dbfd1ab560bdad.js:formatted:4904
p @ airlock.bundle-0ec4ca10a970193d94dbfd1ab560bdad.js:formatted:4880
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@filbertkm
filbertkm / gist:3fef89d16f4ae384af1e
Last active February 11, 2016 20:44
number of museums per country
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?isoCode (count(*) as ?count) WHERE {
?place wdt:P31/wdt:P279* wd:Q33506 .
?place wdt:P17 ?country .
?country wdt:P297 ?isoCode
}
MariaDB [enwiki_p]> select * from wbc_entity_usage where eu_page_id = 6046882;
+-----------+--------------+-----------+------------+----------------+
| eu_row_id | eu_entity_id | eu_aspect | eu_page_id | eu_touched |
+-----------+--------------+-----------+------------+----------------+
| 9113895 | Q6467890 | T | 6046882 | 20160123103100 |
| 11826516 | Q6467890 | X | 6046882 | 20160123103100 |
+-----------+--------------+-----------+------------+----------------+
@filbertkm
filbertkm / gist:364e52f028e65b314d86
Created January 23, 2016 15:22
leduc county - no sidebar links
<!--
NewPP limit report
Parsed by mw1236
Cached time: 20160123045939
Cache expiry: 2592000
Dynamic content: false
CPU time usage: 0.452 seconds
Real time usage: 0.568 seconds
Preprocessor visited node count: 4439/1000000
Preprocessor generated node count: 0/1500000
post login
* action=login
* lgname=Bot
* lgpassword=Password
array (
'login' =>
array (
'result' => 'NeedToken',
2016-01-20 18:09:16 cirrusSearchElasticaWrite Q14475 clientSideTimeout= method=sendData arguments=array(3) cluster=default createdAt=1452822217 errorCount=1 retryCount=0 (id=139253,timestamp=20160115014337) t=593 good
Notice: Unable to unserialize: [a:7:{s:17:"clientSideTimeout";N;s:6:"method";s:8:"sendData";s:9:"arguments";a:3:{i:0;s:7:"content";i:1;a:10:{i:0;O:15:"Elastica\Script":5:{s:24:"]. Unexpected end of buffer during unserialization. in /var/www/wiki/w/includes/jobqueue/JobQueueDB.php on line 803
Fatal error: Invalid operand type was used: cannot perform this operation with arrays in /var/www/wiki/w/extensions/CirrusSearch/includes/Job/ElasticaWrite.php on line 45
{
"description": "full_text search for 'life'",
"path": "wikidatawiki_content\/page\/_search",
"params": {
"timeout": "20s"
},
"query": {
"_source": [
"id",
"title",