Array support?

[waywardmonkeys]

I'm not sure what the best way to do this, but to work with arrays in Postgres, we need access to the connection object to call a method on it:

val sqlArray = connection.createArrayOf("uuid", products.toArray.asInstanceOf[Array[AnyRef]])

When products was an Iterable...

It'd be nice if this could be folded into prepare in Utils.scala somehow, but not sure how given the type name parameter...

Thoughts?

[lambdaknight]

Not a thought, per se, but I tried hacking on this briefly this morning. I tried changing the "prepare" method to:

@tailrec
private[jdub] def prepare(stmt: PreparedStatement, values: Seq[Any], index: Int = 1) {
  if (!values.isEmpty) {
    val v = values.head
    if (v == null) {
      stmt.setNull(index, Types.NULL)
    } else if(v.isInstanceOf[Array[_]]) {
      stmt.setObject(index, v.asInstanceOf[AnyRef], Types.ARRAY)
    } else {
      stmt.setObject(index, v.asInstanceOf[AnyRef])
    }
    prepare(stmt, values.tail, index + 1)
  }
}

Unfortunately, when I tried using this with the "org.postgresql.Driver" driver, I got:

org.postgresql.util.PSQLException: Cannot cast an instance of [I to type Types.ARRAY
    at org.postgresql.jdbc2.AbstractJdbc2Statement.setObject(AbstractJdbc2Statement.java:1736)
    at org.postgresql.jdbc3.AbstractJdbc3Statement.setObject(AbstractJdbc3Statement.java:1483)
    at org.postgresql.jdbc3g.AbstractJdbc3gStatement.setObject(AbstractJdbc3gStatement.java:47)
    at org.postgresql.jdbc4.AbstractJdbc4Statement.setObject(AbstractJdbc4Statement.java:69)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.setObject(AbstractJdbc2Statement.java:1751)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:166)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:166)
    at com.codahale.jdub.Utils$.prepare(Utils.scala:17)
    at com.codahale.jdub.Database$$anonfun$execute$1.apply$mcI$sp(Database.scala:145)
    at com.codahale.jdub.Database$$anonfun$execute$1.apply(Database.scala:139)
    at com.codahale.jdub.Database$$anonfun$execute$1.apply(Database.scala:139)
    at com.yammer.metrics.Timer.time(Timer.scala:20)
    at com.codahale.jdub.Database.execute(Database.scala:138)
    at .<init>(<console>:12)
    at .<clinit>(<console>)
    at .<init>(<console>:11)
    at .<clinit>(<console>)
    at $export(<console>)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at scala.tools.nsc.interpreter.IMain$ReadEvalPrint.call(IMain.scala:592)
    at scala.tools.nsc.interpreter.IMain$Request$$anonfun$10.apply(IMain.scala:828)
    at scala.tools.nsc.interpreter.Line$$anonfun$1.apply$mcV$sp(Line.scala:43)
    at scala.tools.nsc.io.package$$anon$2.run(package.scala:31)
    at java.lang.Thread.run(Thread.java:680)

Unfortunately, I'm not seeing a way to get an Array in there easily (using only a PreparedStatement).