Skip to content

Instantly share code, notes, and snippets.

View vadimii's full-sized avatar

Vadim Gusev vadimii

View GitHub Profile
@vadimii
vadimii / smapin.py
Created January 19, 2012 08:32
Draw points on map with PIL
import Image
import ImageDraw
# For gsheet module see https://gist.github.com/1638779
import gsheet
# First param is spreadsheet ID and second param is sheet ID
WSHEET='0Atgd-n28fU3PdFFHSzJDNDhTS3NDMGx1NWNEdWNpOEE', 2
CCSHEET='0Atgd-n28fU3PdGlsMTdLRUFqR3JvbktmcWhqTFpSZmc', 0
# Second param is column index in sheet
@vadimii
vadimii / gsheet.py
Created January 19, 2012 08:34
Download data from Google Spreadsheets
import urllib2
DOC_PATH = 'https://docs.google.com/spreadsheet/pub?key=%s&output=txt'
GID_PARAM = '&single=true&gid=%s'
def load(docid, sheetid=None):
srcpath = DOC_PATH % docid
if sheetid != None: srcpath = srcpath + (GID_PARAM % sheetid)
src = urllib2.urlopen(srcpath)
return [l.split('\t') for l in src.readlines()]
@vadimii
vadimii / fphoto.py
Created February 6, 2012 11:27
Sort photo, video files
import os
import re
import shutil
import string
JPEG = re.compile(r'^img_\d{4}\.jpg$', re.I)
MOV = re.compile(r'^img_\d{4}\.mov$', re.I)
DATE = re.compile(r'^.*\d{4}-\d{2}-\d{2}$')
PHOTO_DST_DIR = './photo/'
VIDEO_DST_DIR = './video/'
@vadimii
vadimii / OWLAPIExample.groovy
Created March 13, 2012 17:52
Groovy version of Pellet OWLAPI example
import org.semanticweb.owlapi.apibinding.OWLManager
import com.clarkparsia.pellet.owlapiv3.PelletReasonerFactory
def I = { org.semanticweb.owlapi.model.IRI.create(it) }
def file = "http://www.mindswap.org/2004/owl/mindswappers#"
println "Reading file ${file}…"
def manager = OWLManager.createOWLOntologyManager()
def ontology = manager.loadOntology(I(file))
@vadimii
vadimii / explanations.groovy
Created March 14, 2012 00:19
Groovy OWLAPI explanations example
import java.io.PrintWriter
import org.semanticweb.owlapi.apibinding.OWLManager
import com.clarkparsia.owlapi.explanation.DefaultExplanationGenerator
import com.clarkparsia.owlapi.explanation.io.manchester.ManchesterSyntaxExplanationRenderer
import com.clarkparsia.pellet.owlapiv3.PelletReasonerFactory
def I = { org.semanticweb.owlapi.model.IRI.create(it) }
def file = "http://owl.cs.manchester.ac.uk/repository/download?ontology=" +
"file:/Users/seanb/Desktop/Cercedilla2005/hands-on/people.owl" +
@vadimii
vadimii / rightwards-double-arrow.sublime-snippet
Created March 29, 2012 00:11
Sublime text snippet for RIGHTWARDS DOUBLE ARROW ⇒
<snippet>
<content>⇒</content>
<tabTrigger>=></tabTrigger>
<scope>source.scala</scope>
<description>Insert RIGHTWARDS DOUBLE ARROW ⇒</description>
</snippet>
@vadimii
vadimii / gist:2293206
Created April 3, 2012 16:05
How to get user data from vk.com
// Instructions: http://goo.gl/2JIC2
static void Main(string[] args)
{
var apiUrl = "http://api.vk.com/api.php";
var dict = new Dictionary<string, string>();
dict["api_id"] = "123456"; // Change this!
dict["v"] = "3.0";
dict["format"] = "JSON";
var api_secret = "1JH6TCDi8VBGyxQAZQ1Q"; // Change this!
@vadimii
vadimii / gist:2626164
Created May 7, 2012 05:54
Extract domain structure of lomonosov-fund.ru
# coding=utf-8
import urllib2
import string
import os.path
from lxml.html import fromstring
from lxml import etree
from datetime import datetime
base_url = 'http://www.lomonosov-fund.ru/enc/ru/encyclopedia'
local_cache = 'cache/'
@vadimii
vadimii / gist:2820112
Created May 28, 2012 17:06
WSGI Sanitizer
import webapp2
import html5lib
from html5lib import sanitizer,treebuilders,treewalkers
from html5lib.serializer.htmlserializer import HTMLSerializer
class MainPage(webapp2.RequestHandler):
def post(self):
self.response.headers['Content-Type'] = 'text/plain'
TREE = 'lxml'
input_data = self.request.get('content')
@vadimii
vadimii / gist:2841931
Created May 31, 2012 08:32
T-SQL Filter Selection
declare @DomainCategoryID nvarchar(10)
declare @ProjectType nvarchar(50)
declare @ProjectCuratorID int
declare @Results table (
ID int,
ProjectType nvarchar(50),
ProjectCuratorID int,
Phase nvarchar(50),
Publication nvarchar(50)
)