​​​​​​​​✅ Aprendar como criar um CRUD para manipular o MYSQL e consumir via Venom-BOT​

📁​ Arquivos prontos para download nessa aula.

​​👉 ​INSTRUÇÕES BÁSICAS:

CRUD (Create, Read, Update, Delete)

1. BAIXAR O GIT, NODE, VISUALSTUDIO, XAMPP

2- CRIAR DATABASE: TEST

3- ABRIR O GIT

a. cd Desktop

b. mkdir venom-crud

c. cd venom-crud

d. git clone https://github.com/orkestral/venom.git

e. git clone https://github.com/adriansyahdicky/crud_node_react...

=========================================

BACKEND CRUD

cd nodeBackend

npm install

const sequelize = new Sequelize(

    'test', //database

    'root', //username

    '', //password

    {

        host: 'localhost',

        dialect: 'mysql',

        port: 3306

    }

);

node App.js

=========================================

FRONTEND CRUD

cd nodeapp

npm install

npm install node-sass

npm update bootstrap

alterar ips

npx browserslist@latest --update-db

alterar URL nos modules

popular database roles (Admin, Project Manager, Programer)

npm start

=========================================

VENOM-BOT

cd venom

npm install mysql2

npm install venom-bot

config mysql.js (helper)

config app.js (ajustar roles)

node app-mysql.js