(flask_env) % pip install wtforms==3.0.1

(flask_env) % pip install email-validator==2.0.0.post2

# forms.py
from flask_wtf import FlaskForm
from wtforms import StringField, PasswordField, IntegerField, SubmitField, DateField, RadioField, SelectField, BooleanField, TextAreaField
from wtforms.validators import DataRequired, Email, EqualTo, NumberRange

class EntryForm(FlaskForm):
    name = StringField('Name', validators=[DataRequired()])
    age = IntegerField('Age', validators=[DataRequired(), NumberRange(min=0, max=120)])
    password = PasswordField('Password', validators=[DataRequired()])
    confirm_password = PasswordField('Confirm Password', validators=[DataRequired(), EqualTo('password')])
    email = StringField('Email', validators=[DataRequired(), Email()])
    birthday = DateField('Birthday', format='%Y-%m-%d')
    gender = RadioField('Gender', choices=[('M', 'Male'), ('F', 'Female')])
    area = SelectField('Area', choices=[('NA', 'North America'), ('EU', 'Europe'), ('AS', 'Asia')])
    is_married = BooleanField('Married')
    note = TextAreaField('Note')
    submit = SubmitField('Submit')

<!-- _formhelpers.html -->
{% macro render_field(field) %}
  <dt>{{ field.label }}
  <dd>{{ field(**kwargs)|safe }}
  {% if field.errors %}
      <ul style="color: red;">
        {% for error in field.errors %}
        <li>{{ error }}</li>
      {% endfor %}
      </ul>
    {% endif %}
    </dd>
  {% endmacro %}

from wtforms.validators import ValidationError

def contains_special_characters(form, field):
    if not any(char in field.data for char in '@#$%'):
        raise ValidationError('Field must contain one of the following characters: @, #, $, %')

class CustomForm(FlaskForm):
    name = StringField('Name', validators=[DataRequired(), contains_special_characters])
    submit = SubmitField('Submit')

# app.py
from flask import Flask, render_template, redirect, url_for
from forms import EntryForm

app = Flask(__name__)
app.config['SECRET_KEY'] = 'your_secret_key'

@app.route('/entry', methods=['GET', 'POST'])
def entry():
    form = EntryForm()
    if form.validate_on_submit():
        return redirect(url_for('result', form=form))
    return render_template('entry.html', form=form)

@app.route('/result')
def result(form):
    return render_template('result.html', form=form)

if __name__ == '__main__':
    app.run(debug=True)

{% extends "base.html" %}

{% block title %}
    <h1>WTForm: entry</h1>
{% endblock %}

{% block content %}
{% from "_formhelpers.html" import render_field %}
    <form method="POST" novalidate>
        {{ render_field(form.name) }}
        {{ render_field(form.age) }}
        {{ render_field(form.password) }}
        {{ render_field(form.confirm_password) }}
        {{ render_field(form.email) }}
        {{ render_field(form.birthday) }}
        {{ render_field(form.gender) }}
        {{ render_field(form.area) }}
        {{ render_field(form.is_married) }}
        {{ render_field(form.note) }}
        {{ form.submit() }}
    </form>
{% endblock %}

{% extends "base.html" %}

{% block title %}
    <h1>WTForm: result</h1>
{% endblock %}

{% block content %}
    <ul>
        <li>name: {{ form.name.data }}</li>
        <li>age: {{ form.age.data }}</li>
        <li>password: {{ form.password.data }}</li>
        <li>confirm_password: {{ form.confirm_password.data }}</li>
        <li>email: {{ form.email.data }}</li>
        <li>birthday: {{ form.birthday.data }}</li>
        <li>gender: {{ form.gender.data }}</li>
        <li>area: {{ form.area.data }}</li>
        <li>is_married: {{ form.is_married.data }}</li>
        <li>note: {{ form.note.data }}</li>
    </ul>
{% endblock %}

# forms.py
from flask_wtf import FlaskForm
from wtforms import StringField, PasswordField, SubmitField
from wtforms.validators import DataRequired, Email, EqualTo

class RegistrationForm(FlaskForm):
    username = StringField('Username', validators=[DataRequired()])
    email = StringField('Email', validators=[DataRequired(), Email()])
    password = PasswordField('Password', validators=[DataRequired()])
    confirm_password = PasswordField('Confirm Password', validators=[DataRequired(), EqualTo('password')])
    submit = SubmitField('Sign Up')

# app.py
from flask import Flask, render_template, redirect, url_for, flash
from forms import RegistrationForm

app = Flask(__name__)
app.config['SECRET_KEY'] = 'your_secret_key'

@app.route('/register', methods=['GET', 'POST'])
def register():
    form = RegistrationForm()
    if form.validate_on_submit():
        flash(f'Account created for {form.username.data}!', 'success')
        return redirect(url_for('home'))
    return render_template('register.html', form=form)

@app.route('/')
def home():
    return 'Home Page'

if __name__ == '__main__':
    app.run(debug=True)

<!-- templates/register.html -->
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Register</title>
</head>
<body>
    <h1>Register</h1>
    <form method="POST" action="">
        {{ form.hidden_tag() }}
        <p>
            {{ form.username.label }}<br>
            {{ form.username(size=32) }}<br>
            {% for error in form.username.errors %}
                <span style="color: red;">[{{ error }}]</span><br>
            {% endfor %}
        </p>
        <p>
            {{ form.email.label }}<br>
            {{ form.email(size=32) }}<br>
            {% for error in form.email.errors %}
                <span style="color: red;">[{{ error }}]</span><br>
            {% endfor %}
        </p>
        <p>
            {{ form.password.label }}<br>
            {{ form.password(size=32) }}<br>
            {% for error in form.password.errors %}
                <span style="color: red;">[{{ error }}]</span><br>
            {% endfor %}
        </p>
        <p>
            {{ form.confirm_password.label }}<br>
            {{ form.confirm_password(size=32) }}<br>
            {% for error in form.confirm_password.errors %}
                <span style="color: red;">[{{ error }}]</span><br>
            {% endfor %}
        </p>
        <p>{{ form.submit() }}</p>
    </form>
</body>
</html>

from wtforms.validators import ValidationError

def validate_username(form, field):
    if ' ' in field.data:
        raise ValidationError('Username must not contain spaces')

class RegistrationForm(FlaskForm):
    username = StringField('Username', validators=[DataRequired(), validate_username])
    email = StringField('Email', validators=[DataRequired(), Email()])
    password = PasswordField('Password', validators=[DataRequired()])
    confirm_password = PasswordField('Confirm Password', validators=[DataRequired(), EqualTo('password')])
    submit = SubmitField('Sign Up')

import os
from flask import Flask, render_template, redirect, url_for, flash, session
from forms import InputForm

app = Flask(__name__)
app.config['SECRET_KEY'] = os.urandom(24)

@app.route('/input', methods=['GET', 'POST'])
def input():
    form = InputForm()
    if form.validate_on_submit():
        session['name'] = form.name.data
        session['email'] = form.email.data
        return redirect(url_for('output'))
    return render_template('input.html', form=form)

@app.route('/output')
def output():
    return render_template('output.html')

if __name__ == '__main__':
    app.run(debug=True)

from flask_wtf import FlaskForm
from wtforms import StringField, SubmitField
from wtforms.validators import DataRequired, Email

class InputForm(FlaskForm):
    name = StringField('Name', validators=[DataRequired()])
    email = StringField('Email', validators=[DataRequired(), Email()])
    submit = SubmitField('Submit')

{% extends "base.html" %}

{% block title %}
    <h1>WTForm: input</h1>
{% endblock %}

{% block content %}
    {% from "_formhelpers.html" import render_field %}
    <form method="POST" novalidate>
        {{ form.csrf_token }}
        {{ render_field(form.name) }}
        {{ render_field(form.email) }}
        <br />
        {{ form.submit() }}
    </form>
{% endblock %}

{% extends "base.html" %}

{% block title %}
    <h1>WTForm: output</h1>
{% endblock %}

{% block content %}
    <div>
        <ul>
            <li>name: {{ session['name'] }}</li>
            <li>email: {{ session['email'] }}</li>
        </ul>
        <p><a href="{{ url_for('input')}}">Back to input screen</a> </p>
    </div>
{% endblock %}

<!DOCTYPE html>
<html lang="ja">
    <head>
        <meta charset="utf-8">
        <title>Flask WTF Sample</title>
        <link rel="stylesheet" type="text/css" href="{{ url_for('static', filename='style.css') }}">
    </head>
    <body>
        {% block title %}Title{% endblock %}
        <hr />
        {% block content %}Content{% endblock %}
    </body>
</html>

{% macro render_field(field) %}
    <dt>{{ field.label }}
        <dd>{{ field(**kwargs)|safe }}
        {% if field.errors %}
            <ul style="color: red;">
                {% for error in field.errors %}
                    <li>{{ error }}</li>
                {% endfor %}
            </ul>
        {% endif %}
        </dd>
    </dt>
{% endmacro %}

@app.route('/input', methods=['GET', 'POST'])
def input():
    form = InputForm()
    if form.validate_on_submit():
        session['name'] = form.name.data
        session['email'] = form.email.data
        return redirect(url_for('output'))
    return render_template('input.html', form=form)

<form method="POST" novalidate>
    {{ form.csrf_token }}
    {{ render_field(form.name) }}
    {{ render_field(form.email) }}
    <br />
    {{ form.submit() }}
</form>

class InputForm(FlaskForm):
    name = StringField('Name', validators=[DataRequired()])
    email = StringField('Email', validators=[DataRequired(), Email()])
    submit = SubmitField('Submit')

{% macro render_field(field) %}
    <dt>{{ field.label }}
        <dd>{{ field(**kwargs)|safe }}
        {% if field.errors %}
            <ul style="color: red;">
                {% for error in field.errors %}
                    <li>{{ error }}</li>
                {% endfor %}
            </ul>
        {% endif %}
        </dd>
    </dt>
{% endmacro %}

# 仮想環境を作成しアクティブ化
conda create --name flask_env flask flask-sqlalchemy pymysql
conda activate flask_env

# HomebrewでMySQLをインストール
brew install mysql

# MySQLサーバーを起動
brew services start mysql

# MySQLに接続
mysql -u root -p
Enter password: <パスワードを入力>

# データベースとユーザーを作成
CREATE DATABASE flask_db;
CREATE USER 'flask_user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON flask_db.* TO 'flask_user'@'localhost';
FLUSH PRIVILEGES;

mkdir flask_mysql_project
cd flask_mysql_project
touch app.py config.py models.py
mkdir templates
cd templates
touch index.html

# config.py
import os

class Config:
    SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://flask_user:password@localhost/flask_db'
    SQLALCHEMY_TRACK_MODIFICATIONS = False
    SECRET_KEY = os.urandom(24)

# models.py
from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True, nullable=False)
    email = db.Column(db.String(120), unique=True, nullable=False)

    def __repr__(self):
        return f'<User {self.username}>'

# app.py
from flask import Flask, render_template, request, redirect, url_for
from config import Config
from models import db, User

app = Flask(__name__)
app.config.from_object(Config)
db.init_app(app)

@app.route('/')
def index():
    users = User.query.all()
    return render_template('index.html', users=users)

@app.route('/add', methods=['POST'])
def add_user():
    username = request.form['username']
    email = request.form['email']
    new_user = User(username=username, email=email)
    db.session.add(new_user)
    db.session.commit()
    return redirect(url_for('index'))

@app.route('/update/<int:id>', methods=['GET', 'POST'])
def update_user(id):
    user = User.query.get(id)
    if request.method == 'POST':
        user.username = request.form['username']
        user.email = request.form['email']
        db.session.commit()
        return redirect(url_for('index'))
    return render_template('update.html', user=user)

@app.route('/delete/<int:id>')
def delete_user(id):
    user = User.query.get(id)
    if user:
        db.session.delete(user)
        db.session.commit()
    return redirect(url_for('index'))

if __name__ == '__main__':
    with app.app_context():
        db.create_all()
    app.run(debug=True)