/// <summary> /// Prepare a SQL statement for use in a query with variable substitution. /// </summary> /// <param name="request"></param> /// <returns></returns> public PrepareStatementResponse PrepareStatement(PrepareStatementRequest request) { var uriStr = GetEndPoint(NoSQLServices.Prepare, this.Region); var optional = request.GetOptionalQuery(); if (!string.IsNullOrEmpty(optional)) { uriStr = $"{uriStr}?{optional}"; } var uri = new Uri(uriStr); var httpRequestHeaderParam = new HttpRequestHeaderParam() { OpcRequestId = request.OpcRequestId }; using (var webResponse = this.RestClient.Get(uri, httpRequestHeaderParam)) using (var stream = webResponse.GetResponseStream()) using (var reader = new StreamReader(stream)) { var response = reader.ReadToEnd(); return(new PrepareStatementResponse() { PreparedStatement = this.JsonSerializer.Deserialize <PreparedStatement>(response), OpcRequestId = webResponse.Headers.Get("opc-request-id") }); } }
protected override void ProcessRecord() { base.ProcessRecord(); PrepareStatementRequest request; try { request = new PrepareStatementRequest { CompartmentId = CompartmentId, Statement = Statement, OpcRequestId = OpcRequestId }; response = client.PrepareStatement(request).GetAwaiter().GetResult(); WriteOutput(response, response.PreparedStatement); FinishProcessing(response); } catch (Exception ex) { TerminatingErrorDuringExecution(ex); } }