def OpenConnection(self):
"""Opens a connection to SQL Service."""
request = sql_pb2.OpenConnectionRequest()
prop = request.property.add()
prop.key = 'autoCommit'
prop.value = 'false'
if self._user:
prop = request.property.add()
prop.key = 'user'
prop.value = self._user
if self._password:
prop = request.property.add()
prop.key = 'password'
prop.value = self._password
if self._database:
prop = request.property.add()
prop.key = 'database'
prop.value = self._database
self.SetupClient()
response = self.MakeRequest('OpenConnection', request)
self._connection_id = response.connection_id
def OpenConnection(self):
"""Opens an ApiProxy connection to speckle."""
request = sql_pb2.OpenConnectionRequest()
prop = request.property.add()
prop.key = 'autoCommit'
prop.value = 'false'
if self._user:
prop = request.property.add()
prop.key = 'user'
prop.value = self._user
if self._password:
prop = request.property.add()
prop.key = 'password'
prop.value = self._password
response = self.MakeRequest('OpenConnection', request)
self._connection_id = response.connection_id
if self._database:
request = sql_pb2.ExecOpRequest()
request.op.type = client_pb2.OpProto.SET_CATALOG
request.op.catalog = self._database
self.MakeRequest('ExecOp', request)
