HEX
Server: Apache/2.4.54 (Win64) OpenSSL/1.1.1p PHP/7.4.30
System: Windows NT website-api 10.0 build 20348 (Windows Server 2016) AMD64
User: SYSTEM (0)
PHP: 7.4.30
Disabled: NONE
Upload Files
File: C:/github_repos/casibase/object/record_test.go
// Copyright 2025 The Casibase Authors. All Rights Reserved.
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
//      http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

//go:build !skipCi
// +build !skipCi

package object

import (
	"strings"
	"testing"

	"github.com/casibase/casibase/util"
	"github.com/schollz/progressbar/v3"
)

func TestUpdateRecordsLocation(t *testing.T) {
	InitConfig()
	util.InitMaxmindFiles()
	util.InitIpDb()

	records, err := getAllRecords()
	if err != nil {
		panic(err)
	}

	bar := progressbar.Default(int64(len(records)))
	var errorRecords []string
	for _, r := range records {
		bar.Add(1)
		if r.Unit == "" || r.Section == "" {
			clientIp := r.ClientIp
			if strings.Contains(clientIp, " ->") {
				parts := strings.Split(clientIp, " ->")
				clientIp = strings.TrimSpace(parts[len(parts)-1])
			}

			locationInfo, err := util.GetInfoFromIP(clientIp)
			if err != nil {
				errorRecords = append(errorRecords, r.Name+": invalid client ip.")
				continue
			}

			r.Region = locationInfo.Country
			r.City = locationInfo.City
			err = UpdateRecordInternal(r.Id, *r)
			if err != nil {
				errorRecords = append(errorRecords, r.Name+": update error.")
			}
		}
	}

	t.Log("Log location information update completed.\n")
	if len(errorRecords) > 0 {
		t.Log("The following logs encountered errors during the update.\n")
		for _, msg := range errorRecords {
			t.Log(" - " + msg)
		}
	}
}