Spaces:
Sleeping
Sleeping
| from flask import Flask, request, render_template_string, send_from_directory, jsonify | |
| from flask import render_template | |
| import sqlite3 | |
| import os | |
| 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 index(): | |
| html = ''' | |
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="UTF-8"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
| <title>Camera Image</title> | |
| </head> | |
| <body> | |
| <h1>Upload Image</h1> | |
| <form id="uploadForm" enctype="multipart/form-data" method="post" action="/upload"> | |
| <input type="file" name="photo"> | |
| <button type="submit">Upload</button> | |
| </form> | |
| <div id="message"></div> | |
| <h1>Latest Image</h1> | |
| <img id="cameraImage" src="/image" alt="Image" style="width:100%;"> | |
| <script> | |
| document.getElementById('uploadForm').addEventListener('submit', function(event) { | |
| event.preventDefault(); | |
| var formData = new FormData(this); | |
| fetch('/upload', { | |
| method: 'POST', | |
| body: formData | |
| }) | |
| .then(response => { | |
| if (response.ok) { | |
| return response.text(); | |
| } | |
| throw new Error('Network response was not ok.'); | |
| }) | |
| .then(data => { | |
| document.getElementById('message').innerText = data; | |
| var image = document.getElementById("cameraImage"); | |
| image.src = "/image?" + new Date().getTime(); | |
| }) | |
| .catch(error => { | |
| document.getElementById('message').innerText = 'Error: ' + error.message; | |
| }); | |
| }); | |
| </script> | |
| </body> | |
| </html> | |
| ''' | |
| return render_template_string(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))) | |