フラグメントと セルクエリの統合

import os
class Config:   MAIL_USERNAME = '<username>' # Your email address without '@gmail.com'   MAIL_PASSWORD = '<app password>'   MAIL_DEFAULT_SENDER = '<email address>'   MONGO_URI = '<mongodb connection string>'   DATABASE_NAME = "newsletter"   ALLOWED_IPS = ['127.0.0.1']   MAIL_SERVER = 'smtp.gmail.com'   MAIL_PORT = 587   MAIL_USE_TLS = True   CELERY_BROKER_URL = 'amqp://guest:guest@localhost//'   RESULT_BACKEND = MONGO_URI + '/celery_results'

from flask import Flaskfrom flask_mail import Mailfrom flask_pymongo import PyMongofrom celery import Celery
# Create a Flask applicationapp = Flask(__name__)app.config.from_object('config.Config')
# Create a Flask-Mail instancemail = Mail(app)
# Connect to MongoDBclient = PyMongo(app).cxdb = client[app.config['DATABASE_NAME']]
# Create a Celery instancecelery = Celery(app.name, broker=app.config['CELERY_BROKER_URL'])celery.conf.update(app.config)
from routes import *from tasks import *
if __name__ == '__main__':   app.run(debug=True)

from flask_mail import Messagefrom app import app, mail, db, celeryfrom datetime import datetime
@celery.task(bind=True)def send_emails(self, subscribers, title, body):   with app.app_context():      for subscriber in subscribers:            try:               print(f"Sending email to {subscriber['email']}")               msg = Message(title, recipients=[subscriber['email']])               msg.body = body               mail.send(msg)               db.deliveries.insert_one({                  'email': subscriber['email'],                  'title': title,                  'body': body,                  'delivered_at': datetime.utcnow()               })               print("Email sent")
            except Exception as e:               print(f"Failed to send email to {subscriber['email']}: {str(e)}")
      return {'result': 'All emails sent'}

from flask import render_template, request, abort, jsonifyfrom app import app, dbfrom tasks import send_emails
@app.before_requestdef limit_remote_addr():   if 'X-Forwarded-For' in request.headers:      remote_addr = request.headers['X-Forwarded-For'].split(',')[0]   else:      remote_addr = request.remote_addr
   if request.endpoint == 'admin' and remote_addr not in app.config['ALLOWED_IPS']:      abort(403)
@app.route('/')def home():   return render_template('subscribe.html')
@app.route('/admin')def admin():   return render_template('admin.html')
@app.route('/subscribe', methods=['POST'])def subscribe():   first_name = request.form['firstname']   last_name = request.form['lastname']   email = request.form['email']
   if db.users.find_one({'email': email}):      return """      <div class="response error">            <span class="icon">&#x2716;</span> This email is already subscribed!      </div>      """, 409
   db.users.insert_one({'firstname': first_name, 'lastname': last_name, 'email': email, 'subscribed': True})   return """   <div class="response success">      <span class="icon">&#x2714;</span> Subscribed successfully!   </div>   """, 200
@app.route('/send-newsletters', methods=['POST'])def send_newsletters():   title = request.form['title']   body = request.form['body']   subscribers = list(db.users.find({'subscribed': True}))
   for subscriber in subscribers:      subscriber['_id'] = str(subscriber['_id'])
   send_emails.apply_async(args=[subscribers, title, body])   return jsonify({'message': 'Emails are being sent!'}), 202

body {   font-family: system-ui;   font-optical-sizing: auto;   font-weight: 300;   font-style: normal;   margin: 0;   padding: 0;   display: flex;   flex-direction: column;   align-items: center;   justify-content: center;   height: 100vh;   background-color: #040100;}
h1 {   color: white;}
form {   background: #023430;   padding: 30px 40px;   border-radius: 8px;   box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);   width: 100%;   max-width: 400px;   margin: 20px 0;}
label {   display: block;   margin-bottom: 8px;   font-weight: bold;   color: white;}
input[type="text"],input[type="email"],textarea {   width: 100%;   padding: 10px;   margin-bottom: 10px;   border: 1px solid #ccc;   border-radius: 4px;   font-size: 16px;}
button {   background: #00ED64;   color: white;   padding: 10px 20px;   border: none;   border-radius: 4px;   cursor: pointer;   font-size: 16px;   font-family: "Nunito", sans-serif;}
button:hover {   background: #00684A;}
#response {   margin-top: 20px;   font-size: 16px;   color: #28a745;}
footer {   text-align: center;   padding: 20px;   margin-top: 20px;   font-size: 16px;   color: #666;}