This is a quick back-end system. You need create more modules, more versions, more APIs.. with only one json metadata
mongod --port 27017
npm install -g c-core
c-core init
c-core update
cp .env.copy .env
c-core start
npm init project-name
Open the file package.json and update tag "scripts"
"scripts": {
"init": "cross-env START_WITH=init node index.js",
"start": "cross-env START_WITH=start node index.js",
"update": "cross-env START_WITH=update node index.js",
"generate-doc": "cross-env START_WITH=apidoc node index.js",
"clean-doc": "find . -type f -name '_doc.js' -delete",
"apidoc": "npm run generate-doc && apidoc -i api/ -o doc/ && npm run clean-doc"
}
Add dependencies
npm install --save c-core
npm install --save-dev apidoc
npm install --save-dev cross-env
const core = require('c-core');
const cmd = process.env.START_WITH ? process.env.START_WITH : 'start';
try {
core(cmd);
} catch (e) {
console.error(e);
}
cp .env.copy .env
npm run start
Now go to homepage http://localhost:3000
Create file: api/database/mongo.json
{
"driver": "mongoose",
"connection": "mongodb://{HOST}:{PORT}/{DATABASE}",
"options": {
"useNewUrlParser": true,
"useUnifiedTopology": true,
"serverSelectionTimeoutMS": 5000
}
}
Add configuration to setting file: api/setting.json
"database": [
{
"MONGO_DB_HOST": "localhost",
"MONGO_DB_PORT": "27017",
"MONGO_DB_NAME": "eco",
"MONGO_DB_USERNAME": "",
"MONGO_DB_PASSWORD": ""
}
],
npm install --save mysql
Create file: api/database/mysql.json
{
"driver": "mysql",
"database": "[DATABASE]",
"config": {
"connectionLimit" : 10,
"host" : "[SERVER]",
"user" : "[USERNAME]",
"password" : "[PASSWORD]",
"database" : "[DATABASE]"
}
}
Add configuration to setting file: api/setting.json
"database": [
{
"MYSQL_DB_PORT": "3306",
"MYSQL_DB_SERVER": "localhost",
"MYSQL_DB_DATABASE": "eco",
"MYSQL_DB_USERNAME": "eco",
"MYSQL_DB_PASSWORD": "eco"
}
],
npm install --save mssql
Create file: api/database/mssql.json
{
"driver": "mssql",
"database": "[DATABASE]",
"connection": "Server=[SERVER],[PORT];Database=[DATABASE];User Id=[USERNAME];Password=[PASSWORD];",
"config": {
"user": "[USERNAME]",
"password": "[PASSWORD]",
"server": "[SERVER]",
"database": "[DATABASE]",
"connectionTimeout": 15000,
"requestTimeout": 150000,
"pool": {
"min": 1,
"max": 20,
"idleTimeoutMillis": 30000
},
"options": {
"port": "[PORT]",
"appName": "node-mssql",
"encrypt": false,
"useUTC": true
}
}
}
Add configuration to setting file: api/setting.json
"database": [
{
"MSSQL_DB_PORT": "1433",
"MSSQL_DB_SERVER": "10.0.0.15\\sql2012",
"MSSQL_DB_DATABASE": "eco",
"MSSQL_DB_USERNAME": "sa",
"MSSQL_DB_PASSWORD": "2008"
}
],
HTTP/1.1 200 OK
[
{
"gender": "male",
"_id": "5e7115bd926d13129e9b1cdf",
"username": "username",
"email": "email@domain.com",
"password": "password",
"age": 65,
"phone": "0999999999",
"birthday": "2020-03-17T07:06:16.664Z",
"salary": 1500.8,
"avatar": "https://i.pinimg.com/originals/90/b0/b3/90b0b3b15ccecf9efda592b0bdf462aa.jpg",
"last_ip": "30.230.33.25"
}
]
Also when doing requests, it's good to know that:
- If you make POST, PUT, PATCH or DELETE requests, changes will be automatically.
- Your request body JSON should be object enclosed, just like the GET output. (for example
{"name": "Foobar"}
) - Id values are not mutable. Any
id
value in the body of your PUT or PATCH request will be ignored. Only a value set in a POST request will be respected, but only if not already taken. - A POST, PUT or PATCH request should include a
Content-Type: application/json
header to use the JSON in the request body. Otherwise it will result in a 200 OK but without changes being made to the data.
GET -> /*/auth/get-token (*)
GET -> /*/auth/refresh-token (token)
GET -> /*/system/get-captcha (token)
GET -> /v1.0.0/setting/default (token)
GET -> /v1.0.0/setting/init/:password (token)
GET -> /v1.0.0/setting/get-by-id/:id (token,admin)
PUT -> /v1.0.0/setting/get-all (token,admin)
POST -> /v1.0.0/setting/add (token,admin)
POST -> /v1.0.0/setting/edit (token,admin)
DELETE -> /v1.0.0/setting/delete (token,admin)
DELETE -> /v1.0.0/setting/deletes (token,admin)
POST -> /v1.0.0/upload/file (token)
PUT -> /v1.0.0/user/login (token)
PUT -> /v1.0.0/user/logout (token)
PUT -> /v1.0.0/user/login-social (token)
PUT -> /v1.0.0/user/admin (token)
PUT -> /v1.0.0/user/check-username (token)
PUT -> /v1.0.0/user/check-email (token)
PUT -> /v1.0.0/user/forgot-password (token)
PUT -> /v1.0.0/user/reset-password (token)
PUT -> /v1.0.0/user/register-user (token)
PUT -> /v1.0.0/user/change-password (token,login)
PUT -> /v1.0.0/user/send-password (token,admin)
POST -> /v1.0.0/user/add-child (token,login)
GET -> /v1.0.0/user/get-children (token,login)
DELETE -> /v1.0.0/user/del-child (token,login)
POST -> /v1.0.0/user/add-user (token,admin)
POST -> /v1.0.0/user/edit-user (token,login)
GET -> /v1.0.0/user/get-by-id/:id (token,login)
GET -> /v1.0.0/user/get-all (token,admin)
PUT -> /v1.0.0/user/active-user (token,admin)
PUT -> /v1.0.0/user/disable (token,login)
DELETE -> /v1.0.0/user/delete-user (token,admin)
DELETE -> /v1.0.0/user/delete-users (token,admin)
1. c-core init
2. c-core update
3. c-core apidoc
4. c-core start [options]
Options:
--port, -p Start app with port
--host, -h Start app with host
--help Show help [boolean]
--version, -v Show version number [boolean]
Examples:
c-core init
c-core update
c-core apidoc
c-core start -h localhost -p 3000
https://www.npmjs.com/package/c-core
npm install -g pm2
pm2 startup
cp process.json.copy process.json
pm2 start process.json
pm2 save
npm install -g pkg
npm run pack-linux | pack-mac | pack-win
MIT