add file2hex 文件转换为hex 辅助yaml编写

hktalent · hktalent · commit 1fa9b366ac4d · 2022-08-18T08:31:26.000+08:00
diff --git a/lib/util/db.go b/lib/util/db.go
@@ -7,6 +7,7 @@ import (
 	"log"
 	"os"
 	"strings"
+	"time"
 )
 
 var dbCC *gorm.DB
@@ -50,12 +51,14 @@ func GetDb(dst ...interface{}) *gorm.DB {
 	}
 	log.Println("DbName ", szDf)
 	xx01 := sqlite.Open("file:" + szDf + ".db?cache=shared&mode=rwc&_journal_mode=WAL&Synchronous=Off&temp_store=memory&mmap_size=30000000000")
-	db, err := gorm.Open(xx01, &gorm.Config{Logger: logger.Default.LogMode(logger.Silent)})
+	db, err := gorm.Open(xx01, &gorm.Config{PrepareStmt: true, Logger: logger.Default.LogMode(logger.Silent)})
 	if err == nil {
 		db1, _ := db.DB()
 		if err := db1.Ping(); nil == err {
 			dbCC = db
-			db1.SetMaxOpenConns(1)
+			db1.SetConnMaxLifetime(time.Minute * 3)
+			db1.SetMaxIdleConns(GetValAsInt("MaxIdleConns", 100))
+			db1.SetMaxOpenConns(GetValAsInt("MaxOpenConns", 200))
 			if nil != dst && 0 < len(dst) {
 				db.AutoMigrate(dst[0])
 			}
diff --git a/tools/file2hex.go b/tools/file2hex.go
@@ -0,0 +1,17 @@
+package main
+
+import (
+	"fmt"
+	"io/ioutil"
+	"os"
+)
+
+func main() {
+	data, err := ioutil.ReadFile(os.Args[1])
+	if nil == err {
+		fmt.Printf("%x", data)
+	} else {
+
+		fmt.Printf("%v", err)
+	}
+}
