Yongwoo Yu (Yowu) uyu423

Backend Developer. I ❤️ robust backend architecture.

uyu423 / simplicLinkedList.c

Last active October 22, 2018 08:46

	/*
	* Simplic Linked List Structure
	* by Yowu ([email protected] \|\| http://luckyyowu.tistory.com)
	* Date : 2016. 04. 15
	* Development Env.
	* Ubuntu 15.10 (x64, Linux Kernel 4.2.0)
	* GNU Compiler Collection 5.2.1
	* Vi IMproved 7.4, File Encoding UTF-8
	*/
	#include <stdio.h>

uyu423 / helloWorld.c

Created April 20, 2016 06:52

uyu423 / selectDefault.js

Last active July 18, 2016 17:37

	/* node-qsb npm Module Example (Select Query Default) */
	var qsb = require('node-qsb');

	var qs = new qsb().select('tableName')
	.where('idx', '>', '10')
	.build();

	qs.printString();
	//Standard Output : SELECT * FROM `tableName` WHERE `idx` > '10';
	console.log(qs.returnString());

uyu423 / node-qsb.insertExampleOrigin.js

Last active July 18, 2016 17:53

	//node-qsb를 사용하지 않고 데이터베이스 쿼리문 하드 코딩
	var originQs = "insert into users(email, passwd, uName, stdNum, major, phone, emailNotify, tIdx) "
	+ "values ('"+req.email+"', '"+req.sha2passwd +"', '"
	+ req.uName+"', '"+req.stdNum+"', '"+req.major+"', '"+req.phone+"', '"
	+ req.emailNotify+"', 5);";

uyu423 / node-qsb.insertExampleUsingQsb.js

Last active July 18, 2016 17:52

	//node-qsb를 사용한 데이터베이스 쿼리문 관리
	var qsb = require('node-qsb');
	var mysql = require('../config/mysql.js')

	var params = {
	cols : ['email', 'passwd', 'uName', 'stdNum', 'major', 'phone', 'emailNotify', 'tIdx'],
	vals : [req.email, req.sha2passwd, req.uName, req.stdNum, req.major, req.phone, req.emailNotify, '5'],
	}
	var usingQsbQs = new qsb()
	.insert("users")

uyu423 / node-qsb.complexQuery.js

Created July 18, 2016 19:13

	var qsb = require("node-qsb")

	var qs = new qsb().select('myTable', 'MT')
	.join('yourTable', 'YT')
	.join('ourTable', 'OT')
	.where('MT.idx', '=', 'YT.mIdx')
	.where('YT.idx', '=', 'OT.yIdx')
	.where('MT.idx', '<=', 10)
	.whereOr('YT.idx', '<', 100)
	.limit(0, 100)

uyu423 / array&obj&jsonAtJavascript.html

Last active July 24, 2016 17:21

	<head>
	<title>JSON Basic</title>
	<meta charset="utf-8"/>
	</head>
	<body>
	<script>
	/* Array and Object Definition */
	var arr = [ "Yongwoo", 25, "Catholic Univ, of Korea", "Computer Science" ];
	var obj = { "NAME" : "Yongwoo", "AGE" : 25, "UNIVERSITY" : "Catholic Univ, of Korea", "MAJOR" : "Computer Science" };

uyu423 / jsonStringAtJavascript.html

Created July 24, 2016 17:22

	<head>
	<title>JSON Basic</title>
	<meta charset="utf-8"/>
	</head>
	<body>
	<script>
	/* JSON Definition */
	var json = '{ "NAME" : "Yongwoo", "AGE" : 25, "UNIVERSITY" : "Catholic Univ, of Korea", "MAJOR" : "Computer Science" }';

	/* JSON Parse and Check */

uyu423 / array&objAtJavascript.html

Created July 24, 2016 17:22

	<head>
	<title>JSON Basic</title>
	<meta charset="utf-8"/>
	</head>
	<body>
	<script>
	/* Array and Object Definition */
	var arr = [ "Yongwoo", 25, "Catholic Univ, of Korea", "Computer Science" ];
	var obj = { "NAME" : "Yongwoo", "AGE" : 25, "UNIVERSITY" : "Catholic Univ, of Korea", "MAJOR" : "Computer Science" };

uyu423 / expressVaildatorMiddlewareDefine.js

Created July 27, 2016 14:58

	var express = require('express');
	var app = express();
	var expressVaildator('express-vaildator');

	app.use(expressVaildator());