Function TestDoInsert

contrib/drivers/mssql/mssql_z_unit_basic_test.go:117–155

(t *testing.T)

}

func TestDoInsert(t *testing.T) {
	gtest.C(t, func(t *gtest.T) {
		createTable("t_user")
		defer dropTable("t_user")

		i := 10
		data := g.Map{
			"id":          i,
			"passport":    fmt.Sprintf(`t%d`, i),
			"password":    fmt.Sprintf(`p%d`, i),
			"nickname":    fmt.Sprintf(`T%d`, i),
			"create_time": gtime.Now(),
		}
		_, err := db.Insert(context.Background(), "t_user", data)
		gtest.AssertNil(err)

	})

	gtest.C(t, func(t *gtest.T) {
		createTable("t_user")
		defer dropTable("t_user")

		i := 10
		data := g.Map{
			// "id":          i,
			"passport":    fmt.Sprintf(`t%d`, i),
			"password":    fmt.Sprintf(`p%d`, i),
			"nickname":    fmt.Sprintf(`T%d`, i),
			"create_time": gtime.Now(),
		}
		// Save without OnConflict should fail (missing conflict columns)
		_, err := db.Save(context.Background(), "t_user", data, 10)
		gtest.AssertNE(err, nil)

		// Replace should fail because primary key 'id' is not in the data
		_, err = db.Replace(context.Background(), "t_user", data, 10)
		gtest.AssertNE(err, nil)
	})
}

func TestDoInsertGetId(t *testing.T) {
	// create test table