pyexasol_connect_execute_parameterized_query_fetch_results.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# Execute query with parameters
12# PyExtasol uses %s as placeholder for values
13st = C.execute("SELECT * FROM users WHERE user_id = %s", [1])
14
15# Fetch one row
16row = st.fetchone()
17print(row)
18
19# Close connection
20C.close()