xbgmsharp
|
15accaa4cb
|
Update api.metadata version fields to type TEXT
Update debug output formating
Update SQL view statements, Make SQL error proof with REPLACE statement
|
2023-05-25 16:26:19 +02:00 |
|
xbgmsharp
|
8d382b48ac
|
Add telegram bot
|
2023-05-22 11:34:17 +02:00 |
|
xbgmsharp
|
2983f149ad
|
Update .env sample for Telegram-bot
|
2023-05-17 16:37:31 +02:00 |
|
xbgmsharp
|
a1ca97b549
|
Release 0.0.11
v0.0.11
|
2023-05-11 13:32:32 +02:00 |
|
xbgmsharp
|
119c1778e6
|
Update README
|
2023-05-08 10:20:41 +02:00 |
|
xbgmsharp
|
11489ce4aa
|
Update grafana dashboards and configuration
|
2023-05-03 17:04:08 +02:00 |
|
xbgmsharp
|
42b070baa8
|
Update permsisions for grafana_role and grafana_auth_proxy role
|
2023-05-02 18:29:27 +02:00 |
|
xbgmsharp
|
a1df7b218c
|
Update versions to include used extensions
|
2023-05-02 18:27:04 +02:00 |
|
xbgmsharp
|
160d6aa569
|
Update comment on fonction send_notifications
|
2023-04-23 23:13:30 +02:00 |
|
xbgmsharp
|
a2903e08ac
|
Add role comment for user scheduler
|
2023-04-23 23:12:35 +02:00 |
|
xbgmsharp
|
5a74914eac
|
Export helpers function to a separate file
|
2023-04-23 11:06:49 +02:00 |
|
xbgmsharp
|
55dc6275ee
|
Add permision to morrage_view for user_role
|
2023-04-23 11:06:24 +02:00 |
|
xbgmsharp
|
f2c68c82d8
|
Fix error if data type is None
|
2023-04-23 11:04:59 +02:00 |
|
xbgmsharp
|
578ca925db
|
Export helpers/generic functions to a new file
|
2023-04-23 11:00:40 +02:00 |
|
xbgmsharp
|
ae14017cfc
|
Update cron fn, fix tipo
|
2023-04-23 10:57:28 +02:00 |
|
xbgmsharp
|
1b42e3849f
|
Update stay(s),moorage(s) view with more details
|
2023-04-12 21:13:03 +02:00 |
|
xbgmsharp
|
2ffcbc5586
|
Remove unused api essel funtions
|
2023-04-03 22:51:57 +02:00 |
|
xbgmsharp
|
235506f2bc
|
Update fucntions, remove typo on Unknow
|
2023-04-03 22:50:47 +02:00 |
|
xbgmsharp
|
5a2ba54b2a
|
Update export GPX API endpoints, moorages and log.
Logs gpx should be move to the cron process to remove api.metrics dependency
|
2023-04-03 22:49:16 +02:00 |
|
xbgmsharp
|
122c44c338
|
Update new API endpoint api.export_moorages_gpx_fn
|
2023-04-02 17:49:30 +02:00 |
|
xbgmsharp
|
2e451fa93c
|
Update API schema with new endpoint, Add moorages map export (geojson,gpx) and update log export gpx
|
2023-04-01 19:29:12 +02:00 |
|
xbgmsharp
|
d26d008b47
|
Update job_run_details_cleanup_fn to remove logs older than 90 days
|
2023-04-01 19:28:38 +02:00 |
|
xbgmsharp
|
6a6239f344
|
Update description of the public schema
|
2023-04-01 19:28:15 +02:00 |
|
xbgmsharp
|
2f6a0a6133
|
Update public.logbook_update_geojson_fn to export id and time
|
2023-04-01 19:27:16 +02:00 |
|
xbgmsharp
|
bda652b87e
|
Update python function to filter geojson, add parameter to filter on LineString or Point
Still pending work using pg type and transform json
|
2023-04-01 19:25:43 +02:00 |
|
xbgmsharp
|
2f6bb6d5d9
|
Add new public function public.jsonb_diff_val
|
2023-04-01 19:25:14 +02:00 |
|
xbgmsharp
|
2cd9b0dd6c
|
Add API endpoint api.timelapse_fn
|
2023-03-28 19:15:41 +02:00 |
|
xbgmsharp
|
13e4f453d5
|
Add function job_run_details_cleanup_fn, delete old job details log
|
2023-03-28 19:14:53 +02:00 |
|
xbgmsharp
|
bc7d51c71e
|
Add geojson_py_fn in python
|
2023-03-28 19:13:42 +02:00 |
|
xbgmsharp
|
95d3c5bded
|
Add new public function jsonb_recursive_merge and input validation: isdate, istimestamptz
|
2023-03-28 19:12:35 +02:00 |
|
xbgmsharp
|
f0c6f92920
|
pg_cron, add job_run_details_cleanup
|
2023-03-28 19:11:02 +02:00 |
|
xbgmsharp
|
852d2ff583
|
Release v0.0.10
v0.0.10
|
2023-03-03 16:09:05 +01:00 |
|
xbgmsharp
|
7cf7905694
|
Update pushover link to work in prod env
|
2023-03-03 08:35:08 +01:00 |
|
xbgmsharp
|
0f8107a672
|
Update api.pushover_subscribe_link_fn and fix api.generate_otp_fn
|
2023-02-26 23:23:07 +01:00 |
|
xbgmsharp
|
77dec463d1
|
Add urlescape_py_fn to url encode using python
|
2023-02-26 22:57:44 +01:00 |
|
xbgmsharp
|
8ff1d0a8ed
|
Allow user_role to access new api view total_info_view, stats_logs_view, stats_moorages_view
|
2023-02-26 21:09:13 +01:00 |
|
xbgmsharp
|
859788d98d
|
Update api.export_logbook_gpx api.export_logbook_geojson
Update api.moorage_view
Add Create api.total_info_view
Add Comment on missing api view
Add security_invoker on stats view
|
2023-02-25 23:11:32 +01:00 |
|
xbgmsharp
|
62642ffbd6
|
Enforce OTP verification on login
|
2023-02-24 15:59:08 +01:00 |
|
xbgmsharp
|
c3760c8689
|
Allow UPSERT of otp code in generate_otp_fn
|
2023-02-24 15:58:36 +01:00 |
|
xbgmsharp
|
763c9ae802
|
Update versions fn and view
Add new fn public.has_vessel_fn()
Deprecated unused and bad api.vessels2_view,api.vessel_p_view
|
2023-02-24 15:57:32 +01:00 |
|
xbgmsharp
|
37abb3ae1f
|
Minimum valid distance is less than 0.010.
Exclude new function from vessel registration.
|
2023-02-24 15:55:55 +01:00 |
|
xbgmsharp
|
a6da3cab0a
|
Fix vessel_fn to use the latest location rather than the first know location
|
2023-02-15 16:24:11 +01:00 |
|
xbgmsharp
|
22f756b3a9
|
Update permissions to views
|
2023-02-14 19:04:38 +01:00 |
|
xbgmsharp
|
cb3e9d8e57
|
Update moorages_view and moorage_view with security invoker
|
2023-02-14 19:04:13 +01:00 |
|
xbgmsharp
|
1997fe5a81
|
Update logbook_update_geojson_fn, expose less properties in geojson
|
2023-02-14 12:22:58 +01:00 |
|
xbgmsharp
|
5a1451ff69
|
Improve process_logbook_queue_fn. Detect and remove stationary movement.
Add logbook_metrics_dwithin_fn function.
|
2023-02-13 23:56:39 +01:00 |
|
xbgmsharp
|
a18abec1f1
|
Update views owner permission using security_invoker and security_barrier
|
2023-02-09 16:47:02 +01:00 |
|
xbgmsharp
|
322c3ed4fb
|
Update messages templates for email,pushover, telegram
|
2023-02-09 16:46:23 +01:00 |
|
xbgmsharp
|
d648d119cc
|
Update API expose views with the latest pg15 feature security_invoker
|
2023-02-09 16:31:06 +01:00 |
|
xbgmsharp
|
9109474e8a
|
Fix permission issue when vessel is not connected in public.check_jwt()
|
2023-02-07 14:49:32 +01:00 |
|