herudi

const http = require('http');
const pathnode = require('path');
const { parse: parseqs } = require('querystring');
const { parse: parsenodeurl } = require('url');

const METHODS = ['GET', 'POST', 'PUT', 'DELETE', 'PATCH', 'HEAD', 'OPTIONS', 'ALL'];
const PRE_METHOD = 'GET,POST';
const PUSH = Array.prototype.push;
const TYPE = 'Content-Type';
const JSON_TYPE = 'application/json';

herudi

@success-color: #28a745;
@warning-color: #eca52b;
@info-color: #17a2b8;
@buttons: success @success-color, warning @warning-color, info @info-color;
.getButtons(@index:1) when(@index <= length(@buttons)) {
    @name: extract(extract(@buttons, @index),1);
    @color: extract(extract(@buttons, @index),2);
    @colorHoverFocus: lighten(@color, 10%);
    @colorActive: darken(@color, 10%);
    .ant-btn-@{name}{

herudi

.ant-btn-success {
  color: #fff !important;
  background-color: #28a745 !important;
  border-color: #28a745 !important;
  text-shadow: 0 -1px 0 rgba(0, 0, 0, 0.12);
  -webkit-box-shadow: 0 2px 0 rgba(0, 0, 0, 0.045);
  box-shadow: 0 2px 0 rgba(0, 0, 0, 0.045);
}
.ant-btn-success-disabled,
.ant-btn-success.disabled,

herudi

var express = require('express');
var router = express.Router();
var person = require('./../controller/person');

router.get('/person', person.all);
router.post('/person', person.create);
router.get('/person/:person_id', person.byId);
router.get('/person/search/:name', person.search);
router.put('/person/:person_id', person.update);
router.delete('/person/:person_id', person.delete);

herudi

var db_connect = require('./../common/connection');

var person = {};

//get all person
person.all = async function (req, res) {
    try {
        var query = `select * from person`; 
        var persons = await db_connect.query(query);
        res.send(persons);

herudi

var mysql      = require('mysql');
var util = require('util');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : '',
  database : 'expressmysql',
  dateStrings: 'date'
});

herudi

CREATE DATABASE IF NOT EXISTS `expressmysql`;

CREATE TABLE `person` (
`person_id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NULL DEFAULT NULL,
`address` VARCHAR(50) NULL DEFAULT NULL,
`phone` VARCHAR(15) NULL DEFAULT NULL,
`created_at` TIMESTAMP NULL DEFAULT NULL,
`updated_at` TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (`person_id`))

herudi

var express = require('express');
var router = require('./routes/router');
var app = express();

app.use(express.json());
app.use(express.urlencoded({ extended: true }));
app.use('/', router);
app.listen(3000, function(){
	console.log('port 3000')
});