Skip to content

Instantly share code, notes, and snippets.

View lalinsky's full-sized avatar

Lukáš Lalinský lalinsky

View GitHub Profile
@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,
my $tree = HTML::TreeBuilder::XPath->new;
$tree->parse_content($response->content);
my @elements = $tree->findnodes("//div[id='foo']");
my $content = @elements > 0 ? $elements[0]->as_HTML : '';
@lalinsky
lalinsky / fpserver.sh
Created December 15, 2011 11:09
Acoustid Index startup script (FreeBSD)
#!/bin/sh
# PROVIDE: fpserver
# KEYWORD: shutdown
#
# Add the following lines to /etc/rc.conf.local or /etc/rc.conf to
# enable fpserver:
#
# fpserver_enable (bool): Set to NO by default. Set it to YES to
# enable fpserver.
@lalinsky
lalinsky / gist:1574473
Created January 7, 2012 11:18
MusicBrainz Server Setup on Ubuntu
sudo apt-get install cpanminus liblocal-lib-perl libossp-uuid-perl
sudo apt-get install libxml2-dev libpq-dev libexpat1-dev
echo 'eval `perl -Mlocal::lib`' >>~/.bashrc
eval `perl -Mlocal::lib`
perl Makefile.PL
cpanm -n .
sudo apt-get install postgresql-server-dev-8.4 gcc-4.4 libicu-dev postgresql-contrib-8.4
cd postgresql-musicbrainz-collate/
make PG_CONFIG=/usr/lib/postgresql/8.4/bin/pg_config
select id, mbid, (length/60)::text || ':' || (length%60)::text from submission where id in (select distinct submission_id from track_mbid_source where track_mbid_id =1231384);
id | mbid | ?column?
----------+--------------------------------------+----------
24884813 | 6afd8432-f56e-44b0-8331-ce62fdf408fc | 4:1
16685155 | 06d955ce-b888-4bdc-a15f-b206a2f7ac77 | 4:3
1504569 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 4:3
2959818 | 6afd8432-f56e-44b0-8331-ce62fdf408fc | 4:1
11888389 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 4:3
8861348 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 4:3
echo "DROP TYPE cover_art_presence;" | ./mbslave-psql.py
echo "ALTER TABLE release_meta DROP COLUMN cover_art_presence;" | ./mbslave-psql.py
./mbslave-import.py mbdump-derived.tar.bz2
./mbslave-sync.py
./mbslave-psql.py <sql/updates/20120105-caa-flag.sql
echo "UPDATE replication_control SET current_schema_sequence = 14;" | ./mbslave-psql.py
./mbslave-sync.py
@lalinsky
lalinsky / gist:2821278
Created May 28, 2012 21:25
CMakeLists.txt for libofa
PROJECT(libofa)
SET(PROJECT_VERSION 0.1.1)
# 1. If the library source code has changed at all since the last update, then increment revision.
# 2. If any interfaces have been added, removed, or changed since the last update, increment current, and set revision to 0.
# 3. If any interfaces have been added since the last public release, then increment age.
# 4. If any interfaces have been removed since the last public release, then set age to 0.
SET(libofa_SOVERSION_CURRENT 0)
SET(libofa_SOVERSION_REVISION 2)
SET(libofa_SOVERSION_AGE 0)
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