amigan/stillbox
1
0
Fork 0
Code Issues 17 Pull requests Projects Releases Packages Wiki Activity Actions

Evaluate data model #31

New issue
Open
opened 2024-11-10 15:57:01 -05:00 by amigan · 5 comments
amigan commented 2024-11-10 15:57:01 -05:00
Owner
Copy link

Maybe p25 talkgroups should have a layer of indirection (kind of like sdrtrunk aliases) and not use the P25 IDs as their record IDs.

Maybe p25 talkgroups should have a layer of indirection (kind of like sdrtrunk aliases) and not use the P25 IDs as their record IDs.
amigan added the
Kind/Enhancement
 label 2024-11-10 15:57:27 -05:00
amigan commented 2024-11-10 15:58:28 -05:00
Author
Owner
Copy link

Thinking:

  • talkgroups table as now (without tgid and sys, just using uuid or serial as PK)
  • mapping table of p25 sys:tg to talkgroups many-to-one
Thinking: * talkgroups table as now (without tgid and sys, just using uuid or serial as PK) * mapping table of p25 sys:tg to talkgroups many-to-one
amigan commented 2024-11-16 18:50:31 -05:00
Author
Owner
Copy link

This is half-done as of #25. Still need to figure out foreign key constraints that can map either to learned or actual talkgroups.

This is half-done as of #25. Still need to figure out foreign key constraints that can map either to learned or actual talkgroups.
amigan commented 2024-11-17 15:11:25 -05:00
Author
Owner
Copy link

To do in callsnormalize branch:

  • Change monster UNION learned queries to do JOIN with learned table.
  • Change to repository pattern
To do in callsnormalize branch: - [x] Change monster `UNION` learned queries to do `JOIN` with learned table. - [ ] Change to repository pattern
amigan commented 2024-11-19 10:16:35 -05:00
Author
Owner
Copy link

All that is left:

  • Repository pattern
  • Add ways to learn talkgroups (move out of learned, update talkgroups table with all fields and learned = false)
All that is left: - [ ] Repository pattern - [ ] Add ways to learn talkgroups (move out of learned, update talkgroups table with all fields and learned = false)
amigan commented 2024-11-20 09:41:30 -05:00
Author
Owner
Copy link

Collapse learned and talkgroups tables, add talkgroups versions table, simplify queries

Collapse learned and talkgroups tables, add talkgroups versions table, simplify queries
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
trunk
adminui
putTalkgroups
primebug
rrimport
archive/duration
archive/old_filters
archive/react
archive/rustimpl
Labels
Clear labels   
Compat/Breaking

Breaking change that won't be backward compatible

  
Kind/Bug

Something is not working

  
Kind/Documentation

Documentation changes

  
Kind/Enhancement

Improve existing functionality

  
Kind/Feature

New functionality

  
Kind/Security

This is security issue

  
Kind/Testing

Issue or pull request related to testing

  
Priority
Critical
The priority is critical

  
Priority
High
The priority is high

  
Priority
Low
The priority is low

  
Priority
Medium
The priority is medium

  
Reviewed
Confirmed
Issue has been confirmed

  
Reviewed
Duplicate
This issue or pull request already exists

  
Reviewed
Invalid
Invalid issue

  
Reviewed
Won't Fix
This issue won't be fixed

  
Status
Abandoned
Somebody has started to work on this but abandoned work

  
Status
Blocked
Something is blocking this issue or pull request

  
Status
Need More Info
Feedback is required to reproduce issue or to continue work

No labels
Compat/Breaking
Kind/Bug
Kind/Documentation
Kind/Enhancement
Kind/Feature
Kind/Security
Kind/Testing
Priority
Critical
Priority
High
Priority
Low
Priority
Medium
Reviewed
Confirmed
Reviewed
Duplicate
Reviewed
Invalid
Reviewed
Won't Fix
Status
Abandoned
Status
Blocked
Status
Need More Info
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: amigan/stillbox#31
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?