Few days ago, I had a scenario, in which I had to insert scala collection into postgreSQL using Slick. My postgreSQL table has some columns with data types such as Arrays, hstore etc..
I tried to do this using slick, but didn’t get success. After beating my head whole day, I found a solution.
I found a slick extension slick-pg, which supports following postgreSQL types:-
- ARRAY
- Date/Time
- Enum
- Range
- Hstore
- LTree
- JSON
- Inet/MacAddr
text
Searchpostgis
Geometry
In this blog, I have explained how to insert Scala collection into PostgreSQL using Slick through an example. In this example, there is a student table, which has 4 columns
Here hobbies is Array of String and marks is hstore(Set of key-value pair).
As suggested here https://github.com/tminglei/slick-pg , I created a trait MyPostgresDriver and integrated with PostgresDriver like this:-
Then I mapped my table like this:-
After running command sbt run, I was able to store data in postgres.
For complete example, please go here https://gist.github.com/ayushmishra2005/d382801e0cb2d0df9e7c
Reblogged this on himanshu2014.
Good..
Reblogged this on Dinesh Ram Kali..
Reblogged this on Play!ng with Scala and commented:
Easiest Way To Insert Scala Collection into PostgreSQL using Slick