pyexasol_exasol_connect_query_fetch_with_parameters.py

1import pyexasol
2import config
3
4# Connect to Exasol
5C = pyexasol.connect(dsn=config.dsn, user=config.user, password=config.password, schema=config.schema)
6
7# Execute query and fetch all rows
8# Result is a list of tuples
9st = C.execute('SELECT * FROM users')
10print(st.fetchall())
11
12# Execute query and fetch one row at a time
13st = C.execute('SELECT * FROM users')
14for row in st:
15    print(row)
16
17# Execute query with parameters
18# Pyexasol uses qmark (?) as a placeholder
19st = C.execute('SELECT * FROM users WHERE user_id = ?', [1])
20print(st.fetchone())
21
22# Execute query with named parameters
23# Pyexasol uses colon (:name) as a placeholder
24st = C.execute('SELECT * FROM users WHERE user_id = :user_id', {'user_id': 2})
25print(st.fetchone())