Function fillMissingSortKeys

database/database.go:100–131

(db *gorm.DB)

}

func fillMissingSortKeys(db *gorm.DB) error {
	missingSort := int64(0)
	if err := db.Model(new(model.Application)).Where("sort_key IS NULL OR sort_key = ''").Count(&missingSort).Error; err != nil {
		return err
	}

	if missingSort == 0 {
		return nil
	}

	var apps []*model.Application
	if err := db.Order("user_id, sort_key, id ASC").Find(&apps).Error; err != nil && err != gorm.ErrRecordNotFound {
		return err
	}
	fmt.Println("Migrating", len(apps), "application sort keys")

	sortKey := ""
	currentUser := uint(math.MaxUint)
	var err error
	for _, app := range apps {
		if currentUser != app.UserID {
			sortKey = ""
			currentUser = app.UserID
		}
		sortKey, err = fracdex.KeyBetween(sortKey, "")
		if err != nil {
			return err
		}
		app.SortKey = sortKey
	}
	return db.Save(apps).Error
}

func createDirectoryIfSqlite(dialect, connection string) {
	if dialect == "sqlite3" {