wsql

TODO support camel and underscore name mapping like doSomething <-> do_something

currently, only classes supprt, dont support object yet. mapping a column name to a field name. such as field: userName, column: user_name

for values(of type T) to passed into Statement or passed out from ResultSet, it should has a contxt bound of JdbcValueAccessor[T]

package wangzx.scala_commons.sql prdefined a lot of pre-defined implementation for the jdbc value types:

• boolean, byte, short, Int, Long, Float, Double, BigDecimal, scala.BigDecimal

• String

• Date, Time, Timestamp

• Blob, Clob, byte[]

• Option[T] if T has JdbcValueAccessor context bounded

developer can define your's value type such as a MyDate which stored as database Date, you need only define an implicit value of JdbcValueAccessor[MyDate], then you can:

• pass in statement using sql"... where date_field = $myDate"

• passout from ResultSet, using rs.get[MyDate](field index or name)

• mapping to a field of other CaseClass such as User, and then using rowsUser

• mapping to a Row object and rowsRow, and then using row.get[MyDate](field index of name).

any record level(a table row) having a ResultSetMapper context bound can used in rows[T](sql)

the scala-sql library provide a Macro to automate generate the implementation for a given case class T if all it's field is JdbcValueAccess-able(having a JdbcValueAccess context bound).

since the macro will generate a ResultSetMapper class for you anytime if there is not an explicit imported implicit value, maybe a lot of anonymous class will be generated. that is no problem but a bigger jar. to avoid this problem, you can define a implicit ResultSetMappper value in the Case Class's companion object.

case class User(name: String, age: Int)
object User {
implicit val resultSetmapper = ResultSetMapper.material[User]
}

provide a offline Box for ResultSet which is scrollable and only valid with an open connection.

wrap a sql"select * from table where id = $id" object

annotated on a case class, to specify the column mapper, such as @UseColumnMapper(classOf[Camel2UnderscoreMapper]) default using IdentityMapping