Feat : Introducing Aggregate and group by functionality

[manishkushare]

Resolves #9988

[TooljetBot]

Code Review Agent Run #fb233d

• AI Based Review: ✔️ Successful

Code Review Overview

• Summary: This PR introduces significant enhancements to the Tooljet Database UI and backend. New React components for managing aggregate options and group by conditions have been added, along with corresponding styles. The backend has been updated to support these features, including a migration script to enable aggregation in the Tooljet Database. Configuration and service files have been modified to handle new settings and query building logic for aggregates and group by conditions.
• Files: 15
• Issue found: Total - 8, High importance - 8      See detailed feedback ->
• Code change type: Refactoring, Feature Addition, Performance Improvement, Security
• Unit tests added: False
• Estimated effort to review (1-5, lower is better): 3

High-level Feedback

Ensure all SQL queries are validated and sanitized to prevent SQL injection. Optimize functions to avoid performance bottlenecks and add error handling to maintain database consistency. Consider caching results to improve performance and handle unexpected values gracefully in the UI components.

Detailed Feedback

:page_facing_up: server/src/services/tooljet_db.service.ts

Issues: Total - 2, High importance - 2

Line 723-723	🔴 High importance - 1
Line 741-741	🔴 High importance - 1

:page_facing_up: server/migrations/1718264886184-EnableAggregationInTooljetDatabase.ts

Issues: Total - 1, High importance - 1

Line 13-16

🔴 High importance - 1

:page_facing_up: server/src/services/tooljet_db_operations.service.ts

Issues: Total - 1, High importance - 1

Line 93-93

🔴 High importance - 1

:page_facing_up: frontend/src/Editor/QueryManager/QueryEditors/TooljetDatabase/AggregateUI/index.jsx

Issues: Total - 3, High importance - 3

Line 26-26	🔴 High importance - 1
Line 191-191	🔴 High importance - 1
Line 230-230	🔴 High importance - 1

:page_facing_up: server/src/modules/tooljet_db/utils/helper.ts

Issues: Total - 1, High importance - 1

Line 7-7

🔴 High importance - 1

AI Code Review powered by

[github-actions[bot]]

Deployment: https://tooljet-pr-10170.onrender.com Dashboard: https://dashboard.render.com/web/srv-cpt9iujv2p9s73b4d17g

[github-actions[bot]]

Deployment: https://tooljet-pr-10170.onrender.com Dashboard: https://dashboard.render.com/web/srv-cptt5m56l47c73835bl0