Skip to content

Instantly share code, notes, and snippets.

View jhs9396's full-sized avatar

hsjeon jhs9396

2 followers · 4 following
View GitHub Profile
@jhs9396
jhs9396 / AgensGraph levenshtein example data script
Created February 12, 2019 08:50
AgensGraph levenshtein example data script
-- 1. init data
DROP GRAPH LEVENSHTEIN CASCADE;
CREATE GRAPH LEVENSHTEIN;
SET GRAPH_PATH TO LEVENSHTEIN;
CREATE EXTENSION fuzzystrmatch;
-- A report
@jhs9396
jhs9396 / AgensGraph ResultSet formatting source that is similar to Neo4j API call result format
Last active January 11, 2019 07:24
/**
* AgensGraph ResultSet parsing formatting example by Java application source
* Convert a ResultSet that it is similar to Neo4j format
* {graph:{nodes:[...],edges:[...],etc:[]}}
*
* @param resultSet cypher query result set list
* @throws Exception When logic that is parser, converting was executed by error
* @return After resultSet parsing, JSONObject return
*/
@SuppressWarnings("resource")
@jhs9396
jhs9396 / MongoFDW to AgensGraph installation Java source
Last active December 23, 2018 16:16
MongoFDW to AgensGraph installation Java source
/**
* MongoFDW를 AgensGraph에 구성 참고용 개발 소스
* 기타 library, package는 명시하지 않음. 단지 AgensGraph를 사용하기 위해 jdbc driver를 포함시킨 내용만 기술
*
* @author HyeonSu Jeon
*/
import net.bitnine.agensgraph.deps.org.json.simple.JSONArray;
import net.bitnine.agensgraph.deps.org.json.simple.JSONObject;
@jhs9396
jhs9396 / Transaction 데이터 생성 스크립트
Last active January 9, 2018 06:32
<!DOCTYPE html>
<meta charset="utf-8">
<style>
text {
font: bold 48px monospace;
}
.enter {
fill: green;
@jhs9396
jhs9396 / EVehicle
Last active January 30, 2018 05:07
{"evehicle":[{"remaining_amount":49.79067691413385,"ec_charge_time":"20180103063447","evehicle_model_name":"LEAF","eVehicle_id":"tVEH0001","status":"charged"},{"remaining_amount":26.216825377053365,"ec_charge_time":"20180104040030","evehicle_model_name":"RAY","eVehicle_id":"tVEH0002","status":"charged"},{"remaining_amount":50.502593068371105,"ec_charge_time":"20180103222749","evehicle_model_name":"IONIQ","eVehicle_id":"tVEH0003","status":"charged"},{"remaining_amount":45.371253990856005,"ec_charge_time":"20180103023151","evehicle_model_name":"SM3","eVehicle_id":"tVEH0004","status":"charged"},{"remaining_amount":83.42607124801144,"ec_charge_time":"20180103232343","evehicle_model_name":"SOUL","eVehicle_id":"tVEH0005","status":"charged"},{"remaining_amount":58.62918667705414,"ec_charge_time":"20180103083643","evehicle_model_name":"RAY","eVehicle_id":"tVEH0006","status":"charged"},{"remaining_amount":48.78840890323613,"ec_charge_time":"20180102032204","evehicle_model_name":"SM3","eVehicle_id":"tVEH0007","status":
@jhs9396
jhs9396 / Echarger
Last active January 8, 2018 11:12
{"echarger":[
{"ECHARGER_ID":"tCHR0001","ECHARGER_CONNECTOR_TYPE":"DC10","ECHARE_STATION_ID":"tSTA0001"},
{"ECHARGER_ID":"tCHR0002","ECHARGER_CONNECTOR_TYPE":"AC7","ECHARE_STATION_ID":"tSTA0002"},
{"ECHARGER_ID":"tCHR0003","ECHARGER_CONNECTOR_TYPE":"DC7","ECHARE_STATION_ID":"tSTA0002"},
{"ECHARGER_ID":"tCHR0004","ECHARGER_CONNECTOR_TYPE":"AC5","ECHARE_STATION_ID":"tSTA0003"},
{"ECHARGER_ID":"tCHR0005","ECHARGER_CONNECTOR_TYPE":"DC10","ECHARE_STATION_ID":"tSTA0003"},
{"ECHARGER_ID":"tCHR0006","ECHARGER_CONNECTOR_TYPE":"AC7","ECHARE_STATION_ID":"tSTA0003"},
{"ECHARGER_ID":"tCHR0007","ECHARGER_CONNECTOR_TYPE":"DC7","ECHARE_STATION_ID":"tSTA0004"},
{"ECHARGER_ID":"tCHR0008","ECHARGER_CONNECTOR_TYPE":"AC5","ECHARE_STATION_ID":"tSTA0004"},
{"ECHARGER_ID":"tCHR0009","ECHARGER_CONNECTOR_TYPE":"DC10","ECHARE_STATION_ID":"tSTA0004"},
@jhs9396
jhs9396 / station_temp.txt
Last active January 30, 2018 05:07
{
"station":[
{"ECHARE_STATION_ID":"tSTA0001","ESTATION_LOC_LATITUDE":34.995541,"ESTATION_LOC_LONGITUDE":126.708152,"NUM_ECHARGER":1,"PEER_TYPE":"Vpeer","ESTATION_OPEN_TYPE":0,"COMMWITH":["tSTA0002","tSTA0003","tSTA0004","tSTA0005","tSTA0006"]},
{"ECHARE_STATION_ID":"tSTA0002","ESTATION_LOC_LATITUDE":34.995793,"ESTATION_LOC_LONGITUDE":126.720037,"NUM_ECHARGER":2,"PEER_TYPE":"Vpeer","ESTATION_OPEN_TYPE":1,"COMMWITH":["tSTA0001","tSTA0003","tSTA0005","tSTA0007"]},
{"ECHARE_STATION_ID":"tSTA0003","ESTATION_LOC_LATITUDE":35.025341,"ESTATION_LOC_LONGITUDE":126.713062,"NUM_ECHARGER":3,"PEER_TYPE":"Vpeer","ESTATION_OPEN_TYPE":2,"COMMWITH":["tSTA0001","tSTA0002","tSTA0010","tSTA0015"]},
{"ECHARE_STATION_ID":"tSTA0004","ESTATION_LOC_LATITUDE":35.028351,"ESTATION_LOC_LONGITUDE":126.714340,"NUM_ECHARGER":4,"PEER_TYPE":"Vpeer","ESTATION_OPEN_TYPE":0,"COMMWITH":["tSTA0001","tSTA0008","tSTA0009","tSTA0010","tSTA0011"]},
{"ECHARE_STATION_ID":"tSTA0005","ESTATION_LOC_LATITUDE":35.029079,"ESTATION_LOC_LONGITUDE":126.725340,"N