Couchbase sql script file execution from python using couchbase python SDK

Question

I am new with this, I was trying to connect to the couchbase bucket and getting ddata using python, just tried whatever given in the documentation. It's working fine. Now my question is that is i want to execute this select query from a file how can i execute/run sql file using python sdk. I dont want to go with approach that open the file and read query from there.

sql script execution we can do with cbq utility but i am not getting any clue how to do this with SDK . Please help to resolve it

def connect_db():
    print(CONNSTR, authenticator)
    cluster = Cluster(CONNSTR, ClusterOptions(authenticator))
    static_bucket = cluster.bucket('test')
    default_collection = static_bucket.default_collection()
    return cluster, default_collection

def findall():
    """Returns list of matching airports and the source query"""
    queryprep = "SELECT test FROM `test` where test='TotalDue'"
    res = cluster.query(queryprep)
    for row in res:
        test = row['test']
        print(test)
    return res

question from:https://stackoverflow.com/questions/65931519/couchbase-sql-script-file-execution-from-python-using-couchbase-python-sdk

Answer 1

Waitting for answers