Spaces:
Sleeping
Sleeping
| from flask import Flask, request, render_template_string, send_from_directory, jsonify | |
| from flask import render_template | |
| import sqlite3 | |
| import os | |
| own_url = os.getenv('own_url') # URL сервера | |
| import unittest | |
| from whatsapp_api_webhook_server_python.webhooksHandler import startServer | |
| app = Flask(__name__, template_folder="./") | |
| app.config['DEBUG'] = True | |
| UPLOAD_FOLDER = 'static' | |
| IMAGE_FILENAME = 'latest_image.jpg' | |
| # Создание директории, если она не существует | |
| if not os.path.exists(UPLOAD_FOLDER): | |
| os.makedirs(UPLOAD_FOLDER) | |
| # Создание базы данных и таблицы | |
| def init_db(): | |
| try: | |
| conn = sqlite3.connect('data.db') | |
| cursor = conn.cursor() | |
| cursor.execute(''' | |
| CREATE TABLE IF NOT EXISTS contacts ( | |
| id INTEGER PRIMARY KEY AUTOINCREMENT, | |
| name TEXT NOT NULL, | |
| phone TEXT NOT NULL, | |
| email TEXT NOT NULL | |
| ) | |
| ''') | |
| conn.commit() | |
| conn.close() | |
| except Exception as e: | |
| print(f"Error initializing database: {e}") | |
| # Вызов функции для инициализации базы данных | |
| init_db() | |
| def settings(): | |
| return render_template('settings.html') | |
| def onli(): | |
| return render_template('online.html') | |
| def veref(): | |
| return render_template('ver.html') | |
| def se_mes(): | |
| return render_template('se_mes.html') | |
| def se_mes_im(): | |
| return render_template('se_mes_im.html') | |
| def upload_file(): | |
| if 'photo' not in request.files: | |
| return "No file part", 400 | |
| file = request.files['photo'] | |
| if file.filename == '': | |
| return "No selected file", 400 | |
| save_path = os.path.join(UPLOAD_FOLDER, IMAGE_FILENAME) | |
| file.save(save_path) | |
| return f"File uploaded successfully and saved to {save_path}", 200 | |
| def get_image(): | |
| return send_from_directory(UPLOAD_FOLDER, IMAGE_FILENAME) | |
| def se_mes_im2(): | |
| return render_template('se_mes_im2.html') | |
| # Маршрут для обработки GET-запроса | |
| def add_contact(): | |
| try: | |
| name = request.args.get('name') | |
| phone = request.args.get('phone') | |
| email = request.args.get('email') | |
| if not name or not phone or not email: | |
| return "Parameters 'name', 'phone', and 'email' are required.", 400 | |
| conn = sqlite3.connect('data.db') | |
| cursor = conn.cursor() | |
| cursor.execute('INSERT INTO contacts (name, phone, email) VALUES (?, ?, ?)', (name, phone, email)) | |
| conn.commit() | |
| conn.close() | |
| return f"Contact added: {name} - {phone} - {email}", 200 | |
| except Exception as e: | |
| print(f"Error adding contact: {e}") | |
| return "Internal Server Error", 500 | |
| # Маршрут для отображения таблицы контактов | |
| def show_contacts(): | |
| try: | |
| conn = sqlite3.connect('data.db') | |
| cursor = conn.cursor() | |
| cursor.execute('SELECT name, phone, email FROM contacts') | |
| contacts = cursor.fetchall() | |
| conn.close() | |
| # HTML-шаблон для отображения таблицы | |
| html = ''' | |
| <!doctype html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="utf-8"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> | |
| <title>Contacts</title> | |
| <style> | |
| table { | |
| width: 70%; | |
| border-collapse: collapse; | |
| } | |
| th, td { | |
| border: 1px solid black; | |
| padding: 8px; | |
| text-align: left; | |
| } | |
| th { | |
| background-color: #f2f2f2; | |
| } | |
| </style> | |
| </head> | |
| <body> | |
| <h1>Contacts</h1> | |
| <table> | |
| <tr> | |
| <th>Name</th> | |
| <th>Phone</th> | |
| <th>Email</th> | |
| </tr> | |
| {% for contact in contacts %} | |
| <tr> | |
| <td>{{ contact[0] }}</td> | |
| <td>{{ contact[1] }}</td> | |
| <td>{{ contact[2] }}</td> | |
| </tr> | |
| {% endfor %} | |
| </table> | |
| </body> | |
| </html> | |
| ''' | |
| return render_template_string(html, contacts=contacts) | |
| except Exception as e: | |
| print(f"Error showing contacts: {e}") | |
| return "Internal Server Error", 500 | |
| if __name__ == '__main__': | |
| app.run(host='0.0.0.0', port=int(os.environ.get('PORT', 7860))) | |