[NDB] React with Node.js

[NDB] React with Node.js

memorize.aimemorize.ai (lvl 286)
Section 1

Preview this deck

JSONLint for Validation

Front

Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (19)

Section 1

(19 cards)

JSONLint for Validation

Front

https://jsonlint.com

Back

Start the project

Front

npm start or yarn start

Back

VSC git issue with directory massive change

Front

git add . git commit -m "whatever" git push origin master restart vsc

Back

Invalid active developer path (git --version)

Front

xcode-select --install

Back

install mysql using node

Front

npm install --save mysql

Back

view all customers API with MYSQL call

Front

app.get('/api/customers', (req, res) => { connection.query( "SELECT * FROM CUSTOMER", (err, rows, field) => { res.send(rows); } ); });

Back

create-react-app

Front

npm install -g create-react-app

Back

Create a project called management

Front

create-react-app management

Back

Don't forget comma inside query

Front

let sql = "INSERT INTO CUSTOMER VALUES (NULL, ?, ?, ?, ?, ?)"; NOT let sql = "INSERT INTO CUSTOMER VALUES (NULL, ? ? ? ? ?)";

Back

Create AWS RDS

Front

Free tier. MYSQL. Param group with UTF-8 general ci

Back

Download multer for arbitrary input file name

Front

npm install multer --save

Back

HeidiSQL or Sequel Pro for mac

Front

Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases.

Back

npm run dev

Front

"dev": "concurrently --kill-others-on-fail \"npm run server\" \"npm run client\""

Back

Progress Bar (Circular determinate) from Material UI

Front

Back

Material UI

Front

Similar to bootstrap but gives more powerful features for React. You don't have to know CSS in details.

Back

Edit inbound traffic (AWS RDS)

Front

Back

Git init and config

Front

git init git config --global user.email "git이메일주소" git config --global user.name "git이름(별명)" git remote add origin "깃주소" git add . git commit -m "Init" git push origin master

Back

Create database.json

Front

and add the file on gitignore # database /database.json

Back

Customer Map method for iterating

Front

{ customers.map(c=> { return ( <Customer key={c.id} id={c.id} image={c.image} name={c.name} birthday={c.birthday} gender={c.gender} job={c.job}/> )}) }

Back