search

slick / slick-examples

A sample project for getting started with Slick
https://scala-slick.org/
156 stars 70 forks source link

Foreign key for MultiDBCake example #22

Open suriyanto opened 10 years ago

suriyanto commented 10 years ago

I followed the MultiDBCake example to be able to get different databases used between testing and production. In the table definition, I would like to set foreign key between Users and Pictures, which should be similar to below.

def pictureKey = foreignKey("FK_USERPICTURE", pictureId, PictureComponent.Pictures)(.id.get)

However due to the fact that the Pictures object is inside PictureComponent trait, there is no way for me to reference PictureComponent.Pictures. What will be your suggestion on adjusting this example to be able to achieve this?

Thanks, Suriyanto

pussinboots commented 10 years ago

Hello suriyanto,

with the actual code it should work. The import line is trait UserComponent { this: Profile with PictureComponent . With the code with PictureComponent you are able to access slick definition of Pictures.