ROT13 Decryption Database

Overview

This was an educational project for me to learn and apply concepts involving standard query language (SQL), database management systems (DBMS), and object relational mappings (ORM).

Project Description

This project:

• Builds a local database (table) using a DBMS (ex/ MySQL)
• Generates random ROT13 decryption puzzles for the user to answer
• Inserts the answers into the database table
• Queries the table to determine puzzle accuracy
• Displays correct vs incorrect puzzle results

For more details regarding my experience building the project, check the Project Description

Demo

---

Dependencies

• Python 3.11 or greater
• Relational Database Management System (ex/ MySQL, PostgreSQL, SQLite, etc.)
• Python packages:
  • SQLAchemy
  • Random
  • Plotext

How to run this project yourself

1. Clone this repo:

git clone https://github.com/a-rust/rot13-puzzle.git
cd rot13_puzzle

1. Load up a DBMS:

-- For example, using MySQL
mysql -u <user_name> -p
# Enter password  

2. Create a new database:

-- For example, using MySQL
CREATE DATABASE <database_name>

3. Run ./src/database.py:

python3 ./src/database.py

4. Interact with the terminal, and check your database for the full results in the table 'Rot13':

-- For example, using MySQL
SELECT * FROM Rot13_Puzzles