Mapepire-IBMi / mapepire-python

python client for mapepire
Apache License 2.0
4 stars 2 forks source link

add query manager #52

Closed ajshedivy closed 3 weeks ago

ajshedivy commented 3 weeks ago

Fixes #

# connection logic
job = SQLJob()
job.connect(creds)

# Query Manager
query_manager = QueryManager(job)

# create a unique query
query = query_manager.create_query("select * from sample.employee")

# run query
result = query_manager.run_query(query)

job.close()

with SQLJob(creds) as job:
    query_manager = QueryManager(job)
    query = query_manager.create_query('select * from sample.employee')
    result = query_manager.run_query(query, rows_to_fetch=5)

with SQLJob(creds) as job:
    query_manager = QueryManager(job)
    result = query_manager.query_and_run('select * from sample.employee', rows_to_fetch=5)

Changes proposed in this pull request:

-

Before submitting