from flask import Flask, render_template_string, request, redirect, url_for import psycopg2 import os from datetime import datetime app = Flask(__name__) # Подключение к PostgreSQL def get_db_connection(): return psycopg2.connect( host=os.environ.get('DB_HOST', 'postgres'), database=os.environ.get('DB_NAME', 'blog'), user=os.environ.get('DB_USER', 'blog_user'), password=os.environ.get('DB_PASSWORD', 'blog_password') ) # Современный HTML шаблон INDEX_HTML = ''' Blog | Dedov Egor BSMO-32-25

Blog System v1.0

Author: Dedov Egor

Group: BSMO-32-25

Time: {{ current_time.strftime('%Y-%m-%d %H:%M:%S') }}

Blog Posts

{% if posts %} {% for post in posts %}

#{{ post[0] }}

{% endfor %} {% else %}

No posts yet. Create your first post below.

{% endif %}

New Post

''' @app.route('/', methods=['GET', 'POST']) def index(): conn = get_db_connection() cur = conn.cursor() if request.method == 'POST': title = request.form['title'] content = request.form['content'] cur.execute('INSERT INTO posts (title, content) VALUES (%s, %s)', (title, content)) conn.commit() cur.execute('SELECT id, title, content FROM posts ORDER BY id DESC') posts = cur.fetchall() cur.close() conn.close() return render_template_string(INDEX_HTML, posts=posts, current_time=datetime.now()) @app.route('/delete/', methods=['POST']) def delete_post(post_id): conn = get_db_connection() cur = conn.cursor() cur.execute('DELETE FROM posts WHERE id = %s', (post_id,)) conn.commit() cur.close() conn.close() return redirect(url_for('index')) if __name__ == '__main__': app.run(host='0.0.0.0', port=5000, debug=True)

Blog Posts

{{ post[1] }}

New Post