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;