search

technologiestiftung / zms-supabase

Supabase backend and db setup for the ZMS project
MIT License
1 stars 0 forks source link

feat: Compute scores with current time ref #34

Closed ff6347 closed 1 year ago

ff6347 commented 1 year ago

Do not merge we have a drift between migrations and the production DB. Should be resolved manually after the testing

This PR adds a cron job that computes scores based on 

((scheduled_time - check_in_time)::integer / 60) + ((CURRENT_TIMESTAMP - scheduled_time))::integer / 60

Also fixes a drift between db and migrations

socket-security[bot] commented 1 year ago

Socket Security Pull Request Report

👍 No dependency changes detected in pull request

Pull request report summary
Issue Status
Install scripts ✅ 0 issues
Native code ✅ 0 issues
Bin script confusion ✅ 0 issues
Bin script shell injection ✅ 0 issues
Unresolved require ✅ 0 issues
Invalid package.json ✅ 0 issues
HTTP dependency ✅ 0 issues
Git dependency ✅ 0 issues
Potential typo squat ✅ 0 issues
Known Malware ✅ 0 issues
Telemetry ✅ 0 issues
Protestware/Troll package ✅ 0 issues

Powered by socket.dev

ff6347 commented 1 year ago

Do not merge we have a drift between migrations and the production DB. Should be resolved manually after the testing