• Home
• com.ecwid.clickhouse
• clickhouse-client
• 0.3.0
• source code
• Convert.kt

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.ecwid.clickhouse.convert.Convert.kt Maven / Gradle / Ivy

package com.ecwid.clickhouse.convert

import java.math.BigDecimal
import java.text.SimpleDateFormat
import java.util.*

object Convert {

	object Int8 {
		@JvmStatic
		fun toValue(str: String?) = requireNotNull(str).toByte()

		@JvmStatic
		fun toNullableValue(str: String?) = str?.toByte()

		@JvmStatic
		fun toArray(array: List) = array.map(::toValue)

		@JvmStatic
		fun toNullableArray(array: List) = array.map(::toNullableValue)

		@JvmStatic
		fun fromValue(value: Byte) = value.toString()

		@JvmStatic
		fun fromNullableValue(value: Byte?) = value?.toString()

		@JvmStatic
		fun fromArray(array: List) = array.map(::fromValue)

		@JvmStatic
		fun fromArray(array: ByteArray) = array.map(::fromValue)

		@JvmStatic
		fun fromNullableArray(array: List) = array.map(::fromNullableValue)
	}

	object Int16 {
		@JvmStatic
		fun toValue(str: String?) = requireNotNull(str).toShort()

		@JvmStatic
		fun toNullableValue(str: String?) = str?.toShort()

		@JvmStatic
		fun toArray(array: List) = array.map(::toValue)

		@JvmStatic
		fun toNullableArray(array: List) = array.map(::toNullableValue)

		@JvmStatic
		fun fromValue(value: Short) = value.toString()

		@JvmStatic
		fun fromNullableValue(value: Short?) = value?.toString()

		@JvmStatic
		fun fromArray(array: List) = array.map(::fromValue)

		@JvmStatic
		fun fromNullableArray(array: List) = array.map(::fromNullableValue)
	}

	object Int32 {
		@JvmStatic
		fun toValue(str: String?) = requireNotNull(str).toInt()

		@JvmStatic
		fun toNullableValue(str: String?) = str?.toInt()

		@JvmStatic
		fun toArray(array: List) = array.map(::toValue)

		@JvmStatic
		fun toNullableArray(array: List) = array.map(::toNullableValue)

		@JvmStatic
		fun fromValue(value: Int) = value.toString()

		@JvmStatic
		fun fromNullableValue(value: Int?) = value?.toString()

		@JvmStatic
		fun fromArray(array: List) = array.map(::fromValue)

		@JvmStatic
		fun fromNullableArray(array: List) = array.map(::fromNullableValue)
	}

	object Int64 {
		@JvmStatic
		fun toValue(str: String?) = requireNotNull(str).toLong()

		@JvmStatic
		fun toNullableValue(str: String?) = str?.toLong()

		@JvmStatic
		fun toArray(array: List) = array.map(::toValue)

		@JvmStatic
		fun toNullableArray(array: List) = array.map(::toNullableValue)

		@JvmStatic
		fun fromValue(value: Long) = value.toString()

		@JvmStatic
		fun fromNullableValue(value: Long?) = value?.toString()

		@JvmStatic
		fun fromArray(array: List) = array.map(::fromValue)

		@JvmStatic
		fun fromNullableArray(array: List) = array.map(::fromNullableValue)
	}

	object UInt32 {
		@JvmStatic
		fun toValue(str: String?) = Integer.parseUnsignedInt(requireNotNull(str))

		@JvmStatic
		fun toNullableValue(str: String?) = str?.let { Integer.parseUnsignedInt(str) }

		@JvmStatic
		fun toArray(array: List) = array.map(::toValue)

		@JvmStatic
		fun toNullableArray(array: List) = array.map(::toNullableValue)

		@JvmStatic
		fun fromValue(value: Int) = Integer.toUnsignedString(value)

		@JvmStatic
		fun fromNullableValue(value: Int?) = value?.let { Integer.toUnsignedString(value) }

		@JvmStatic
		fun fromArray(array: List) = array.map(::fromValue)

		@JvmStatic
		fun fromNullableArray(array: List) = array.map(::fromNullableValue)
	}

	object UInt64 {
		@JvmStatic
		fun toValue(str: String?) = java.lang.Long.parseUnsignedLong(requireNotNull(str))

		@JvmStatic
		fun toNullableValue(str: String?) = str?.let { java.lang.Long.parseUnsignedLong(str) }

		@JvmStatic
		fun toArray(array: List) = array.map(::toValue)

		@JvmStatic
		fun toNullableArray(array: List) = array.map(::toNullableValue)

		@JvmStatic
		fun fromValue(value: Long) = java.lang.Long.toUnsignedString(value)

		@JvmStatic
		fun fromNullableValue(value: Long?) = value?.let { java.lang.Long.toUnsignedString(value) }

		@JvmStatic
		fun fromArray(array: List) = array.map(::fromValue)

		@JvmStatic
		fun fromNullableArray(array: List) = array.map(::fromNullableValue)
	}

	object Float32 {
		@JvmStatic
		fun toValue(str: String?) = requireNotNull(str).toFloat()

		@JvmStatic
		fun toNullableValue(str: String?) = str?.toFloat()

		@JvmStatic
		fun toArray(array: List) = array.map(::toValue)

		@JvmStatic
		fun toNullableArray(array: List) = array.map(::toNullableValue)

		@JvmStatic
		fun fromValue(value: Float) = value.toString()

		@JvmStatic
		fun fromNullableValue(value: Float?) = value?.toString()

		@JvmStatic
		fun fromArray(array: List) = array.map(::fromValue)

		@JvmStatic
		fun fromNullableArray(array: List) = array.map(::fromNullableValue)
	}

	object Float64 {
		@JvmStatic
		fun toValue(str: String?) = requireNotNull(str).toDouble()

		@JvmStatic
		fun toNullableValue(str: String?) = str?.toDouble()

		@JvmStatic
		fun toArray(array: List) = array.map(::toValue)

		@JvmStatic
		fun toNullableArray(array: List) = array.map(::toNullableValue)

		@JvmStatic
		fun fromValue(value: Double) = value.toString()

		@JvmStatic
		fun fromNullableValue(value: Double?) = value?.toString()

		@JvmStatic
		fun fromArray(array: List) = array.map(::fromValue)

		@JvmStatic
		fun fromNullableArray(array: List) = array.map(::fromNullableValue)
	}

	object Decimal {
		@JvmStatic
		fun toValue(str: String?) = requireNotNull(str).toBigDecimal()

		@JvmStatic
		fun toNullableValue(str: String?) = str?.toBigDecimal()

		@JvmStatic
		fun toArray(array: List) = array.map(::toValue)

		@JvmStatic
		fun toNullableArray(array: List) = array.map(::toNullableValue)

		@JvmStatic
		fun fromValue(value: BigDecimal) = value.toString()

		@JvmStatic
		fun fromNullableValue(value: BigDecimal?) = value?.toString()

		@JvmStatic
		fun fromArray(array: List) = array.map(::fromValue)

		@JvmStatic
		fun fromNullableArray(array: List) = array.map(::fromNullableValue)
	}

	object Str {
		@JvmStatic
		fun fromValue(str: String) = escapeAndQuoteString(str)

		@JvmStatic
		fun fromNullableValue(str: String?) = str?.let { escapeAndQuoteString(it) }

		@JvmStatic
		fun fromArray(array: List) = array.map(::fromValue)

		@JvmStatic
		fun fromNullableArray(array: List) = array.map(::fromNullableValue)

		private const val QUOTE: Char = '\''
		private const val BACKSLASH = '\\'

		private fun escapeAndQuoteString(str: String): String {
			// 2 symbols for quotes and 8 for possible escaping
			// it's just heuristics, no serious science behind :)
			val capacity = str.length + 10

			return buildString(capacity) {
				append(QUOTE)

				for (char in str) {
					when (char) {
						QUOTE -> {
							append(BACKSLASH)
							append(QUOTE)
						}
						BACKSLASH -> {
							append(BACKSLASH)
							append(BACKSLASH)
						}
						else -> append(char)
					}
				}
				append(QUOTE)
			}
		}
	}

	object DateTime {
		@JvmStatic
		fun toValue(str: String?, timeZone: TimeZone) = convertFromString(requireNotNull(str), timeZone)

		@JvmStatic
		fun toNullableValue(str: String?, timeZone: TimeZone) = str?.let { convertFromString(str, timeZone) }

		@JvmStatic
		fun toArray(array: List, timeZone: TimeZone) = array.map { toValue(it, timeZone) }

		@JvmStatic
		fun toNullableArray(array: List, timeZone: TimeZone) = array.map { toNullableValue(it, timeZone) }

		@JvmStatic
		fun fromValue(value: java.util.Date, timeZone: TimeZone) = convertToString(value, timeZone)

		@JvmStatic
		fun fromNullableValue(value: java.util.Date?, timeZone: TimeZone) =
			value?.let { convertToString(value, timeZone) }

		@JvmStatic
		fun fromArray(array: List, timeZone: TimeZone) = array.map { fromValue(it, timeZone) }

		@JvmStatic
		fun fromNullableArray(array: List, timeZone: TimeZone) =
			array.map { fromNullableValue(it, timeZone) }

		private val DATETIME_FORMAT = ThreadLocal.withInitial {
			SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
		}

		private fun convertFromString(string: String, timeZone: TimeZone): java.util.Date {
			val format = DATETIME_FORMAT.get()
			format.timeZone = timeZone
			return format.parse(string)
		}

		private fun convertToString(value: java.util.Date, timeZone: TimeZone): String {
			val format = DATETIME_FORMAT.get()
			format.timeZone = timeZone
			return format.format(value)
		}
	}

	object Date {
		@JvmStatic
		fun toValue(str: String?, timeZone: TimeZone) = convertFromString(requireNotNull(str), timeZone)

		@JvmStatic
		fun toNullableValue(str: String?, timeZone: TimeZone) = str?.let { convertFromString(str, timeZone) }

		@JvmStatic
		fun toArray(array: List, timeZone: TimeZone) = array.map { toValue(it, timeZone) }

		@JvmStatic
		fun toNullableArray(array: List, timeZone: TimeZone) = array.map { toNullableValue(it, timeZone) }

		@JvmStatic
		fun fromValue(value: java.util.Date, timeZone: TimeZone) = convertToString(value, timeZone)

		@JvmStatic
		fun fromNullableValue(value: java.util.Date?, timeZone: TimeZone) =
			value?.let { convertToString(value, timeZone) }

		@JvmStatic
		fun fromArray(array: List, timeZone: TimeZone) = array.map { fromValue(it, timeZone) }

		@JvmStatic
		fun fromNullableArray(array: List, timeZone: TimeZone) =
			array.map { fromNullableValue(it, timeZone) }

		private val DATE_FORMAT = ThreadLocal.withInitial {
			SimpleDateFormat("yyyy-MM-dd")
		}

		private fun convertFromString(string: String, timeZone: TimeZone): java.util.Date {
			val format = DATE_FORMAT.get()
			format.timeZone = timeZone
			return format.parse(string)
		}

		private fun convertToString(value: java.util.Date, timeZone: TimeZone): String {
			val format = DATE_FORMAT.get()
			format.timeZone = timeZone
			return format.format(value)
		}
	}

	object Enum {
		@JvmStatic
		fun > toValue(str: String?, clazz: Class) =
			java.lang.Enum.valueOf(clazz, requireNotNull(str))

		@JvmStatic
		fun > toNullableValue(str: String?, clazz: Class) =
			str?.let { java.lang.Enum.valueOf(clazz, str) }

		@JvmStatic
		fun > toArray(array: List, clazz: Class) = array.map { toValue(it, clazz) }

		@JvmStatic
		fun > toNullableArray(array: List, clazz: Class) =
			array.map { toNullableValue(it, clazz) }

		@JvmStatic
		fun > fromValue(value: T?) = requireNotNull(value).name

		@JvmStatic
		fun > fromNullableValue(value: T?) = value?.name

		@JvmStatic
		fun > fromArray(array: List) = array.map { fromValue(it) }

		@JvmStatic
		fun > fromNullableArray(array: List) = array.map { fromNullableValue(it) }

	}

	object Map {
		@JvmStatic
		fun fromValue(map: kotlin.collections.Map) =
			map.map { kv ->
				val value = kv.value?.let { "'$it'" } ?: "NULL"
				"'${kv.key}'" to value
			}.toMap()

		@JvmStatic
		fun toMapValue(map: kotlin.collections.Map) = fromValue(map)
	}
}