node-express-mvc-cli or create-node-express

客户端请求一个路由,通过路由转发给控制器，控制器引入 models 和处理各种业务逻辑，models 专门封装对数据的增删查改操作。再返回给控制器，最后结果返回到view

node 基于 express 的脚手架

命令行

yarn add commander --save

用户交互 inquirer

this.registerPrompt('list', require('./prompts/list'));
this.registerPrompt('input', require('./prompts/input'));
this.registerPrompt('number', require('./prompts/number'));
this.registerPrompt('confirm', require('./prompts/confirm'));
this.registerPrompt('rawlist', require('./prompts/rawlist'));
this.registerPrompt('expand', require('./prompts/expand'));
this.registerPrompt('checkbox', require('./prompts/checkbox'));
this.registerPrompt('password', require('./prompts/password'));
this.registerPrompt('editor', require('./prompts/editor'));

！!//@ ! "inquirer": "^7.0.3", yarn add inquirer --save

"ora": "^6.1.2"

"ora": "^4.0.3"

命令行等待优化 const ora = require('ora') const processGenFiles = ora('Create project……') processGenFiles.start() // 进度条开始 await genFiles(answers); processGenFiles.succeed(Create project complete: i18n-b-${name})

git 模版下载 download-git-repo

大部分 CLI 工具的模版并不在本地，而是从网上下载。可以用 download-git-repo 这个库，以及 github API

const { promisify } = require('util')

const clone = async function (repo, desc) { const download = promisify(require('download-git-repo')) // download-git-repo: Download and extract a git repository (GitHub, GitLab, Bitbucket) const ora = require('ora') const process = ora(下载......${repo}) process.start() // 进度条开始 await download(repo, desc) // download-git-repo 导出的 download 方法，第一个参数 repo 是仓库地址，格式有三种： // GitHub - github:owner/name or simply owner/name // GitLab - gitlab:owner/name // Bitbucket - bitbucket:owner/name process.succeed() }

await clone('[email protected]:sz-web/i18n-b-dashboard.git', name)

用法：：：：：

yarn start init

yarn start init --use-yarn

yarn start init-mvc

edit-json-file

let file = editJsonFile(destination + '/package.json', { autosave: true });

file.set('name', path.basename(destination));

ncp 拷贝生成依赖

dotenv

Create a .env file in the root of your project: S3_BUCKET="YOURS3BUCKET" SECRET_KEY="YOURSECRETKEYGOESHERE"

module-alias

require('../../../../some/very/deep/module') 可以写成为： import module from '@deep/module'

express-async-errors

app.get('/users', async (req, res) => { const users = await User.findAll(); res.send(users); });

流程

需不需要 typescript------------ yes no

目录：：：

Controller 前后端交互层控制器 Service 后端业务逻辑层 Mapper 操作数据库 Model 类型定义 Config 配置文件 Utils 工具类 Statci 静态文件

问题

yarn run v1.22.5 $ node bin/cli.js init internal/modules/cjs/loader.js:1085 throw new ERR_REQUIRE_ESM(filename, parentPath, packageJsonPath); ^

Error [ERR_REQUIRE_ESM]: Must use import to load ES Module: C:\material\NODE\node-express-cli\node_modules\ora\index.js require() of ES modules is not supported. require() of C:\material\NODE\node-express-cli\node_modules\ora\index.js from C:\material\NODE\node-express-cli\lib\node-express-mvc-cli.js is an ES module file as it is a .js file whose nearest parent package.json contains "type": "module" which defines all .js files in that package scope as ES modules. Instead rename index.js to end in .cjs, change the requiring code to use import(), or remove "type": "module" from C:\material\NODE\node-express-cli\node_modules\ora\package.json. at require (internal/modules/cjs/helpers.js:88:18) at Object. (C:\material\NODE\node-express-cli\lib\node-express-mvc-cli.js:9:13) at Module._compile (internal/modules/cjs/loader.js:1068:30) at Object.Module._extensions..js (internal/modules/cjs/loader.js:1097:10) at Module.load (internal/modules/cjs/loader.js:933:32) at Function.Module._load (internal/modules/cjs/loader.js:774:14) { code: 'ERR_REQUIRE_ESM' }

var inquirer = require('inquirer');

const questions = [ { type: 'confirm', name: 'order', message: '您好，需要点餐吗?', default: true, }, { type: 'number', name: 'amount', message: '你们几个人?', default: 1, }, { type: 'list', name: 'mainFood', message: '主食需要吃点什么？', choices: ['Rice', 'Noodle', 'Pizza'], // 对用户的回答进行转换，返回转换过的结果 filter(val) { return val.toLowerCase(); }, default: 'Pizza', // 注意：default 值为转化前的值 }, { type: 'list', name: 'smell', message: '需要什么口味的？', choices: [ { key: 0, name: "辣", value: "hot" }, { key: 1, name: "甜", value: "sweet" }, ], }, { type: 'rawlist', message: 'Pizza 要多大尺寸的？', name: 'size', choices: ['5 寸', '6 寸', '7 寸'], when(answers) { return answers.mainFood === 'pizza'; }, default: 1, // default 是选项在 choices 数组中的索引 }, { type: 'checkbox', name: 'menu', message: '想要吃点什么菜?', choices: [ { name: '东坡肉', checked: true, }, { name: '剁椒鱼头', }, { name: '法式鹅肝', disabled: '卖完了', }, { name: '西红柿炒鸡蛋', }, ], }, { type: 'expand', name: 'drinks', message: '饮料喝点什么?', choices: [ { key: 'a', // key 必须是单个小写的字符 name: '小麦茶', value: 'XiaoMaiCha', }, { key: 'b', name: '雪碧', value: 'XueBi', }, { key: 'c', name: '果粒橙', value: 'GuoLiCheng', }, ], default: 0, // default 值必须是选项在 choices 数组中的索引 }, { type: 'input', name: 'vipCard', message: "请输入会员卡号", validate(value) { const pass = /^\d{8}$/.test(value); if (pass) { return true; }

  return '会员卡号是8位纯数字！';
},

}, { type: 'password', name: 'pwd', message: '请输入会员卡密码', mask: '*', validate(value) { let valid = value.length === 6;

  return valid || '密码必须是6位！';
},

}, { type: 'editor', name: 'suggest', message: '您对本店有什么建议吗？', }, ];

inquirer .prompt(questions) .then((answers) => { console.log(answers) }) .catch((error) => { if (error.isTtyError) { // Prompt couldn't be rendered in the current environment } else { // Something else went wrong }

知识点：

const UserModel = (param: any) => { console.log(param, "param"); return new Promise((resolve, reject) => { const res = db.sequelizeRoot.query(SELECT * FROM user where id=${param}, { type: db.sequelizeRoot.QueryTypes.SELECT, });

console.log("Database syntax error", res);

// const isError = res.then((e: any) => {
//   console.log(e, "6666");
//   return e;
// });
// console.log("Database syntax error111", isError);

// /register
// middleware...
// 7 param
// 66666 Promise { <pending> }
// TRY ERROR[object Promise]

// if (res) {
//   reject(res);
// }

resolve(res);

}).then((val: any) => { console.log("val", val); const res = db.sequelizeRoot.query( SELECT * FROM user where userId='${val[0].userId}', { type: db.sequelizeRoot.QueryTypes.SELECT, } );

return res;

}); };