This is the tenth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation Today we are going to test our code. First, we need to have some mocks: We start with tests for WHERE clause: And now tests for simple … Continue reading SQLxD Part 10 — WHERE and tests

This is the ninth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation As the last predicate we implement LIKE operator. It is not that simple so the implementation is pretty long. By the way, did you know that there … Continue reading SQLxD Part 9 — WHERE and LIKE operator

This is the eighth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation We continue implementing the predicates. Today we will join them to construct logic expressions. In order to be able to handle complex expressions we need to introduce … Continue reading SQLxD Part 8 — WHERE with joined predicates

This is the seventh part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation Last time we saw how to handle FROM clause. Today we are going to implement filtering logic for handling WHERE. We start with the clause logic: As … Continue reading SQLxD Part 7 — WHERE with simple predicates

This is the sixth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation We already know how to transform XML nodes into SQL-like rows. Now it is time to execute DQL queries. For now I will just describe operators implementation, … Continue reading SQLxD Part 6 — FROM