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
ComputedColumnValidatorensures 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_columnsproperty can now be included in the query configuration for reports. - The
ComputedColumnValidatorservice can be used to validate computed column expressions before they are executed.
📝 Merged Pull Requests
- #168: feat: Add Core Scheduling Module
- #169: feat: Add computed columns support to query builder
- #171: feat: Add computed column validation endpoint
Full Changelog: v1.6.24...v1.6.25