FAQ

Here are a list of questions that people have asked about Relate in the past. If you have a question you’d like answered (and maybe put here), please create a Github issue in the repo.

Q: How do I interpolate table names into a query? $tableName makes it a parameter

A: This can be done by using Query Composition:

val tableName = if (good) sql"jedi" else sql"sith"
sql"INSERT INTO $tableName VALUES ..."

Q: I don’t trust you one bit. How do I run the benchmarks?

A: The Relate repo contains the benchmarks we use to make sure we don’t regress when adding features. Just clone the repo, fire up SBT, and run bench:test. You’ll find the reports in target/benchmarks/reports/index.html. The benchmarks were built with Scalameter.

Q: Why can’t I interpolate <insert type here>?

A: Relate only supports interpolation for common types supported by the JVM. However, you can create an implicit function (or implicit class) from the type you’d like to interpolate to a Parameter. For example, to interpolate an org.joda.time.DateTime you could create an implicit def like this:

implicit def fromDateTime(dt: DateTimte): SingleParameter = {
  new TimestampParameter(dt.getMillis)
}

See Parameters.scala for details and examples.