import oracledb

try:
    conn = oracledb.connect(user='sisvietnam', password='sisvietnam', dsn='localhost:1521/sisvietnam')
    cursor = conn.cursor()
    cursor.execute("SELECT COUNT(*) FROM sis_post")
    posts = cursor.fetchone()[0]
    cursor.execute("SELECT COUNT(*) FROM sis_doctor")
    doctors = cursor.fetchone()[0]
    cursor.execute("SELECT COUNT(*) FROM sis_media")
    media = cursor.fetchone()[0]
    print(f"Posts: {posts}")
    print(f"Doctors: {doctors}")
    print(f"Media: {media}")
    conn.close()
except Exception as e:
    print(f"Error: {e}")