import org.scalaquery.session._
import org.scalaquery.session.Database.threadLocalSession
import org.scalaquery.ql.TypeMapper._
import org.scalaquery.ql.extended.{ExtendedTable => Table}

object Queries2 {
	object Menu extends Table[(Int, String, String, Int, Int, Boolean)]("stm_menu") {
		// CD_MENU NM_MENU DS_MENU CD_MARCA CD_GRUPO STATUS
		def id      = column[Int]("cd_menu", O PrimaryKey, O AutoInc)
		def nm      = column[String]("nm_menu")
		def ds      = column[String]("ds_menu")
		def marcaId = column[Int]("cd_marca")
		def grupoId = column[Int]("cd_grupo")
		def status  = column[Boolean]("status")
		def * = id ~ nm ~ ds ~ marcaId ~ grupoId ~ status
	}
	def main(args:Array[String]) = {
		import org.scalaquery.ql._
		import org.scalaquery.ql.extended.OracleDriver.Implicit._
		val db = Database.forURL("jdbc:oracle:thin:@localhost:1521:xe", driver = "oracle.jdbc.driver.OracleDriver")
		db withSession {
			val m = Menu
			// could not find implicit value for evidence parameter of type org.scalaquery.ql.TypeMapper[(Int, java.lang.String, java.lang.String, Int, Int, Boolean)]
			println(m.insertStatementFor ((1, "String", "String", 1, 1, false)) )
		}

	}

}