Skip to content

Instantly share code, notes, and snippets.

View uyu423's full-sized avatar

Yongwoo Yu (Yowu) uyu423

251 followers · 39 following
View GitHub Profile
@uyu423
uyu423 / helloWorld.c
Created April 20, 2016 06:52
#include <stdio.h>
int main(void) {
printf("Hello World\n");
}
@uyu423
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
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
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
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
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
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
uyu423 / expressVaildatorMiddlewareDefine.js
Created July 27, 2016 14:58
var express = require('express');
var app = express();
var expressVaildator('express-vaildator');
app.use(expressVaildator());
@uyu423
uyu423 / expressVaildatorSimpleExample.js
Last active July 27, 2016 15:08
var express = require('express');
var util = require('util');
var expressVaildator = require('express-validator');
var app = express();
app.use(expressVaildator());
app.get('/*', function(req, res) {
req.checkQuery('email', 'Invaild email type').isEmail();
@uyu423
uyu423 / expressSampleCodeWithES6.js
Created August 10, 2016 19:58
/* import dependency package */
import express from 'express';
import path from 'path';
import bodyParser from 'body-parser';
import dotenv from 'dotenv';
import morgan from 'morgan';
import session from 'express-session';
import expressValidator from 'express-validator';
import webpackDevServer from 'webpack-dev-server';