from flask import Flask
import mysql.connector
# === DB 接続情報
"""
テスト用 DB & テーブル
CREATE DATABASE sample_db;
USE sample_db;
CREATE TABLE users (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(50) NOT NULL,
email_address VARCHAR(100) NOT NULL,
PRIMARY KEY (id)
);
use sample_db;
insert into users (name, email_address) values
('John Smith', 'john@example.com'),
('Jane Doe', 'jane@example.com'),
('Bob Johnson', 'bob@example.com'),
('Alice Lee', 'alice@example.com'),
('Mike Davis', 'mike@example.com');
"""
def conn_db():
conn = mysql.connector.connect(
host='127.0.0.1',
user='root',
password='root',
port='33306',
# db='flask_db_01'
db='sample_db'
)
return conn
# SQL 文
sql = 'SELECT * FROM users'
try:
conn = conn_db()
cursor = conn.cursor()
cursor.execute(sql)
rows = cursor.fetchall()
except(mysql.connector.errors.ProgrammingError) as e:
print('エラー')
print(e)
print('select開始')
for r_val in rows:
print(r_val[0], r_val[1], r_val[2])