class2sql

SQL insert and select statements generator based on Scala case class.

Table of contents

• Goals
• Getting started
• Examples

Goals

• Provide simple tool for generating SQL inserts based on Scala case classes
• Provide easy API to query JDBC table and map result to Scala case class

Getting started

Include dependencies

"com.github.piotr-kalanski" % "class2sql_2.11" % "0.1.0"

or

<dependency>
    <groupId>com.github.piotr-kalanski</groupId>
    <artifactId>class2sql_2.11</artifactId>
    <version>0.1.0</version>
</dependency>

Examples

Generate inserts

import com.datawizards.class2jdbc._

case class Person(name: String, age: Int)

val data = Seq(Person("p1", 1), Person("p2", 2))
generateInserts(data)

INSERT INTO Person(name,age) VALUES('p1',1)
INSERT INTO Person(name,age) VALUES('p2',2)

Select from table

import com.datawizards.jdbc2class._

case class Person(name: String, age: Int)

val connectionString = "jdbc:h2:mem:test"
val connection = DriverManager.getConnection(connectionString, "", "")
selectTable[Person](connection, "people")