當用戶不輸入字段 var 時返回默認值（notes ='this will be default'）qapi := `UPDATE custom_param SET param_value = $1, start_date = $2, end_date = $3, status = $4 `enter code here` WHERE param_name = 'default-password'RETURNING param_value, start_date, end_date, status, notes; `// insrt into master_paramsqlError := tx.QueryRowContext(ctx, qapi, request.Value, request.StartDate, request.EndDate, request.Status, request.Notes).Scan( &value, &startDate, &endDate, &status, ¬es,)queryInsertNotes := `insert `if request.Notes != "" { notes = request.Notes}if sqlError != nil { log.Println("SQL Error on ReadApplication on UpdateScheduleMaintenance", sqlError) tx.Rollback() return schedule, sqlError}err = tx.Commit()if err != nil { tx.Rollback() return schedule, err}當用戶不輸入任何注釋時返回默認注釋
1 回答
叮當貓咪
TA貢獻1776條經驗 獲得超12個贊
我認為你需要這樣的東西，沒有測試過代碼，但你明白了。
notes := "this will be default"
if request.Notes != "" {
notes = request.Notes
}
qapi := `
UPDATE custom_param SET param_value = $1, start_date = $2, end_date = $3, status = $4, notes = $4 WHERE param_name = 'default-password'
RETURNING param_value, start_date, end_date, status, notes;
`
// insrt into master_param
sqlError := tx.QueryRowContext(ctx, qapi, request.Value, request.StartDate, request.EndDate, request.Status, notes).Scan(
&value,
&startDate,
&endDate,
&status,
¬es,
)
if sqlError != nil {
log.Println("SQL Error on ReadApplication on UpdateScheduleMaintenance", sqlError)
tx.Rollback()
return schedule, sqlError
}
err = tx.Commit()
if err != nil {
tx.Rollback()
return schedule, err
}
- 1 回答
- 0 關注
- 128 瀏覽
添加回答
舉報
0/150
提交
取消