| 187 | } |
| 188 | |
| 189 | func TestNullTypeString(t *testing.T) { |
| 190 | var b Sqlizer |
| 191 | var name sql.NullString |
| 192 | |
| 193 | b = Eq{"name": name} |
| 194 | sql, args, err := b.ToSql() |
| 195 | |
| 196 | assert.NoError(t, err) |
| 197 | assert.Empty(t, args) |
| 198 | assert.Equal(t, "name IS NULL", sql) |
| 199 | |
| 200 | name.Scan("Name") |
| 201 | b = Eq{"name": name} |
| 202 | sql, args, err = b.ToSql() |
| 203 | |
| 204 | assert.NoError(t, err) |
| 205 | assert.Equal(t, []interface{}{"Name"}, args) |
| 206 | assert.Equal(t, "name = ?", sql) |
| 207 | } |
| 208 | |
| 209 | func TestNullTypeInt64(t *testing.T) { |
| 210 | var userID sql.NullInt64 |