202403171120_delete_ldk_payments.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  // TODO: delete the whole migration
  11  // Delete LDK payments that were not migrated to the new LDK format (PaymentKind)
  12  // this has now been removed as it only affects old test builds that should have been updated by now
  13  // in case someone encounters it, they can run the commands on their DB to fix the issue.
  14  var _202403171120_delete_ldk_payments = &gormigrate.Migration{
  15  	ID: "202403171120_delete_ldk_payments",
  16  	Migrate: func(tx *gorm.DB) error {
  17  
  18  		/*ldkDbPath := filepath.Join(appConfig.Workdir, "ldk", "storage", "ldk_node_data.sqlite")
  19  		if _, err := os.Stat(ldkDbPath); errors.Is(err, os.ErrNotExist) {
  20  			logger.Logger.Info("No LDK database, skipping migration")
  21  			return nil
  22  		}
  23  		ldkDb, err := sql.Open("sqlite", ldkDbPath)
  24  		if err != nil {
  25  			return err
  26  		}
  27  		result, err := ldkDb.Exec(`update ldk_node_data set primary_namespace="payments_bkp" where primary_namespace == "payments"`)
  28  		if err != nil {
  29  			return err
  30  		}
  31  		rowsAffected, err := result.RowsAffected()
  32  		if err != nil {
  33  			return err
  34  		}
  35  		logger.Logger.WithFields(logrus.Fields{
  36  			"rowsAffected": rowsAffected,
  37  		}).Info("Removed incompatible payments from LDK database")
  38  
  39  		return err*/
  40  		return nil
  41  	},
  42  	Rollback: func(tx *gorm.DB) error {
  43  		return nil
  44  	},
  45  }
  46