config_manager.py

import psycopg2

DB_PARAMS = { "dbname": "config_db", "user": "postgres", "password": "password", "host": "localhost", "port": 5432 }

def add_config(key, value, user): conn = psycopg2.connect(**DB_PARAMS) cur = conn.cursor() cur.execute(""" INSERT INTO configs(key, value, updated_by) VALUES (%s, %s, %s); """, (key, value, user)) conn.commit() cur.close() conn.close() print(f"Config {key} added by {user}.")

def get_latest_config(key): conn = psycopg2.connect(**DB_PARAMS) cur = conn.cursor() cur.execute(""" SELECT value FROM configs WHERE key=%s ORDER BY updated_at DESC LIMIT 1; """, (key,)) val = cur.fetchone() cur.close() conn.close() return val[0] if val else None

if name == "main": add_config("max_connections", "200", "admin") print("Latest value:", get_latest_config("max_connections"))