Skip to content

Instantly share code, notes, and snippets.

View hoony-o-1's full-sized avatar
๐Ÿข
small, slow, and solid

hoony hoony-o-1

๐Ÿข
small, slow, and solid
View GitHub Profile
@hoony-o-1
hoony-o-1 / lazyload.js
Created April 12, 2017 01:03
function to lazyload a javascript library
export const lazyLoad = (src, callback) => {
const script = document.createElement('script')
script.type = 'text/javascript'
script.async = true
script.src = src
document.getElementsByTagName('head')[0].appendChild(script); // add to page
if (script.readyState) {
script.onreadystatechange = function () {
if (script.readyState == "loaded" || script.readyState == "complete") {
var x = 'jyhwng'
// string.length
console.log(x.length === 6)
// string.prototype.indexOf
var index = x.indexOf('j')
console.log(index === 0)
@hoony-o-1
hoony-o-1 / README.md
Created December 29, 2016 05:27
Node.js + SQL ์„œ๋ฒ„ ๊ตฌ์ถ•ํ•˜๊ธฐ

Node.js & MySQL ์„œ๋ฒ„ ๊ตฌ์ถ•ํ•˜๊ธฐ

Node.js ์„œ๋ฒ„ ๊ธฐ์ดˆ

Node.js์—์„œ RESTful API๋ฅผ ๊ตฌ์ถ•ํ•˜๊ธฐ ์œ„ํ•ด ์“ฐ์ด๋Š” ๊ฐ€์žฅ ๊ธฐ๋ณธ์ ์ธ ํ”„๋ ˆ์ž„์›Œํฌ๋Š” Express - Node.js web application framework์ž…๋‹ˆ๋‹ค.

var express = require('express')

var app = express()

app.get('/', function(req, res) {

Keybase proof

I hereby claim:

  • I am the6thm0nth on github.
  • I am the6thm0nth (https://keybase.io/the6thm0nth) on keybase.
  • I have a public key ASDl4da1m8A4hZHfwXj-cKo89AAmxoeIj-01U_KWBe70DAo

To claim this, I am signing this object:

@hoony-o-1
hoony-o-1 / psqlfix.txt
Created March 3, 2016 07:47
Change postgres default template0 to UTF8 encoding
mike@rbci:~$ psql -U postgres
psql (9.0.3)
Type "help" for help.
postgres=# update pg_database set datallowconn = TRUE where datname = 'template0';
UPDATE 1
postgres=# \c template0
You are now connected to database "template0".
template0=# update pg_database set datistemplate = FALSE where datname = 'template1';
UPDATE 1
@hoony-o-1
hoony-o-1 / votes.py
Last active January 11, 2016 07:29
export to csv file with votes results during 19th the National Assembly(by Congress Report)
from os import listdir
import sys
import json
import csv
import gevent
import pandas as pd
import numpy as np
@hoony-o-1
hoony-o-1 / main_attendances.R
Last active January 7, 2016 14:07
create csv file with attendances for Assembly plenary seesion / data from Congress Report project
library(jsonlite)
basic.members <- fromJson("assembly_members.json")
basic.attendances <- read.csv("attendances.csv")
members <- basic.members[, c("idx", "name_kr", "party", "when_elected")]
main.attendances <- merge(members, basic.attendances, by = "idx")
write.csv(main.attendances, file = "main_attendaces.csv", sep = ",", row.names = FALSE)
@hoony-o-1
hoony-o-1 / congress-report-attendances-records.py
Last active January 11, 2016 03:28
to calculate 19th congress member's attendances records / data from Congress Report project
from os import listdir
import sys
import json
import csv
import gevent
import pandas as pd
import numpy as np
@hoony-o-1
hoony-o-1 / csvtomongo.py
Created December 16, 2015 12:43
csv to mongo with python
import sys
import csv
from pymongo import MongoClient
MONGO_HOST = 'localhost'
MONGO_PORT = 27017
DOCUMENT_NAME = 'test'
COLLECTION_NAME = 'service'
@hoony-o-1
hoony-o-1 / csvtojson.py
Last active December 16, 2015 12:16
csv to json with python
import json
import csv
CSV_FILENAME = 'services.csv'
JSON_FILENAME = 'services.json'
COLUMNS = ('์ œ๋ชฉ', '์ง€์›๋‚ด์šฉ', '์„œ๋น„์Šค ๋ชฉ์ ', '์‹œํ–‰์ผ์ž', '์ข…๋ฃŒ์ผ์ž', '์†Œ๊ด€๊ธฐ๊ด€', '์†Œ๊ด€๊ธฐ๊ด€ ์—ฐ๋ฝ์ฒ˜', '๊ด€์‹ฌ๋ถ„์•ผ', '์ง€์›ํ˜•ํƒœ', '์ง€์›๋Œ€์ƒ', '์ˆ˜๊ธ‰์ž๊ฒฉ', '์„ ์ •๊ธฐ์ค€', '์ค‘๋ณต๋ถˆ๊ฐ€ ์„œ๋น„์Šค', '์‹ ์ฒญํ•„์š”์—ฌ๋ถ€', '์˜จ๋ผ์ธ์‹ ์ฒญ๊ฐ€๋Šฅ์—ฌ๋ถ€', '์ฒ˜๋ฆฌ๊ธฐํ•œ', '์‹ ์ฒญ์ ˆ์ฐจ', '๊ตฌ๋น„์„œ๋ฅ˜', '์‹ ์ฒญ๊ธฐํ•œ', '์ ‘์ˆ˜๊ธฐ๊ด€', '์ ‘์ˆ˜๊ธฐ๊ด€ ์—ฐ๋ฝ์ฒ˜', '์ฒ˜๋ฆฌ๊ธฐ๊ด€', '์ฒ˜๋ฆฌ๊ธฐ๊ด€ ์—ฐ๋ฝ์ฒ˜', '๋ฌธ์˜์ฒ˜', '๋ฌธ์˜์ „ํ™”๋ฒˆํ˜ธ', '์›น์‚ฌ์ดํŠธ')
def convert():
csv_reader = open(CSV_FILENAME, 'r')
json_writer = open(JSON_FILENAME, 'w')