عرض عملي: إعادة كتابة تقرير المبيعات باستخدام jOOQ

خطوة بخطوة

1. Show the report as plain SQL from MID-011 (CTE and window function).
2. Add the jOOQ Gradle/Maven plugin; generate classes from the Flyway-migrated database.
3. Rewrite the query using DSL.with(...), DSL.rank().over(...), and fetch into a record.
4. Planned mistake: change a column name in a migration without regenerating classes; show the build failing, then regenerate. Explain this is the safety net.
5. Compare results with the original query and note readability and refactor safety.

Prepares MID-022-LAB1.

اختبر فهمك