From 660cf2c94ce6a87ac33d704ab1f68b2d4a258d92 Mon Sep 17 00:00:00 2001 From: nicole mikołajczyk Date: Tue, 12 Aug 2025 14:05:15 +0200 Subject: [feature] scheduled statuses (#4274) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit An implementation of [`scheduled_statuses`](https://docs.joinmastodon.org/methods/scheduled_statuses/). Will fix #1006. this is heavily WIP and I need to reorganize some of the code, working on this made me somehow familiar with the codebase and led to my other recent contributions i told some fops on fedi i'd work on this so i have no choice but to complete it 🤷‍♀️ btw iirc my avatar presents me working on this branch Signed-off-by: nicole mikołajczyk Reviewed-on: https://codeberg.org/superseriousbusiness/gotosocial/pulls/4274 Co-authored-by: nicole mikołajczyk Co-committed-by: nicole mikołajczyk --- internal/db/scheduledstatus.go | 59 ++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 59 insertions(+) create mode 100644 internal/db/scheduledstatus.go (limited to 'internal/db/scheduledstatus.go') diff --git a/internal/db/scheduledstatus.go b/internal/db/scheduledstatus.go new file mode 100644 index 000000000..b266462c2 --- /dev/null +++ b/internal/db/scheduledstatus.go @@ -0,0 +1,59 @@ +// GoToSocial +// Copyright (C) GoToSocial Authors admin@gotosocial.org +// SPDX-License-Identifier: AGPL-3.0-or-later +// +// This program is free software: you can redistribute it and/or modify +// it under the terms of the GNU Affero General Public License as published by +// the Free Software Foundation, either version 3 of the License, or +// (at your option) any later version. +// +// This program is distributed in the hope that it will be useful, +// but WITHOUT ANY WARRANTY; without even the implied warranty of +// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +// GNU Affero General Public License for more details. +// +// You should have received a copy of the GNU Affero General Public License +// along with this program. If not, see . + +package db + +import ( + "context" + "time" + + "code.superseriousbusiness.org/gotosocial/internal/gtsmodel" + "code.superseriousbusiness.org/gotosocial/internal/paging" +) + +type ScheduledStatus interface { + // GetAllScheduledStatuses returns all pending scheduled statuses. + GetAllScheduledStatuses(ctx context.Context) ([]*gtsmodel.ScheduledStatus, error) + + // GetScheduledStatusByID gets one scheduled status with the given id. + GetScheduledStatusByID(ctx context.Context, id string) (*gtsmodel.ScheduledStatus, error) + + // GetScheduledStatusesForAcct returns statuses scheduled by the given account. + GetScheduledStatusesForAcct( + ctx context.Context, + acctID string, + page *paging.Page, + ) ([]*gtsmodel.ScheduledStatus, error) + + // PutScheduledStatus puts the given scheduled status in the database. + PutScheduledStatus(ctx context.Context, status *gtsmodel.ScheduledStatus) error + + // DeleteScheduledStatusByID deletes one scheduled status from the database. + DeleteScheduledStatusByID(ctx context.Context, id string) error + + // DeleteScheduledStatusByID deletes all scheduled statuses from an account from the database. + DeleteScheduledStatusesByAccountID(ctx context.Context, accountID string) error + + // DeleteScheduledStatusesByApplicationID deletes all scheduled statuses posted from the given application from the database. + DeleteScheduledStatusesByApplicationID(ctx context.Context, applicationID string) error + + // UpdateScheduledStatusScheduledDate updates `scheduled_at` param for the given scheduled status in the database. + UpdateScheduledStatusScheduledDate(ctx context.Context, scheduledStatus *gtsmodel.ScheduledStatus, scheduledAt *time.Time) error + + // GetScheduledStatusesCountForAcct returns the number of pending statuses scheduled by the given account, optionally for a specific day. + GetScheduledStatusesCountForAcct(ctx context.Context, acctID string, scheduledAt *time.Time) (int, error) +} -- cgit v1.2.3