Function TestBuildUniqueKeyMinValuesPreparedQuery

go/sql/builder_test.go:705–738

(t *testing.T)

}

func TestBuildUniqueKeyMinValuesPreparedQuery(t *testing.T) {
	databaseName := "mydb"
	originalTableName := "tbl"
	uniqueKeyColumns := NewColumnList([]string{"name", "position"})
	uniqueKey := &UniqueKey{Name: "PRIMARY", Columns: *uniqueKeyColumns}
	{
		query, err := BuildUniqueKeyMinValuesPreparedQuery(databaseName, originalTableName, uniqueKey)
		require.NoError(t, err)
		expected := `
			select /* gh-ost mydb.tbl */ name, position
			  from
			    mydb.tbl
			  force index (PRIMARY)
			  order by
			    name asc, position asc
			  limit 1
		`
		require.Equal(t, normalizeQuery(expected), normalizeQuery(query))
	}
	{
		query, err := BuildUniqueKeyMaxValuesPreparedQuery(databaseName, originalTableName, uniqueKey)
		require.NoError(t, err)
		expected := `
			select /* gh-ost mydb.tbl */ name, position
			  from
			    mydb.tbl
			  force index (PRIMARY)
			  order by
			    name desc, position desc
			  limit 1
		`
		require.Equal(t, normalizeQuery(expected), normalizeQuery(query))
	}
}

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