logs.py 393 B

12345678910111213141516
  1. import psycopg2
  2. from psycopg2.extras import DictCursor
  3. conn = psycopg2.connect(
  4. dbname='adcfi',
  5. user='postgres',
  6. password='Ultr4p0d3r0s0##',
  7. host='200.13.89.42',
  8. port='5432'
  9. )
  10. with conn.cursor(cursor_factory=DictCursor) as cur:
  11. cur.execute("SELECT * FROM calificaciones.calificaciones_log ORDER BY log_timestamp DESC LIMIT 10")
  12. for row in cur:
  13. print(row)