nafg/slick-additions

Helpers for Scala Slick (slick.typesafe.com)

nafg

@nafg

http://slick.typesafe.com/doc/3.0.0/api/index.html#slick.backend.DatabaseConfig$

You see that forConfig[P] returns a DatabaseConfig[P],

and on http://slick.typesafe.com/doc/3.0.0/api/index.html#slick.backend.DatabaseConfig,

you can see that DatabaseConfig[P]#driver: P

that is, the val driver of a DatabaseConfig[P] has type P

Which is the type parameter to forConfig

Peter Hancox

@phancox

So can I do DatabaseConfig.forConfig[JdbcProfile with KeyedTableComponent](config) or something to that effect?

nafg

@nafg

Sounds good to me

And indeed it seems it does choose the driver at run time

if you use that API

Personally I usually do it like this:

Peter Hancox

@phancox

Thought that was going to work but doesn't seem to

nafg

@nafg

trait Abstract {
  val driver: JdbcProfile with KeyedTableComponent
  val db: driver.Database
}
object Concrete extends Abstract {
  object driver extends PostgresDriver with KeyedTableComponent
  import driver.api._
  val db = Database.forConfig ...
}

What issue are you getting?

Peter Hancox

@phancox

The forConfig statement seems fine with that change. But EntityTable etc are no longer defined in the trait that references the driver

nafg

@nafg

Can you show in a scastie?

Also it's in driver.api._

Peter Hancox

@phancox

What I can't do with the code you just showed me is select a different database such as H2 in the config file

nafg

@nafg

yeah my code made that mistake, let me edit

@phancox right, I usually do it at compile time, not runtime. That's the distinction

Peter Hancox

@phancox

I won't waste any more of your time then. Just wanted to make sure that I hadn't missed the obvious.

If you haven't used this code with dynamic database selection before, then I'll try and make it work myself.

nafg

@nafg

@phancox if you show me a scastie with DatabaseConfig.forConfig not working, maybe I can help

Peter Hancox

@phancox

Not that proficient with the scastie given I'm scattered across multiple modules. Thhis one shoes the module where I do the database setup http://scastie.org/11255

I'll amend it for the change we just discussed and try and add the entity class in

nafg

@nafg

First of all, change the dependency to slick-additions

0.4.0-RC2 should work

Peter Hancox

@phancox

http://scastie.org/11261 sorry didn't know the package name

Peter Hancox

@phancox

Any ideas?

nafg

@nafg

http://scastie.org/11262 fixes the organization name

Oh I have to add the resolver

it's on bintray (jcenter)

http://scastie.org/11263

Peter Hancox

@phancox

Guess it needs imports? In my code I've just copied your two scala files into my package

nafg

@nafg

Need an import

http://scastie.org/11263

Compiles fine

ouch ;)

For the same price you could have looked up the organization setting in build.sbt...

Peter Hancox

@phancox

Looks good, thanks.

My problem wasn't the imports but I think I might have screwed up the val profile

My actual code is a bit more complicated, you have the simplified version.

One more thing ....

In my test code, inserts appear to be happening twice. noticed it when the unique index was violated.

However, this doesn't seem to be happening when I run your test case. So just wondering if you've seen something similar before?

Peter Hancox

@phancox

This was my problem:
val profile = if (dbmsName == "PostgreSQL") PostgresDriver else dc.driver
I override the driver for PostgreSQL to drop the identifier quotes. This is why making the change to forConfig[....] threw errors in my code here. I'll still have to take care of this issue but should be much simpler.

nafg

@nafg

so instead of PostgresDriver use MyPostgresDriver where

object MyPostgresDriver extends PostgresDriver with KeyedTableComponent

then the LUB will include KeyedTableComponent

Where communities thrive

People

Repo info

Activity