PureSQL+sqlite3

Generates fake data to the SQLite3 DB, then executes a series of pure SQL scripts (from 1 to 13) with queries to the fake data.

When main.py executed, asks if you want to re-generate the database.
If yes, then re-creates a new SQLite3 DB from the 'script.sql' file.
Then generates fake data with 'Faker'. Uses 'groups' and 'subjects' lists during the process.
Converts the data to the format that is suitable for the upload to the DB. For example, adds random date for each mark.
Uploads everything by replacing values in the pre-set SQL queries.
Finishes
If no, runs all available scripts that are named by the template.
Scripts are filled with the pure SQL queries for the fake data.

Name		Name	Last commit message	Last commit date
Latest commit History 5 Commits
.gitattributes		.gitattributes
.gitignore		.gitignore
LICENSE		LICENSE
README.md		README.md
college.db		college.db
main.py		main.py
poetry.lock		poetry.lock
pyproject.toml		pyproject.toml
query_1.sql		query_1.sql
query_10.sql		query_10.sql
query_11.sql		query_11.sql
query_12.sql		query_12.sql
query_13.sql		query_13.sql
query_2.sql		query_2.sql
query_3.sql		query_3.sql
query_4.sql		query_4.sql
query_5.sql		query_5.sql
query_6.sql		query_6.sql
query_7.sql		query_7.sql
query_8.sql		query_8.sql
query_9.sql		query_9.sql
script.sql		script.sql

Provide feedback