Skip to content

Instantly share code, notes, and snippets.

View Jwata's full-sized avatar
🌴
On vacation

Junji Watanabe Jwata

🌴
On vacation
View GitHub Profile
# try to send 10 times http request to AWS (US West Virginia )
~% for i in `seq 1 10`;do curl -kL http://ec2-54-88-204-250.compute-1.amazonaws.com/ -o /dev/null -w "%{http_code}\t%{time_total}\n" 2> /dev/null;done
200 0.370
200 0.501
200 0.429
200 0.362
200 0.378
200 0.363
200 0.374
200 0.387
select t1.job_posting_id from (select jp.id as job_posting_id from job_posting jp where jp.`valid_to` > '2015-03-03 00:34:52.404' AND jp.`occupation_type` IN ('restaurant') AND NOT jp.`occupation_type` = 'night') t1
inner join
(
select job_posting_id from
(select l.job_posting_id from location l where l.locality_id IN (1113)) t2
inner join
(select f.job_posting_id from feature f where f.title IN ('dailypayment')) t3
using (job_posting_id)
) t4
using (job_posting_id)
junji_watanabe@MAC0012-2140272 ~/Development/CareerCompass% cat requirements_2.txt
【必須要件】
・WEBシステムの設計、実装、テスト、メンテナンスにおける深い経験
・データベースの設計、運用管理経験
・LAMP、CakePHPに精通
・JavaScript、CSS、HTML5についての専門的知識
【求める人物像】
・チームワークを尊重し、成果を出すために貢献できる方
・あいまいな状況の中でも前進し、変化に柔軟かつ迅速に対応できる方
@Jwata
Jwata / parse.py
Last active August 29, 2015 14:26
import MeCab
from gensim import corpora, models, similarities
file_name = 'requirements_3.txt'
mecab = MeCab.Tagger("-Ochasen -d /usr/local/Cellar/mecab/0.996/lib/mecab/dic/mecab-ipadic-neologd/")
with open(file_name) as f:
all_tokens = []
for line in f:
INSERT INTO user_login_history 
            ( 
                        remote_address, 
                        user_agent, 
                        latitude, 
                        longitude, 
                        login_at, 
                        user_identifier 
            ) 

myprofile_settings

SELECT t0.id               c0, 
       t0.first_name       c1, 
       t0.middle_name      c2, 
       t0.last_name        c3, 
       t0.gender           c4, 
       t0.birth_year       c5, 
       t0.job              c6, 
       t0.income           c7, 
Usage: gist [options] [filename or stdin] [filename] ...
Filename '-' forces gist to read from stdin.
-p, --[no-]private Make the gist private
-t, --type [EXTENSION] Set syntax highlighting of the Gist by file extension
-d, --description DESCRIPTION Set description of the new gist
-o, --[no-]open Open gist in browser
-m, --man Print manual
-v, --version Print version
-h, --help Display this screen
Usage: gist [options] [filename or stdin] [filename] ...
Filename '-' forces gist to read from stdin.
-p, --[no-]private Make the gist private
-t, --type [EXTENSION] Set syntax highlighting of the Gist by file extension
-d, --description DESCRIPTION Set description of the new gist
-o, --[no-]open Open gist in browser
-m, --man Print manual
-v, --version Print version
-h, --help Display this screen
Usage: gist [options] [filename or stdin] [filename] ...
Filename '-' forces gist to read from stdin.
-p, --[no-]private Make the gist private
-t, --type [EXTENSION] Set syntax highlighting of the Gist by file extension
-d, --description DESCRIPTION Set description of the new gist
-o, --[no-]open Open gist in browser
-m, --man Print manual
-v, --version Print version
-h, --help Display this screen