Skip to content

Instantly share code, notes, and snippets.

View pirosuke's full-sized avatar

Hiroki Tanaka pirosuke

11 followers · 18 following
  • Japan
View GitHub Profile
@pirosuke
pirosuke / ssh_tunnel_template.js
Created January 19, 2019 17:49
Template To Control Server Through SSH Tunnel With Node.js
const tunnel = require('tunnel-ssh');
async function main() {
const sshUserName = 'SSH_USER_NAME';
const sshPassword = 'SSH_PASSWORD';
let sshConfig = {
host: 'SSH_HOST_ADDRESS',
port: SSH_PORT,
username: sshUserName,
@pirosuke
pirosuke / resize_images.js
Created January 20, 2019 13:36
An Example To Resize Image Files Using OpenCV And Node.js
const path = require('path');
const fs = require('fs');
const cv = require('opencv4nodejs');
function resizeImagesToMax(srcDirPath, destDirPath, maxWidthHeight) {
const srcFileList = fs.readdirSync(srcDirPath);
for (const srcFileName of srcFileList) {
if (!srcFileName.endsWith('.JPG')) {
continue;
@pirosuke
pirosuke / check_exif.js
Last active January 21, 2019 15:27
A Sample Script To Get EXIF Data From Image File.
const path = require('path');
const fs = require('fs');
const piexif = require('piexifjs');
function getExifFromImage(imgPath) {
const imgData = fs.readFileSync(imgPath).toString('binary');
const exifRawData = piexif.load(imgData);
const exifData = {};
for (const exifType in exifRawData) {
@pirosuke
pirosuke / remove_exif.js
Created January 21, 2019 15:35
A Sample Script To Remove EXIF Data From Image File.
const path = require('path');
const fs = require('fs');
const piexif = require('piexifjs');
function removeExifFromImage(srcImgPath, destImgPath) {
const imgData = fs.readFileSync(srcImgPath).toString('binary');
const newImgData = piexif.remove(imgData);
fs.writeFileSync(destImgPath, newImgData, 'binary');
}
@pirosuke
pirosuke / fetch_log.js
Last active January 24, 2019 04:50
An Example To Connect To Remote Server And Download PostgreSQL Log File
const path = require('path');
const Ssh = require('node-ssh');
const moment = require('moment');
const tar = require('tar');
async function downloadSlowQueryLog(sshInfo, sshPassword, remoteSlowQueryLogDir, slowQueryLogFileName, localSlowQueryLogFilePath) {
const ssh = new Ssh();
const remoteSlowQueryLogFilePath = remoteSlowQueryLogDir + '/' + slowQueryLogFileName;
@pirosuke
pirosuke / convert_img_to_line_drawing.py
Created January 19, 2019 16:58
Convert Image Files To Line Drawings With OpenCV
# -*- 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],
@pirosuke
pirosuke / excel2psql.py
Last active March 8, 2023 06:07
A Python script to create SQL file from Excel
# 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
pirosuke / index.html
Created May 8, 2019 14:32
Image Convert With OpenCV.js
<html>
<head>
<title>OpenCV.js Test</title>
</head>
<body>
<table>
<tr>
<th>source</th>
<th>output</th>
</tr>
@pirosuke
pirosuke / fetch_remote_db_data.js
Created January 19, 2019 17:51
Sample To Fetch Data From Remote Database Table Through SSH Tunnel With Node.js
const tunnel = require('tunnel-ssh');
import knexLib = require('knex');
async function main() {
const sshUserName = 'SSH_USER_NAME';
const sshPassword = 'SSH_PASSWORD';
let sshConfig = {
host: 'SSH_HOST_ADDRESS',
port: SSH_PORT,