Array in INSERT query

[Pavel Naydenov]

Hello!
How can I use arrays with autosession? I found approach like this: https://github.com/nlinker/scalike-pg-arrays/blob/master/src/main/scala/nick/Foo.scala#L71 but it don't use JDBC array support:

  def create(name: String, barz: List[Int])(implicit session: DBSession = autoSession): Foo = {
    val generatedKey =
      sql"""
      INSERT INTO ${Foo.table} (
        ${column.name}
      , ${column.barz}
      ) VALUES (
        ${name}
      , ARRAY[${barz}]
      )
      """.updateAndReturnGeneratedKey.apply()
    Foo( id = generatedKey, name = name, barz = barz)
}

In pure JDBC I can create java.sql.Array using Connection object. But I don't know how can I do it using auto session in scalikejdbc

[Kaz Sera]

Hi Pavel,

Consider using ParameterBinder. That should work for your case.

http://scalikejdbc.org/documentation/operations.html#using-parameterbinder

-Kaz

2017年3月7日火曜日 15時16分04秒 UTC+9 Pavel Naydenov:

[Pavel Naydenov]

Hi Kaz, thanks for your answer!

Using ParameterBinder I can get access only to the PreparedStatement. But I think that I have to get access to the connection (I mean java.sql.Connection). As I know I can create instance of java.sql.Array using connection (using Connection#createArrayOf method).

[Fares]

Hey,

connection is a variable in the DBSession trait. You can access it like this (assuming you still have your implicit session in scope):

session.connection.createArrayOf