database/gdb: Problem with subquery usage

[chaegumi]

What do you want to ask?

package main

import (
	"context"
	"time"

	"github.com/gogf/gf/v2/database/gdb"
	"github.com/gogf/gf/v2/frame/g"
	"github.com/gogf/gf/v2/os/gctx"
)

func getData(ctx context.Context) error {
	curtime := time.Now()
	curdate := curtime.Format("2006-01-02")

	startTime := curdate + " 00:00:00"
	endTime := curdate + " 23:59:59"

	var results []struct {
		Id      int64
		SiteId  int64
		Keyword string
		Domain  string
	}

	subQuery := g.Model("serp_keywords_cron B").Fields("B.id").Where("B.keyword_id", "A.id").Where("B.created_time>=", startTime).Where("B.created_time<=", endTime)

	return g.Model("serp_keywords A").Where("NOT EXISTS ?", subQuery).Limit(1).Scan(&results)
}

func main() {

	ctx := gctx.New()

	sql, err := gdb.ToSQL(ctx, func(ctx context.Context) error {
		return getData(ctx)
	})
	if err != nil {
		panic(err)
	}

	g.Dump(sql)

}

解析出来的sql有问题，是我写法错误吗？

SELECT `id`,`site_id`,`keyword` FROM `serp_keywords` A WHERE NOT EXISTS (SELECT B.id FROM `serp_keywords_cron` B WHERE (`B`.`keyword_id`=**'A.id'**) AND (B.created_time>='2024-11-14 00:00:00') AND (B.created_time<='2024-11-14 23:59:59')) LIMIT 1

B.keyword_id='A.id'这个解析不能正确处理

[gqcn]

@chaegumi The second parameter of function Where is the value of the first parameter, like Where(key, value). You can use Where(gdb.Raw("B.keyword_id=A.id")) or Where("B.keyword_id", gdb.Raw("A.id")).