Skip to content

Instantly share code, notes, and snippets.

@masakiplus
masakiplus / 0_reuse_code.js
Created February 5, 2016 05:47
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
#!/bin/bash
itemcount=0
subcount=1
for a in `ls G*.JPG 2> /dev/null`
do
echo "$a"
lastproduct="$productid"
productid=`echo "$a" | gawk '{print substr($a, 9,6)}'`
@masakiplus
masakiplus / exec.bat
Last active August 29, 2015 14:17
auto mail sender
@echo off
rem smail.exe installation required
set pdfpath=%1
set smailpath="exeplace"
set smtp=smtp.gmail.com
set from=hoge@gmail.com
set to="hoge@gmail.com"
for /f "delims=;" %%i in ('dir /b /od %pdfpath%\*.pdf') do (
#! /usr/bin/sh
INPUT_FILE=data1
OUTPUT_FILE=data2
awk -c '
BEGIN {
FS = "\t" # TAB chara fow win platform
OFS = "\t"
REC_N = 15 # column number
@masakiplus
masakiplus / importer.sql
Created December 19, 2012 14:00
stored procedure to import csv
-- 取り込み用ローデータの削除
DELETE [r_tbl];
-- データの取り込み実施
BULK INSERT [r_tbl] from 'raw.txt' WITH
(
FIELDTERMINATOR = '\t',
ROWTERMINATOR = '0x0a'
);
@masakiplus
masakiplus / procedure.py
Created December 19, 2012 13:57
python script to exec procedure
#!/usr/bin/env python
# -*- coding: utf-8 -*-
import pymssql
#DB接続
conn = pymssql.connect(host='server', user='user', password='pass', database='dbname')
cur = conn.cursor()
#ストアド・プロシージャ実行
v_sql = 'exec [dbo].[importer]'
@masakiplus
masakiplus / acquisition.sh
Created December 19, 2012 13:54
Shell Script for data acquisition
#!/bin/bash
# 各種設定:パスワードはパラメータから取得
HOST=hoge
USER=fuga
PASS=fugafuga
TARGET_DIR=/home/user/xxx/
BACKUP_DIR=/home/user/xxx/
SCRIPT_DIR=/home/user/script/
@masakiplus
masakiplus / gist:3927063
Created October 21, 2012 14:05
flurry sdk android
import com.flurry.android.FlurryAgent;
@Override
protected void onStart()
{
super.onStart();
FlurryAgent.onStartSession(this, "YOUR_API_KEY");
}
@Override
@masakiplus
masakiplus / gist:3927056
Created October 21, 2012 14:04
flurry sdk iOS
#import "Flurry.h"
- (void)applicationDidFinishLaunching:(UIApplication *)application
{
[Flurry startSession:@"YOUR_API_KEY"];
//your code
}
@masakiplus
masakiplus / gist:3927055
Created October 21, 2012 14:04
flurry sdk iOS
#import "Flurry.h"
- (void)applicationDidFinishLaunching:(UIApplication *)application
{
[Flurry startSession:@"YOUR_API_KEY"];
//your code
}