app.py

from flask import Flask, render_template, request, redirect, url_for, session, flash
from flask_sqlalchemy import SQLAlchemy
from bs4 import BeautifulSoup
from werkzeug.security import generate_password_hash, check_password_hash
from functools import wraps
from datetime import datetime
from flask import send_from_directory

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///blog.db'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
app.config['SECRET_KEY'] = 'coloque_sua_chave_aqui'
db = SQLAlchemy(app)
POSTS_PER_PAGE = 4
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(100), unique=True, nullable=False)
    password_hash = db.Column(db.String(128), nullable=False)

    def set_password(self, password):
        self.password_hash = generate_password_hash(password)

    def check_password(self, password):
        return check_password_hash(self.password_hash, password)


class Post(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(255), nullable=False)
    content = db.Column(db.Text, nullable=False)
    created_at = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)


def login_required(f):
    @wraps(f)
    def decorated_function(*args, **kwargs):
        if 'user_id' not in session:
            return redirect(url_for('login'))
        return f(*args, **kwargs)
    return decorated_function

def extract_image_and_excerpt(content):
    soup = BeautifulSoup(content, 'html.parser')


    image = soup.find('img')
    

    if image:
        image.extract()
    

    paragraphs = soup.find_all('p')
    for p in paragraphs:
        if "Photo by" in p.get_text() or "Imagem por" in p.get_text():
            p.extract()


    text = soup.get_text()


    excerpt = ' '.join(text.split())[:150]
    
    return image['src'] if image else None, excerpt




@app.route('/')
def index():
    page = request.args.get('page', 1, type=int)
    per_page = 4
    pagination = Post.query.order_by(Post.id.desc()).paginate(page=page, per_page=per_page, error_out=False)
    posts_with_images_and_excerpts = []
    for post in pagination.items:
        image_url, excerpt = extract_image_and_excerpt(post.content)
        posts_with_images_and_excerpts.append({
            'post': post,
            'image_url': image_url,
            'excerpt': excerpt
        })
    return render_template('index.html', posts=posts_with_images_and_excerpts, pagination=pagination)

@app.errorhandler(404)
def page_not_found(e):
    return render_template('404.html'), 404

@app.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'POST':
        username = request.form['username']
        password = request.form['password']
        user = User.query.filter_by(username=username).first()
        if user and user.check_password(password):
            session['user_id'] = user.id
            return redirect(url_for('admin'))
        else:
            flash('Nome de usuário ou senha incorretos')
    return render_template('login.html')

@app.route('/post/<int:post_id>')
def post(post_id):
    post = Post.query.get_or_404(post_id)
    return render_template('post.html', post=post)

@app.route('/admin', methods=['GET'])
@login_required 
def admin():
    page = request.args.get('page', 1, type=int)
    posts = Post.query.order_by(Post.created_at.desc()).paginate(page=page, per_page=POSTS_PER_PAGE, error_out=False)
    next_url = url_for('admin', page=posts.next_num) if posts.has_next else None
    prev_url = url_for('admin', page=posts.prev_num) if posts.has_prev else None
    return render_template('admin.html', posts=posts.items, next_url=next_url, prev_url=prev_url)

@app.route('/create_post', methods=['GET', 'POST'])
def create_post():
    if request.method == 'POST':
        title = request.form['title']
        content = request.form['content']
        new_post = Post(title=title, content=content)
        db.session.add(new_post)
        db.session.commit()
        flash('Post criado com sucesso!')
        return redirect(url_for('admin'))
    return render_template('admin.html', creating_new_post=True)


@app.route('/edit_post/<int:post_id>', methods=['GET', 'POST'])
def edit_post(post_id):
    post = Post.query.get_or_404(post_id)
    if request.method == 'POST':
        post.title = request.form['title']
        post.content = request.form['content']
        db.session.commit()
        flash('Post atualizado com sucesso!')
        return redirect(url_for('admin'))
    return render_template('admin.html', post_to_edit=post)


@app.route('/delete_post/<int:post_id>', methods=['GET', 'POST'])
def delete_post(post_id):
    post = Post.query.get_or_404(post_id)
    db.session.delete(post)
    db.session.commit()
    flash('Post excluído com sucesso!')
    return redirect(url_for('admin'))

@app.route('/logout')
def logout():
    session.pop('user_id', None)
    return redirect(url_for('login'))

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

@app.route('/search', methods=['GET'])
def search():
    query = request.args.get('query')
    if query:
        
        results = Post.query.filter(Post.title.contains(query) | Post.content.contains(query)).all()
    else:
        results = []
    return render_template('search_results.html', query=query, results=results)

@app.route('/robots.txt')
def serve_robots():
    return send_from_directory(app.static_folder, 'robots.txt')

@app.route('/sitemap.xml') 
def serve_sitemap():
    return send_from_directory(app.static_folder, 'sitemap.xml') 

@app.route('/feed') 
def feed():
    return send_from_directory(app.static_folder, 'feed.xml') 


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