postgres

var (
	ThingTable = postgres.Generate(postgres.Table[gorestapi.Thing]{
		Table: `"thing"`,
		Fields: []*postgres.Field[gorestapi.Thing]{
			{Name: "id", ID: true, Insert: "$#", Value: func(rec *gorestapi.Thing) (driver.Value, error) { return rec.ID, nil }},
			{Name: "created", Insert: "NOW()", NullVal: "0001-01-01 00:00:00 UTC"},
			{Name: "updated", Insert: "NOW()", Update: "NOW()", NullVal: "0001-01-01 00:00:00 UTC"},
			{Name: "name", Insert: "$#", Update: "$#", Value: func(rec *gorestapi.Thing) (driver.Value, error) { return rec.Name, nil }},
			{Name: "description", Insert: "$#", Update: "$#", Value: func(rec *gorestapi.Thing) (driver.Value, error) { return rec.Description, nil }},
		},
		Selector: postgres.Selector[gorestapi.Thing]{
			FilterFieldTypes: queryp.FilterFieldTypes{
				"thing.id":          queryp.FilterTypeSimple,
				"thing.created":     queryp.FilterTypeTime,
				"thing.updated":     queryp.FilterTypeTime,
				"thing.name":        queryp.FilterTypeString,
				"thing.description": queryp.FilterTypeString,
			},
			SortFields: queryp.SortFields{
				"thing.id":          "",
				"thing.created":     "",
				"thing.updated":     "",
				"thing.name":        "",
				"thing.description": "",
			},
			DefaultSort: queryp.Sort{
				&queryp.SortTerm{Field: "thing.name", Desc: false},
			},
		},
	})
)

var (
	WidgetTable = postgres.Generate(postgres.Table[gorestapi.Widget]{
		Table: `"widget"`,
		Fields: []*postgres.Field[gorestapi.Widget]{
			{Name: "id", ID: true, Insert: "$#", Value: func(rec *gorestapi.Widget) (driver.Value, error) { return rec.ID, nil }},
			{Name: "created", Insert: "NOW()", NullVal: "0001-01-01 00:00:00 UTC"},
			{Name: "updated", Insert: "NOW()", Update: "NOW()", NullVal: "0001-01-01 00:00:00 UTC"},
			{Name: "name", Insert: "$#", Update: "$#", Value: func(rec *gorestapi.Widget) (driver.Value, error) { return rec.Name, nil }},
			{Name: "description", Insert: "$#", Update: "$#", Value: func(rec *gorestapi.Widget) (driver.Value, error) { return rec.Description, nil }},
			{Name: "thing_id", Insert: "$#", Update: "$#", Value: func(rec *gorestapi.Widget) (driver.Value, error) { return rec.ThingID, nil }},
		},
		Joins: `
		LEFT JOIN thing ON widget.thing_id = thing.id
		`,
		Selector: postgres.Selector[gorestapi.Widget]{
			FilterFieldTypes: queryp.FilterFieldTypes{
				"widget.id":          queryp.FilterTypeSimple,
				"widget.created":     queryp.FilterTypeTime,
				"widget.updated":     queryp.FilterTypeTime,
				"widget.name":        queryp.FilterTypeString,
				"widget.description": queryp.FilterTypeString,
				"thing.name":         queryp.FilterTypeString,
				"thing.description":  queryp.FilterTypeString,
			},
			SortFields: queryp.SortFields{
				"widget.id":          "",
				"widget.created":     "",
				"widget.updated":     "",
				"widget.name":        "",
				"widget.description": "",
				"thing.name":         "",
				"thing.description":  "",
			},
			DefaultSort: queryp.Sort{
				&queryp.SortTerm{Field: "thing.name", Desc: false},
			},
			PostProcessRecord: func(rec *gorestapi.Widget) error {
				if rec.ThingID == nil || *rec.ThingID == "" {
					rec.Thing = nil
				}
				return nil
			},
		},
		PostProcessRecord: func(rec *gorestapi.Widget) error {
			if rec.ThingID == nil || *rec.ThingID == "" {
				rec.Thing = nil
			}
			return nil
		},
		SelectAdditionalFields: ThingTable.GenerateAdditionalFields(true),
	})
)