202406061259_delete_content.go raw

   1  package migrations
   2  
   3  import (
   4  	_ "embed"
   5  
   6  	"github.com/go-gormigrate/gormigrate/v2"
   7  	"gorm.io/gorm"
   8  )
   9  
  10  // Delete the content column from both request and response events table
  11  var _202406061259_delete_content = &gormigrate.Migration{
  12  	ID: "202406061259_remove_content_columns",
  13  	Migrate: func(tx *gorm.DB) error {
  14  		if err := tx.Exec("ALTER TABLE response_events DROP COLUMN content").Error; err != nil {
  15  			return err
  16  		}
  17  
  18  		if err := tx.Exec("ALTER TABLE request_events DROP COLUMN content").Error; err != nil {
  19  			return err
  20  		}
  21  
  22  		// Disabled for now: not used.
  23  		// Cannot run when testing with txdb: VACUUM must be run outside of transaction.
  24  		// if !testing.Testing() {
  25  		// 	if err := tx.Exec("VACUUM").Error; err != nil {
  26  		// 		return err
  27  		// 	}
  28  		// }
  29  
  30  		return nil
  31  	},
  32  	Rollback: func(tx *gorm.DB) error {
  33  		return nil
  34  	},
  35  }
  36