Skip to content

Instantly share code, notes, and snippets.

View zverok's full-sized avatar

Victor Shepelev zverok

495 followers · 50 following
View GitHub Profile
@zverok
zverok / gist:6422227
Created September 3, 2013 10:33
ALTER TABLE mentions_client_2 DROP COLUMN `journal_community_id`, DROP COLUMN `journal_user_id`, DROP COLUMN `journal_is_client_journal`, DROP COLUMN `source_id`, DROP COLUMN `source_url`, DROP COLUMN `deleted`, ADD COLUMN `manual_spam` boolean NULL DEFAULT '0';
ALTER TABLE mentions_client_3 DROP COLUMN `journal_community_id`, DROP COLUMN `journal_user_id`, DROP COLUMN `journal_is_client_journal`, DROP COLUMN `source_id`, DROP COLUMN `source_url`, DROP COLUMN `deleted`, ADD COLUMN `manual_spam` boolean NULL DEFAULT '0';
ALTER TABLE mentions_client_4 DROP COLUMN `journal_community_id`, DROP COLUMN `journal_user_id`, DROP COLUMN `journal_is_client_journal`, DROP COLUMN `source_id`, DROP COLUMN `source_url`, DROP COLUMN `deleted`, ADD COLUMN `manual_spam` boolean NULL DEFAULT '0';
ALTER TABLE mentions_client_5 DROP COLUMN `journal_community_id`, DROP COLUMN `journal_user_id`, DROP COLUMN `journal_is_client_journal`, DROP COLUMN `source_id`, DROP COLUMN `source_url`, DROP COLUMN `deleted`, ADD COLUMN `manual_spam
@zverok
zverok / gist:6449709
Created September 5, 2013 12:54
sheet "Обзор" do
cell 'C2', report_meta
cell 'C7', @mentions.summary['value']
cell 'D7', @mentions.summary['change_pct']
cell 'C9', @mentioners.summary['value']
cell 'D9', @mentioners.summary['change_pct']
cell 'C11', @reputation_index.summary['value']
@zverok
zverok / logdump2
Created September 10, 2013 10:08
Иррелевантное упоминание
------------------------
api_v2.log:
I, [2013-09-10T13:07:01.966473 #29874] INFO -- : Processing POST /v2/clients/2145/mentions/by/seed/473.json?component=dvapper Query: {component: "dvapper"} JSON: {author: {name: "Ariana-Joan Butera-Grande", guid: "216539801", url: "http://vk.com/id216539801"}, journal: {name: "Ariana-Joan Butera-Grande", guid: "216539801", url: "http://vk.com/id216539801", kind_class: "user"}, kind_class: "newsfeed", url: "http://vk.com/wall216539801_327", title: "", body: "Happy 18th Birthday Ariana Grande !\n\nHappy 18th Birthday Ariana Grande !\n\nHappy 18th Birthday Ariana Grande ! I do not own the song or the photos, credit to Bruno Mars for the song, and all the blogs and google where I got the photos and GIFs. Ariana's birthday is June 26th ! \nHope X3<...>", created_at: "2013-08-30T12:53:41+04:00", fetch: {id: 3126748}}
amqp.log:
I, [2013-09-10T13:07:02.005063 #29874] INFO -- : bsp.topic.v2[dvapper.mention:topic.create]: {id: 2012696, mention_id: 234138
@zverok
zverok / gist:6593908
Created September 17, 2013 12:50
[
{
"@id": "http://www.ontologyportal.org/WordNet",
"@graph": [
{
"@id": "_:g74216380",
"@type": [
"urn:gridsby:filter",
"http://www.ontologyportal.org/WordNet.owl#NounSynset"
]
@zverok
zverok / styles.rb
Last active December 23, 2015 17:59
# определяем основные стили
TABLE_BORDER_STYLE = {:style => :dotted, :color => '000000'}
TONALITY_STYLE = {:alignment => {:horizontal => :center, :vertical => :center}, :b => true, :sz => 18}
STYLES = {
:default => {:font_name => 'Calibri', :sz => 9},
:header => {:sz => 11},
:title => {:sz => 18, :alignment => {:horizontal => :center, :vertical => :center}},
@zverok
zverok / gist:6683604
Last active December 23, 2015 19:38
seeds = GET '/clients/{client_id}/seeds.json'
seeds_by_labels = {labels: {}, competitors: {}, empty: []}
$.each(seeds, function(){
seed = this
$.each(seed.labels2, function(){
if(this.is_competitor) {
seeds_by_labels['competitors'][this.label] ||= []
seeds_by_labels['competitors'][this.label].push(seed)
} else {
seeds_by_labels['labels'][this.label] ||= []
@zverok
zverok / gist:6702650
Created September 25, 2013 17:00
{
"author" => {
"guid" => "46970801",
"name" => nil,
"url" => "http://vk.com/club46970801"
},
"body" => "В покушении на шехзадэ Селима виновата снова Махидевран? Может таким образом \"чистит\" дорогу в Манису Мустафе? Или кто-то другой замешан в этом?\nПодготовлено группой \" http://vk.com/muhtesem_public \"\nУважайте чужой труд. Если будет копирование без указания истояник грозит БАН\n\n",
"created_at" => "2013-09-25T16:24:28+04:00",
"fetch" => {
"id" => "3242394"
@zverok
zverok / gist:6881625
Created October 8, 2013 08:43
{
id: 52541,
title: "Сдаю 1 комнатную квартиру от собственника",
body: "Сдаю 1комнатную квартиру на ДЛИТЕЛЬНЫЙ срок,семейной паре (желательно без детей) М.Каширская мкрн Сабурово (10 минут транспортом) общ пл.38 кв.м. кухня 9, комн.19 холл 6кв.м металл.дверь домофон 9 эт.17 эт.дома балкон в квартире есть все необходимое для проживания на кухне холодильник имп. эл.плита, микроволновка и т.д. ванная совмещенная имеется стиралка имп. ... Подробнее",
url: "http://realtonews.livejournal.com/6233909.html",
platform: {
id: 3,
name: "LiveJournal",
url: "http://www.livejournal.com/"
},
@zverok
zverok / gist:7007471
Created October 16, 2013 13:10
{
"@graph": [
{
"@id": "http://grids.by/zverok/doctor.who/documents/Episodes/cols",
"@type": "http://grids.by/types/Axis",
"http://purl.org/ontology/olo/core#length": 4,
"http://purl.org/ontology/olo/core#slot": [
{
"@id": "http://grids.by/zverok/doctor.who/documents/Episodes/cols/slot/1"
},
@zverok
zverok / gist:7008241
Created October 16, 2013 14:02
{
"@context":{
"schema":"http://schema.org/",
"olo":"http://purl.org/ontology/olo/core#",
"gbt":"http://grids.by/types/",
"gbr":"http://grids.by/relations/",
"name":"schema:name",
"description":"schema:description",
"Document":"gbt:Document",
"Axis":"gbt:Axis",