What's Changed

feat: Comprehensive API Performance Optimization (99.4% improvement) by @roncodes in #176

Full Changelog: v1.6.26...v1.6.27

Contributors

roncodes

Assets 2

20 Nov 09:12

github-actions

v1.6.26

964fb94

v1.6.26

What's Changed

Fix: Support computed columns in aggregate functions by @roncodes in #173
Fix: Complete support for computed columns in aggregates by @roncodes in #174
Add comprehensive SQL function support to ComputedColumnValidator by @roncodes in #175
v1.6.26 by @roncodes in #172

Full Changelog: v1.6.25...v1.6.26

Contributors

roncodes

Assets 2

17 Nov 09:13

github-actions

v1.6.25

36cf81e

v1.6.25

Fleetbase Core API v1.6.25 Release Notes

This release of the Fleetbase Core API introduces a powerful new scheduling module, support for computed columns in the query builder, and several key improvements and bug fixes. These updates provide a more robust and extensible platform for developers building on Fleetbase.

✨ What's New

Core Scheduling Module

A comprehensive, polymorphic, and reusable scheduling system has been integrated into the core API. This module provides the foundation for a wide range of scheduling applications, from driver and vehicle scheduling in FleetOps to delivery window management in Storefront.

Key Features:

Polymorphic Architecture: Schedule any entity type within the Fleetbase ecosystem.
Pluggable Constraint System: Define custom rules and constraints for scheduling.
Event-Driven: A rich set of events for extending and customizing scheduling workflows.
Recurring Patterns: Support for recurring schedules using RRULE.
Multi-Timezone Support: Manage schedules across different timezones.

Computed Columns in Query Builder

The query builder now supports computed columns, allowing for more complex and powerful data queries. This feature includes:

Secure Expression Validation: A new ComputedColumnValidator ensures the security and integrity of computed column expressions.
Whitelist-Based Validation: A whitelist of allowed SQL functions and operators prevents malicious code injection.
Column Reference Resolution: The system can now resolve column references within computed expressions.
Validation Endpoint: A new API endpoint (/reports/validate-computed-column) allows for real-time validation of computed column expressions.

🚀 Improvements and Fixes

String Literal Handling: The computed column validator now correctly handles string literals, preventing them from being misinterpreted as column names.
Query Results: Computed columns are now correctly included in query results and metadata.
Table Prefixes: A bug that caused table prefixes to be incorrectly added to string literals in computed columns has been fixed.
JSON Column Search: The search scope has been updated to properly support searching within JSON columns.

🧑‍💻 Developer Notes

The new scheduling module is accessible via a set of new API endpoints under /int/v1/schedules.
The computed_columns property can now be included in the query configuration for reports.
The ComputedColumnValidator service can be used to validate computed column expressions before they are executed.