#!/usr/bin/python3

# -------------------------------------------------------------------------------------------
import http.cookies
import os
from dash_utils import get_connection

# Clear session from DB and cookie
cookie = http.cookies.SimpleCookie(os.environ.get("HTTP_COOKIE"))
session_id = cookie.get("session_id")

# print("Content-Type: text/html; charset=utf-8")
if session_id:
    session_id = session_id.value
    # Connect to DB
    db = get_connection()
    curs = db.cursor()
    curs.execute("""
        UPDATE users 
           SET session_id = NULL 
         WHERE session_id = %s
    """, (session_id,))
    db.commit()
    curs.close()
    db.close()

# Clear cookie
print("Set-Cookie: session_id=deleted; expires=Thu, 01 Jan 1970 00:00:00 GMT; Path=/")
print("Status: 302 Found")
print("Location: /cgi-bin/cpadmin_login.py")
print()