pyexasol_connect_execute_parameterized_query_fetch_result.py

1import pyexasol
2
3# Connect to Exasol
4C = pyexasol.connect(
5    dsn='localhost:8563',
6    user='sys',
7    password='password',
8    schema='main'
9)
10
11# Basic query with parameters
12stmt = C.execute('SELECT * FROM users WHERE user_id = :user_id', {'user_id': 1})
13
14# Fetch one row as a dictionary
15row = stmt.fetchone()
16print(row)
17
18# Close connection
19C.close()