import psycopg2
import sys

try:
    conn = psycopg2.connect("dbname=student_db user=odoo password=odoo host=db")
    cur = conn.cursor()
    cur.execute("""
        SELECT r.name, r.domain_force, r.perm_read, r.global, g.name 
        FROM ir_rule r 
        LEFT JOIN rule_group_rel rg ON r.id = rg.rule_group_id 
        LEFT JOIN res_groups g ON rg.group_id = g.id 
        WHERE r.model_id = (SELECT id FROM ir_model WHERE model = 'education.lms.course')
    """)
    rows = cur.fetchall()
    for r in rows:
        print(r)
except Exception as e:
    print(f"DB Error: {e}")