主页 / 问题 / 947898
Accepted
Vadim
Asked:2020-02-22 14:49:56 +0000 UTC2020-02-22 14:49:56 +0000 UTC

烧瓶如何在邮件列表中隐藏收件人列表

  • 772

有一个脚本可以从数据库向所有用户发送文件。但收件人可以看到所有其他收件人。如何隐藏它们？

from flask import Flask, render_template, make_response
from flask_celery import make_celery
from flask_sqlalchemy import SQLAlchemy
from flask_mail import Mail, Message
import os

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///subscribe.db'
app.config['MAIL_SERVER'] = 'mail.post.com'
app.config['MAIL_PORT'] = 25
app.config['MAIL_USERNAME'] = 'UserName'
app.config['MAIL_PASSWORD'] = 'Secret'


db = SQLAlchemy(app)
celery = make_celery(app)
mail = Mail(app)

class Subscribe(db.Model):
    id = db.Column('id', db.Integer, primary_key=True)
    email = db.Column('email', db.String(50), unique=True, nullable=False)
    company = db.Column(db.String(50), nullable=False)


    def __repr__(self):
        return f"Subscribe('{self.company}', '{self.email}')"


@app.route('/sendmail', methods=['GET', 'POST'])
def index():
    with app.app_context():
        theuser = Subscribe.query.filter(Subscribe.id).all()
        msg = Message('Hello', sender='flask@post.com', recipients=[theuser.email for theuser in Subscribe.query.all()])

        msg.body = "testing"
        msg.html = "<b>testing</b>"

        with app.open_resource(r"C:\dir\worry_cat.jpg") as fp:
            msg.attach("image.png", "image/png", fp.read())

        for theuser in Subscribe.query.all():
            mail.send(msg)

        return 'Message sent!'
python

1 个回答

  1. Best Answer

    循环绕过用户并分别向每个用户发送电子邮件：

    with app.open_resource(r"C:\dir\worry_cat.jpg") as fp:
    img = fp.read()

    for theuser in Subscribe.query.all():
        msg = Message('Hello', sender='flask@post.com', recipients=[theuser.email])

        msg.body = "testing"
        msg.html = "<b>testing</b>"

        msg.attach("image.png", "image/png", img)

        mail.send(msg)
    • 1

相关问题