Skip to content

Latest commit

 

History

History
66 lines (55 loc) · 1.7 KB

INSTALLATION.md

File metadata and controls

66 lines (55 loc) · 1.7 KB
Raw

Procedure to install and run the Code

1. Requirements

  1. Node js
  2. NPM
  3. MySQL

2. Clone the repo

git clone https://github.com/Akilan1999/Centralized_IOE.git

Navigate to the directory

cd Centralized_IOE/

3. Add your sql username and password

Navigate to config/database.js

var connection = mysql.createConnection({
  host: 'localhost',
  user: 'ADD YOUR USERNAME', //DB username
  password: 'ADD YOUR PASSWORD', //DB password
  database: 'shared_electricity'
});

4. Adding the sql database to your localhost

  1. Login to SQL
mysql -u root -p
  1. Import shared_electricity.sql
mysql> source \shared_electricity.sql;
  1. Basic insert statements which are nessary
mysql> insert into users values(0,'<your name>','<your username>','<your password>');
  1. Only for testing you can do some inserts statement (Remember the primary is auto_increment so once a insert is done the that table -> The next inserts should done without inserting the primary key value as it's automatically incremented);

Ex: This is for adding batteries

mysql> insert into battery_info values(0,2,'POWERWALL 1','Solar City',500,300);
mysql> insert into battery_info(user_id,model_no, manufacturing_company,Storage,Current_power) values(2,'POWERWALL 2','Solar City',500,500);

5. Start server

node app.js

URL: http://localhost:8003

6. Login with the username and password in the DB.

If successful this should be your home page

7. SQL Er-Diagram

Note : The password is not hashed.