Oh boy! I just noticed there's not one mention of ...

# komapper

[dave08]

Oh boy! I just noticed there's not one mention of how to create indexes/unique indexes and foreign keys with komapper's schema creator...! Is this possible?

[Toshihiro Nakamura]

No, it is not possible. However you can use QueryDsl.executeScript.
See the related discussion: https://github.com/komapper/komapper/discussions/602

[dave08]

I guess there's no plan to add that then?

[Toshihiro Nakamura]

Yes, there’s no plan.

[dave08]

And that's how you guys write your tests? Using executeScript? I would maybe consider at least having helper schema functions like QueryDsl.create for indexes, at least one testing against different backends like h2 (for fast tests) and postgresql (for slower, but more production-like tests), will have to write those statements only once...

[dave08]

In a nice dsl form instead of having to figure out the sql needed for each.

[dave08]

And it could use the already existing Meta objects...

[Toshihiro Nakamura]

You can implement your own SchemaStatementBuilder and return it from your dialect:
https://github.com/komapper/komapper/blob/v1.5.0/komapper-dialect-h2/src/main/kotlin/org/komapper/dialect/h2/H2Dialect.kt#L25
The SchemaStatementBuilder instance is called from QueryDsl.create and QueryDsl.drop .

[dave08]

I'm not really sure what to do there... I don't see how I would specify the indexes that need to be made... I was thinking something like QueryDsl.createIndex(...)