implicit val componentKindsMapping: SlickDriver.SimpleArrayJdbcType[ComponentKind] =
new SimpleArrayJdbcType[String]("text").mapTo[ComponentKind](ComponentKind(_), _.name)
bars.identifiers is of type text[], and column foos.identifier is type varchar(254).
I'm trying to upgrade my project to slick 3.3.0, so I set slick-pg to 0.17.2 but unfortunately in slick-pg 0.17.1 a few deps including json4s were upgraded to latest version. Alas json4s 3.6.x versions have a longstanding bug for case classes with type constructors (json4s/json4s#507). My project also dependes on json4s and thus breaks when upgrading. Is there anyway this dependency hell can be circumvented?
`import com.github.tminglei.slickpg._
trait MyPostgresDriver
extends ExPostgresProfile
with PgArraySupport
with PgDateSupportJoda
with PgEnumSupport
with PgRangeSupport
with PgHStoreSupport
with PgSearchSupport
with PgPostGISSupport {
override val api = new MyAPI {}
trait MyAPI
extends API
with ArrayImplicits
with DateTimeImplicits
with RangeImplicits
with HStoreImplicits
with SearchImplicits
with PostGISImplicits
with SearchAssistants
}
object MyPostgresDriver extends MyPostgresDriver`
Bascially none of the PG types here are found.
org.postgresql.util.PSQLException: ERROR: function st_dwithin(point, bytea, double precision) does not exist
[info] Hint: No function matches the given name and argument types. You might need to add explicit type casts.
[info] Position: 140
def byDistance(point: Point, distance: Double): Future[Seq[House]] =
db run {
houses
.filter(r => r.location.dWithin(point.bind, distance.bind))
.result
.map(t => t)
}
due to: org.postgresql.util.PSQLException: ERROR: column "location" is of type point but expression is of type bytea
[info] Hint: You will need to rewrite or cast the expression.
[info] Position: 157
def distance[P2, R](geom: Rep[P2])(implicit om: o#to[Float, R]) = {
om.column(GeomLibrary.Distance, n, geom.toNode)
}
Rather than repeating myself here, I'll post my https://twitter.com/heyrutvik/status/1182521309991002112 which describes the problem of using
<-> with hyphened string in to_tsquery function.Please take a look, thanks!
drop table if exists orders cascade;
CREATE TABLE orders (
ID serial NOT NULL PRIMARY KEY,
info json NOT NULL
);
INSERT INTO orders (info)
VALUES
('{"interestedIn":[11],"countries":["IT", "UK"]}'),
('{"interestedIn":[12],"countries":["US", "UK"]}'),
('{"interestedIn":[1,2,3],"countries":["UK"]}'),
('{"interestedIn":[14,15,16],"countries":["DE", "UK"]}');
select *
from orders
where info::jsonb -> 'countries' ? 'US'
;
Hi All, we're trying to get upserts working with slick. Trying to use slick-pg to enable this, but we can't find how to access the new methods. We created our own profile that extends ExPostgresProfile, and it looks like it's configured OK in application.conf. We replaced import profile.api._ with import MySlickPostgresProfile.api._
However, our methods that use testtable.insertOrUpdate still seems to use the old version, and .insertOrUpdateAll isn't found. Is there some weird implicit scala thing we need to do?
Option[scala.collection.Seq] which is a type-constructor and not a type, hence the compilation fails
Option[List[String]] - which seems consistent with array columns declaration for slick-pg, as of https://github.com/tminglei/slick-pg#configurable-typemappers - then the generated code comes as expected, but the compiler hangs in some non-terminating loop when trying to compile the project