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.
package com.metricstream.jdbc
import java.io.IOException
import java.io.InputStream
import java.io.InputStreamReader
import java.io.Reader
import java.io.StringReader
import java.math.BigDecimal
import java.net.URL
import java.sql.Blob
import java.sql.Clob
import java.sql.Date
import java.sql.NClob
import java.sql.Ref
import java.sql.ResultSet
import java.sql.ResultSetMetaData
import java.sql.RowId
import java.sql.SQLException
import java.sql.SQLFeatureNotSupportedException
import java.sql.SQLWarning
import java.sql.SQLXML
import java.sql.Statement
import java.sql.Time
import java.sql.Timestamp
import java.time.OffsetDateTime
import java.time.ZoneOffset
import java.util.Calendar
import java.util.concurrent.atomic.AtomicLong
import java.sql.Array as SQLArray
import com.opencsv.CSVReader
import com.opencsv.exceptions.CsvException
import org.slf4j.LoggerFactory
class MockResultSet private constructor(
tag: String,
names: Array?,
private val data: Array>,
usages: Int = 1
) : ResultSet {
private val tag: String
private val columnIndices: Map
private var rowIndex = -1
private var wasNull = false
private var autoGenerated = false
private var remaining = usages - 1
private var rowId = 0
private var closed: Boolean = false
private fun index(columnName: String) = columnIndices[columnName.uppercase()] ?: Int.MAX_VALUE
private fun outOfRange(columnIndex: Int) = autoGenerated || (rowIndex >= data.size || columnIndex >= data[rowIndex].size)
private fun answerObject(columnIndex: Int): Any? = when {
outOfRange(columnIndex) -> THE_ANSWER_TO_THE_ULTIMATE_QUESTION.toString()
else -> data[rowIndex][columnIndex]
}.also {
MockSQLBuilderProvider.invocations.getRsObject++
wasNull = it == null
}
private fun answerDouble(columnIndex: Int) = when {
outOfRange(columnIndex) -> THE_ANSWER_TO_THE_ULTIMATE_QUESTION.toDouble()
else -> when (val value = data[rowIndex][columnIndex]) {
is Double? -> value
is String -> value.toDouble()
else -> throw SQLException()
}
}.also {
MockSQLBuilderProvider.invocations.getRsDouble++
wasNull = it == null
} ?: 0.0
private fun answerTimestamp(columnIndex: Int) = when {
outOfRange(columnIndex) -> Timestamp(THE_ANSWER_TO_THE_ULTIMATE_QUESTION.toLong())
else -> when (val value = data[rowIndex][columnIndex]) {
is Timestamp? -> value
is String -> Timestamp.valueOf(value)
is Long -> Timestamp(value)
else -> throw SQLException()
}
}.also {
MockSQLBuilderProvider.invocations.getRsTimestamp++
wasNull = it == null
}
private fun answerDate(columnIndex: Int) = when {
outOfRange(columnIndex) -> Date(THE_ANSWER_TO_THE_ULTIMATE_QUESTION.toLong())
else -> when (val value = data[rowIndex][columnIndex]) {
is Date? -> value
is String -> Date.valueOf(value)
is Long -> Date(value)
else -> throw SQLException()
}
}.also {
MockSQLBuilderProvider.invocations.getRsDate++
wasNull = it == null
}
private fun answerOffsetDateTime(columnIndex: Int) = when {
outOfRange(columnIndex) -> OffsetDateTime.of(4242, 4, 2, 4, 2, 4, 2, ZoneOffset.UTC)
else -> when (val value = data[rowIndex][columnIndex]) {
is OffsetDateTime? -> value
is String -> OffsetDateTime.parse(value)
else -> throw SQLException()
}
}.also {
MockSQLBuilderProvider.invocations.getRsObject++
wasNull = it == null
}
private fun answerLong(columnIndex: Int) = when {
outOfRange(columnIndex) -> THE_ANSWER_TO_THE_ULTIMATE_QUESTION.toLong()
else -> when (val value = data[rowIndex][columnIndex]) {
is Long? -> value
is String -> value.toLong()
else -> throw SQLException()
}
}.also {
MockSQLBuilderProvider.invocations.getRsLong++
wasNull = it == null
} ?: 0L
private fun answerInt(columnIndex: Int) = when {
outOfRange(columnIndex) -> THE_ANSWER_TO_THE_ULTIMATE_QUESTION
else -> when (val value = data[rowIndex][columnIndex]) {
is Int? -> value
is String -> value.toInt()
else -> throw SQLException()
}
}.also {
MockSQLBuilderProvider.invocations.getRsInt++
wasNull = it == null
} ?: 0
private fun answerBoolean(columnIndex: Int) = when {
outOfRange(columnIndex) -> true
else -> when (val value = data[rowIndex][columnIndex]) {
null -> null
is Int -> value != 0
is String -> value != "0"
else -> throw SQLException()
}
}.also {
MockSQLBuilderProvider.invocations.getRsBoolean++
wasNull = it == null
} ?: false
private fun answerString(columnIndex: Int) = when {
outOfRange(columnIndex) -> THE_ANSWER_TO_THE_ULTIMATE_QUESTION.toString()
else -> data[rowIndex][columnIndex] as String?
}.also {
MockSQLBuilderProvider.invocations.getRsString++
wasNull = it == null
}
private fun answerBigDecimal(columnIndex: Int) = when {
outOfRange(columnIndex) -> THE_ANSWER_TO_THE_ULTIMATE_QUESTION.toBigDecimal()
else -> data[rowIndex][columnIndex] as BigDecimal?
}.also {
MockSQLBuilderProvider.invocations.getRsBigDecimal++
wasNull = it == null
}
override fun unwrap(iface: Class): T = throw SQLException("Not a wrapper")
override fun isWrapperFor(iface: Class<*>): Boolean = false
override fun close() {
closed = true
}
override fun next(): Boolean {
if (remaining < -1) {
throw SQLException("Forced exception")
}
MockSQLBuilderProvider.invocations.next++
rowId++
rowIndex++
if (rowIndex == data.size && remaining > 0) {
rowIndex = 0
remaining--
}
return rowIndex < data.size
}
override fun wasNull(): Boolean = wasNull
override fun getString(columnIndex: Int): String? = answerString(columnIndex - 1)
override fun getString(columnLabel: String): String? = answerString(index(columnLabel))
override fun getBoolean(columnIndex: Int): Boolean = answerBoolean(columnIndex - 1)
override fun getBoolean(columnLabel: String): Boolean = answerBoolean(index(columnLabel))
override fun getByte(columnIndex: Int): Byte = answerInt(columnIndex - 1).toByte()
override fun getByte(columnLabel: String): Byte = answerInt(index(columnLabel)).toByte()
override fun getShort(columnIndex: Int): Short = answerInt(columnIndex - 1).toShort()
override fun getShort(columnLabel: String): Short = answerInt(index(columnLabel)).toShort()
override fun getInt(columnIndex: Int): Int = answerInt(columnIndex - 1)
override fun getInt(columnLabel: String): Int = answerInt(index(columnLabel))
override fun getLong(columnIndex: Int): Long = answerLong(columnIndex - 1)
override fun getLong(columnLabel: String): Long = answerLong(index(columnLabel))
override fun getFloat(columnIndex: Int): Float = answerDouble(columnIndex - 1).toFloat()
override fun getFloat(columnLabel: String): Float = answerDouble(index(columnLabel)).toFloat()
override fun getDouble(columnIndex: Int): Double = answerDouble(columnIndex - 1)
override fun getDouble(columnLabel: String): Double = answerDouble(index(columnLabel))
override fun getBigDecimal(columnIndex: Int, p1: Int): BigDecimal? = answerBigDecimal(columnIndex - 1)
override fun getBigDecimal(columnLabel: String, p1: Int): BigDecimal? = answerBigDecimal(index(columnLabel))
override fun getBigDecimal(columnIndex: Int): BigDecimal? = answerBigDecimal(columnIndex - 1)
override fun getBigDecimal(columnLabel: String): BigDecimal? = answerBigDecimal(index(columnLabel))
override fun getBytes(columnIndex: Int): ByteArray? = null
override fun getBytes(columnLabel: String): ByteArray? = null
override fun getDate(columnIndex: Int): Date? = answerDate(columnIndex - 1)
override fun getDate(columnLabel: String): Date? = answerDate(index(columnLabel))
override fun getDate(columnIndex: Int, p1: Calendar?): Date? = answerDate(columnIndex - 1)
override fun getDate(columnLabel: String, p1: Calendar?): Date? = answerDate(index(columnLabel))
override fun getTime(columnIndex: Int): Time? = null
override fun getTime(columnLabel: String): Time? = null
override fun getTime(columnIndex: Int, p1: Calendar?): Time? = null
override fun getTime(columnLabel: String, p1: Calendar?): Time? = null
override fun getTimestamp(columnIndex: Int): Timestamp? = answerTimestamp(columnIndex - 1)
override fun getTimestamp(columnLabel: String): Timestamp? = answerTimestamp(index(columnLabel))
override fun getTimestamp(columnIndex: Int, p1: Calendar?): Timestamp? = answerTimestamp(columnIndex - 1)
override fun getTimestamp(columnLabel: String, p1: Calendar?): Timestamp? = answerTimestamp(index(columnLabel))
override fun getAsciiStream(columnIndex: Int): InputStream? = null
override fun getAsciiStream(columnLabel: String): InputStream? = null
override fun getUnicodeStream(columnIndex: Int): InputStream? = null
override fun getUnicodeStream(columnLabel: String): InputStream? = null
override fun getBinaryStream(columnIndex: Int): InputStream? = null
override fun getBinaryStream(columnLabel: String): InputStream? = null
override fun getWarnings(): SQLWarning? = null
override fun clearWarnings() {
}
override fun getCursorName(): String = throw SQLFeatureNotSupportedException()
override fun getMetaData(): ResultSetMetaData = MockResultSetMetaData(this.columnIndices)
override fun getObject(columnIndex: Int): Any? = answerObject(columnIndex - 1)
override fun getObject(columnLabel: String): Any? = answerObject(index(columnLabel))
override fun getObject(columnIndex: Int, p1: MutableMap>?): Any? = null
override fun getObject(columnLabel: String, p1: MutableMap>?): Any? = null
override fun getObject(columnIndex: Int, p1: Class): T? {
if (p1 == OffsetDateTime::class.java) {
return answerOffsetDateTime(columnIndex - 1) as T?
} else {
TODO("Not yet implemented")
}
}
override fun getObject(columnLabel: String, p1: Class?): T? {
if (p1 == OffsetDateTime::class.java) {
return answerOffsetDateTime(index(columnLabel)) as T?
} else {
TODO("Not yet implemented")
}
}
override fun findColumn(columnLabel: String): Int {
val columnIndex = index(columnLabel)
if (columnIndex == Int.MAX_VALUE) throw SQLException("Invalid column name")
return columnIndex + 1
}
override fun getCharacterStream(columnIndex: Int): Reader? = null
override fun getCharacterStream(columnLabel: String): Reader? = null
override fun isBeforeFirst(): Boolean = rowId == 0
override fun isAfterLast(): Boolean = rowIndex >= data.size - 1 && remaining <= 0
override fun isFirst(): Boolean = rowId == 1
override fun isLast(): Boolean = rowIndex == data.size - 1 && remaining <= 0
override fun beforeFirst() {
throw SQLException("The result set type is TYPE_FORWARD_ONLY")
}
override fun afterLast() {
throw SQLException("The result set type is TYPE_FORWARD_ONLY")
}
override fun first(): Boolean {
throw SQLException("The result set type is TYPE_FORWARD_ONLY")
}
override fun last(): Boolean {
throw SQLException("The result set type is TYPE_FORWARD_ONLY")
}
override fun getRow(): Int {
return rowId
}
override fun absolute(columnIndex: Int): Boolean {
throw SQLException("The result set type is TYPE_FORWARD_ONLY")
}
override fun relative(columnIndex: Int): Boolean {
throw SQLException("The result set type is TYPE_FORWARD_ONLY")
}
override fun previous(): Boolean {
throw SQLException("The result set type is TYPE_FORWARD_ONLY")
}
override fun setFetchDirection(direction: Int) {
if (direction != ResultSet.FETCH_FORWARD) {
throw SQLException("The result set type is TYPE_FORWARD_ONLY")
}
}
override fun getFetchDirection(): Int = ResultSet.FETCH_FORWARD
override fun setFetchSize(rows: Int) {
if (rows < 0) {
throw SQLException("Invalid fetch size")
}
}
override fun getFetchSize(): Int = 100
override fun getType(): Int = ResultSet.TYPE_FORWARD_ONLY
override fun getConcurrency(): Int = ResultSet.CONCUR_READ_ONLY
override fun rowUpdated(): Boolean = false
override fun rowInserted(): Boolean = false
override fun rowDeleted(): Boolean = false
override fun updateNull(columnIndex: Int) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateNull(columnLabel: String) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBoolean(columnIndex: Int, p1: Boolean) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBoolean(columnLabel: String, p1: Boolean) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateByte(columnIndex: Int, p1: Byte) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateByte(columnLabel: String, p1: Byte) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateShort(columnIndex: Int, p1: Short) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateShort(columnLabel: String, p1: Short) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateInt(columnIndex: Int, p1: Int) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateInt(columnLabel: String, p1: Int) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateLong(columnIndex: Int, p1: Long) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateLong(columnLabel: String, p1: Long) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateFloat(columnIndex: Int, p1: Float) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateFloat(columnLabel: String, p1: Float) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateDouble(columnIndex: Int, p1: Double) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateDouble(columnLabel: String, p1: Double) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBigDecimal(columnIndex: Int, p1: BigDecimal?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBigDecimal(columnLabel: String, p1: BigDecimal?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateString(columnIndex: Int, p1: String?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateString(columnLabel: String, p1: String?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBytes(columnIndex: Int, p1: ByteArray?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBytes(columnLabel: String, p1: ByteArray?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateDate(columnIndex: Int, p1: Date?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateDate(columnLabel: String, p1: Date?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateTime(columnIndex: Int, p1: Time?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateTime(columnLabel: String, p1: Time?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateTimestamp(columnIndex: Int, p1: Timestamp?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateTimestamp(columnLabel: String, p1: Timestamp?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateAsciiStream(columnIndex: Int, p1: InputStream?, p2: Int) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateAsciiStream(columnLabel: String, p1: InputStream?, p2: Int) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateAsciiStream(columnIndex: Int, p1: InputStream?, p2: Long) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateAsciiStream(columnLabel: String, p1: InputStream?, p2: Long) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateAsciiStream(columnIndex: Int, p1: InputStream?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateAsciiStream(columnLabel: String, p1: InputStream?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBinaryStream(columnIndex: Int, p1: InputStream?, p2: Int) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBinaryStream(columnLabel: String, p1: InputStream?, p2: Int) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBinaryStream(columnIndex: Int, p1: InputStream?, p2: Long) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBinaryStream(columnLabel: String, p1: InputStream?, p2: Long) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBinaryStream(columnIndex: Int, p1: InputStream?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBinaryStream(columnLabel: String, p1: InputStream?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateCharacterStream(columnIndex: Int, p1: Reader?, p2: Int) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateCharacterStream(columnLabel: String, p1: Reader?, p2: Int) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateCharacterStream(columnIndex: Int, p1: Reader?, p2: Long) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateCharacterStream(columnLabel: String, p1: Reader?, p2: Long) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateCharacterStream(columnIndex: Int, p1: Reader?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateCharacterStream(columnLabel: String, p1: Reader?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateObject(columnIndex: Int, p1: Any?, p2: Int) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateObject(columnIndex: Int, p1: Any?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateObject(columnLabel: String, p1: Any?, p2: Int) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateObject(columnLabel: String, p1: Any?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun insertRow() {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateRow() {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun deleteRow() {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun refreshRow() {
throw SQLException("The result set concurrency is TYPE_FORWARD_ONLY")
}
override fun cancelRowUpdates() {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun moveToInsertRow() {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun moveToCurrentRow() {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun getStatement(): Statement? = null
override fun getRef(columnIndex: Int): Ref? = null
override fun getRef(columnLabel: String): Ref? = null
override fun getBlob(columnIndex: Int): Blob? = null
override fun getBlob(columnLabel: String): Blob? = null
override fun getClob(columnIndex: Int): Clob? = null
override fun getClob(columnLabel: String): Clob? = null
override fun getArray(columnIndex: Int): SQLArray? = null
override fun getArray(columnLabel: String): SQLArray? = null
override fun getURL(columnIndex: Int): URL? = null
override fun getURL(columnLabel: String): URL? = null
override fun updateRef(columnIndex: Int, p1: Ref?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateRef(columnLabel: String, p1: Ref?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBlob(columnIndex: Int, p1: Blob?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBlob(columnLabel: String, p1: Blob?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBlob(columnIndex: Int, p1: InputStream?, p2: Long) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBlob(columnLabel: String, p1: InputStream?, p2: Long) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBlob(columnIndex: Int, p1: InputStream?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateBlob(columnLabel: String, p1: InputStream?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateClob(columnIndex: Int, p1: Clob?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateClob(columnLabel: String, p1: Clob?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateClob(columnIndex: Int, p1: Reader?, p2: Long) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateClob(columnLabel: String, p1: Reader?, p2: Long) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateClob(columnIndex: Int, p1: Reader?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateClob(columnLabel: String, p1: Reader?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateArray(columnIndex: Int, p1: SQLArray?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateArray(columnLabel: String, p1: SQLArray?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun getRowId(columnIndex: Int): RowId? = null
override fun getRowId(columnLabel: String): RowId? = null
override fun updateRowId(columnIndex: Int, p1: RowId?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateRowId(columnLabel: String, p1: RowId?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun getHoldability(): Int = ResultSet.CLOSE_CURSORS_AT_COMMIT
override fun isClosed(): Boolean = closed
override fun updateNString(columnIndex: Int, p1: String?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateNString(columnLabel: String, p1: String?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateNClob(columnIndex: Int, p1: NClob?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateNClob(columnLabel: String, p1: NClob?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateNClob(columnIndex: Int, p1: Reader?, p2: Long) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateNClob(columnLabel: String, p1: Reader?, p2: Long) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateNClob(columnIndex: Int, p1: Reader?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateNClob(columnLabel: String, p1: Reader?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun getNClob(columnIndex: Int): NClob? = null
override fun getNClob(columnLabel: String): NClob? = null
override fun getSQLXML(columnIndex: Int): SQLXML? = null
override fun getSQLXML(columnLabel: String): SQLXML? = null
override fun updateSQLXML(columnIndex: Int, p1: SQLXML?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateSQLXML(columnLabel: String, p1: SQLXML?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun getNString(columnIndex: Int): String? = answerString(columnIndex - 1)
override fun getNString(columnLabel: String): String? = answerString(index(columnLabel))
override fun getNCharacterStream(columnIndex: Int): Reader? = null
override fun getNCharacterStream(columnLabel: String): Reader? = null
override fun updateNCharacterStream(columnIndex: Int, p1: Reader?, p2: Long) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateNCharacterStream(columnLabel: String, p1: Reader?, p2: Long) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateNCharacterStream(columnIndex: Int, p1: Reader?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun updateNCharacterStream(columnLabel: String, p1: Reader?) {
throw SQLException("The result set concurrency is CONCUR_READ_ONLY")
}
override fun toString(): String = tag
companion object {
private val logger = LoggerFactory.getLogger(MockResultSet::class.java)
private val counter = AtomicLong(0)
internal const val THE_ANSWER_TO_THE_ULTIMATE_QUESTION = 42
/**
* Creates the mock ResultSet.
*
* @param usages the number of times this resultset is used, defaults to 1
* @return a mocked ResultSet
*/
@JvmStatic
@JvmOverloads
fun createGenerated(tag: String, usages: Int = 1): ResultSet {
return MockResultSet(tag, null, arrayOf(arrayOf(THE_ANSWER_TO_THE_ULTIMATE_QUESTION.toString())), usages)
}
/**
* Adds a mock ResultSet.
*
* @param usages the number of times this resultset is used, defaults to 1
* @return a mocked ResultSet
*/
@JvmStatic
@JvmOverloads
fun addGenerated(tag: String, usages: Int = 1) {
MockSQLBuilderProvider.addResultSet(createGenerated(tag, usages))
}
/**
* Creates the mock ResultSet.
*
* @param columnNames the names of the columns
* @param data the data to be returned from the mocked ResultSet
* @param usages the number of times this resultset is used, defaults to 1
* @return a mocked ResultSet
* @throws SQLException if building the mocked ResultSet fails
*/
@JvmStatic
@JvmOverloads
@Throws(SQLException::class)
fun create(tag: String, columnNames: Array?, data: Array>, usages: Int = 1): ResultSet {
return MockResultSet(tag, columnNames, data, usages)
}
/**
* Adds a mock ResultSet object to the queue.
*
* @param columnNames the names of the columns
* @param data the data to be returned from the mocked ResultSet
* @param usages the number of times this resultset is used, defaults to 1
*/
@JvmStatic
@JvmOverloads
fun add(tag: String, columnNames: Array?, data: Array>, usages: Int = 1) {
MockSQLBuilderProvider.addResultSet(create(tag, columnNames, data, usages))
}
/**
* Creates the mock ResultSet.
*
* @param data the data to be returned from the mocked ResultSet
* @return a mocked ResultSet
* @throws SQLException if building the mocked ResultSet fails
*/
@JvmStatic
@Throws(SQLException::class)
fun create(tag: String, data: Array>): ResultSet {
return MockResultSet(tag, null, data)
}
/**
* Adds a mock ResultSet object to the queue.
*
* @param data the data to be returned from the mocked ResultSet
*/
@JvmStatic
fun add(tag: String, data: Array>) {
val rs = create(tag, data)
MockSQLBuilderProvider.addResultSet(rs)
}
/**
* Creates the mock ResultSet.
*
* @param csv the data to be returned from the mocked ResultSet
* @return a mocked ResultSet
* @throws SQLException if building the mocked ResultSet fails
*/
@JvmStatic
@JvmOverloads
@Throws(SQLException::class)
fun create(tag: String, csv: String, withLabels: Boolean, generated: Boolean = false): ResultSet {
try {
CSVReader(StringReader(csv)).use { csvReader ->
val data: MutableList> = csvReader.readAll()
val columnNames = if (withLabels) data.removeAt(0).map { it!! }.toTypedArray() else null
return MockResultSet(tag, columnNames, data.toTypedArray() as Array>).apply {
this.autoGenerated = generated
}
}
} catch (ex: IOException) {
logger.error("Cannot parse CSV {}", csv)
throw SQLException("Invalid data")
} catch (ex: CsvException) {
logger.error("Cannot parse CSV {}", csv)
throw SQLException("Invalid data")
}
}
/**
* Adds a mock ResultSet object to the queue.
*
* @param csv the data to be returned from the mocked ResultSet
*/
@JvmStatic
fun add(tag: String, csv: String, withLabels: Boolean) {
MockSQLBuilderProvider.addResultSet(create(tag, csv, withLabels, false))
}
/**
* Creates the mock ResultSet.
*
* @param csv A CSV file containing the data, optionally with a header line
* @return a mocked ResultSet
* @throws SQLException in case of errors
*/
@JvmStatic
@Throws(SQLException::class)
fun create(tag: String, csv: InputStream, withLabels: Boolean): ResultSet {
try {
CSVReader(InputStreamReader(csv)).use { csvReader ->
val data = csvReader.readAll()
val columnNames = if (withLabels) data.removeAt(0) else null
return MockResultSet(tag, columnNames, data.toTypedArray() as Array>)
}
} catch (ex: Exception) {
logger.error("Cannot parse CSV {}", csv)
throw SQLException("Invalid data")
}
}
/**
* Adds a mock ResultSet object to the queue.
*
* @param csv A CSV file containing the data, optionally with a header line
*/
@JvmStatic
@JvmOverloads
fun add(tag: String, csv: InputStream, withLabels: Boolean = true) {
MockSQLBuilderProvider.addResultSet(create(tag, csv, withLabels))
}
/**
* Creates the mock ResultSet.
*
* @param csvs the data to be returned from the mocked ResultSet
* @return a mocked ResultSet
* @throws SQLException if building the mocked ResultSet fails
*/
@JvmStatic
@Throws(SQLException::class)
fun create(tag: String, labels: String, vararg csvs: String): ResultSet {
try {
CSVReader(StringReader(labels)).use { csvReader1 ->
val columnNames = csvReader1.readNext()
val data = mutableListOf>()
for (csv in csvs) {
CSVReader(StringReader(csv)).use { csvReader2 -> data.addAll(csvReader2.readAll()) }
}
return MockResultSet(tag, columnNames, data.toTypedArray() as Array>)
}
} catch (ex: IOException) {
logger.error("Cannot parse CSV {}", listOf(*csvs))
throw SQLException("Invalid data")
} catch (ex: CsvException) {
logger.error("Cannot parse CSV {}", listOf(*csvs))
throw SQLException("Invalid data")
}
}
/**
* Adds a mock ResultSet object to the queue.
*
* @param csvs the data to be returned from the mocked ResultSet
*/
@JvmStatic
fun add(tag: String, labels: String, vararg csvs: String) {
MockSQLBuilderProvider.addResultSet(create(tag, labels, *csvs))
}
/**
* Creates an empty mock ResultSet.
*
* @return a mocked ResultSet
* @throws SQLException if building the mocked ResultSet fails
*/
@JvmStatic
@Throws(SQLException::class)
fun empty(tag: String): ResultSet {
return MockResultSet(tag, arrayOf(), arrayOf(), 0)
}
/**
* Creates an empty mock ResultSet.
*
* @return a mocked ResultSet
*/
@JvmStatic
fun addEmpty(tag: String) {
MockSQLBuilderProvider.addResultSet(empty(tag))
}
@JvmStatic
@Throws(SQLException::class)
fun broken(tag: String): ResultSet {
return MockResultSet(tag, arrayOf(), arrayOf(), -1)
}
@JvmStatic
fun addBroken(tag: String) {
MockSQLBuilderProvider.addResultSet(broken(tag))
}
}
init {
this.tag = tag.ifEmpty { "MockResultSet#${counter.incrementAndGet()}" }
val columnNames: Array = if (names.isNullOrEmpty()) {
Array(data.getOrNull(0)?.size ?: 0) { i: Int -> "COLUMN${i + 1}" }
} else {
names
}
columnIndices = columnNames.mapIndexed { i, n -> n.uppercase() to i }.toMap()
}
}
