dqpfkzu360216 2019-02-28 12:08
浏览 163
已采纳

将数组类型的DB字段扫描到Golang中的数组/切片中

tl; dr

I have an sql table users which includes an array field. How can I Scan it to variable in golang? My approach:

var id        int
var username  string
var activites []string
row := db.QueryRow("SELECT id, username, activities FROM users WHERE id = 1")
err := row.Scan(&id, &username, &activites)

Works fine for id, username.

  • 写回答

1条回答 默认 最新

  • dspows0637 2019-02-28 17:29
    关注

    As @mkopriva already pointed out, this can either be accomplished using the StringArray method or with the more flexible Array method (as it accepts an interface as the argument), both found within the "github.com/lib/pq" package.

    As an aside, it is also a good practice to use prepared statements.

    Full example:

    var id int
    var username string
    var activities []string
    
    sqlStatement := `
        SELECT
            id,
            username, 
            activities 
        FROM 
            users 
        WHERE 
            id = $1
    `
    
    stmt, err := db.Prepare(sqlStatement)
    if err != nil {
        // handle err
    }
    
    defer stmt.Close()
    
    row := stmt.QueryRow(1)
    
    err = row.Scan(
        &id,
        &username,
        pq.Array(&activities) // used here
    )
    
    if err == sql.ErrNoRows {
        // handle err
    }
    
    if err != nil {
        // handle err
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 DSP28335AD采集实验
  • ¥15 在winods上用C# 怎么编写CAN通信在linux运行
  • ¥15 关于螺旋焊缝的图像处理
  • ¥15 qt 散点图自定义图形
  • ¥100 将USDZ文件转化为带颜色的OBJ文件
  • ¥15 对象代号: , 表单: 不存在!
  • ¥15 WebSocket的问题
  • ¥15 centos上启动kylin后网页报错404
  • ¥20 使用hackrf进行信号收发时接收到的信号幅度太小
  • ¥15 WebSocket的问题