public void IsConnectedTest() { Logger.LogLine("IsConnected Tests"); var dataSet = DBConnectionObj.Query <LRSDataSet.IsConnectedData>(LRSDataSet.IsConnectedData.SelectQuery); var isConnectedData = dataSet.ToList(); if (!isConnectedData.Any()) { Logger.Log("No test cases found"); } var testIterator = 1; PassCount = 0; FailCount = 0; foreach (var test in isConnectedData) { Logger.LogLine("Executing test {0}", testIterator); #region Run against OSS try { var inputGeomSegment1 = test.InputGeom1.GetGeom(); var inputGeomSegment2 = test.InputGeom2.GetGeom(); test.ExpectedResult1 = test.ExpectedResult1; Logger.LogLine("Input geom 1:{0} geom 2:{1}", inputGeomSegment1.ToString(), inputGeomSegment2.ToString()); Logger.Log("IsConnected with a tolerance of {0}", inputGeomSegment1.ToString(), inputGeomSegment2.ToString(), test.Tolerance); Logger.LogLine("Expected Result: {0}", test.ExpectedResult1); MSSQLTimer.Restart(); // OSS Function Execution test.SqlObtainedResult1 = Geometry.IsConnected(inputGeomSegment1, inputGeomSegment2, test.Tolerance).ToString(); MSSQLTimer.Stop(); Logger.Log("Obtained Point: {0}", test.SqlObtainedResult1); } catch (Exception ex) { test.Result = "Failed"; test.SqlError = ex.Message; Logger.LogError(ex); } #endregion #region Run against Oracle OracleTimer.Restart(); // Oracle Function Execution OracleConnectorObj.DoIsConnectedGeomSegmentTest(test); OracleTimer.Stop(); #endregion // Update results to database UpdateTestResults(test, LRSDataSet.IsConnectedData.TableName, testIterator); Logger.Log("Test Result : {0}", test.Result); testIterator++; } }
public void ClipGeometrySegmentTest() { Logger.LogLine("Clip Geometry Segments Tests"); var dataSet = DBConnectionObj.Query <LRSDataSet.ClipGeometrySegmentData>(LRSDataSet.ClipGeometrySegmentData.SelectQuery); var clipGeometrySegmentData = dataSet.ToList(); if (!clipGeometrySegmentData.Any()) { Logger.Log("No test cases found"); } var testIterator = 1; PassCount = 0; FailCount = 0; foreach (var test in clipGeometrySegmentData) { Logger.LogLine("Executing test {0}", testIterator); #region Run against OSS try { var inputGeomSegment = test.InputGeom.GetGeom(); Logger.Log("Input Geom : {0}", inputGeomSegment.ToString()); Logger.Log("Start Measure : {0}", test.StartMeasure); Logger.Log("End Measure : {0}", test.EndMeasure); Logger.Log("Input Geom : {0}", inputGeomSegment.ToString()); Logger.Log("Expected Geom : {0}", test.ExpectedResult1); MSSQLTimer.Restart(); // OSS Function Execution test.SqlObtainedResult1 = Geometry.ClipGeometrySegment(inputGeomSegment, test.StartMeasure, test.EndMeasure, test.Tolerance)?.ToString().TrimNullValue(); MSSQLTimer.Stop(); Logger.Log("Obtained Result: {0}", test.SqlObtainedResult1); } catch (Exception ex) { test.Result = "Failed"; test.SqlError = ex.Message; Logger.LogError(ex); } #endregion #region Run against Oracle OracleTimer.Restart(); // Oracle Function Execution OracleConnectorObj.DoClipGeometrySegment(test); OracleTimer.Stop(); #endregion // Update test results in DB UpdateTestResults(test, LRSDataSet.ClipGeometrySegmentData.TableName, testIterator); Logger.Log("Test Result : {0}", test.Result); testIterator++; } }
public void LocatePointAlongGeomTest() { Logger.LogLine("LocatePointAlongGeom Tests"); var dataSet = DBConnectionObj.Query <LRSDataSet.LocatePointAlongGeomData>(LRSDataSet.LocatePointAlongGeomData.SelectQuery); var locatePointAlongGeomData = dataSet.ToList(); if (!locatePointAlongGeomData.Any()) { Logger.Log("No test cases found"); } var testIterator = 1; PassCount = 0; FailCount = 0; foreach (var test in locatePointAlongGeomData) { Logger.LogLine("Executing test {0}", testIterator); #region Run against OSS try { var inputGeomSegment1 = test.InputGeom.GetGeom(); Logger.LogLine("Input geom :{0}", inputGeomSegment1.ToString()); Logger.Log("Location point along Geom at a measure of {0}", test.Measure); Logger.LogLine("Expected Result: {0}", test.ExpectedResult1); MSSQLTimer.Restart(); // OSS Function Execution test.SqlObtainedResult1 = Geometry.LocatePointAlongGeom(inputGeomSegment1, test.Measure).ToString(); MSSQLTimer.Stop(); Logger.Log("Obtained Result: {0}", test.SqlObtainedResult1); } catch (Exception ex) { test.Result = "Failed"; test.SqlError = ex.Message; Logger.LogError(ex); } #endregion #region Run against Oracle OracleTimer.Restart(); // Oracle Function Execution OracleConnectorObj.DoLocatePointAlongGeomTest(test); Logger.Log("Oracle Result: {0}", test.OracleResult1); OracleTimer.Stop(); #endregion // Update results to database UpdateTestResults(test, LRSDataSet.LocatePointAlongGeomData.TableName, testIterator); Logger.Log("Test Result : {0}", test.Result); testIterator++; } }
public void PolygonToLineTest() { var dataSet = DBConnectionObj.Query <UtilDataSet.PolygonToLineData>(UtilDataSet.PolygonToLineData.SelectQuery); var polygonToLineData = dataSet.ToList(); if (!polygonToLineData.Any()) { Logger.Log("No test cases found"); } var testIterator = 1; PassCount = 0; FailCount = 0; foreach (var test in polygonToLineData) { Logger.LogLine("Executing test {0}", testIterator); #region Run against OSS try { var geom = test.InputGeom.GetGeom(); var expectedGeom = test.ExpectedResult1.GetGeom(); Logger.LogLine("Input geom 1:{0}", geom); Logger.LogLine("Expected Result: {0}", expectedGeom); MSSQLTimer.Restart(); // OSS Function Execution test.SqlObtainedResult1 = Geometry.PolygonToLine(geom).ToString(); MSSQLTimer.Stop(); Logger.Log("Obtained Result : {0}", test.SqlObtainedResult1); } catch (Exception ex) { test.Result = "Failed"; test.SqlError = ex.Message; Logger.LogError(ex); } #endregion #region Run against Oracle OracleTimer.Restart(); // Oracle Function Execution OracleConnectorObj.DoPolygonToLineTest(test); OracleTimer.Stop(); #endregion // Update results to database UpdateTestResults(test, UtilDataSet.PolygonToLineData.TableName, testIterator); Logger.Log("Test Result : {0}", test.Result); testIterator++; } }
public void ValidateLRSGeometryTest() { Logger.LogLine("Validate LRS Geometry Segments Tests"); var dataSet = DBConnectionObj.Query <LRSDataSet.ValidateLRSGeometryData>(LRSDataSet.ValidateLRSGeometryData.SelectQuery); var testIterator = 1; PassCount = 0; FailCount = 0; foreach (var test in dataSet) { Logger.LogLine("Executing test {0}", testIterator); #region Run against OSS try { var inputGeomSegment = test.InputGeom.GetGeom(); test.ExpectedResult1 = test.ExpectedResult1; Logger.Log("Input Geom : {0}", inputGeomSegment.ToString()); Logger.Log("Expected Geom : {0}", test.ExpectedResult1); MSSQLTimer.Restart(); // OSS Function Execution test.SqlObtainedResult1 = Geometry.ValidateLRSGeometry(inputGeomSegment).ToString(CultureInfo.CurrentCulture); MSSQLTimer.Stop(); Logger.Log("Obtained Result: {0}", test.SqlObtainedResult1); } catch (Exception ex) { test.Result = "Failed"; test.SqlError = ex.Message; Logger.LogError(ex); } #endregion #region Run against Oracle OracleTimer.Restart(); // Oracle Function Execution OracleConnectorObj.ValidateLRSGeometry(test); OracleTimer.Stop(); #endregion // Update test results in DB UpdateTestResults(test, LRSDataSet.ValidateLRSGeometryData.TableName, testIterator); Logger.Log("Test Result : {0}", test.Result); testIterator++; } if (testIterator == 1) { Logger.Log("No test cases found"); } }
public void ConvertToLrsGeomTest() { Logger.LogLine("ConvertedLrsGeomTest() Tests"); var dataSet = DBConnectionObj.Query <LRSDataSet.ConvertToLrsGeomData>(LRSDataSet.ConvertToLrsGeomData.SelectQuery); var ConvertToLrsGeomData = dataSet.ToList(); if (!ConvertToLrsGeomData.Any()) { Logger.Log("No test cases found"); } var testIterator = 1; PassCount = 0; FailCount = 0; foreach (var test in ConvertToLrsGeomData) { Logger.LogLine("Executing test {0}", testIterator); #region Run against OSS try { var geom = test.InputGeom.GetGeom(); Logger.LogLine("Input geom: {0}", geom); Logger.LogLine("Expected Result: {0}", test.ExpectedResult1); MSSQLTimer.Restart(); // OSS Function Execution if (Geometry.ConvertToLrsGeom(geom, test.StartMeasure, test.EndMeasure) != null) { test.SqlObtainedResult1 = Geometry.ConvertToLrsGeom(geom, test.StartMeasure, test.EndMeasure).ToString(); } else { test.SqlObtainedResult1 = null; } MSSQLTimer.Stop(); Logger.Log("Obtained Result: {0}", test.SqlObtainedResult1); } catch (Exception ex) { test.Result = "Failed"; test.SqlError = ex.Message; Logger.LogError(ex); } #endregion #region Run against Oracle OracleTimer.Restart(); // Oracle Function Execution OracleConnectorObj.DoConvertToLrsGeom(test); OracleTimer.Stop(); Logger.Log("Oracle Result: {0}", test.OracleResult1); #endregion // Update results to database UpdateTestResults(test, LRSDataSet.ConvertToLrsGeomData.TableName, testIterator); Logger.Log("Test Result : {0}", test.Result); testIterator++; } }
public void SplitGeometrySegmentTest() { Logger.LogLine("SplitGeometrySegment Tests"); var dataSet = DBConnectionObj.Query <LRSDataSet.SplitGeometrySegmentData>(LRSDataSet.SplitGeometrySegmentData.SelectQuery); var splitGeometrySegmentData = dataSet.ToList(); if (!splitGeometrySegmentData.Any()) { Logger.Log("No test cases found"); } var testIterator = 1; PassCount = 0; FailCount = 0; foreach (var test in splitGeometrySegmentData) { Logger.LogLine("Executing test {0}", testIterator); #region Run against OSS try { var geom = test.InputGeom.GetGeom(); Logger.LogLine("Splitting Input geom: {0} at a measure of : {1}", geom, test.Measure); Logger.Log("Expected Split Geom Segment 1: {0}", test.ExpectedResult1); Logger.Log("Expected Split Geom Segment 2: {0}", test.ExpectedResult2); MSSQLTimer.Restart(); // OSS Function Execution Geometry.SplitGeometrySegment(geom, test.Measure, out var obtainedGeom1, out var obtainedGeom2); MSSQLTimer.Stop(); test.SqlObtainedResult1 = obtainedGeom1?.ToString(); test.SqlObtainedResult2 = obtainedGeom2?.ToString(); Logger.LogLine("Obtained Result1: {0}", test.SqlObtainedResult1); Logger.Log("Obtained Result2: {0}", test.SqlObtainedResult2); } catch (Exception ex) { test.Result = "Failed"; test.SqlError = ex.Message; Logger.LogError(ex); } #endregion #region Run against Oracle OracleTimer.Restart(); // Oracle Function Execution OracleConnectorObj.DoSplitGeometrySegmentTest(test); OracleTimer.Stop(); #endregion // Update results to database UpdateTestResults(test, LRSDataSet.SplitGeometrySegmentData.TableName, testIterator, true); Logger.Log("Test Result : {0}", test.Result); testIterator++; } }
public void MergeAndResetGeometrySegments() { Logger.LogLine("Merge and Reset Geometry Segments Tests"); var dataSet = DBConnectionObj.Query <LRSDataSet.MergeAndResetGeometrySegmentsData>(LRSDataSet.MergeAndResetGeometrySegmentsData.SelectQuery); var mergeAndResetGeometrySegmentsData = dataSet.ToList(); if (!mergeAndResetGeometrySegmentsData.Any()) { Logger.Log("No test cases found"); } var testIterator = 1; foreach (var test in mergeAndResetGeometrySegmentsData) { Logger.LogLine("Executing test {0}", testIterator); #region Run against OSS try { var geom1 = test.InputGeom1.GetGeom(); var geom2 = test.InputGeom2.GetGeom(); var expectedGeom = test.ExpectedResult1.GetGeom(); Logger.LogLine("Input geom 1:{0}", geom1); Logger.Log("Input geom 2:{0}", geom2); Logger.LogLine("Expected Result: {0}", expectedGeom); MSSQLTimer.Restart(); // OSS Function Execution test.SqlObtainedResult1 = Geometry.MergeAndResetGeometrySegments(geom1, geom2, test.Tolerance).ToString(); MSSQLTimer.Stop(); Logger.Log("Obtained Result : {0}", test.SqlObtainedResult1); } catch (Exception ex) { test.Result = "Failed"; test.SqlError = ex.Message; Logger.LogError(ex); } #endregion #region Run against Oracle OracleTimer.Restart(); // Oracle Function Execution OracleConnectorObj.DoMergeAndResetGeomTest(test); OracleTimer.Stop(); #endregion // Update results to database UpdateTestResults(test, LRSDataSet.MergeAndResetGeometrySegmentsData.TableName, testIterator); Logger.Log("Test Result : {0}", test.Result); testIterator++; } }