Skip to content

Instantly share code, notes, and snippets.

View leandrob13's full-sized avatar

Leandro Bolivar leandrob13

21 followers · 7 following
View GitHub Profile
@leandrob13
leandrob13 / OptionFilter.scala
Created September 25, 2015 13:36
Based on MaybeFilter (https://gist.github.com/cvogt/9193220), it uses implicit class to add the methods to the Query objects. FilteredBy works for filtering lists and it returns the query if no filters were applied. FoundBy works for finding a single register, if no filter defined it returns None.
implicit class OptionFilter[ X, Y ]( query: Query[ X, Y, Seq ] ) {
def filteredBy[ T ]( op: Option[ T ] )( f: ( X, T ) => Column[ Option[ Boolean ] ] ): Query[ X, Y, Seq ] = {
op map { o => query.filter( f( _, o ) ) } getOrElse { query }
}
def foundBy[ T ]( op: Option[ T ] )( f: ( X, T ) => Column[ Option[ Boolean ] ] ): Query[ X, Y, Seq ] = {
op map { o => query.filter( f( _, o ) ) } getOrElse { query.take( 0 ) }
}
}
@leandrob13
leandrob13 / SlickQueryOps.scala
Last active July 14, 2022 21:09
Trait that adds two functions to the slick Query type. I am using typelevel.cats as the functional library. Works for play-slick 3.1
trait SlickQueryOps {
databaseConfig: HasDatabaseConfig[ JdbcProfile ] =>
import cats.Apply
import cats.std.list._
import driver.api._
type BooleanOp = ( Rep[ Boolean ], Rep[ Boolean ] ) => Rep[ Boolean ]
implicit class OptionFilter[ X, Y ]( query: Query[ X, Y, Seq ] ) {
@leandrob13
leandrob13 / UserTables.scala
Last active April 11, 2016 22:30
package user.persistence.tables
object UserTables {
val driver = slick.driver.MySQLDriver
import driver.api._
class Users(tag: Tag) extends Table[UserRegister](tag, "USERS") {
val username: Rep[ String ] = column[ String ]( "USERNAME", O.PrimaryKey )
@leandrob13
leandrob13 / UserRepository.scala
Last active April 12, 2016 04:47
package user.persistence.repository
import user.persistence.tables.UserRegister
import user.persistence.tables.UserTables.Users
import play.api.Play
import play.api.db.slick.DatabaseConfigProvider
import scala.concurrent.Future
case class UserFilter(name: Option[ String ] = None, lastname: Option[ String ] = None,
email: Option[ String ] = None, username: Option[ String ] = None,
@leandrob13
leandrob13 / UserController.scala
Last active April 12, 2016 02:06
package user.controllers
import genesis.user.persistence.repository.{UserFilter, UserRepository}
import play.api.libs.json._
import play.api.mvc.{Action, Controller}
import scala.concurrent.Future
/**
* Created by leandrob13 on 10/9/15.
*/
@leandrob13
leandrob13 / ListT.scala
Last active April 16, 2016 16:17
package cats.data
import cats._
import cats.functor.Contravariant
import ListT._
/**
* ListT monad transformer.
*/
sealed class ListT[M[_], A](val value: M[Step[A, ListT[M, A]]]) {
@leandrob13
leandrob13 / ListTSimpleTest.sc
Created April 16, 2016 16:21
Scala worksheet with a simple ListT test
import cats.data.{Kleisli, ListT}
import cats.std.list._
type ListTA[A] = ListT[List, A]
val (f, g, h, x) = (
(a: Int) => a match {
case 0 => ListT.fromList(List(List(0, 1)))
case 1 => ListT.fromList(List(List(0), List(1)))
@leandrob13
leandrob13 / ReaderSequenced.scala
Last active June 29, 2017 10:43
import cats.data._
import cats.syntax.traverse._
import cats.std.list._
import scala.util.Try
def tryInt(s: String): Try[Int] = Try(s.toInt)
def reader: Reader[Try[Int], String] = Reader[Try[Int], String] { t =>
t.map(s => s"$s is a number").getOrElse("not")
@leandrob13
leandrob13 / TablaSlick.scala
Created November 30, 2016 21:43
protected val driver = com.typesafe.slick.driver.oracle.OracleDriver
import TperTiposPersonasRegistro._
import driver.api._
class TperTiposPersonas( _tableTag: Tag ) extends Table[TperTiposPersonasRegistro]( _tableTag, None, "TPER_TIPOS_PERSONAS" ) {
val cdtipoPersona: Rep[String] = column[String]( "CDTIPO_PERSONA", O.PrimaryKey, O.Length( 2, varying = true ) )
val dstipoPersona: Rep[Option[String]] = column[Option[String]]( "DSTIPO_PERSONA", O.Length( 30, varying = true ) )
val febaja: Rep[Option[Timestamp]] = column[Option[Timestamp]]( "FEBAJA" )
val snnumerico: Rep[Option[Char]] = column[Option[Char]]( "SNNUMERICO" )
@leandrob13
leandrob13 / TableGen.sbt
Created November 30, 2016 21:47
lazy val root = (project in file(".")).enablePlugins(PlayScala).
settings(
slick <<= slickCodeGenTask // register manual sbt command
)
// code generation task
lazy val slick = TaskKey[Seq[File]]("gen-tables")
lazy val slickCodeGenTask = (sourceManaged, dependencyClasspath in Compile, runner in Compile, streams) map { (dir, cp, r, s) =>
val outputDir = (dir / "slick").getPath // place generated files in sbt's managed sources folder
val url = "jdbc:oracle:thin:@mdebddd06.suranet.com:1537/DLLOLFHA" // connection info for a pre-populated throw-away, in-memory db for this demo, which is freshly initialized on every run