INSERT ... ON DUPLICATE KEY UPDATE

[deividaspetraitis]

Is your feature request related to a problem? Please describe.

I might missed some details in docs but was not able to figure out how to construct INSERT ... ON DUPLICATE KEY UPDATE statement instead of INSERT IGNORE ... ON DUPLICATE KEY UPDATE

For example given example in docs:

        db := goqu.Dialect("mysql")
	insertSQL, args, _ := db.Insert("items").
		Rows(
			goqu.Record{"name": "Test1", "address": "111 Test Addr"},
			goqu.Record{"name": "Test2", "address": "112 Test Addr"},
		).
		OnConflict(goqu.DoUpdate("key", goqu.Record{"updated": goqu.L("NOW()")})).
		ToSQL()
	fmt.Println(insertSQL, args)

Would produce:

INSERT IGNORE INTO `items` (`address`, `name`) VALUES ('111 Test Addr', 'Test1'), ('112 Test Addr', 'Test2') ON DUPLICATE KEY UPDATE `updated`=NOW() []

I am looking for a way to construct:

INSERT INTO `items` (`address`, `name`) VALUES ('111 Test Addr', 'Test1'), ('112 Test Addr', 'Test2') ON DUPLICATE KEY UPDATE `updated`=NOW() []

Describe the solution you'd like

I think an option allowing to choose between INSERT and INSERT IGNORE while constructing statement would solve this problem, for example:

        db := goqu.Dialect("mysql")
	insertSQL, args, _ := db.Insert("items").Ignore(false).
        ...

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Dialect

• postgres
• mysql
• sqlite3

[kirill-lokhmatov]

yes it looks like a bug.

goqu/sqlgen/insert_sql_generator.go

Line 75 in 31d438d

if isg.DialectOptions().SupportsInsertIgnoreSyntax && o != nil {

here ignore is always produced on any conflict. Created a PR #373

[jwendel]

Just wondering, any update on this PR going in? I just stumbled on this as well.

I'm happy to attempt moving this PR to v9 if @doug-martin thinks PR #373 was an OK approach.

[autowp]

Is any updates or workaround with that issue?