Skip to content

Instantly share code, notes, and snippets.

View lalinsky's full-sized avatar

Lukáš Lalinský lalinsky

View GitHub Profile
diff --git a/mbslave-sync.py b/mbslave-sync.py
index 7b1fdfa..2c44285 100755
--- a/mbslave-sync.py
+++ b/mbslave-sync.py
@@ -172,6 +172,7 @@ status = StatusReport(schema_seq, replication_seq)
if config.monitoring.enabled:
status.load(config.monitoring.status_file)
+num_packets = 0
while True:
@lalinsky
lalinsky / AcoustIDTest.vb
Last active December 14, 2015 21:39
AcoustID Compressed Request in VB.NET
Module AcoustIDTest
Sub Main()
Dim clientApiKey As String = "8XaBELgH"
Dim duration As Integer = 641
Dim fingerprint As String = "AQABz0qUkZK4oOfhL-CPc4e5C_wW2H2QH9uDL4cvoT8UNQ-eHtsE8cceeFJx-LiiHT-aPzhxoc-Opj_eI5d2hOFyMJRzfDk-QSsu7fBxqZDMHcfxPfDIoPWxv9C1o3yg44d_3Df2GJaUQeeR-cb2HfaPNsdxHj2PJnpwPMN3aPcEMzd-_MeB_Ej4D_CLP8ghHjkJv_jh_UDuQ8xnILwunPg6hF2R8HgzvLhxHVYP_ziJX0eKPnIE1UePMByDJyg7wz_6yELsB8n4oDmDa0Gv40hf6D3CE3_wH6HFaxCPUD9-hNeF5MfWEP3SCGym4-SxnXiGs0mRjEXD6fgl4LmKWrSChzzC33ge9PB3otyJMk-IVC6R8MTNwD9qKQ_CC8kPv4THzEGZS8GPI3x0iGVUxC1hRSizC5VzoamYDi-uR7iKPhGSI82PkiWeB_eHijvsaIWfBCWH5AjjCfVxZ1TQ3CvCTclGnEMfHbnZFA8pjD6KXwd__Cn-Y8e_I9cq6CR-4S9KLXqQcsxxoWh3eMxiHI6TIzyPv0M43YHz4yte-Cv-4D16Hv9F9C9SPUdyGtZRHV-OHEeeGD--BKcjVLOK_NCDXMfx44dzHEiOZ0Z44Rf6DH5R3uiPj4d_PKolJNyRJzyu4_CTD2WOvzjKH9GPb4cUP1Av9EuQd8fGCFee4JlRHi18xQh96NLxkCgfWFKOH6WGeoe4I3za4c5hTscTPEZTES1x8kE-9MQPjT8a8gh5fPgQZtqCFj9MDvp6fDx6NCd07bjx7MLR9AhtnFnQ70GjOcV0opmm4zpY3SOa7HiwdTtyHa6NC4e-HN-OfC5-OP_gLe2QDxfUCz_0w9l65HiPAz9-IaGO
sub can_see_vote_count
{
my ($self, $editor) = @_;
my $editor_id = defined $editor ? $editor->id ? -1;
my $editor_is_involved =
$self->proposer_id == $editor_id ||
$self->candidate_id == $editor_id ||
(defined $self->seconder_1_id && $self->seconder_1_id == $editor_id) ||
(defined $self->seconder_2_id && $self->seconder_2_id == $editor_id);
@lalinsky
lalinsky / server.py
Created April 29, 2013 09:55
Example audio fingerprint server using Chromaprint
import chromaprint
from flask import Flask, request, jsonify
SQL_TABLES = """
CREATE TABLE IF NOT EXISTS fingerprint
(
id INTEGER PRIMARY KEY,
fingerprint TEXT NOT NULL
server 1:
acoustid=> select * from track where id=1;
-[ RECORD 1 ]-+-------------------------------------
id | 1
gid | 4a7c2f1e-cf40-383c-a1c1-d1272d8234cd
recording | 8
medium | 872243
position | 30
create temporary table track_ac_count as select artist_credit, count(*) from track group by artist_credit;
create temporary table release_ac_count as select artist_credit, count(*) from release group by artist_credit;
create temporary table release_group_ac_count as select artist_credit, count(*) from release_group group by artist_credit;
create temporary table recording_ac_count as select artist_credit, count(*) from recording group by artist_credit;
create temporary table artist_credit_new as
select
artist_credit.id,
artist_credit.name,
artist_credit.artist_count,
CREATE VIEW area_parent AS
SELECT entity0 AS parent, entity1 AS child FROM l_area_area WHERE link IN (
SELECT id FROM link WHERE link_type IN (
SELECT id FROM link_type WHERE gid = 'de7cc874-8b1b-3a05-8272-f3834c968fb7'
)
);
WITH
RECURSIVE area_root (leaf, id, name, root) AS (
SELECT area.id, area.id, area.name, area_parent.parent
@lalinsky
lalinsky / osx
Created April 15, 2014 09:36
picard build scripts
cd deps
tar xf chromaprint-fpcalc-*.tar.gz
rm chromaprint-fpcalc-*.tar.gz
export PATH=`pwd`/`ls | grep chromaprint-fpcalc`:$PATH
cd ..
cat <<EOS >patch_version.py
import re, sys, datetime
source = open('picard/__init__.py').read()
patched_source = re.sub(r'PICARD_VERSION = \((\d+), (\d+), (\d+), (\S+), (\d+)\)', r'PICARD_VERSION = (\1, \2, \3, "dev", ' + datetime.date.today().strftime('%Y%m%d') + ')', source)
{
"metadata": {
"version": {
"essentia": "2.1-beta1",
"essentia_git_sha": "v2.1_beta1-34-gf95df8b",
"extractor": "music 1.0"
},
"audio_properties": {
"analysis_sample_rate": 44100,
"bit_rate": 0,
diff -Naur ./src/slon/slon.h ../slony1-2.0.7/src/slon/slon.h
--- a/src/slon/slon.h 2016-02-23 19:29:31.534631870 +0000
+++ b/src/slon/slon.h 2011-07-11 21:19:57.000000000 +0000
@@ -29,9 +29,6 @@
#include <sys/time.h>
#endif
-#ifndef INT64_FORMAT
-#define INT64_FORMAT "%" INT64_MODIFIER "d"
-#endif