from datetime import datetime
from flask_login import UserMixin
from werkzeug.security import generate_password_hash, check_password_hash
from bluelog.extensions import db

class Admin(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True) # 主鍵字段
    username = db.Column(db.String(20))          # 用戶名
    password_hash = db.Column(db.String(128))    # 密碼散列值
    blog_title = db.Column(db.String(60))        # 博客標(biāo)題
    blog_sub_title = db.Column(db.String(100))   # 博客副標(biāo)題
    name = db.Column(db.String(30))              # 用戶姓名
    about = db.Column(db.Text)                   # 關(guān)于信息
    def set_password(self, password):
        self.password_hash = generate_password_hash(password)
    def validate_password(self, password):
        return check_password_hash(self.password_hash, password)

class Category(db.Model):
    id = db.Column(db.Integer, primary_key=True)        # 主鍵字段
    name = db.Column(db.String(30), unique=True)        # 分類名稱
    posts = db.relationship('Post', back_populates='category')  # 分類和文章之間是一對多關(guān)系
    def delete(self):
        default_category = Category.query.get(1)
        posts = self.posts[:]
        for post in posts:
            post.category = default_category
        db.session.delete(self)
        db.session.commit()

class Post(db.Model):
    id = db.Column(db.Integer, primary_key=True)         # 主鍵字段
    title = db.Column(db.String(60))                     # 標(biāo)題
    body = db.Column(db.Text)                            # 正文
    timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)  # 時(shí)間戳
    can_comment = db.Column(db.Boolean, default=True)    # 是否能被評(píng)論
    category_id = db.Column(db.Integer, db.ForeignKey('category.id'))   # 所屬分類，外鍵字段
    category = db.relationship('Category', back_populates='posts')  # 分類和文章之間是一對多關(guān)系
    comments = db.relationship('Comment', back_populates='post', cascade='all, delete-orphan')  # 文章和評(píng)論是一對多關(guān)系

class Comment(db.Model):
    id = db.Column(db.Integer, primary_key=True)        # 主鍵字段
    author = db.Column(db.String(30))                   # 作者
    email = db.Column(db.String(254))                   # 電子郵件
    site = db.Column(db.String(255))                    # 站點(diǎn)
    body = db.Column(db.Text)                           # 正文
    from_admin = db.Column(db.Boolean, default=False)   # 是否是管理員的評(píng)論
    reviewed = db.Column(db.Boolean, default=False)     # 是否通過審核
    timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)  # 時(shí)間戳
    replied_id = db.Column(db.Integer, db.ForeignKey('comment.id'))   # 外鍵
    post_id = db.Column(db.Integer, db.ForeignKey('post.id'))         # 外鍵
    post = db.relationship('Post', back_populates='comments')         # 文章和評(píng)論是一對多關(guān)系
    replies = db.relationship('Comment', back_populates='replied', cascade='all, delete-orphan')  # 設(shè)置級(jí)聯(lián)刪除
    replied = db.relationship('Comment', back_populates='replies', remote_side=[id]) # 自關(guān)聯(lián)多對一需用 remote_side=id 指定 ‘一' 的一方

class Link(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(30))
    url = db.Column(db.String(255))

from faker import Faker
fake = Faker()

def fake_admin():
def fake_categories(count=10):
def fake_posts(count=50):
def fake_links():

from bluelog.models import Admin, Category
def create_app(config_name=None):
    ...
	register_template_context(app)
	return app
def register_template_context(app):
    @app.context_processor
    def make_template_context():
    	admin = Admin.query.first()
        categories = Category.query.order_by(Category.name).all()
        return dict(admin=admin, categories=categories)

<div class="page-header">
<h1 class="display-3">{{ admin.blog_title|default('Blog Title') }}</h1>
<h4 class="text-muted">&nbsp;{{ admin.blog_sub_title|default('Blog Subtitle') }}</h4>
</div>

<li {% if request.endpoint == 'blog.index' %}class="active"{% endif %}>
<a href="{{ url_for('blog.index') }}" rel="external nofollow" >Home</a>
</li>

<main class="container">
	{% for message in get_flashed_messages(with_categories=True) %}
	<div class="alert alert-{{ message[0] }}" role="alert">
		<button type="button" class="close" data-dismiss="alert">&times;</button>
		{{ message[1] }}
	</div>
	{% endfor %}
	...
</main>

from flask_wtf import FlaskForm
from wtforms import StringField, PasswordField, SubmitField, BooleanField
from wtforms.validators import DataRequired
class LoginForm(FlaskForm):
    username = StringField('Username', validators=[DataRequired(), Length(1, 20)])
    password = PasswordField('Password', validators=[DataRequired(), Length(1, 128)])
    remember = BooleanField('Remember me')
    submit = SubmitField('Log in')

from flask_ckeditor import CKEditorField
from flask_wtf import FlaskForm
from wtforms import StringField, SubmitField, SelectField
from wtforms.validators import DataRequired, Length
from bluelog.models import Category
class PostForm(FlaskForm):
    title = StringField('Title', validators=[DataRequired(), Length(1, 60)])
    category = SelectField('Category', coerce=int, default=1)
    body = CKEditorField('Body', validators=[DataRequired()])
    submit = SubmitField()
    def __init__(self, *args, **kwargs):
        super(PostForm, self).__init__(*args, **kwargs)
        self.category.choices = [(category.id, category.name)
                                 for category in Category.query.order_by(Category.name).all()]

from wtforms import StringField, SubmitField, ValidationError
from wtforms import DataRequired
from bluelog.models import Category
class CategoryForm(FlaskForm):
    name = StringField('Name', validators=[DataRequired(), Length(1, 30)])
    submit = SubmitField()
    def validate_name(self, field):
        if Category.query.filter_by(name=field.data).first():
            raise ValidationError('Name already in use.')

from flask_wtf import FlaskForm
from wtforms import StringField, SubmitField, TextAreaField
from wtforms.validators import DataRequired, Email, URL, Length, Optional
class CommentForm(FlaskForm):
    author = StringField('Name', validators=[DataRequired(), Length(1, 30)])
    email = StringField('Email', validators=[DataRequired(), Email(), Length(1, 254)])
    site = StringField('Site', validators=[Optional(), URL(), Length(0, 255)])
    body = TextAreaField('Comment', validators=[DataRequired()])
    submit = SubmitField()

class AdminCommentForm(CommentForm):
    author = HiddenField()
    email = HiddenField()
    site = HiddenField()

from flask import render_template, Blueprint
blog_bp = Blueprint('blog', __name__)
@blog_bp.route('/')
def index():
	return render_template('blog/index.html')
@blog_bp.route('/about')
def about():
	return render_template('blog/about.html')
@blog_bp.route('/category/<int:category_id>')
def show_category(category_id):
	return render_template('blog/category.html')
@blog_bp.route('/post/<int:post_id>', methods=['GET', 'POST'])
def show_post(post_id):
	return render_template('blog/post.html')

from flask import url_for
def send_mail(subject, to, html):
	...

def send_new_comment_email(post):
    post_url = url_for('blog.show_post', post_id=post.id, _external=True) + '#comments'
    send_mail(subject='New comment', to=current_app.config['BLUELOG_EMAIL'],
              html='<p>New comment in post <i>%s</i>, click the link below to check:</p>'
                   '<p><a href="%s" rel="external nofollow"  rel="external nofollow" >%s</a></P>'
                   '<p><small style="color: #868e96">Do not reply this email.</small></p>'
                   % (post.title, post_url, post_url))

def send_new_reply_email(comment):
    post_url = url_for('blog.show_post', post_id=comment.post_id, _external=True) + '#comments'
    send_mail(subject='New reply', to=comment.email,
              html='<p>New reply for the comment you left in post <i>%s</i>, click the link below to check: </p>'
                   '<p><a href="%s" rel="external nofollow"  rel="external nofollow" >%s</a></p>'
                   '<p><small style="color: #868e96">Do not reply this email.</small></p>'
                   % (comment.post.title, post_url, post_url))

from threading import Thread
from flask import current_app
from flask_mail import Message
from bluelog.extensions import mail
def _send_async_mail(app, message):
    with app.app_context():
        mail.send(message)
def send_mail(subject, to, html):
    app = current_app._get_current_object()
    message = Message(subject, recipients=[to], html=html)
    thr = Thread(target=_send_async_mail, args=[app, message])
    thr.start()
    return thr