Restore talkgroups from version table backup #43

New issue

Open

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; ```