[学習メモ]エンジニア探検隊#2 -DBを立ててみる- - Qiita

from flask import Flask, jsonify,request import csv import mysql.connector,json app = Flask(__name__) def select_to_json(table): sql = (f'INSERT INTO {table}(name, score) values (%s, %s)') cursor.execute('select * from shooting_db.scores') data = cursor.fetchall() records = [] for row in data: record = {'name': row[0], 'score': row[1]} records.append(record) records = sorted(records, key=lambda x: