database-project

This project provides simple REST API for your MySQL database with user authorization support. There is also a sample frontend written in Angular.js

How to run the backend + sample frontend

• Install Node.js
• npm install
• node server.js
• point your browser to http://localhost:3000

Quick API reference:

Authorization:

• /login (GET - returns 200 if user is authorized, POST - logs user in)
• /logoff (GET - log user off)

Fetching data from tables:

• /tables (GET - list tables)
• /table/:name (GET - list avaliable fields in the given table or view)
• /table/:name/:fields (GET - fetches data for the fields separated by commas)
• /reports (GET - list views)

Writing data to the tables:

• /table/:name/:key/:id (POST - updates row on the given value of key)