Every analytics tool wants a subscription. And your data. I built Twiligent instead. YouTube stats. Instagram stats. One dashboard. Runs locally on your machine.
-- puts back the earlier finish_automation_send, without the recipient or the followers-only wait
drop function if exists public.finish_automation_send(text, text, text, text, text, text, text, integer, integer, integer, timestamptz, timestamptz, text, text, text, text);
create or replace function public.finish_automation_send(
p_id text,
p_attempt_id text,
p_status text,
p_outcome text,
p_reason text default null,
p_error_message text default null,
p_message_id text default null,
p_error_code integer default null,
p_error_subcode integer default null,
p_http_status integer default null,
p_next_attempt_at timestamptz default null,
p_cooldown_until timestamptz default null,
p_cooldown_reason text default null,
p_pause_reason text default null
)
returns boolean
language plpgsql
set search_path = ''
as $$
declare
job public.automation_comments%rowtype;
begin
update public.automation_comments c
set status = p_status,
status_reason = p_reason,
error_message = p_error_message,
message_id = coalesce(p_message_id, c.message_id),
accepted_at = case when p_status = 'accepted' then now() else c.accepted_at end,
next_attempt_at = p_next_attempt_at,
claimed_at = null
where c.id = p_id and (c.status = 'sending' or (c.status = 'needs_review' and c.status_reason = 'interrupted'))
returning * into job;
if not found then
return false;
end if;
update public.automation_attempts t
set outcome = p_outcome,
error_code = p_error_code,
error_subcode = p_error_subcode,
http_status = p_http_status,
finished_at = now()
where t.id = p_attempt_id and t.automation_comment_id = p_id;
if p_cooldown_until is not null then
insert into public.automation_accounts (account_id, user_id, cooldown_until, cooldown_reason)
values (job.account_id, job.user_id, p_cooldown_until, p_cooldown_reason)
on conflict (account_id) do update
set cooldown_until = greatest(coalesce(public.automation_accounts.cooldown_until, excluded.cooldown_until), excluded.cooldown_until),
cooldown_reason = excluded.cooldown_reason;
end if;
if p_pause_reason is not null then
insert into public.automation_accounts (account_id, user_id, paused, paused_reason)
values (job.account_id, job.user_id, true, p_pause_reason)
on conflict (account_id) do update set paused = true, paused_reason = excluded.paused_reason;
end if;
return true;
end;
$$;
revoke execute on function public.finish_automation_send(text, text, text, text, text, text, text, integer, integer, integer, timestamptz, timestamptz, text, text) from public, anon, authenticated;
grant execute on function public.finish_automation_send(text, text, text, text, text, text, text, integer, integer, integer, timestamptz, timestamptz, text, text) to service_role;