英文:
sql: expected 8 arguments, got 0 using `preparex` and `context.context`
问题
我的问题与那个问题无关。我的问题主要是关于preparex和ctx。我已经使用db.NamedExec完成了实现，我的代码对这些都有效。我在这里尝试做的是理解context.context和preparex，并使用这两个进行实现。
代码片段：
model.go
type User struct {ID int `db:"id" json:"id"`CreatedAt time.Time `db:"created_at" json:"created_at"`UpdatedAt time.Time `db:"updated_at" json:"updated_at"`DeletedAt time.Time `db:"deleted_at" json:"deleted_at"`Username string `db:"username" json:"username"`Password string `db:"password" json:"password"`FirstName string `db:"first_name" json:"first_name"`LastName string `db:"last_name" json:"last_name"`Phone string `db:"phone" json:"phone"`Status bool `db:"status" json:"status"`Addrs []UserAddress}
查询：
queryInsertUserData = `INSERT INTO users (id, created_at, updated_at, deleted_at, username, password, first_name, last_name, phone, status) VALUES($1, now(), now(), $2, $3, $4, $5, $6, $7, $8)`
type queries struct {insertUserData,insertAddrData *sqlx.Stmt}// prepareStatement是一个用于准备sqlx语句的方法func (queries *queries) prepareStatement(db *sqlx.DB, query string) (*sqlx.Stmt, error) {stmt, err := db.Preparex(query) //https://go.dev/doc/database/prepared-statementsif err != nil {return nil, err}return stmt, err}constructUserData, err := queries.prepareStatement(db, queryInsertUserData)queries.insertUserData = constructUserData
实现：
// 插入用户数据func (postgres *Postgres) InsertUserData(ctx context.Context) (*entity.User, error) {c := entity.User{}err := postgres.queries.insertUserData.SelectContext(ctx, &c) //<---这里if err != nil {return nil, err}return &c, nil}
我的ctx是：
ctx = context.WithValue(ctx, "ID", 1)ctx = context.WithValue(ctx, "Username", "John")ctx = context.WithValue(ctx, "Password", "pass")
当我传递给postgres.queries.insertUserData.SelectContext(ctx, &c)时
我得到：sql: expected 8 arguments, got 0
为什么它说得到了0个参数？有人可以帮我解决这个问题吗？如何传递ctx并提供插入查询值？
英文:
My question is not related to that one. My question was mostly on preparex and ctx. I have already done with the implementation using the db.NamedExec and my code is working for those. What I am trying to do here is to understand context.context and preparex. Implement using these two.
CODE SNIPPET:
model.go
type User struct {ID int `db:"id" json:"id"`CreatedAt time.Time `db:"created_at" json:"created_at"`UpdatedAt time.Time `db:"updated_at" json:"updated_at"`DeletedAt time.Time `db:"deleted_at" json:"deleted_at"`Username string `db:"username" json:"username"`Password string `db:"password" json:"password"`FirstName string `db:"first_name" json:"first_name"`LastName string `db:"last_name" json:"last_name"`Phone string `db:"phone" json:"phone"`Status bool `db:"status" json:"status"`Addrs []UserAddress}
Query:
queryInsertUserData = `INSERT INTO users (id, created_at, updated_at, deleted_at, username, password, first_name, last_name, phone, status) VALUES($1, now(), now(), $2, $3, $4, $5, $6, $7, $8)`
type queries struct {insertUserData,insertAddrData *sqlx.Stmt}//prepareStatement is a method for preparing sqlx statementfunc (queries *queries) prepareStatement(db *sqlx.DB, query string) (*sqlx.Stmt, error) {stmt, err := db.Preparex(query) //https://go.dev/doc/database/prepared-statementsif err != nil {return nil, err}return stmt, err}constructUserData, err := queries.prepareStatement(db, queryInsertUserData)queries.insertUserData = constructUserData
Implementation:
// Insert User datafunc (postgres *Postgres) InsertUserData(ctx context.Context) (*entity.User, error) {c := entity.User{}err := postgres.queries.insertUserData.SelectContext(ctx, &c) //<---hereif err != nil {return nil, err}return &c, nil}
my ctx is :
ctx = context.WithValue(ctx, "ID", 1)ctx = context.WithValue(ctx, "Username", "John")ctx = context.WithValue(ctx, "Password", "pass")
when I am passing to postgres.queries.insertUserData.SelectContext(ctx, &c)
I am getting: sql: expected 8 arguments, got 0
why it is saying got 0? Can anyone help me with this? How to pass ctx and provide the insert query values?
答案1
得分: 1
我没有理解你的代码结构，但从主要的上下文（插入查询）来看，你应该像这样做：
package mainimport ("context""database/sql""log")var db *sql.DBtype User struct {ID int `db:"id" json:"id"`CreatedAt time.Time `db:"created_at" json:"created_at"`UpdatedAt time.Time `db:"updated_at" json:"updated_at"`DeletedAt time.Time `db:"deleted_at" json:"deleted_at"`Username string `db:"username" json:"username"`Password string `db:"password" json:"password"`FirstName string `db:"first_name" json:"first_name"`LastName string `db:"last_name" json:"last_name"`Phone string `db:"phone" json:"phone"`Status bool `db:"status" json:"status"`Addrs []UserAddress}func main() {users := []User {{...User 1 data...},{...User 2 data...},}stmt, err := db.Prepare("INSERT INTO users (id, created_at, updated_at, deleted_at, username, password, first_name, last_name, phone, status) VALUES($1, now(), now(), $2, $3, $4, $5, $6, $7, $8)")if err != nil {log.Fatal(err)}defer stmt.Close() // Prepared statements take up server resources and should be closed after use.for id, user := range users {if _, err := stmt.Exec(id+1, user.Username, user.Password,... other data); err != nil {log.Fatal(err)}}}
此外，你可以使用Gorm这个强大的包来使用所有关系型数据库。
英文:
I didn't get the structure of your code, but from the main context (inserting query) you should do something like this:
package mainimport ("context""database/sql""log")var db *sql.DBtype User struct {ID int `db:"id" json:"id"`CreatedAt time.Time `db:"created_at" json:"created_at"`UpdatedAt time.Time `db:"updated_at" json:"updated_at"`DeletedAt time.Time `db:"deleted_at" json:"deleted_at"`Username string `db:"username" json:"username"`Password string `db:"password" json:"password"`FirstName string `db:"first_name" json:"first_name"`LastName string `db:"last_name" json:"last_name"`Phone string `db:"phone" json:"phone"`Status bool `db:"status" json:"status"`Addrs []UserAddress}func main() {users := []User {{...User 1 data...},{...User 2 data...},}stmt, err := db.Prepare("INSERT INTO users (id, created_at, updated_at, deleted_at, username, password, first_name, last_name, phone, status) VALUES($1, now(), now(), $2, $3, $4, $5, $6, $7, $8)")if err != nil {log.Fatal(err)}defer stmt.Close() // Prepared statements take up server resources and should be closed after use.for id, user := range users {if _, err := stmt.Exec(id+1, user.Username, user.Password,... other data); err != nil {log.Fatal(err)}}}
also, you can use the Gorm powerful package for using all relational databases.
答案2
得分: 1
我使用这个助手进行插入操作。
使用以下查询语法：
INSERT INTO checks (status) VALUES (:status)returning id;
示例结构体
type Row struct {Status string `db:"status"`}
// Insert函数使用查询SQL命令将行插入表中// 表仅用于日志记录，实际表名在查询中定义// 函数期望具有命名参数的查询func Insert(ctx context.Context, row interface{}, query string, table string, tx *sqlx.Tx) (int64, error) {// 将命名查询转换为本机参数格式query, args, err := tx.BindNamed(query, row)if err != nil {return 0, fmt.Errorf("无法绑定参数插入到表 %q 中：%w", table, err)}var id struct {Val int64 `db:"id"`}err = sqlx.GetContext(ctx, tx, &id, query, args...)if err != nil {return 0, fmt.Errorf("无法插入到表 %q 中：%w", table, err)}return id.Val, nil}
英文:
I use this helper for inserts.
Works with query syntax as follows:
INSERT INTO checks (status) VALUES (:status)returning id;
Sample struct
type Row struct {Status string `db:"status"`}
// Insert inserts row into table using query SQL command// table used only for loging, actual table name defined in query// function expects Query with named parametersfunc Insert(ctx context.Context, row interface{}, query string, table string, tx *sqlx.Tx) (int64, error) {// convert named query to native parameters formatquery, args, err := tx.BindNamed(query, row)if err != nil {return 0, fmt.Errorf("cannot bind parameters for insert into %q: %w", table, err)}var id struct {Val int64 `db:"id"`}err = sqlx.GetContext(ctx, tx, &id, query, args...)if err != nil {return 0, fmt.Errorf("cannot insert into %q: %w", table, err)}return id.Val, nil}
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论