xbgmsharp
9532075bc4
Update frontend to release 0.0.7
2023-10-25 22:18:56 +02:00
xbgmsharp
5996b4d483
Upgrade to the latest version and prepare for next release
2023-10-25 12:40:49 +02:00
xbgmsharp
fdd6fc18e1
Update logbook tests, no more track_gpx field
2023-10-25 12:08:11 +02:00
xbgmsharp
af3866fafe
Add new test for export logbooks endpoint
2023-10-25 12:07:07 +02:00
xbgmsharp
53daaa9947
Update vessel_fn to handle empty vessel name from signalk in api.metadata
2023-10-25 09:28:10 +02:00
xbgmsharp
3fed9e0b6a
Update public.logbook_update_geojson_fn, expose more data
...
Update public.logbook_metrics_dwithin_fn, expend large zone for invalid logbook, increase to 15metres.
Disable public.logbook_update_gpx_fn, back to using api.export_logbook_gpx_fn.
Add public.get_app_url_fn, allow limited access to the ap url settings.
2023-10-25 09:27:48 +02:00
xbgmsharp
f3168542fd
Update api.timelapse_fn, use track_geom as geometry instead of track_geojson as geojson. x10 faster.
...
Update api.export_logbook_geojson_fn, output as JSONB as per best practice.
Update api.export_logbook_gpx_fn, dynamic from track_geojson on 'geometry'->>'type' = 'Point'.
Add api.export_logbooks_gpx_fn, export multiple logs in a GPX format
Add api.export_logbooks_kml_fn, export multiple logs in a KML format
2023-10-25 09:27:03 +02:00
xbgmsharp
d266485fef
Update table api.logbook, remove tack_gpx colunm, update track_geojson to jsonb type
2023-10-25 09:25:51 +02:00
xbgmsharp
8738becd82
Update OpenAPI documentation
2023-10-25 09:24:27 +02:00
xbgmsharp
ad43ca6629
Update auth.accounts wiht comments
2023-10-23 21:39:53 +02:00
xbgmsharp
9368878963
Update .gitignore
2023-10-22 20:46:20 +02:00
xbgmsharp
496491a43a
Update README
2023-10-22 20:46:08 +02:00
xbgmsharp
7494b39abc
Update api views with standard name-casing
2023-10-22 19:50:13 +02:00
xbgmsharp
74426a75f8
Update maint tests, cleanup
2023-10-22 19:44:34 +02:00
xbgmsharp
9bac88a8cc
Update main tests, add openapi.json update
2023-10-22 19:43:46 +02:00
xbgmsharp
c0af53155c
Update tests to match new public_id colunm for auth.accounts
2023-10-22 19:43:06 +02:00
xbgmsharp
e0aa6a4d0e
Udpate README
2023-10-22 19:39:39 +02:00
xbgmsharp
2425b674f7
Update auth.accounts, remove unused userid, add public_id integer for anonymous and grafana orgId references
2023-10-22 19:34:41 +02:00
xbgmsharp
b7a1462ec6
Update permissions
2023-10-22 19:28:03 +02:00
xbgmsharp
a31d857a6e
Update open API documentation
2023-10-22 19:25:58 +02:00
xbgmsharp
dbeb64c0dc
Add schemalint github actioni for best practice reference
2023-10-22 19:24:45 +02:00
xbgmsharp
229c219751
Update metrics_trigger_fn, Ignore metric entry if latitude,longitude are equal,l
...
Update api.logbook and api.stays tables, update type to text instead of varchar
2023-10-22 18:43:54 +02:00
xbgmsharp
3216ffe42c
Update cron_process_no_activity_fn, check for vessel with no activity for more than 200 days then send notification
...
Add cron_process_deactivated_fn, check for inactivity for more than 1 year to send notification and delete data
2023-10-18 23:25:21 +02:00
xbgmsharp
e2e3e5814e
Update api.vessel_fn expose data from the signalk rather than from user input
...
Update api.settings_fn expose accounts.public_id in settings
Update api.eventlogs_view, cleanup formating
Add api.ispublic_fn, check is a page is publicly accessible from user preferences
2023-10-18 23:21:22 +02:00
xbgmsharp
5f709eb71e
Update mocha http tests, add export_logbook_kml_fn basic test
2023-10-18 11:45:39 +02:00
xbgmsharp
d5bf36a85c
Update message template for notifications
2023-10-18 11:44:54 +02:00
xbgmsharp
90d48c0c52
Update cron job, fix job details cleanup
2023-10-16 21:46:09 +02:00
xbgmsharp
62707aa86c
Update export_logbook_gpx_fn, update comment
2023-10-16 16:31:42 +02:00
xbgmsharp
ac187a1480
update kml export, fix linestrng xml export
2023-10-16 12:21:25 +02:00
xbgmsharp
7b0bf7494f
Udpate get_user_settings_from_vesselid, optimize query use citext extensions.
...
Update public.check_jwt, fix typo..
2023-10-16 11:53:44 +02:00
xbgmsharp
c64219e249
Fix init export_gpx2
2023-10-16 00:55:33 +02:00
xbgmsharp
2127dd7fcb
Update github actions test, increase delay to allow the db to be loaded from initdb
2023-10-16 00:48:42 +02:00
xbgmsharp
2a583b94dc
Update api.export_logbook_kml_fn, allow export in SML content-type
2023-10-16 00:37:16 +02:00
xbgmsharp
147d9946c3
Update connections limit to 20 for anonymous
2023-10-16 00:29:16 +02:00
xbgmsharp
993cfaeaff
Update cron jobs
2023-10-13 15:59:21 +02:00
xbgmsharp
3e70283221
Update public.logbook_update_geojson_fn formating
2023-10-13 15:58:40 +02:00
xbgmsharp
0697acb940
Update message template
2023-10-13 15:40:15 +02:00
xbgmsharp
8ca4d03649
Update permisions for user_role and grafana
2023-10-13 15:39:18 +02:00
xbgmsharp
7a465ff532
Update grafana home dashboard with geomap
2023-10-13 14:58:41 +02:00
xbgmsharp
96dce86678
Update api.export_logbook_kml_fn but still not working in REST
2023-10-11 17:33:55 +02:00
xbgmsharp
8dd827f70d
Add new SQL tests for update_logbook_observations_fn
2023-10-11 17:31:43 +02:00
xbgmsharp
572f0cd19d
Fix job_run_details_cleanup_fn
2023-10-11 17:20:08 +02:00
xbgmsharp
047f243758
Fix api.update_logbook_observations_fn.
2023-10-11 17:19:10 +02:00
xbgmsharp
5c494896c6
Increase default number of connection ofr grafana_auth
2023-10-11 17:18:41 +02:00
xbgmsharp
b7e717afbc
Update notificaiton jobs, fix sql query for no_vessel,no_metadata,no_activitye
2023-10-10 13:51:51 +02:00
xbgmsharp
2f3912582a
Update api.export_logbook_kml_fn fix export
2023-10-09 20:38:24 +02:00
xbgmsharp
f7b9a54a71
Update KML export with basic LineString support
2023-10-09 20:30:27 +02:00
xbgmsharp
4e554083b0
Add Row level security to vessel_view. Clean up code, unsing pg15 RLS can be apply to view
2023-10-09 16:27:19 +02:00
xbgmsharp
69b6490534
Update api.vessels_view LIMIT to last metrics.
...
Add Rowlevel security measures to view
2023-10-09 16:26:02 +02:00
xbgmsharp
8b336f6f9b
Add explicit schema when public
2023-10-09 16:22:30 +02:00
