nogibjj / sjg80-miniproject5-sqlite-lab Goto Github PK

This is a Python project that demonstrates how to create a script that interacts with a MySQL database. The project allows you to connect to a MySQL database, perform CRUD (Create, Read, Update, Delete) operations, and includes tests to verify the functionality.

This project focus on the following points: Requirements:

1. Connect to a SQL Database: • The script must establish a connection to an SQL database, allowing it to interact with the database.
2. Perform CRUD Operations: • The script should perform CRUD (Create, Read, Update, Delete) operations on the SQL database.
3. Write at Least Two Different SQL Queries: • The script must include a minimum of two distinct SQL queries that serve a specific purpose in the context of the application.

• Use an AI Assistant, but use a different one then you used from a previous lab (Anthropic's Claud, Bard, Copilot, CodeWhisperer, Colab AI, etc)
• ETL-Query: [E] Extract a dataset from URL, [T] Transform, [L] Load into SQLite Database and [Q] Query For the ETL-Query lab:
• [E] Extract a dataset from a URL like Kaggle or data.gov. JSON or CSV formats tend to work well.
• [T] Transform the data by cleaning, filtering, enriching, etc to get it ready for analysis.
• [L] Load the transformed data into a SQLite database table using Python's sqlite3 module.
• [Q] Write and execute SQL queries on the SQLite database to analyze and retrieve insights from the data.

• Fork this project and get it to run
• Make the query more useful and not a giant mess that prints to screen
• Convert the main.py into a command-line tool that lets you run each step independantly
• Fork this project and do the same thing for a new dataset you choose
• Make sure your project passes lint/tests and has a built badge
• Include an architectural diagram showing how the project works