18 lines
568 B
Python
18 lines
568 B
Python
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}")
|