package migrationsimport ("context""database/sql""github.com/pressly/goose/v3")func init() {goose.AddMigrationContext(upAddDiscToAlbum, downAddDiscToAlbum)}func upAddDiscToAlbum(ctx context.Context, tx *sql.Tx) error {_, err := tx.ExecContext(ctx, `alter table album add discs JSONB default '{}';`)if err != nil {return err}_, err = tx.ExecContext(ctx, `update album set discs = t.discsfrom (select album_id, json_group_object(disc_number, disc_subtitle) as discsfrom (select distinct album_id, disc_number, disc_subtitlefrom media_filewhere disc_number > 0order by album_id, disc_number)group by album_idhaving discs <> '{"1":""}') as twhere album.id = t.album_id;`)return err}func downAddDiscToAlbum(ctx context.Context, tx *sql.Tx) error {_, err := tx.ExecContext(ctx, `alter table album drop discs;`)return err}