Currency-Exchange

Simple Demo for Currency Exchange Web app and it's related service

Prerequisites

install Mysql -- https://dev.mysql.com/downloads/mysql/
install Git https://git-scm.com/download/win
install node.js -- https://nodejs.org/en/

Keep in mind

Please make sure to make mysql username: root and the password: 123456 because root user credentails will be used when deploying the db script in Currency-Exchange\db\mysqlScripts\mysqlrunner.dev windows command and in the server and the service configuration files.
Please make sure to choose default collation utf8 when installing mysql .

Deployment process

Run Currency-Exchange\db\mysqlScripts\mysqlrunner.dev for deploying the needed scripts.
Run Currency-Exchange\server\install command for installing the needed node.js modules for the server.
Run Currency-Exchange\service\install command for installing the needed node.js modules for the service.

Running process

Run Currency-Exchange\service\run service command for starting the currency exchange service
Run Currency-Exchange\server\run server command for starting the currency exchange server
Browse\Currency-Exchange\website\index.html file.

Design overview

Currency Exchange Service :

responsible to get the currency exchange rates from the third party and insert these rates in the DB.

ExchangeRate table : used to maintain the latest rate for each currency.
ExchangeRatesLogs table : will be used in the future for making exchange rates chart and also for the data validity.
Scheduler table : used to maintain the last date when the service has been run.

Currency Exchange Server

responsible for the Restful API .

Restful API :

convert : convert a given value from currency to currency using the latest rates .
- http Method : GET
- params : fromCurrency , toCurrency , value
getRates : get all curency rates for a specifc currency
- http Method : GET
- params : currency