pirosuke

CREATE OR REPLACE FUNCTION SF_GET_LIST_SIMILARITY(
    p_list1 text[],
    p_list2 text[]
) RETURNS NUMERIC(19,4) AS $$
DECLARE
    w_list text[] := '{}';
BEGIN
    IF p_list1 IS NULL OR p_list2 IS NULL THEN
        RETURN 0;
    END IF; 

pirosuke

CREATE OR REPLACE FUNCTION SF_IN_LIST(
    p_list1 text[],
    p_list2 text[]
) RETURNS BOOLEAN AS $$
DECLARE
    w_is_in_list BOOLEAN := true;
BEGIN
    IF p_list1 IS NULL OR p_list2 IS NULL THEN
        RETURN false;
    END IF; 

pirosuke

# coding: utf-8

from __future__ import unicode_literals
import xlrd
import codecs

def output_insert_sqls(excel_path, output_path, sheet_names, table_names):
    book = xlrd.open_workbook(excel_path)
    out_f = codecs.open(output_path, "w", "utf_8")

pirosuke

def get_obj_attr(root, str_path, default_val="", debug=False):
    attr_path = str_path.split(".")
    base_obj = root
    for attr in attr_path:
        if hasattr(base_obj, attr):
            base_obj = base_obj.__dict__[attr]
        else:
            if debug:
                print "No attribute: %s" % attr
            base_obj = default_val

pirosuke

var xmlrpc = require('xmlrpc');

var Hatebu = {};

Hatebu.getHatebuCount = function (domain, callback) {
	var client = xmlrpc.createClient({
		host: "b.hatena.ne.jp",
		path: "/xmlrpc"
	});
	client.methodCall('bookmark.getTotalCount', [domain], function (error, value) {

pirosuke

var express = require('express')
  , bodyParser = require('body-parser')
  , ifttt = require('./ifttt')
  , http = require('http')
  , path = require('path');

var app = express();

// all environments
app.set('port', process.env.PORT || 3000);

pirosuke

const cron = require('node-cron');

const exampletask = require('./exampletask');

cron.schedule('0 9 * * * *', () => {
    exampletask.main();
    console.log('task completed');
});

pirosuke

const msnodesql = require("msnodesqlv8");

async function fetchDataList(conn, query) {
    return new Promise((resolve, reject) => {
        conn.query(query, (err, rows) => {
            if (err !== null) {
                reject(err);
                return;
            }

pirosuke

const WebSocket = require('ws');
const app = require('express')();
const server = require('http').Server(app);
const uuid = require('uuid/v4');

// Creates a JSON string for "setblock" command request
function setBlockCommand(x, y, z, blockType) {
    return JSON.stringify({
        "body": {
            "origin": {

pirosuke

# -*- coding: utf-8 -*-

import os

import cv2
import numpy as np

def create_line_drawing_image(img):
    kernel = np.array([
        [1, 1, 1, 1, 1],