from flask import jsonify, Response
import json
import cx_Oracle
import os
from config.key import DATABASE_ID, DATABASE_PW
from config.URLs import DATABASE_URL


def search(insta_id):
    connection = cx_Oracle.connect(DATABASE_ID, DATABASE_PW, DATABASE_URL)
    cursor = connection.cursor()

    query = """
        select * from users where user_id=\'%s\'
    """ % insta_id

    cursor.execute(query)
    exist = cursor.fetchall()

    cursor.close()

    return Response(json.dumps(exist), mimetype='application/json')


if __name__ == '__main__':
    os.putenv('NLS_LANG', '.UTF8')
    cx_Oracle.init_oracle_client(lib_dir="/Users/choewonseog/Downloads/instantclient_19_8")
    print(search('__tester2__').data)