Ms Rdbms

GitbookMicroservices2021-02-16


📑 DB


create database dbms;
create user dbms_user;
ALTER USER 'dbms_user' IDENTIFIED WITH mysql_native_password  BY 'dbms~123456$'

use dbms;
grant all privileges on *.* to 'dbms_user';

use mysql;
update user set authentication_string=password('test') where user='test' and Host='localhost';

FLUSH PRIVILEGES;

🪕 sequelize


  • sequelize-cli,
  • sequelize-auto
$ npx sequelize-cli init
$ npx sequelize-cli model:generate - name User - attributes firstName:string,lastName:string,email:string
$ npx sequelize-auto -o "./models" -d dbname -h localhost -u test -p 3306 -x motdepasse -e mysql

🪕 Model Query


  • findAll
  • findByPk
  • findOne
  • findOrCreate
  • findAndCountAll

📑 API


CRUD API 说明
User GET /api/users 取所有用户信息