| 226 | } |
| 227 | |
| 228 | func TestNilPointer(t *testing.T) { |
| 229 | var name *string = nil |
| 230 | eq := Eq{"name": name} |
| 231 | sql, args, err := eq.ToSql() |
| 232 | |
| 233 | assert.NoError(t, err) |
| 234 | assert.Empty(t, args) |
| 235 | assert.Equal(t, "name IS NULL", sql) |
| 236 | |
| 237 | neq := NotEq{"name": name} |
| 238 | sql, args, err = neq.ToSql() |
| 239 | |
| 240 | assert.NoError(t, err) |
| 241 | assert.Empty(t, args) |
| 242 | assert.Equal(t, "name IS NOT NULL", sql) |
| 243 | |
| 244 | var ids *[]int = nil |
| 245 | eq = Eq{"id": ids} |
| 246 | sql, args, err = eq.ToSql() |
| 247 | assert.NoError(t, err) |
| 248 | assert.Empty(t, args) |
| 249 | assert.Equal(t, "id IS NULL", sql) |
| 250 | |
| 251 | neq = NotEq{"id": ids} |
| 252 | sql, args, err = neq.ToSql() |
| 253 | assert.NoError(t, err) |
| 254 | assert.Empty(t, args) |
| 255 | assert.Equal(t, "id IS NOT NULL", sql) |
| 256 | |
| 257 | var ida *[3]int = nil |
| 258 | eq = Eq{"id": ida} |
| 259 | sql, args, err = eq.ToSql() |
| 260 | assert.NoError(t, err) |
| 261 | assert.Empty(t, args) |
| 262 | assert.Equal(t, "id IS NULL", sql) |
| 263 | |
| 264 | neq = NotEq{"id": ida} |
| 265 | sql, args, err = neq.ToSql() |
| 266 | assert.NoError(t, err) |
| 267 | assert.Empty(t, args) |
| 268 | assert.Equal(t, "id IS NOT NULL", sql) |
| 269 | |
| 270 | } |
| 271 | |
| 272 | func TestNotNilPointer(t *testing.T) { |
| 273 | c := "Name" |