Function TestBuildDMLInsertQuery

go/sql/builder_test.go:847–894

(t *testing.T)

}

func TestBuildDMLInsertQuery(t *testing.T) {
	databaseName := "mydb"
	tableName := "tbl"
	tableColumns := NewColumnList([]string{"id", "name", "rank", "position", "age"})
	args := []interface{}{3, "testname", "first", 17, 23}
	{
		sharedColumns := NewColumnList([]string{"id", "name", "position", "age"})
		builder, err := NewDMLInsertQueryBuilder(databaseName, tableName, tableColumns, sharedColumns, sharedColumns)
		require.NoError(t, err)
		query, sharedArgs, err := builder.BuildQuery(args)
		require.NoError(t, err)
		expected := `
			insert /* gh-ost mydb.tbl */ ignore
				into mydb.tbl
					(id, name, position, age)
				values
					(?, ?, ?, ?)
		`
		require.Equal(t, normalizeQuery(expected), normalizeQuery(query))
		require.Equal(t, []interface{}{3, "testname", 17, 23}, sharedArgs)
	}
	{
		sharedColumns := NewColumnList([]string{"position", "name", "age", "id"})
		builder, err := NewDMLInsertQueryBuilder(databaseName, tableName, tableColumns, sharedColumns, sharedColumns)
		require.NoError(t, err)
		query, sharedArgs, err := builder.BuildQuery(args)
		require.NoError(t, err)
		expected := `
			insert /* gh-ost mydb.tbl */ ignore
				into mydb.tbl
					(position, name, age, id)
				values
					(?, ?, ?, ?)
		`
		require.Equal(t, normalizeQuery(expected), normalizeQuery(query))
		require.Equal(t, []interface{}{17, "testname", 23, 3}, sharedArgs)
	}
	{
		sharedColumns := NewColumnList([]string{"position", "name", "surprise", "id"})
		_, err := NewDMLInsertQueryBuilder(databaseName, tableName, tableColumns, sharedColumns, sharedColumns)
		require.Error(t, err)
	}
	{
		sharedColumns := NewColumnList([]string{})
		_, err := NewDMLInsertQueryBuilder(databaseName, tableName, tableColumns, sharedColumns, sharedColumns)
		require.Error(t, err)
	}
}

func TestBuildDMLInsertQuerySignedUnsigned(t *testing.T) {
	databaseName := "mydb"