Feature: Insert-IF-NOT-EXIST #1521

New Issue

6543 · 2020-02-18T22:01:40Z

6543 commented

2020-02-18 22:01:40 +00:00

an insert function witch only insert if entry not exist

sqlite: fmt.Sprintf("INSERT INTO issue_watch(user_id,issue_id,mode) SELECT %d,%d,%d WHERE NOT EXISTS(SELECT 1 FROM issue_watch WHERE user_id = %d AND issue_id = %d);", userID, issueID, mode, userID, issueID)

why not: xorm.InsertUniqe(obj,condition)

an insert function witch only insert if entry not exist sqlite: `fmt.Sprintf("INSERT INTO issue_watch(user_id,issue_id,mode) SELECT %d,%d,%d WHERE NOT EXISTS(SELECT 1 FROM issue_watch WHERE user_id = %d AND issue_id = %d);", userID, issueID, mode, userID, issueID)` why not: `xorm.InsertUniqe(obj,condition)`

lunny commented

2020-02-19 00:02:31 +00:00

Maybe you mean InsertSelect? I think it has been implemented.

Maybe you mean `InsertSelect`? I think it has been implemented.

6543 commented

2020-02-19 03:04:05 +00:00