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 | 取所有用户信息 |
