Bank

A Bank application designed using Python and a custom MySQLconnector API to communicate with a MySQL database. This will allow the Bank to manage persistent data and is ACID compliant.

Config

A config.ini file is required and must contain login credentials in the following format:


## Start of File ##

[MYSQL]

host = yourHostName

username = yourUsername

password = yourPassword

database = yourDatabaseName

## End of File ##

MySQL database schema

CREATE TABLE “accounts” (

“account_no” int AUTO_INCREMENT,

“name” varchar(15) NOT NULL,

“balance” int NOT NULL,

“open_date” datetime DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (“account_no”),

CONSTRAINT “accounts_chk_1” CHECK ((“balance” >= 0))

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;