Skip to content

Instantly share code, notes, and snippets.

View AKB428's full-sized avatar
🥳
Out sick

AKB428 AKB428

🥳
Out sick
View GitHub Profile
@AKB428
AKB428 / create_dummy_posdata.rb
Created September 12, 2015 05:24
create_dummy_posdata.rb
require 'date'
(1..12).each do |i|
date = Date.new(2014, i, 1)
(1..10).each do |x|
shop_id = x
sales = 100000 * date.month * shop_id
puts sprintf("%d,%s,%d", shop_id, date, sales)
end
end
@AKB428
AKB428 / 2015_Q3_Anime.sql
Created September 12, 2015 03:01
2015_Q3_Anime.sql
SELECT
name,
title,
IF(sum(score) > 10, 10, sum(score)) as score
FROM (
SELECT
name,
title,
1 AS score,
FROM (
@AKB428
AKB428 / CF2SQL
Created September 9, 2015 08:38
CF2
SELECT
name,
title,
sum(score) as score
FROM (
SELECT
name,
title,
1 AS score,
FROM (
@AKB428
AKB428 / cf.sql
Created September 9, 2015 08:20
協調フィルタリングデータ生成
SELECT
name,
title,
sum(score) as score
FROM (
SELECT
name,
title,
1 AS score,
FROM (
@AKB428
AKB428 / ApacheKafka_OSX_Install
Last active September 1, 2015 20:03
Apache Kafka OSX インストール
==> Installing kafka
==> Downloading http://mirrors.ibiblio.org/apache/kafka/0.8.2.1/kafka-0.8.2.1-src.tgz
######################################################################## 100.0%
==> gradle
==> gradle jar
==> Caveats
To start Kafka, ensure that ZooKeeper is running and then execute:
kafka-server-start.sh /usr/local/etc/kafka/server.properties
@AKB428
AKB428 / application.json
Last active August 31, 2015 17:20
MSの画像解析サービスProject Oxfordでコスプレ ラブライブ四天王の年齢判定をプログラミングしてみる ref: http://qiita.com/AKB428/items/ba32bdf917037956b40f
{
"Azure" : {
"subscription_key": ""
}
}
@AKB428
AKB428 / trans.rb
Created August 17, 2015 16:42
trans.rb
#ruby trans.rb every60min20150816.log
def parser(line)
list = line.split(',')
list[0..8]
end
open(ARGV[0]) {|file|
counter = 0
@AKB428
AKB428 / sc.emptyRDD
Created August 5, 2015 18:03
sc.emptyRDD
sc.emptyRDD
@AKB428
AKB428 / movie_film_creater.rb
Created July 26, 2015 09:45
MovieFilmCreater
require 'RMagick'
class MovieFilmCreater
def initialize(image_file1, image_file2, image_file3, image_file4)
@image_file1 = image_file1
@image_file2 = image_file2
@image_file3 = image_file3
@image_file4 = image_file4
end
@AKB428
AKB428 / Mastering_DMP_Chapter05.md
Last active August 29, 2015 14:24
[Mastering DMP] 05

#5章 データーベースにCookieを保存する

ブラウザからDMPサーバーへリクエストがあった場合、初期アクセスならCookieID発行、2回目以降のアクセスの場合はそのオーディエンスの過去のリクエストログから広告を出すのがCookieを利用したDMPの基本的な処理になります。

ここではリクエストのログをMariaDB(MySQL)に保存する方法について説明します。

application.conf設定

以下の記述を追加します