Composite primary keys

[mcraveiro]

Hi sqlgen developers,

I noticed that the documentation for primary keys only mentions a single field [1]. I also did a search in the repo for "composite" and found no matches. Is there a way to declare a primary key made up of several fields by any chance? I just realised last time I had this need, I hacked around and created the composite primary key directly in SQL and now my sqlgen code is not matching the SQL, e.g.:

    primary key (id, valid_from, valid_to),

But

    sqlgen::PrimaryKey<std::string> id;

At any rate, this is not a biggie as I can always do this for new entities but it would be nice to model them correctly.

Many thanks for your time.

[1] sqlgen::PrimaryKey

[liuzicheng1987]

@mcraveiro , yes, that is possible, except for SQLite, which doesn't support that.

[liuzicheng1987]

@mcraveiro just declare several fields a rfl::PrimaryKey.

Maybe we should make that more explicit in the documentation, though, so I will leave the issue open.