Traders

See project on retool.com

Creating a database from existing tables, queries to the database

Use all data from tables Northwind_Traders/assets/databases;

Project will work from existing database : Northwind_Traders/assets/northwinddb.sql

Express + PostgreSQL + Sequelize + Bootstrap

Endpoints

GET http:\{your_host}:{your_port}/ - start page;

GET http:\{your_host}:{your_port}/employees - get all employees;

GET http:\{your_host}:{your_port}/employees/:employeeid - get employees with current id;

GET http:\{your_host}:{your_port/customers - get all customers;

GET http:\{your_host}:{your_port}/customers/:customerid - get customers with current id;

GET http:\{your_host}:{your_port}/products - get all products;

GET http:\{your_host}:{your_port}/products/:productid - get products with current id;

GET http:\{your_host}:{your_port}/orders - get all orders;

GET http:\{your_host}:{your_port}/orders/:orderid - get orders with current id;

GET http:\{your_host}:{your_port}/suppliers/ - get all suppliers;

GET http:\{your_host}:{your_port}/suppliers/:supplierid - get suppliers with current id;

GET http:\{your_host}:{your_port}/search/ - search for products names or company name, contact name, contacttitle;

GET http:\{your_host}:{your_port}/dashboard - get all users sql query;