We have deprecated some existing steps and provided their replacements in Cycle versions 2.25+. 

The steps that are impacted are steps that work against result sets for both moca and sql. The deprecated steps are: 

• Given I assign row <ROW_NUMBER> column "<COLUMN_NAME>" to variable "<VARIABLE_NAME>"    

• Given I verify "<VALUE>" in row <ROW_NUMBER> column "<COLUMN_NAME>" in result set       

• Given I verify <NUMBER> rows in result set

The new replacement steps are:

• I verify "<VALUE>" in row <ROW_NUMBER> column "<COLUMN_NAME>" in SQL result set

• I assign row <ROW_NUMBER> column "<COLUMN_NAME>" from SQL result set to variable "<VARIABLE_NAME>"

• I verify <NUMBER> rows in SQL result set

• I verify "<VALUE>" in row <ROW_NUMBER> column "<COLUMN_NAME>" in MOCA result set

• I assign row <ROW_NUMBER> column "<COLUMN_NAME>" from MOCA result set to variable "<VARIABLE_NAME>"

• I verify <NUMBER> rows in MOCA result set

Update Steps in VS Code

To easily update these steps, you can use the VS Code Cycle Testing extension. Open your project in VS Code, and navigate to the Problems tab in the console. 

Alternative Approach 

If you are unable to use the VS Code extension, you can run the following scripts in Powershell:

$results = Get-ChildItem "C:\<PATH>\<TO>\<DIRECTORY>" -Recurse -File |

    Where-Object { $_.FullName -notmatch "\\Output\\" } |

    Select-String -Pattern "I assign row"

$results          # show matches

$results.Count    # show number of matches

$results = Get-ChildItem "C:\<PATH>\<TO>\<DIRECTORY>" -Recurse -File |

    Where-Object { $_.FullName -notmatch "\\Output\\" } |

    Select-String -Pattern "in result set"

$results          # show matches

$results.Count    # show number of matches