How to "climb" FireBird DB through Python?

Question

Python

Good afternoon! There is the following database (FireBird)

How can I get into this EVENTS table through Python and print the data, let's say in print?
Wrote this:

import fdb
con = fdb.connect(dsn='DESKTOP-TVUF8FU:D:/Dev/Python/FireBird_test/GLOBALMZSH.FDB', user='sysdba', password='masterkey')
cur = con.cursor()
test = cur.execute("select * from EVENTS")
print (test)

Here's the mistake: I'm generally zero with the database, and I found nothing more about working with FireBird than how to create an empty database and add a table there. Please tell me how to extract data from this "mess". Thank you! <fdb.fbcore.Cursor object at 0x000002798F32E2B0>

Answer 1

Didn't work with FireBird, but you should probably use fetchall():

import fdb
con = fdb.connect(dsn='DESKTOP-TVUF8FU:D:/Dev/Python/FireBird_test/GLOBALMZSH.FDB', user='sysdba', password='masterkey')
cur = con.cursor()
cur.execute("select * from EVENTS")
test = cur.fetchall()
print (test)