""" Akshay's Mridangam Arangetram Website """ import sqlite3 import os import smtplib from email.mime.multipart import MIMEMultipart from email.mime.text import MIMEText from flask import ( Flask, render_template, request, jsonify, redirect, url_for, session ) app = Flask(__name__) # ── Config ─────────────────────────────────────────────────────────────────── app.secret_key = "change-this-to-a-random-secret-string-before-deploying" ADMIN_USERNAME = "arangetram.admin" # ← change this ADMIN_PASSWORD = "es0M1xzIACFyITYcWv43" # ← change this to something strong # Email settings — fill these in to enable confirmation emails # For Gmail: use an App Password (not your regular password) # Guide: https://support.google.com/accounts/answer/185833 EMAIL_ENABLED = True # ← set True once configured EMAIL_FROM = "mridangam.akshay@gmail.com" # ← your sending email EMAIL_PASSWORD = "zbfj njvq uzcu tgey" # ← Gmail App Password EMAIL_SMTP_HOST = "smtp.gmail.com" EMAIL_SMTP_PORT = 587 # Event details used in confirmation email — update these! EVENT_NAME = "Akshay's Mridangam Arangetram" EVENT_DATE = "July 25th, 2026" EVENT_TIME = "3:00 PM" EVENT_VENUE = "East Forsyth High School (8910 Jot Em Down Rd, Gainesville, GA 30506)" EVENT_CONTACT = "mridangam.akshay@gmail.com" DB_PATH = os.path.join(os.path.dirname(__file__), "rsvps.db") # ── Database ────────────────────────────────────────────────────────────────── def get_db(): conn = sqlite3.connect(DB_PATH) conn.row_factory = sqlite3.Row return conn def init_db(): with get_db() as conn: conn.execute(""" CREATE TABLE IF NOT EXISTS rsvps ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, email TEXT NOT NULL, guests INTEGER NOT NULL DEFAULT 1, message TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP ) """) # ── Email ───────────────────────────────────────────────────────────────────── def send_confirmation_email(name, email, guests): if not EMAIL_ENABLED: return subject = f"Thank you for RSVP-ing! {EVENT_NAME}" html_body = f"""

You're Confirmed

{EVENT_NAME}

Dear {name},

We are delighted to confirm your RSVP. Your presence will make this celebration truly special!

Event Details

Date{EVENT_DATE}
Time{EVENT_TIME}
Venue{EVENT_VENUE}
Guests{guests} {'person' if guests == 1 else 'people'}

If you have any questions/comments please email us at {EVENT_CONTACT}

Thank you,
Anand, Gayathri, Akshara, and Akshay

{EVENT_NAME.upper()}
""" plain_body = f"""Dear {name}, Your RSVP is confirmed! Event : {EVENT_NAME} Date : {EVENT_DATE} Time : {EVENT_TIME} Venue : {EVENT_VENUE} Guests: {guests} {'person' if guests == 1 else 'people'} If you have any questions/comments please email us at {EVENT_CONTACT} Thank you, Anand, Gayathri, Akshara, & Akshay """ try: msg = MIMEMultipart("alternative") msg["Subject"] = subject msg["From"] = EMAIL_FROM msg["To"] = email msg.attach(MIMEText(plain_body, "plain")) msg.attach(MIMEText(html_body, "html")) with smtplib.SMTP(EMAIL_SMTP_HOST, EMAIL_SMTP_PORT) as server: server.starttls() server.login(EMAIL_FROM, EMAIL_PASSWORD) server.sendmail(EMAIL_FROM, email, msg.as_string()) except Exception as e: print(f"[Email] Failed to send to {email}: {e}") # ── Public Routes ───────────────────────────────────────────────────────────── @app.route("/") def index(): return render_template("index.html") @app.route("/artists") def artists(): return render_template("artists.html") @app.route("/gallery") def gallery(): return render_template("gallery.html") @app.route("/program") def program(): return render_template("program.html") @app.route("/rsvp", methods=["POST"]) def rsvp(): data = request.get_json() name = (data.get("name") or "").strip() email = (data.get("email") or "").strip() guests = int(data.get("guests") or 1) message = (data.get("message") or "").strip() if not name or not email: return jsonify({"ok": False, "error": "Name and email are required."}), 400 if guests < 1 or guests > 20: return jsonify({"ok": False, "error": "Guests must be between 1 and 20."}), 400 with get_db() as conn: conn.execute( "INSERT INTO rsvps (name, email, guests, message) VALUES (?, ?, ?, ?)", (name, email, guests, message) ) send_confirmation_email(name, email, guests) return jsonify({"ok": True}) # ── Admin Routes ────────────────────────────────────────────────────────────── @app.route("/admin", methods=["GET", "POST"]) def admin_login(): error = None if request.method == "POST": username = request.form.get("username", "").strip() password = request.form.get("password", "").strip() if username == ADMIN_USERNAME and password == ADMIN_PASSWORD: session["admin"] = True return redirect(url_for("admin_rsvps")) else: error = "Incorrect username or password." return render_template("admin_login.html", error=error) @app.route("/admin/logout") def admin_logout(): session.pop("admin", None) return redirect(url_for("admin_login")) @app.route("/admin/rsvps") def admin_rsvps(): if not session.get("admin"): return redirect(url_for("admin_login")) with get_db() as conn: rows = conn.execute("SELECT * FROM rsvps ORDER BY created_at DESC").fetchall() return render_template("admin_rsvps.html", rsvps=rows) @app.route("/admin/rsvps/delete/", methods=["POST"]) def delete_rsvp(rsvp_id): if not session.get("admin"): return redirect(url_for("admin_login")) with get_db() as conn: conn.execute("DELETE FROM rsvps WHERE id = ?", (rsvp_id,)) return redirect(url_for("admin_rsvps")) # ── Main ────────────────────────────────────────────────────────────────────── if __name__ == "__main__": init_db() app.run(debug=True, port=5050)