Restore talkgroups from version table backup #43

New issue

Closed

opened 2024-11-20 22:43:24 -05:00 by amigan · 0 comments

amigan commented

2024-11-20 22:43:24 -05:00

Owner

insert into talkgroups (system_id, tgid, name, alpha_tag, tg_group, frequency, metadata, tags, alert, alert_config, weight, learned, ignored) select system_id, tgid, name, alpha_tag, tg_group, frequency, metadata, tags, alert, alert_config, weight, learned, ignored from talkgroup_versions on conflict (system_id, tgid) do update set name = excluded.name, alpha_tag = excluded.alpha_tag, tg_group = excluded.tg_group, metadata = excluded.metadata, tags = excluded.tags, alert = excluded.alert, alert_config = excluded.alert_config, weight = excluded.weight, learned = excluded.learner, ignored = excluded.ignored;

``` insert into talkgroups (system_id, tgid, name, alpha_tag, tg_group, frequency, metadata, tags, alert, alert_config, weight, learned, ignored) select system_id, tgid, name, alpha_tag, tg_group, frequency, metadata, tags, alert, alert_config, weight, learned, ignored from talkgroup_versions on conflict (system_id, tgid) do update set name = excluded.name, alpha_tag = excluded.alpha_tag, tg_group = excluded.tg_group, metadata = excluded.metadata, tags = excluded.tags, alert = excluded.alert, alert_config = excluded.alert_config, weight = excluded.weight, learned = excluded.learner, ignored = excluded.ignored; ```

amigan added the

Kind/Enhancement

label 2024-11-20 22:43:24 -05:00

amigan closed this issue

2024-11-21 07:43:14 -05:00

No milestone

No project

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#43

No description provided.