Skip to main content

Customize column types

Note that use of this feature is in general discouraged, see warning in user-selected type.

If you're not happy with the types PostgreSQL and Typo has ended up with for a given column, you can override it.

This is referred to within Typo as a user-selected type.

import typo.{Options, TypeOverride}

val rewriteColumnTypes = TypeOverride.relation {
  case ("schema.table", "column") => "org.foo.ColumnId"
}

Options(
  pkg = "org.foo",
  dbLib = None,
  typeOverride = rewriteColumnTypes
)

More structured version​

The version above is "simplified", in that is takes a descriptive type and explodes it into strings. You may prefer the version below which is more cumbersome but more structured:

import typo.db.RelationName

val rewriteMore = TypeOverride.of { 
  case (RelationName(Some(schema), tableName), colName) if schema.contains("foo") && colName.value.startsWith("foo") => "org.foo.Bar" 
}

Composing multiple column overrides:​

rewriteColumnTypes.orElse(rewriteMore)