/python-mysql-example

A small example to show how to use mysql in python.

Primary LanguagePythonMIT LicenseMIT

python-mysql-example

A small example to show how to use mysql in python.

It's only a teaching challenge for a my friend and it use by default (hardcoded) the "test" database and the "customers" table.

Requirements

Prepare

Create .env file with your mysql credentials

DB_USERNAME=foo
DB_PASSWORD=bar

Activate virtual environment

source env/bin/activate

Install dependencies

pip install -r requirements.txt

Deactivate the virtual environment when you finished

deactivate

Usage

Run ./main.py, enter a string (name) and a number (revenue):

./main.py   # OR    python main.py
Customer name: foo
Customer revenue: 123

READ:   []
CREATE
READ:   [('foo', None)]
UPDATE
READ:   [('foo', Decimal('123'))]
DELETE
READ:   []