Skip to content

Instantly share code, notes, and snippets.

View nakagami's full-sized avatar

Hajime Nakagami nakagami

View GitHub Profile
@nakagami
nakagami / test_aggregate_pg.py
Last active August 29, 2015 14:15
PostgreSQL 統計処理用の集約関数の python テストコード
# coding:utf-8
# PostgreSQL 統計処理用の集約関数 SQL:2006
# https://www.postgresql.jp/document/9.3/html/functions-aggregate.html
import unittest
import minipg
import decimal
values_with_null = [
(1, 1),
@nakagami
nakagami / test_stddev_fb.py
Created March 12, 2015 13:47
Test for STDDEV_POP(), STDDEV_SAMP(), VAR_POP() and VAR_SAMP() functions with Firebird3
# coding:utf-8
import unittest
import tempfile
import firebirdsql
class TestStdDev(unittest.TestCase):
host='localhost'
port=3050
user='sysdba'
@nakagami
nakagami / test_corr_fb.py
Created March 21, 2015 04:34
Test covar_samp(), covar_pip() and corr() functions with Firebird3
# coding:utf-8
import unittest
import tempfile
import firebirdsql
values_with_null = [
(1, 1),
(2, 2),
(3, 4),
@nakagami
nakagami / test_covar_samp_pg_and_fb.py
Created March 22, 2015 01:09
test COVAR_SAMP() by PostgreSQL and Firebird3
# coding:utf-8
import unittest
import tempfile
import minipg
import firebirdsql
class TestCovarSamp(unittest.TestCase):
def test_pg(self):
connection = minipg.connect(
@nakagami
nakagami / test_regr_fb.py
Created March 24, 2015 09:14
Test for REGR_XXXX() function with Firebird3
# coding:utf-8
import unittest
import tempfile
import firebirdsql
values_with_null = [
(1, 1),
(2, 2),
(3, 4),
@nakagami
nakagami / mqttpub.py
Created November 15, 2015 04:24
A sample of MQTT publisher (QoS=0)
#!/usr/bin/env python2.7
from __future__ import print_function
import datetime
import time
import paho.mqtt.client as mqtt # https://pypi.python.org/pypi/paho-mqtt/
topic = "foo/bar"
if __name__ == '__main__':
client = mqtt.Client(protocol=mqtt.MQTTv311)
@nakagami
nakagami / mqttsub.py
Created November 15, 2015 04:26
A sample of MQTT subscriber (QoS=0)
#!/usr/bin/env python2.7
from __future__ import print_function
import paho.mqtt.client as mqtt # https://pypi.python.org/pypi/paho-mqtt/
topic = "foo/bar"
def on_connect(client, userdata, flags, respons_code):
print('connect:status {0}'.format(respons_code))
client.subscribe(topic)
@nakagami
nakagami / detect_cmyk_jpeg.py
Created May 21, 2013 01:21
Walk and detect CMYK Jpeg, and print it's path name
#!/usr/bin/env python
"""
Detect CMYK Jpeg under current directory
use PIL (or Pillow)
"""
import os
from PIL import Image
START_PATH='.'
@nakagami
nakagami / anytype_sample.go
Created September 11, 2013 02:04
A sample code, to use reflect and convert interface{} to original type.
package main
import (
"fmt"
"reflect"
)
type AnyType interface{}
func f(a AnyType) AnyType {
@nakagami
nakagami / list_sample.go
Created September 11, 2013 02:04
A sample code of "container/list".
// http://golang.org/pkg/container/list/
package main
import (
"fmt"
"container/list"
)
func main() {
l := list.New()