com.dbobjekts.metadata.column.BigDecimalColumns.kt Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of db-objekts-core Show documentation

There is a newer version: 0.6.0-RC2

package com.dbobjekts.metadata.column

import com.dbobjekts.api.AnyTable
import java.math.BigDecimal
import java.sql.PreparedStatement
import java.sql.ResultSet
import java.sql.Types

/**
 * Represents a database column whose type is converted from and to a BigDecimal
 *
 * @param name    The column name in the corresponding database table
 */
class BigDecimalColumn(table: AnyTable, name: String, aggregateType: AggregateType?) :
    NonNullableColumn(table,name, BigDecimal::class.java, aggregateType) {
    constructor(table: AnyTable, name: String) : this(table, name, null)

    fun sum() = BigDecimalColumn(table, nameInTable, AggregateType.SUM)
    fun avg() = BigDecimalColumn(table, nameInTable, AggregateType.AVG)
    fun min() = BigDecimalColumn(table, nameInTable, AggregateType.MIN)
    fun max() = BigDecimalColumn(table, nameInTable, AggregateType.MAX)

    override fun getValue(position: Int, resultSet: ResultSet): BigDecimal = resultSet.getBigDecimal(position)

    override fun setValue(position: Int, statement: PreparedStatement, value: BigDecimal) =
        statement.setBigDecimal(position, value)

}

class NullableBigDecimalColumn(table: AnyTable, name: String, aggregateType: AggregateType?) :
    NullableColumn(table,name, Types.NUMERIC, BigDecimal::class.java, aggregateType) {
    constructor(table: AnyTable, name: String) : this(table, name, null)

    fun sum() = BigDecimalColumn(table, nameInTable, AggregateType.SUM)
    fun avg() = BigDecimalColumn(table, nameInTable, AggregateType.AVG)
    fun min() = BigDecimalColumn(table, nameInTable, AggregateType.MIN)
    fun max() = BigDecimalColumn(table, nameInTable, AggregateType.MAX)

    override fun getValue(position: Int, resultSet: ResultSet): BigDecimal? = resultSet.getBigDecimal(position)

    override fun setValue(position: Int, statement: PreparedStatement, value: BigDecimal?) =
        statement.setBigDecimal(position, value!!)
}