Skip to content

SigNoz is an open-source, OpenTelemetry-native observability platform for your team and their AI agents. Get logs, metrics, and traces in one tool with features like APM, distributed tracing, log management, infra monitoring, etc. Combined with SigNoz MCP and a native AI teammate (in SigNoz Cloud) it helps you build more resilient apps.

2.3 KB
Raw Blame
package sqlmigration

import (
	"context"

	"github.com/SigNoz/signoz/pkg/factory"
	"github.com/uptrace/bun"
	"github.com/uptrace/bun/migrate"
)

type modifyDatetime struct{}

func NewModifyDatetimeFactory() factory.ProviderFactory[SQLMigration, Config] {
	return factory.NewProviderFactory(factory.MustNewName("modify_datetime"), newModifyDatetime)
}

func newModifyDatetime(_ context.Context, _ factory.ProviderSettings, _ Config) (SQLMigration, error) {
	return &modifyDatetime{}, nil
}

func (migration *modifyDatetime) Register(migrations *migrate.Migrations) error {
	if err := migrations.Register(migration.Up, migration.Down); err != nil {
		return err
	}

	return nil
}

func (migration *modifyDatetime) Up(ctx context.Context, db *bun.DB) error {
	// only run this for old sqlite db
	if db.Dialect().Name().String() != "sqlite" {
		return nil
	}

	// begin transaction
	tx, err := db.BeginTx(ctx, nil)
	if err != nil {
		return err
	}

	defer func() {
		_ = tx.Rollback()
	}()

	tables := []string{"dashboards", "rules", "planned_maintenance", "ttl_status", "saved_views"}
	columns := []string{"created_at", "updated_at"}
	for _, table := range tables {
		for _, column := range columns {
			if err := modifyColumn(ctx, tx, table, column); err != nil {
				return err
			}
		}
	}

	for _, column := range []string{"started_at", "terminated_at"} {
		if err := modifyColumn(ctx, tx, "agents", column); err != nil {
			return err
		}
	}

	if err := tx.Commit(); err != nil {
		return err
	}

	return nil
}

func modifyColumn(ctx context.Context, tx bun.Tx, table string, column string) error {
	// rename old column
	if _, err := tx.ExecContext(ctx, `ALTER TABLE `+table+` RENAME COLUMN `+column+` TO `+column+`_old`); err != nil {
		return err
	}

	// cannot add not null constraint to the column
	if _, err := tx.ExecContext(ctx, `ALTER TABLE `+table+` ADD COLUMN `+column+` TIMESTAMP`); err != nil {
		return err
	}

	// update the new column with the value of the old column
	if _, err := tx.ExecContext(ctx, `UPDATE `+table+` SET `+column+` = `+column+`_old`); err != nil {
		return err
	}

	// drop the old column
	if _, err := tx.ExecContext(ctx, `ALTER TABLE `+table+` DROP COLUMN `+column+`_old`); err != nil {
		return err
	}
	return nil
}

func (migration *modifyDatetime) Down(ctx context.Context, db *bun.DB) error {
	return nil
}