import (
	"database/sql"
	"log"

	"github.com/pressly/goose/v3"
)

const (
    upSQL1 = `
CREATE INDEX measurement_usls_idx ON ONLY measurement (unitsales);
`

    upSQL2 = `
CREATE INDEX CONCURRENTLY measurement_usls_200602_idx
    ON measurement_y2006m02 (unitsales);
ALTER INDEX measurement_usls_idx
    ATTACH PARTITION measurement_usls_200602_idx;
`

    downSQL = `DROP INDEX measurement_usls_idx`
)

func init() {
	goose.AddMigrationNoTx(up, down)
}

func up(db *sql.DB) error {
        if _, err := db.Exec(upSQL1); err != nil {
		return err
	}
         if _, err := db.Exec(upSQL2); err != nil {
		return err
	}
	return nil
}

func down(db *sql.DB) error {
        if _, err := db.Exec(downSQL); err != nil {
		return err
	}
        return nil
}