Making a Database Schema

Database

One of or if not the most important tool to store data! 

For this project, we will be using mysql, which is already set up as, with the root and two users, Jenny and Liam! 

 

The general idea is to have a database schema like this in a relational database. 

https://dbdiagram.io/   --> this basically puts in the sql queries and make it into a database schema!

For this, we will be using mysql, with the python library mysql.connector, and the workbench that is installed on our local computers. 

mysql workbench

This query creates a table called anime, forum_ids and comments in a database schema called myanimelist.  

We will be using the following libraries for these quereies : 

import mysql.connector  # to connect to mysql server
import requests
import json

To connect to the following database, use 

host = 'localhost'
database = 'myanimelist'
user = 'jenny'
password = ''

cnx = mysql.connector.connect(user=user, password=password, host=host, database=database)
cursor = cnx.cursor

This will connect to the database and it will allow making queries 

# Perform a query
query = "SELECT * FROM anime;"
cursor = cnx.cursor()
cursor.execute(query)

# Fetch and print the results
for result in cursor:
    print(result)

# Close the cursor and connection
cursor.close()
cnx.close()

Checked it connected successfully! 

 

Next step is the headache part, which is calling the right API data and inserting that correct data into the database for each table.