Function TestDelete

internal/sqlbuilder/builder_test.go:1460–1480

(t *testing.T)

}

func TestDelete(t *testing.T) {
	bt := WithTemplate(&testTemplate)
	assert := assert.New(t)

	assert.Equal(
		`DELETE FROM "artist" WHERE (name = $1)`,
		bt.DeleteFrom("artist").Where("name = ?", "Chavela Vargas").String(),
	)

	assert.Equal(
		`DELETE FROM "artist" WHERE (name = $1) RETURNING 1`,
		bt.DeleteFrom("artist").Where("name = ?", "Chavela Vargas").Amend(func(query string) string {
			return fmt.Sprintf("%s RETURNING 1", query)
		}).String(),
	)

	assert.Equal(
		`DELETE FROM "artist" WHERE (id > 5)`,
		bt.DeleteFrom("artist").Where("id > 5").String(),
	)
}

func TestPaginate(t *testing.T) {
	b := &sqlBuilder{t: newTemplateWithUtils(&testTemplate)}