dounuo1881 2019-01-17 07:51
浏览 175

“ gorm:query_option”在行方法中不起作用

In my case, I need to use "For Update" query in a transaction. But when I use "Rows" method,"gorm:query_option" just does not work.

When I use "First" or "Find" method, "gorm:query_option" works very well,but it does not work in Rows method at all.

tx.Model(&model)
.Where("id=?",1622888221580295)
.Set("gorm:query_option","For Update")
.First(&model);

output is : SELECT * FROM 'table_name' WHERE (id='1622888221580295') ORDER BY 'adv_convert'.'id' ASC LIMIT 1 FOR UPDATE

rows,err := tx.Model(&model).Where("id=?",1622888221580295).Set("gorm:query_option","For Update").Rows();

output: SELECT * FROM 'table_name' WHERE (id='1622888221580295')

How can I query a "For Update" query with Rows method

  • 写回答

0条回答 默认 最新

    报告相同问题?