This is example code for my talk titled "Delete Your For Loops". The purpose of the talk is to use a real world problem to show how to refactor from a fully imperative programming model towards a functional model.

The "csharp" directory contains a successive refinement exercise refactoring to LINQ

The "java" directory contains a successive refinement exercise refactoring to Java8 streams, lambdas, and optional.

The "javascript" directory contains a successive refinement exercise refactoring to ES6 map/filter/reduce.

Key concepts demonstrated:

1. Pure Functions
2. Immutability
3. Map/Filter/Reduce
4. Higher Order Functions

All exercises solve the same problem - translating a spreadsheet into an SQL script. In this case the spreadsheet contains rows of user IDs and the application permissions that should be granted to each user. The spreadsheet also contains other information and comments that are helpful to a human, but not necessary for the program.

The authority model is simple. There is a database table named ApplicationPermission containing two columns: user_id and application_id. If user f.smith has authority to application 23, then there is a row in the table with those values.

On inspection of the spreadsheet, we've determined the following:

1. If the text of the first column contains a '.' in the second position, then the row contains a valid user ID and permissions
2. If the text of the second column is 'X', then the user should have access to the application with the ID 2237
3. If the text of the third column is 'X', then the user should have access to the application with the ID 4352
4. If the text of the fourth column is 'X', then the user should have access to the application with the ID 3657
5. If the text of the fifth column is 'X', then the user should have access to the application with the ID 5565

So if there is a spreadsheet row with f.smith in the first column and X in the second column, the program should generate this SQL stement:

   insert into ApplicationPermission(user_id, application_id) values('f.smith', 2237);

The output of converting the spreadheet should be 44 insert statements.

Off to the races...