[Recipe of Code] GET /makers

restapi_get_makers.py

import pandas as pd
import pymysql
from flask import Flask, request
from flask_restful import Api, Resource


host = 'your_mysql_ip'
user = 'your_username'
password = 'your_password'
database = 'rest'


class Makers(Resource):
    """ /makers """
    def get(self):
        query = f'SELECT * FROM rest.Makers'
        conn = pymysql.connect(host=host, user=user, password=password, database=database)
        dataframe = pd.read_sql(sql=query, con=conn)
        conn.close()
        
        makers = dataframe.to_dict('record')
        ret = { 'data': makers }
        return ret, 200

    
if __name__ == '__main__':
    app = Flask(__name__)
    api = Api(app)

    api.add_resource(Makers, '/makers')
    app.run(host='0.0.0.0', port=5555)