Skip to content

Instantly share code, notes, and snippets.

View slaporte's full-sized avatar

Stephen LaPorte slaporte

105 followers · 82 following
View GitHub Profile
@slaporte
slaporte / gist:263835cf5f911a3ff04c2da471b4d9c1
Created August 22, 2016 04:22
CREATE TABLE campaign(
id INTEGER PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(255) NOT NULL,
description __,
url __,
);
CREATE TABLE round(
id INTEGER PRIMARY KEY AUTO_INCREMENT,
@slaporte
slaporte / recent-hashtags.sql
Created February 15, 2016 10:08
Select distinct ht.ht_text, ht.ht_update_timestamp
FROM recentchanges AS rc
JOIN hashtag_recentchanges AS htrc
ON htrc.htrc_id = rc.htrc_id
JOIN hashtags AS ht
ON ht.ht_id = htrc.ht_id
WHERE rc.rc_type = 0
AND rc.htrc_lang LIKE 'en'
AND ht.ht_text NOT IN('redirect', 'ifexist', 'switch', 'ifexpr')
AND ht.ht_text REGEXP '[[:alpha:]]+'
@slaporte
slaporte / gist:1b2486ca2b248b874e27
Last active August 29, 2015 14:26 — forked from mahmoud/gist:ee52a8b0a75d80c26353
  • add social search record count
  • change hashtag job to run more frequently
  • change hashtag job to only pull since the last found hashtag (or 24 hours)
  • GeoSearch continuation followup
  • GeoSearch trigger strategy
  • Daily email update (MZMC)
  • Weeklypedia translations
  • Weeklypedia stats RSS
@slaporte
slaporte / gist:26aea3c603d3f61fb88b
Created August 1, 2015 18:35
/(#|＃)([a-z0-9_\u00c0-\u00d6\u00d8-\u00f6\u00f8-\u00ff\u0100-\u024f\u0253-\u0254\u0256-\u0257\u0300-\u036f\u1e00-\u1eff\u0400-\u04ff\u0500-\u0527\u2de0-\u2dff\ua640-\ua69f\u0591-\u05bf\u05c1-\u05c2\u05c4-\u05c5\u05d0-\u05ea\u05f0-\u05f4\ufb12-\ufb28\ufb2a-\ufb36\ufb38-\ufb3c\ufb40-\ufb41\ufb43-\ufb44\ufb46-\ufb4f\u0610-\u061a\u0620-\u065f\u066e-\u06d3\u06d5-\u06dc\u06de-\u06e8\u06ea-\u06ef\u06fa-\u06fc\u0750-\u077f\u08a2-\u08ac\u08e4-\u08fe\ufb50-\ufbb1\ufbd3-\ufd3d\ufd50-\ufd8f\ufd92-\ufdc7\ufdf0-\ufdfb\ufe70-\ufe74\ufe76-\ufefc\u200c-\u200c\u0e01-\u0e3a\u0e40-\u0e4e\u1100-\u11ff\u3130-\u3185\ua960-\ua97f\uac00-\ud7af\ud7b0-\ud7ff\uffa1-\uffdc\u30a1-\u30fa\u30fc-\u30fe\uff66-\uff9f\uff10-\uff19\uff21-\uff3a\uff41-\uff5a\u3041-\u3096\u3099-\u309e\u3400-\u4dbf\u4e00-\u9fff\u20000-\u2a6df\u2a700-\u2b73f\u2b740-\u2b81f\u2f800-\u2fa1f]*[a-z_\u00c0-\u00d6\u00d8-\u00f6\u00f8-\u00ff\u0100-\u024f\u0253-\u0254\u0256-\u0257\u0300-\u036f\u1e00-\u1eff\u0400-\u04ff\u0500-\u0527\u2de0-\u2dff\ua640-\ua69f\u0591-\u05bf\u05c1
@slaporte
slaporte / cawiki
Last active August 29, 2015 14:26
Most edited Wikipedia articles, by lanuguage
+------------------------------------------------+----------+
| page_title | COUNT(*) |
+------------------------------------------------+----------+
| Haskell | 4565 |
| Activisme_pedòfil | 4139 |
| Futbol_Club_Barcelona | 3756 |
| Esperanto | 3362 |
| Compilador_Haskell_de_Glasgow | 2361 |
| Múscul_flexor_curt_dels_dits_del_peu | 2126 |
| Barcelona | 2122 |
@slaporte
slaporte / eswp_top_articles.md
Last active August 29, 2015 14:26
Most edited Spanish Wikipedia articles (July 28, 2015)
@slaporte
slaporte / another.sql
Last active August 29, 2015 14:24
SELECT rc.rc_id,
rc.rc_cur_id,
rc.rc_title,
rc.rc_timestamp,
rc.rc_this_oldid,
rc.rc_last_oldid,
rc.rc_user_text,
rc.rc_old_len,
rc.rc_new_len,
rc.rc_comment
@slaporte
slaporte / hashtag_sync.py
Created July 13, 2015 02:30
import os
import oursql
from .utils import find_hashtags
'''
Schema TODO:
- unique index on lang and rcid
- add update_date
'''
@slaporte
slaporte / all_licenses.json
Created July 12, 2015 19:33
{
"1000Bit": {
"2004": 0,
"2005": 0,
"2006": 6,
"2007": 0,
"2008": 3,
"2009": 0,
"2010": 0,
"2011": 0,
@slaporte
slaporte / eswp_weeklypedia.md
Last active August 29, 2015 14:24
Spanish Weeklypedia: June 25 - July 2

Spanish Weeklypedia: June 25 - July 2

Articles

20,119 authors made 102,175 contributions to 38,859 different articles. The top 20 articles:

  1. Ain't It Fun (canción de Paramore) (251 changes by 1 authors)

  2. Ibahernando (242 changes by 4 authors)