setup

inpunwbs02-wcg.corp.capgemini.com

mysqld -P3306 --skip-grant-tables

mysql -P3306 mysql

update mysql.user set authentication_string=password('admin') where user='root';

MYSql scripts:
db_account:
-----------

CREATE TABLE customer
(
    customer_id integer NOT NULL,
    customer_name varchar(20)  NOT NULL,
    password varchar(20) ,
    last_login date,
    mobile_no integer,
    email_id varchar(50) ,
    CONSTRAINT pk_custid PRIMARY KEY (customer_id)
);


INSERT INTO customer( customer_id ,  customer_name ,  password ,  last_login ,  mobile_no ,  email_id ) VALUES
(556677,	'Raja',	'capg123',	NULL,	NULL,	NULL);

INSERT INTO customer ( customer_id ,  customer_name ,  password ,  last_login ,  mobile_no ,  email_id ) VALUES
(556678,	'Mahesh',	'capg123',	NULL,	NULL,	NULL);




CREATE TABLE account_tansaction
(
    transaction_id numeric NOT NULL,
    tx_date timestamp,
    tx_details varchar(200) ,
    tx_type varchar(300),
    account_no numeric(16),
    tx_value numeric(10, 2),
    tx_description varchar(250) ,
    CONSTRAINT account_tansaction_pkey PRIMARY KEY (transaction_id)
);

INSERT INTO account_tansaction(transaction_id, tx_date, tx_details, tx_type, account_no, tx_value, tx_description)
	VALUES (1, '2017-02-12 12:23:42', 'Credit ref no 123456', 'CR', 556677, 1200, 'Credit by Cash');
    
INSERT INTO account_tansaction(transaction_id, tx_date, tx_details, tx_type, account_no, tx_value, tx_description)
	VALUES (2, '2017-02-18 12:23:42', 'Debit ATM ref No 1234564', 'DR', 556677, 1600, 'Debit at ATM');
    
INSERT INTO account_tansaction(transaction_id, tx_date, tx_details, tx_type, account_no, tx_value, tx_description)
	VALUES (3, '2017-02-01 12:23:42', 'Credit ref No 324234', 'CR', 556677, 1500, 'Credti by Netbanking');

	
	
CREATE TABLE account
(
    account_no integer NOT NULL,
    customer_id integer,
    ifsc_code varchar(30)  NOT NULL,
    account_type varchar(20)  NOT NULL,
    account_balance double precision NOT NULL,
    account_creation_date date,
    account_status boolean NOT NULL,
    CONSTRAINT pk_accno PRIMARY KEY (account_no),
    CONSTRAINT account_customer_id_fkey FOREIGN KEY (customer_id)
        REFERENCES customer (customer_id) 
);



INSERT INTO account (account_no, customer_id, ifsc_code, account_type, account_balance, account_creation_date, account_status) VALUES
(355245,	556677,	'DBSB238',	'S',	25000,	'2016-11-12',	1),
(355230,	556677,	'DBSB234',	'S',	5000,	'2016-11-08',	1),
(355650,	556677,	'DBSB274',	'S',	50000,	'2016-12-03',	1),
(355680,	556678,	'DBSB244',	'S',	50000,	'2016-01-03',	1),
(3557230,	556678,	'DBSB294',	'S',	50000,	'2016-11-11',	1);


Kill process on specific port
=================================
netstat -ano | findstr :yourPortNumber

taskkill /PID typeyourPIDhere /F



Docker
======
Download the boot2docker.iso file manually by going to https://api.github.com/repos/boot2docker/boot2docker/releases/latest then clicking on the html_url and finally choosing to download the file.

Once you get the file go and place it manually in /Users/{user}/.docker/machine/cache/

Finally re-run this command docker-machine create --driver virtualbox default