how to make a db connection created through ADO available to all methods within and outside the unit

[sriram_sig]

how to make a db connection created through ADO available to all methods within and outside the unit, when using python as the scripting language

AConnection = ADO.CreateADOConnection()

[tristaanogre]

You will need to make that connection variable exported from the Python unit.  I don't know Python well but I'm sure there's documentation for it.

[TanyaYatskovska]

Hi @sriram_sig,

Please refer to this article - it contains a Python example:

https://support.smartbear.com/testcomplete/docs/reference/program-objects/ado/createadoconnection.ht...

[TanyaYatskovska]

Hi @sriram_sig,

Did you find the answer to your question?

[sriram_sig]

Not yet. If i want a variable to be available in other methods i assign it to Project variables and then retrieve it when needed. Likewise lets say i have a method which just establishes connection with the db, how can i use this db connection in other methods. I'm stuck here, since i cannot assign this to project variables.

[sriram_sig]

The example which you provided me earlier helps to create db connection, but i also want to use this same connection in other methods

[tristaanogre]

Rather than a project variable, is there a way to make a variable declared in one Python unit available for others?  In JavaScript, if you export a variable and then use the "requires" call in a subsequent unit, you can access that variable anywhere.

Alternatively, you could create a Script Extension whose sole purpose is to provide an ADO DB connection. that you can then access from anywhere.

[cunderw · Accepted solution]

I'm not a python dev by any means but something like this I think is what you are looking for:

connectSting = ""

AConnection = ADO.CreateADOConnection()

def GetConnection():
  if AConnection.Connected == False:
    Log.Message("Connecting")
    AConnection.ConnectionString = connectSting
    # Suppress the login dialog box
    AConnection.LoginPrompt = False    
    AConnection.Open()
  elif AConnection.Connected == True:
    Log.Message("Connected")
  return AConnection
  
def test():
  connection = GetConnection()
  connection = GetConnection()

Then if you want to use that in other script units see: https://support.smartbear.com/testcomplete/docs/scripting/calling-routines/declared-in-another-unit/...

[sriram_sig]

Thank you. This is exactly what i was looking for.