connection = cx_Oracle.mkedsn('','',servicename='')

conn = cx_Oracle.connect(user='',password='',dsn=dsn_tns)
c.execute('''SELECT APPLE, BANANA, CARROT FROM VEGETABLES''')
for row in c:
print (row)
conn.close()
**output: {"apple":"fruit","banana":"fruit","carrot":"vegetable"}**

from flask import  FLASK
 import cx_Oracle, json
dbconnection = cx_Oracle.makedsn('','',servicename='')

app = Flask(__name__)

@app.route('/')
def healthtest():
return "Good"

@app.route('/search', methods=['POST'])
req = req.get_json():
def searching():

 return searching
@app.route('/query',methods=['GET'])

if  target == "Food":
conn = cx_Oracle.connect(user='',password='',dsn=dsn_tns)
c.execute('''SELECT APPLE, BANANA, CARROT FROM VEGETABLES''')
for row in c:
print (row)
conn.close()
else :
    print "No DATA"

   app.run(host=0.0.0.0, port=0000, debug=True)