Hello All,
I 'am tying to mimic the below curl in python::
sh-4.2$ curl -X "POST" "http://slc05ewk.us.oracle.com:8080/ords/hr/_/sql" \
-H "Content-Type: application/sql" \
-u TESTUSER1:testuser1 \
-d $'SELECT sysdate FROM dual;'
**output**::
{"env":{"defaultTimeZone":"PST8PDT"},"items":[{"statementId":1,"statementType":"query","statementPos":{"startLine":1,"endLine":1},"statementText":"SELECT sysdate FROM dual","resultSet":{"metadata":[{"columnName":"SYSDATE","jsonColumnName":"sysdate","columnTypeName":"DATE","precision":0,"scale":0,"isNullable":1}],"items":[{"sysdate":"2020-11-04T04:56:22Z"}],"hasMore":false,"limit":100,"offset":0,"count":1},"response":[],"result":0}]}sh-4.2$
I tried below with python, but it doesn’t give the above…
# import requests module
import requests
from requests.auth import HTTPBasicAuth
# Making a get request
url = 'http://slc05ewk.us.oracle.com:8080/ords/hr/_/sql'
sql = 'select sysdate from dual;'
response = requests.get(url, auth = HTTPBasicAuth('testuser1', 'testuser1'), data=sql)
# print request object
print(response.text)
All i get is below::
-bash-4.2$ python restSQL_1.py
{"database_product_name":"Oracle","database_product_version":"Oracle Database 20c Enterprise Edition Release 20.0.0.0.0 - Development\nVersion 20.1.0.0.0","database_major_version":20,"database_minor_version":0}
-bash-4.2$
How do i get it done ?
Thank you.
Regards,
John Jacob