v0.8.0

-- Update PostgreSQL 16.6, TimescaleDB: 2.17.2, PostGIS: 3.5.0
-- Add new documentation @mmdevs
-- Add MobilityDB support
-- Update logbook tbl, add trip from mobilitydb
-- Update logbook table, add support for mobility temporal type
-- Add api.export_logbook_geojson_linestring_trip_fn, transform spatiotemporal trip into a geojson with the corresponding properties
-- Add api.export_logbook_geojson_point_trip_fn, transform spatiotemporal trip into a geojson with the corresponding properties
-- Add logbook_update_geojson_trip_fn, update geojson from trip to geojson
-- Add api.export_logbook_gpx_trip_fn, update gpx from a trip
-- Add api.export_logbook_kml_trip_fn, update kml from a trip
-- Add api.export_logbook_geojson_linestring_trip_fn, replace timelapse_fn, transform spatiotemporal trip into a geojson with the corresponding properties
-- Add export_logbooks_geojson_point_trips_fn, replace timelapse2_fn, Generate the GeoJSON from the time sequence value
-- Add export_logbook_geojson_trip_fn, update geojson from trip to geojson
-- Update api.export_logbooks_gpx_trips_fn
-- Update api.export_logbooks_kml_trips_fn
-- Add update_trip_notes_fn, add temporal sequence into a trip notes
-- Add delete_trip_entry_fn, delete temporal sequence into a trip
-- Update log_view with dynamic GeoJSON from trip
-- Update api.vessels_view
-- Update api.versions_fn(), add mobilitydb
-- Update metrics_trigger_fn, Ignore entry if new time is in the future.
-- Update Monitor offline, check metadata tbl and metrics tbl, reduce flapping
-- Update moorages_view, make arrivals&departure and total_duration computed data
-- Update moorage_view, make arrivals&departure and total_duration computed data, add total visits
-- Update moorages map, use api.moorage_view as source table
-- Update mapgl_fn, refactor function using existing function
-- Update api.export_moorages_gpx_fn, use moorage_view as source to include computed data
-- Add api.export_moorages_kml_fn, export all moorages as kml
-- Update public.process_pre_logbook_fn, update stationary detection, if we have less than 20 metrics or less than 0.5NM or less than avg 0.5knts
-- Update api.export_logbook_kml_fn
-- Allow users to update certain columns on specific TABLES on API schema
-- Refresh user_role permissions

Full Changelog: v0.7.8...v0.8.0

v0.7.8

• Update moorages map, export more properties (notes,reference_count) from moorages tbl
• Update mapgl_fn, update moorages map sub query to export more properties (notes,reference_count) from moorages tbl
• Update logbook_update_geojson_fn, fix corrupt linestring properties
• Add trigger to update logbook stats from user edit geojson

Full Changelog: v0.7.7...v0.7.8

v0.7.7

• Add new email template account_inactivity
• Update HTML email for new logbook
• Update stats_logs_fn, update debug
• Fix stays and moorage statistics for user by date
• Update api.stats_moorages_view, fix time_spent_at_home_port
• Add stats_fn, user statistics by date
• Add mapgl_fn, generate a geojson with all logs as linestring and moorages
• Add cron_inactivity_fn, cleanup all data for inactive users and vessels
• Add cron_deactivated_fn, delete all data for inactive users and vessels
• Remove unused and duplicate function, cron_process_no_activity_fn
• Update tests (5551376, 5551376, c792bf8)
• Update openapi documentation
• Update github workflows

Full Changelog: v0.7.6...v0.7.7

v0.7.6

• Update public.process_lat_lon_fn, Ensure name without double quote, Fix issue with when string contains quote
• Update public.qgis_bbox_trip_py_fn, Add error handling for invalid argument
• Update public.qgis_bbox_py_fn, Add error handling for invalid argument
• Update public.get_app_settings_fn, Add new qgis and video URLs settings
• Update public.process_post_logbook_fn, Remove qgis dependency, Add logbook_stats
• Update public.cron_alerts_fn, Update alert message. Add the date and format the numeric value
• Update public.metrics_trigger_fn, CleanUp DEBUG print, ensure only one "new_stay" insert.
• Update public.check_jwt, reset config value Set default settings to avoid sql shared session cache for every new HTTP request
• Update public.send_email_py_fn, Update HTML email for new logbook email
• Update deactivated email template
• Update new logbook email template
• Update role authenticator, set api role SQL connection to 30
• Update table auth.vessels, Remove CONSTRAINT unique email for vessels table, Create new index for vessels table

Full Changelog: v0.7.5...v0.7.6

v0.7.5

• Add video error notification message
• Add CRON for new video notification
• Add export logbooks as png from webserver
• Add missing comment on function cron_process_no_activity_fn
• Update public.cron_alerts_fn, Fix error when stateOfCharge is null. Make stateOfCharge null value assume to be charge 1.
• Update api.export_logbooks_gpx_fn, Fix error: None of these media types are available: text/xml
• Update grafana provisioning, ERROR: KeyError: 'secureJsonFields'
• Update grafana,qgis,api role SQL connection to 30
• Update video cronjob
• Create qgis schema for qgis projects

Full Changelog: v0.7.4...v0.7.5

v0.7.4

Full Changelog: v0.7.2...v0.7.4

v0.7.2

Full Changelog: v0.7.1...v0.7.2

v0.7.1

Full Changelog: v0.7.0...v0.7.1

v0.7.0

Full Changelog: v0.6.1...v0.7.0

v0.6.1

Full Changelog: v0.6.0...v0.6.1