go-gorm / playground Goto Github PK

Run GORM_DIALECT=sqlite ./test.sh
git clone --depth 1 -b  
error: switch `b' requires a value
##[error]Process completed with exit code 129.

[
{
"INFO": {
  "DESCRIPTION": "lorem ipsum",
  "BUYERS": [
   {
   "ID": 1,
   "NAME": "John Doe"
   },
   {
   "ID": 2,
   "NAME": "Jane Doe"
   }
  ]
 }
},
{
"INFO": {
  "DESCRIPTION": "lorem ipsum",
  "BUYERS": [
   {
   "ID": 1,
   "NAME": "John Doe"
   },
   {
   "ID": 2,
   "NAME": "Michael"
   }
  ]
 }
},
]

SELECT * FROM products WHERE info -> 'buyers' @> '[{"name": "Jane Doe"}]'

result = db.Where("info-> 'buyers' @> '[{\"name\": @name}]'", map[string]interface{}{"name": request.body.name}).Find(&products)

SELECT * FROM "product" WHERE info-> 'buyers' @> '[{"name": @name}]'
ERROR: invalid input syntax for type json (SQLSTATE 22P02)

[
{
"INFO": {
  "DESCRIPTION": "lorem ipsum",
  "BUYERS": [
   {
   "ID": 1,
   "NAME": "John Doe"
   },
   {
   "ID": 2,
   "NAME": "Jane Doe"
   }
  ]
 }
}
]

git clone --depth 1 -b master https://github.com/go-gorm/gorm.git
Cloning into 'gorm'...
remote: Enumerating objects: 179, done.
remote: Counting objects: 100% (179/179), done.
remote: Compressing objects: 100% (173/173), done.
remote: Total 179 (delta 11), reused 61 (delta 4), pack-reused 0
Receiving objects: 100% (179/179), 226.27 KiB | 2.73 MiB/s, done.
Resolving deltas: 100% (11/11), done.
go: downloading gorm.io/driver/postgres v1.5.2
go: downloading gorm.io/driver/sqlite v1.5.3
go: downloading gorm.io/driver/mysql v1.5.1
go: downloading gorm.io/driver/sqlserver v1.5.1
go: downloading github.com/jackc/pgx/v5 v5.4.3
go: downloading github.com/go-sql-driver/mysql v1.7.1
go: downloading github.com/microsoft/go-mssqldb v1.5.0
go: downloading github.com/jackc/pgx v3.6.2+incompatible
go: downloading github.com/jackc/pgservicefile v0.0.0-20221227161230-091c0ba34f0a
go: downloading golang.org/x/crypto v0.12.0
go: downloading golang.org/x/text v0.12.0
go: downloading github.com/jackc/pgpassfile v1.0.0
go: downloading github.com/microsoft/go-mssqldb v1.6.0
go: downloading github.com/golang-sql/sqlexp v0.1.0
go: downloading github.com/golang-sql/civil v0.0.0-20220223132316-b832511892a9
go: downloading golang.org/x/crypto v0.14.0
go: downloading golang.org/x/text v0.13.0
go: upgraded github.com/microsoft/go-mssqldb v1.5.0 => v1.6.0
go: upgraded golang.org/x/crypto v0.12.0 => v0.14.0
go: upgraded golang.org/x/text v0.12.0 => v0.13.0
go: upgraded gorm.io/driver/sqlite v1.5.3 => v1.5.4
Creating network "playground_default" with the default driver
Creating playground_mysql_1    ... done
Creating playground_postgres_1 ... done
Creating playground_mssql_1    ... done
starting...
testing sqlite...
2023/10/08 15:46:37 testing sqlite3...

2023/10/08 15:46:37 /home/qcazelles/Desktop/playground/db.go:97 table "companies" has more than one primary key
[0.023ms] [rows:0] CREATE TABLE `companies` (`id` integer PRIMARY KEY AUTOINCREMENT,`name` text,PRIMARY KEY (`id`))
2023/10/08 15:46:37 Failed to auto migrate, but got error table "companies" has more than one primary key
FAIL	gorm.io/playground	0.038s

2023/10/08 15:40:03 /home/qcazelles/Desktop/minimal_reproducer/main.go:21 table "test_structs" has more than one primary key
[0.016ms] [rows:0] CREATE TABLE `test_structs` (`id` integer PRIMARY KEY AUTOINCREMENT,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,PRIMARY KEY (`id`))
table "test_structs" has more than one primary key

	gormDb, err := gorm.Open(mysql.Open("Dsn"), &gorm.Config{
	})
	if err != nil {
		//gorm 数据库驱动初始化失败
		return nil, err
	}
	var resolverConf dbresolver.Config

	// 如果开启了读写分离，配置读数据库（resource、read、replicas）
		resolverConf = dbresolver.Config{
			Sources:  []gorm.Dialector{mysql.Open("WriteDsn")}, 
			Replicas: []gorm.Dialector{mysql.Open("ReadDsn")},  
			Policy:   dbresolver.RandomPolicy{}, 
		}
		
	err = gormDb.Use(dbresolver.Register(resolverConf, "").SetConnMaxIdleTime(time.Minute).
		SetConnMaxLifetime(10* time.Second).
		SetMaxIdleConns(10).
		SetMaxOpenConns(30))   // 这里设置的连接池最大连接为30 
	if err != nil {
		return nil, err
	}
	

	//  并发性能测试，同时测试连接池
	var wg sync.WaitGroup
	// 并发最大连接数设置为 128 进行本次测试， 问题如下：
	// 如果使用 database/sql 原生操作，在数据库使用  show  processlist 命令查看，程序执行期间的连接为 30+已有连接
	// 使用 gorm 测试，连接池的上限根本无效,数据库的连接就是 128+已有连接

	var conNum = make(chan uint16, 128)
	wg.Add(1000)
	time1 := time.Now()
	for i := 1; i <= 1000; i++ {
		conNum <- 1
		go func() {
			defer func() {
				<-conNum
				wg.Done()
			}()
			var received []tb_code_lists
			gormDb.Table("tb_code_list").Select("code", "name", "company_name", "province", "city", "remark", "status", "created_at", "updated_at").Where("id<=?", 3500).Find(&received)
			//fmt.Printf("本次读取的数据条数:%d\n",len(received))
		}()
	}
	wg.Wait()
	fmt.Printf("耗时（ms）:%d\n", time.Now().Sub(time1).Milliseconds())

 Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..
mssql_1     | Error: MSSQL SERVER took more than thirty seconds to start up.
mssql_1     | tail: inotify cannot be used, reverting to polling: Function not implemented

`
type BaseModel struct {
	gorm.Model
	CreatedBy uint                  `gorm:"column:CreatedBy;type:bigint(20) UNSIGNED;not null;default:0;"`
	UpdatedBy uint                  `gorm:"column:UpdatedBy;type:bigint(20) UNSIGNED;not null;default:0;"`
	DeletedBy soft_delete.DeletedAt `gorm:"softDelete:flag,DeletedAtField:DeletedAt;column:DeletedBy;type:bigint(20) UNSIGNED;not null;default:0;"`
}
`