Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

View s-wool's full-sized avatar

Norikazu Kato s-wool

View GitHub Profile
@s-wool
s-wool / gist:7085167
Created October 21, 2013 14:50
hueのsqlite→mysqlでハマる。
> beeswax:0002_auto__add_field_queryhistory_notify
> beeswax:0003_auto__add_field_queryhistory_server_name__add_field_queryhistory_serve
> beeswax:0004_auto__add_session__add_field_queryhistory_server_type__add_field_query
> beeswax:0005_auto__add_field_queryhistory_statement_number
> beeswax:0006_auto__add_field_session_application
> beeswax:0007_auto__add_field_savedquery_is_trashed
> beeswax:0008_auto__add_field_queryhistory_query_type
- Loading initial data for beeswax.
No fixtures found.
Running migrations for hbase:
@s-wool
s-wool / gist:7267210
Last active December 27, 2015 04:29
hueのsqlite→mysqlのmigrationがこけるので 要--ignore-whitespace
diff -u a/apps/jobsub/src/jobsub/migrations/0002_auto__add_ooziestreamingaction__add_oozieaction__add_oozieworkflow__ad.py b/apps/jobsub/src/jobsub/migrations/0002_auto__add_ooziestreamingaction__add_oozieaction__add_oozieworkflow__ad.py
--- a/apps/jobsub/src/jobsub/migrations/0002_auto__add_ooziestreamingaction__add_oozieaction__add_oozieworkflow__ad.py 2013-07-13 07:49:44.000000000 +0900
+++ b/apps/jobsub/src/jobsub/migrations/0002_auto__add_ooziestreamingaction__add_oozieaction__add_oozieworkflow__ad.py 2013-11-01 18:30:10.115837288 +0900
@@ -46,7 +46,7 @@
('files', self.gf('django.db.models.fields.CharField')(default='[]', max_length=512)),
('mapper', self.gf('django.db.models.fields.CharField')(max_length=512)),
('reducer', self.gf('django.db.models.fields.CharField')(max_length=512)),
- ('job_properties', self.gf('django.db.models.fields.TextField')(default='[]')),
+ ('job_properties', self.gf('django.db.models.fields.CharField')(default='[]',
@s-wool
s-wool / gist:7516488
Created November 17, 2013 18:32
apt-cygの64bit対応とxzファイルの対応
--- apt-cyg.orig 2010-04-28 03:55:43.000000000 +0900
+++ apt-cyg 2013-11-18 03:31:25.034070400 +0900
@@ -95,14 +95,14 @@ function getsetup()
then
touch setup.ini
mv setup.ini setup.ini-save
- wget -N $mirror/setup.bz2
+ wget -N $mirror/x86_64/setup.bz2
if test -e setup.bz2 && test $? -eq 0
then
@s-wool
s-wool / upload_gmusic.py
Last active December 29, 2015 06:19
gmusicapiのOauth認証
>>> from gmusicapi import Musicmanager
>>> mm = Musicmanager()
>>> mm.perform_oauth()
No handlers could be found for logger "oauth2client.util"
Visit the following url:
https://accounts.google.com/o/oauth2/auth?scope=https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fmusicmanager&redirect_uri=urn%3Aietf%3Awg%3Aoauth%3A2.0%3Aoob&response_type=code&client_id=652850857958.apps.googleusercontent.com&access_type=offline
#URLコピペしてブラウザから認証するとコードが表示されるので、↓にコピペします
Follow the prompts, then paste the auth code here and hit enter: your_auth_code
<oauth2client.client.OAuth2Credentials object at 0xf4e6d0>
@s-wool
s-wool / set_id3.py
Created November 24, 2013 15:05
set id3 tag to mp3 file.
# -*- coding:utf-8 -*-
import eyed3
audio_file = eyed3.load("radiko_file.mp3")
audio_file.tag.artist = (u"Artist Name")
audio_file.tag.album = (u"Album Name")
audio_file.tag.title = (u"Title")
audio_file.tag.images.set(eyed3.id3.frames.ImageFrame.FRONT_COVER, "cover.jpg", "image/jpeg")
@s-wool
s-wool / convert_skype_emoticons.pl
Created December 1, 2013 08:38
convert skype emoticons to animated gif file
#!/usr/bin/env perl
use strict;
use warnings;
use Imager;
use File::Basename;
use constant SIZE => 20;
my @emoticons = glob "/Applications/Skype.app/Contents/Resources/*_anim.png";
@s-wool
s-wool / hue2.5.diff
Last active December 31, 2015 08:09
enable other cache backend in hue
diff -u -r rpmbuild.bak/SOURCES/hue-2.5.0-cdh4.4.0/desktop/conf/hue.ini rpmbuild/SOURCES/hue-2.5.0-cdh4.4.0/desktop/conf/hue.ini
--- rpmbuild.bak/SOURCES/hue-2.5.0-cdh4.4.0/desktop/conf/hue.ini 2013-09-04 12:36:56.000000000 +0900
+++ rpmbuild/SOURCES/hue-2.5.0-cdh4.4.0/desktop/conf/hue.ini 2013-12-14 15:15:16.000000000 +0900
@@ -178,6 +178,10 @@
## password=
## name=desktop/desktop.db
+ [[cache]]
+ # backend=locmem://
+ # key_prefix=
@s-wool
s-wool / hue_mysql5.6.diff
Created December 14, 2013 13:17
MySQL5.6でhueのsyncdbが動かない件のとりあえずの対応
diff -r -u hue.orig/apps/jobsub/src/jobsub/migrations/0003_convertCharFieldtoTextField.py hue/apps/jobsub/src/jobsub/migrations/0003_convertCharFieldtoTextField.py
--- hue.orig/apps/jobsub/src/jobsub/migrations/0003_convertCharFieldtoTextField.py 2013-12-09 16:06:58.518311322 +0000
+++ hue/apps/jobsub/src/jobsub/migrations/0003_convertCharFieldtoTextField.py 2013-12-14 13:10:27.126396795 +0000
@@ -9,13 +9,14 @@
def forwards(self, orm):
# Changing field 'OozieStreamingAction.job_properties'
- db.alter_column('jobsub_ooziestreamingaction', 'job_properties', self.gf('django.db.models.fields.TextField')())
+ #db.alter_column('jobsub_ooziestreamingaction', 'job_properties', self.gf('django.db.models.fields.TextField')())
@s-wool
s-wool / gist:960e565b8e778be82953
Created September 16, 2014 16:24
第6回elasticsearch勉強会

Aggregationあれこれ

Elasticsearch Inc. Jun Ohtaniさん @johtani この間のefk本の勉強会発表からaggs関連詳しくしたような感じかな

  • Aggregation機能はver 1.0から
@s-wool
s-wool / restore_rack_topology.pl
Created December 12, 2014 14:57
Cloudera Managerでrack awarenessを戻すスクリプト
#!/usr/bin/env perl
use strict;
use warnings;
use File::Basename;
use LWP::UserAgent;
use JSON::XS;
use Data::Dumper;
my $topology_file_path = shift @ARGV;