我有如下所示的map[string]interface 輸入用戶(hù)user := map[string]interface{}{ "firstname": firstname, "lastname": lastname, "country": country, "email": email, }上面給出的值來(lái)自其他函數(shù)作為變量，因此未在“”中指示。例如，我需要從上面的接口生成如下動(dòng)態(tài)查詢(xún)："INSERT INTO USERTABLE (key1, key2, key3, key4) VALUES (val1, val2, val3, val4) RETURNING id迭代器將在其中計(jì)算鍵和值并生成如下查詢(xún)"INSERT INTO USERTABLE (firstname, lastname, country, email) VALUES (firstname, lastname, country, email) RETURNING userid"希望構(gòu)建一個(gè)動(dòng)態(tài)字符串。
1 回答
HUWWW
TA貢獻(xiàn)1874條經(jīng)驗(yàn) 獲得超12個(gè)贊
純?nèi)??
func prepareInsert(table string, params map[string]interface{}) string {
columns := len(params)
fieldSlice := make([]string, 0, columns)
for field, _ := range params {
fieldSlice = append(fieldSlice, field)
}
fields := strings.Join(fieldSlice, ",")
placeholders := prepareQueryPlaceholders(1, columns)
return fmt.Sprintf(`INSERT INTO %s (%s) VALUES (%s) RETURNING %s`, table, fields, placeholders, fields)
}
func prepareQueryPlaceholders(start, quantity int) string {
placeholders := make([]string, 0, quantity)
end := start + quantity
for i := start; i < end; i++ {
placeholders = append(placeholders, strings.Join([]string{"$", strconv.Itoa(i)}, ""))
}
return strings.Join(placeholders, ",")
}
- 1 回答
- 0 關(guān)注
- 219 瀏覽
添加回答
舉報(bào)
0/150
提交
取消