gtsocial-umbx

Unnamed repository; edit this file 'description' to name the repository.
Log | Files | Refs | README | LICENSE

20230221150957_status_pin_client_api.go (2224B)

      1 // GoToSocial
      2 // Copyright (C) GoToSocial Authors admin@gotosocial.org
      3 // SPDX-License-Identifier: AGPL-3.0-or-later
      4 //
      5 // This program is free software: you can redistribute it and/or modify
      6 // it under the terms of the GNU Affero General Public License as published by
      7 // the Free Software Foundation, either version 3 of the License, or
      8 // (at your option) any later version.
      9 //
     10 // This program is distributed in the hope that it will be useful,
     11 // but WITHOUT ANY WARRANTY; without even the implied warranty of
     12 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
     13 // GNU Affero General Public License for more details.
     14 //
     15 // You should have received a copy of the GNU Affero General Public License
     16 // along with this program.  If not, see <http://www.gnu.org/licenses/>.
     17 
     18 package migrations
     19 
     20 import (
     21 	"context"
     22 	"strings"
     23 
     24 	"github.com/superseriousbusiness/gotosocial/internal/gtsmodel"
     25 	"github.com/uptrace/bun"
     26 )
     27 
     28 func init() {
     29 	up := func(ctx context.Context, db *bun.DB) error {
     30 		return db.RunInTx(ctx, nil, func(ctx context.Context, tx bun.Tx) error {
     31 			// Drop the now unused 'pinned' column in statuses.
     32 			if _, err := tx.ExecContext(ctx, "ALTER TABLE ? DROP COLUMN ?", bun.Ident("statuses"), bun.Ident("pinned")); err != nil &&
     33 				!(strings.Contains(err.Error(), "no such column") || strings.Contains(err.Error(), "does not exist") || strings.Contains(err.Error(), "SQLSTATE 42703")) {
     34 				return err
     35 			}
     36 
     37 			// Create new (more useful) pinned_at column.
     38 			if _, err := tx.NewAddColumn().Model(&gtsmodel.Status{}).ColumnExpr("? TIMESTAMPTZ", bun.Ident("pinned_at")).Exec(ctx); err != nil &&
     39 				!(strings.Contains(err.Error(), "already exists") || strings.Contains(err.Error(), "duplicate column name") || strings.Contains(err.Error(), "SQLSTATE 42701")) {
     40 				return err
     41 			}
     42 
     43 			// Index new column appropriately.
     44 			if _, err := tx.
     45 				NewCreateIndex().
     46 				Model(&gtsmodel.Status{}).
     47 				Index("statuses_account_id_pinned_at_idx").
     48 				Column("account_id", "pinned_at").
     49 				Exec(ctx); err != nil {
     50 				return err
     51 			}
     52 
     53 			return nil
     54 		})
     55 	}
     56 
     57 	down := func(ctx context.Context, db *bun.DB) error {
     58 		return nil
     59 	}
     60 
     61 	if err := Migrations.Register(up, down); err != nil {
     62 		panic(err)
     63 	}
     64 }