Duck4s/com.softinio.duck4s/com.softinio.duck4s.algebra/ParameterBinder

ParameterBinder

com.softinio.duck4s.algebra.ParameterBinder

See theParameterBinder companion trait

Companion object providing implicit ParameterBinder instances for common types.

This object contains given instances for primitive types (Int, Long, Double, String, Boolean) and Option types, providing automatic parameter binding for these common cases.

Attributes

Since: 0.1.0
Companion: trait
Graph
Supertypes: class Object

trait Matchable

class Any
Self type: ParameterBinder.type

Members list

Type members

Classlikes

Implicit ParameterBinder for BigDecimal values.

Attributes

Since

0.1.4

Example

batch.addBatch((BigDecimal("123.45"), "item"))

Supertypes

trait ParameterBinder[BigDecimal]

class Object

trait Matchable

class Any

Self type

bigDecimalBinder.type

Implicit ParameterBinder for Boolean values.

Attributes

Since

0.1.0

Example

batch.addBatch(("Product A", true)) // true for active

Supertypes

trait ParameterBinder[Boolean]

class Object

trait Matchable

class Any

Self type

booleanBinder.type

Implicit ParameterBinder for Array[Byte] values (BLOB columns).

Attributes

Since: 0.1.4
Supertypes: trait ParameterBinder[Array[Byte]]

class Object

trait Matchable

class Any
Self type: bytesBinder.type

Implicit ParameterBinder for java.sql.Date values.

Attributes

Since

0.1.4

Example

batch.addBatch((java.sql.Date.valueOf("2024-06-15"), "event"))

Supertypes

trait ParameterBinder[Date]

class Object

trait Matchable

class Any

Self type

dateBinder.type

Implicit ParameterBinder for Double values.

Attributes

Since

0.1.0

Example

batch.addBatch(("Product", 19.99))

Supertypes

trait ParameterBinder[Double]

class Object

trait Matchable

class Any

Self type

doubleBinder.type

Implicit ParameterBinder for Float values.

Attributes

Since: 0.1.4
Supertypes: trait ParameterBinder[Float]

class Object

trait Matchable

class Any
Self type: floatBinder.type

Implicit ParameterBinder for Int values.

Attributes

Since

0.1.0

Example

 // Used automatically in batch operations batch.addBatch(("Alice",
 25)) // 25 bound as Int

Supertypes

trait ParameterBinder[Int]

class Object

trait Matchable

class Any

Self type

intBinder.type

Implicit ParameterBinder for java.time.LocalDate values.

Passed via setObject; DuckDB maps this to the DATE column type.

Attributes

Since: 0.1.4
Supertypes: trait ParameterBinder[LocalDate]

class Object

trait Matchable

class Any
Self type: localDateBinder.type

Implicit ParameterBinder for java.time.LocalDateTime values.

Passed via setObject; DuckDB maps this to the TIMESTAMP column type.

Attributes

Since: 0.1.4
Supertypes: trait ParameterBinder[LocalDateTime]

class Object

trait Matchable

class Any
Self type: localDateTimeBinder.type

Implicit ParameterBinder for Long values.

Attributes

Since

0.1.0

Example

batch.addBatch((1234567890L, "data"))

Supertypes

trait ParameterBinder[Long]

class Object

trait Matchable

class Any

Self type

longBinder.type

Implicit ParameterBinder for java.time.OffsetDateTime values.

Passed via setObject; DuckDB maps this to the TIMESTAMPTZ column type.

Attributes

Since: 0.1.4
Supertypes: trait ParameterBinder[OffsetDateTime]

class Object

trait Matchable

class Any
Self type: offsetDateTimeBinder.type

Implicit ParameterBinder for String values.

Attributes

Since

0.1.0

Example

batch.addBatch(("Alice", "Engineer"))

Supertypes

trait ParameterBinder[String]

class Object

trait Matchable

class Any

Self type

stringBinder.type

Implicit ParameterBinder for java.sql.Timestamp values.

Attributes

Since

0.1.4

Example

batch.addBatch((java.sql.Timestamp.valueOf("2024-01-01 12:00:00"), "event"))

Supertypes

trait ParameterBinder[Timestamp]

class Object

trait Matchable

class Any

Self type

timestampBinder.type

Implicit ParameterBinder for java.util.UUID values.

DuckDB supports UUID natively; this binder uses setObject to pass the UUID directly without string conversion.

Attributes

Since

0.1.4

Example

batch.addBatch((java.util.UUID.randomUUID(), "label"))

Supertypes

trait ParameterBinder[UUID]

class Object

trait Matchable

class Any

Self type

uuidBinder.type

Givens

Implicit ParameterBinder for BigDecimal values.

Attributes

Since

0.1.4

Example

batch.addBatch((BigDecimal("123.45"), "item"))

Implicit ParameterBinder for Boolean values.

Attributes

Since

0.1.0

Example

batch.addBatch(("Product A", true)) // true for active

Implicit ParameterBinder for Array[Byte] values (BLOB columns).

Attributes

Since: 0.1.4

Implicit ParameterBinder for java.sql.Date values.

Attributes

Since

0.1.4

Example

batch.addBatch((java.sql.Date.valueOf("2024-06-15"), "event"))

Implicit ParameterBinder for Double values.

Attributes

Since

0.1.0

Example

batch.addBatch(("Product", 19.99))

Implicit ParameterBinder for Float values.

Attributes

Since: 0.1.4

Implicit ParameterBinder for Int values.

Attributes

Since

0.1.0

Example

 // Used automatically in batch operations batch.addBatch(("Alice",
 25)) // 25 bound as Int

Implicit ParameterBinder for java.time.LocalDate values.

Passed via setObject; DuckDB maps this to the DATE column type.

Attributes

Since: 0.1.4

Implicit ParameterBinder for java.time.LocalDateTime values.

Passed via setObject; DuckDB maps this to the TIMESTAMP column type.

Attributes

Since: 0.1.4

Implicit ParameterBinder for Long values.

Attributes

Since

0.1.0

Example

batch.addBatch((1234567890L, "data"))

Implicit ParameterBinder for java.time.OffsetDateTime values.

Passed via setObject; DuckDB maps this to the TIMESTAMPTZ column type.

Attributes

Since: 0.1.4

Implicit ParameterBinder for Option values.

This binder handles nullable parameters by binding the wrapped value if present, or NULL if the Option is None.

Type parameters

T: the type of the wrapped value

Value parameters

binder: implicit ParameterBinder for the wrapped type T

Attributes

Returns

a ParameterBinder for Option[T]

Since

0.1.0

Example

 // Some values are bound normally, None becomes NULL batch.addBatch(
 ("Alice", Some(25)), // age = 25 ("Bob", None) // age = NULL )

Implicit ParameterBinder for String values.

Attributes

Since

0.1.0

Example

batch.addBatch(("Alice", "Engineer"))

Implicit ParameterBinder for java.sql.Timestamp values.

Attributes

Since

0.1.4

Example

batch.addBatch((java.sql.Timestamp.valueOf("2024-01-01 12:00:00"), "event"))

Implicit ParameterBinder for java.util.UUID values.

DuckDB supports UUID natively; this binder uses setObject to pass the UUID directly without string conversion.

Attributes

Since

0.1.4

Example

batch.addBatch((java.util.UUID.randomUUID(), "label"))

In this article

Generated with