| | from flask import Flask, request, render_template_string, 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="./") |
| |
|
| | |
| | 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() |
| |
|
| |
|
| |
|
| | @app.route('/settings', methods=['GET']) |
| | def settings(): |
| | return render_template('settings.html') |
| |
|
| |
|
| | @app.route('/online', methods=['GET']) |
| | def onli(): |
| | return render_template('online.html') |
| |
|
| |
|
| |
|
| | |
| | @app.route('/add_contact', methods=['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 |
| |
|
| | |
| | @app.route('/contacts') |
| | 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 = ''' |
| | <!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))) |
| |
|
