Function TestNewTwoColumnRangeMeta

go/sql/builder_test.go:605–642

(t *testing.T)

}

func TestNewTwoColumnRangeMeta(t *testing.T) {
	{
		// No enum columns → plain "col asc" / "col desc" ORDER BY clauses.
		uniqueKeyColumns := NewColumnList([]string{"name", "position"})
		m := newTwoColumnRangeMeta(uniqueKeyColumns)
		require.Equal(t, "`name`", m.col1Name)
		require.Equal(t, "`position`", m.col2Name)
		require.Equal(t, "?", m.col1Val)
		require.Equal(t, "?", m.col2Val)
		require.Equal(t, "`name` asc, `position` asc", m.orderByAsc)
		require.Equal(t, "`name` desc, `position` desc", m.orderByDesc)
	}
	{
		// Enum on first column only.
		uniqueKeyColumns := NewColumnList([]string{"name", "position"})
		uniqueKeyColumns.SetColumnType("name", EnumColumnType)
		m := newTwoColumnRangeMeta(uniqueKeyColumns)
		require.Equal(t, "concat(`name`) asc, `position` asc", m.orderByAsc)
		require.Equal(t, "concat(`name`) desc, `position` desc", m.orderByDesc)
	}
	{
		// Enum on second column only.
		uniqueKeyColumns := NewColumnList([]string{"name", "position"})
		uniqueKeyColumns.SetColumnType("position", EnumColumnType)
		m := newTwoColumnRangeMeta(uniqueKeyColumns)
		require.Equal(t, "`name` asc, concat(`position`) asc", m.orderByAsc)
		require.Equal(t, "`name` desc, concat(`position`) desc", m.orderByDesc)
	}
	{
		// Enum on both columns.
		uniqueKeyColumns := NewColumnList([]string{"name", "position"})
		uniqueKeyColumns.SetColumnType("name", EnumColumnType)
		uniqueKeyColumns.SetColumnType("position", EnumColumnType)
		m := newTwoColumnRangeMeta(uniqueKeyColumns)
		require.Equal(t, "concat(`name`) asc, concat(`position`) asc", m.orderByAsc)
		require.Equal(t, "concat(`name`) desc, concat(`position`) desc", m.orderByDesc)
	}
}

func TestBuildTwoColumnUnionParts(t *testing.T) {
	rangeStartArgs := []interface{}{3, 17}