202404021909_nullable_expires_at.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 LDK payments that were not migrated to the new LDK format (PaymentKind)
  11  // TODO: delete this sometime in the future (only affects current testers)
  12  var _202404021909_nullable_expires_at = &gormigrate.Migration{
  13  	ID: "202404021909_nullable_expires_at",
  14  	Migrate: func(tx *gorm.DB) error {
  15  
  16  		err := tx.Exec(`update app_permissions set expires_at = NULL where expires_at = '0001-01-01 00:00:00+00:00'`).Error
  17  
  18  		return err
  19  	},
  20  	Rollback: func(tx *gorm.DB) error {
  21  		return nil
  22  	},
  23  }
  24