How to deal with nullable fields?

[fairking]

Sorry, searched docs, nothing around this topic. All examples and documentation has no nullable/optional fields.

So the question is how to use migrations with nullable columns (how to describe nullable columns) and how to define them as entity fields (optional fields).

type Todo struct {
    ID   int
    Active bool // ???
}

schema.CreateTable("todos", func(t *rel.Table) {
        t.ID("id")
        t.Bool("active") // ???
    })

[Fs02]

you can use rel.Required(false)

https://github.com/go-rel/sql/blob/be5e6ac51f8646ac1d56968ff7bf91c764ff46c5/specs/migration.go#L22

[fairking]

I don't understand. Your example shows required('true'). What sense does it make? I have the same result without required("true").

[fairking]

So you are assuming the default is required('false'). Then how can I handle null in go having such situation?

[Fs02]

So you are assuming the default is required('false').

yes, it's the default

Then how can I handle null in go having such situation?

you can just use pointer, example:

type Todo struct {
    ID   int
    Active *bool // <= use pointer
}