foreign key types in !table are not supported by codegen transforms

[ghost]

sysl:

PoOrder:
    !table Assessment:
        assessmentId <: int:
            @label = "Assessment ID"
    !table AssessmentNote:
        assessmentId <: Assessment.assessmentId:
            @label = "Assessment ID"

attempting to run this through the sysl codegen will error out on the Assessment.assessmentId "type".

[tiagralee]

Hi @anz-gordonj7 , the : after the type doesn't look right to me,
I found a reference example as below, you can also try add a [~pk] after the primary key
https://github.com/anz-bank/sysl/blob/master/demo/petshop/petshop.sysl
let me know if this helps.

PoOrder:
    !table Assessment:
        assessmentId <: int [~pk]
            @label = "Assessment ID"
    !table AssessmentNote:
        assessmentId <: Assessment.assessmentId
            @label = "Assessment ID"

[ghost]

@tiagralee hi, no the sysl is perfectl valid, codegen fails though, try to run it like "sysl gen --root . --root-transform . --transform transforms/svc_types.sysl --grammar grammars/go.gen.g --start goFile "

I think petshop.sysl has the same problem actually

[tiagralee]

@anz-gordonj7 Thanks for clarify, I'll take a look.

[tiagralee]

Hi @anz-gordonj7 , do we want codegen to support data models in !table? got two approach to solve this.

1. bypass !table when codegen for types (if we don't need data models to be generated)
2. make the type transform support cross referencing across types

[ghost]

We need the go code to generate the types correctly, for that I guess it just means we need the foreign key field to just generate as an int, we dont need the automatic linking (we just need types, not a database)

[tiagralee]

Thanks @anz-gordonj7 , got it.

[anzdaddy]

There is an existing implementation of relation model codegen for Go on an unmerged branch: https://github.com/anz-bank/sysl/tree/anzdaddy/relgom