Commit graph

41 commits

Author SHA1 Message Date
f7fdaf9867 don't alert ignored 2024-11-19 10:18:12 -05:00
ef69d95583 Initial calls normalization
fix

wip
2024-11-19 10:18:12 -05:00
4eddd7d1df Learned has uuids 2024-11-15 23:25:57 -05:00
e82f07e094 housekeeping 2024-11-15 11:34:54 -05:00
af80e46068 New DB schema 2024-11-15 10:37:58 -05:00
e38ebe6802 reid first stab 2024-11-14 10:16:20 -05:00
d592e20d37 FKEY constraint prevents alerts on learned talkgroups 2024-11-12 10:14:11 -05:00
6e1640e4b4 PUT talkgroup 2024-11-10 10:13:38 -05:00
3f133e152a UUID is part of Call and is generated by us.
Closes #8
2024-11-06 20:47:10 -05:00
fb2387c212 API begin 2024-11-04 23:42:09 -05:00
d917e13c4f Embed 2024-11-03 09:45:51 -05:00
5338bb0071 Use sqlc.embed 2024-11-03 08:44:34 -05:00
ecd7a39db0 Store suppressed alerts 2024-11-02 14:27:07 -04:00
83b6b0e4f4 Initial 2024-11-02 09:41:48 -04:00
f54d0d250a Add alerts to table 2024-11-01 09:15:48 -04:00
47c1beec4a Implement tgcache 2024-10-31 16:14:38 -04:00
0d793cb31a Notify and alerting 2024-10-31 13:21:00 -04:00
cdc2034af6 Initial alerting
wip

kind of working

wip
2024-10-31 13:15:48 -04:00
343dc86591 Whole db size 2024-10-20 13:04:42 -04:00
9f2ddada28 Calls size 2024-10-20 12:26:32 -04:00
2b4d1e5488 fix tgs 2024-09-02 19:15:58 -04:00
ddff9f4a6a alpha tag 2024-08-23 14:28:47 -04:00
692dcf98da Get system name 2024-08-20 08:17:02 -04:00
f16f545961 Fix scan error 2024-08-17 11:52:53 -04:00
12138ab6eb get tg 2024-08-16 16:47:39 -04:00
95407633e1 add tginfo 2024-08-16 14:54:50 -04:00
4d35153aff Add call duration field. 2024-08-11 13:49:43 -04:00
d3d6220af6 Filters 2024-08-06 21:33:52 -04:00
f05a717e2f Move tg tags into the tg table 2024-07-28 23:07:04 -04:00
234671bc9d Don't return everything since bytea included 2024-07-28 09:01:30 -04:00
a25aaccbf3 calls trigger 2024-07-27 19:25:16 -04:00
d94ae3b701 call apikey 2024-07-24 22:42:30 -04:00
e9dbfe33e3 proper foreign key 2024-07-17 19:49:50 -04:00
20c21beca9 use composite key for talkgroups 2024-07-17 19:45:46 -04:00
57449e99a0 Get IDs 2024-07-17 19:40:21 -04:00
d7352ddb53 Set call transcript 2024-07-17 19:33:09 -04:00
c79bfc0fde Add talkgroup tags 2024-07-17 19:30:49 -04:00
72edd16d7b Use call_date 2024-07-16 19:35:16 -04:00
d6d2da3e04 Schema 2024-07-16 19:31:30 -04:00
c75dd9ec43 Add config flag 2024-07-15 22:30:32 -04:00
2db6cae67e clean up SQL 2024-07-15 19:03:48 -04:00