notes.txt

//Our npm commands: 
// npm init -y
// npm i react react-dom
// npm install -D babel-loader @babel/core @babel/preset-env @babel/preset-react  
// npm i -D style-loader file-loader css-loader sass-loader sass
// npm install webpack-dev-server --save-dev
// npm i -D webpack webpack-cli
// npm install --save-dev html-webpack-plugin

// npm install nodemon
//npm install express
//npm install node-fetch
// npm install react-router react-router-dom pg
// npm install -D source-map-loader
// npm install cors
// npm install moment --save
npm install dotenv --save
npm i eslint 
// npx webpack serve
// npm install concurrently
// npm install chart.js
// npm install react-chartjs-2


SQL commands

CREATE TABLE poll (id BIGSERIAL NOT NULL PRIMARY KEY, poll_id INT NOT NULL, poll_options VARCHAR(50), users VARCHAR(50), entries VARCHAR(50));


INSERT INTO poll (poll_id, poll_options) values (1, 'cats');
INSERT INTO poll (poll_id, poll_options) values (1, 'dogs');
INSERT INTO poll (poll_id, poll_options) values (1, 'birds');


INSERT INTO poll (poll_id, users, entries) values (1, 'Bob', 'dogs');

SELECT * FROM poll;  see all of cell_bank


ALTER TABLE poll ADD COLUMN poll_prompt VARCHAR(100);

INSERT INTO poll (poll_id, poll_prompt) values (1,'What is your favorite type of pet?');

//spelled fishes wrong so correcting it
UPDATE poll SET poll_options = 'fishes' WHERE id = 7;

//update jess
"UPDATE poll SET poll_id, options=$2, users=$3, entries=$4 WHERE id=$5 returning *"