nbcp.myoql.db.sql.extend.SingleSqlData_Extend.kt Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of ktmyoql Show documentation
kotlin orm -- mysql,mongo , just like ktorm
The newest version!
@file:JvmName("MyOqlSql")
@file:JvmMultifileClass

package nbcp.myoql.db.sql.extend

import nbcp.base.comm.*
import nbcp.base.db.*
import nbcp.base.enums.*
import nbcp.base.extend.*
import nbcp.base.utils.*
import nbcp.myoql.db.*
import nbcp.myoql.db.comm.*
import nbcp.myoql.db.enums.*
import nbcp.myoql.db.sql.base.*
import nbcp.myoql.db.sql.component.*
import nbcp.myoql.db.sql.extend.*
import java.io.Serializable


fun SqlParameterData.toWhereData(): WhereData {
    return WhereData(this.expression, this.values);
}

//fun SingleSqlData.toColumnsData(): ColumnsData {
//    return ColumnsData(this.expression, this.values)
//}

//fun SqlColumnNames.toSelectSql(): String =
//    this.map {
//        if (it.getAliasName() == it.name) it.fullName
//        else
//            it.fullName + " as " + db.sql.getSqlQuoteName(it.getAliasName())
//    }.joinToString(",")


infix fun SqlColumnName.and(next: SqlColumnName): SqlColumnNames {
    return SqlColumnNames(this, next)
}

infix fun SqlColumnNames.and(next: SqlColumnName): SqlColumnNames {
    this.add(next)
    return this;
}

//val SqlColumnName.asc: SqlOrderBy
//    get() = SqlOrderBy(true, SingleSqlData(this.fullName));// this.toSingleSqlData())
//
//val SqlColumnName.desc: SqlOrderBy
//    get() = SqlOrderBy(false, SingleSqlData(this.fullName))


//fun SqlColumnName.ifNull(elseValue: SingleSqlData, alias: String = ""): SingleSqlData {
//    return SingleSqlData(
//        "ifNull(${this.fullName},${elseValue.expression}) as ${alias.AsString(this.getAliasName())}",
//        elseValue.values
//    )
//}


data class CaseWhenData, T : Serializable>(var mainEntity: M) :
    Serializable {
    private val caseWhens = mutableListOf>()
    private lateinit var elseEnd: Pair

    fun whenThen(caseWhen: (M) -> WhereData, then: BaseAliasSqlSect): CaseWhenData {
        this.caseWhens.add(caseWhen(this.mainEntity) to then)
        return this;
    }

    fun elseEnd(elseEnd: BaseAliasSqlSect, alias: String): SqlParameterData {
        var ret = SqlParameterData();
        ret.expression += "case";

        this.caseWhens.forEach {
            var where = it.first.toSingleData()

            ret.expression += " when "
            ret += where

            ret.expression += " then "
            ret += it.second.toSingleSqlData()
        }

        ret.expression += " else "
        ret += elseEnd.toSingleSqlData()

        ret.expression += " end ${alias}"

        return ret;
    }
}


fun , T : Serializable> M.case(): CaseWhenData {
    return CaseWhenData(this)
}


/**
 * @param index : 从1开始.
 */
//fun PreparedStatement.setValue(index: Int, param: SqlParameterData) {
//    var sqlType = DbType.of(param.type).sqlType
//    if (param.value == null) {
//        this.setNull(index, sqlType)
//        return
//    }
//
//    var value = param.value
//
//    if (sqlType == java.sql.Types.VARCHAR) {
//        this.setString(index, value.AsString())
//        return
//    } else if (sqlType == java.sql.Types.INTEGER) {
//        this.setInt(index, param.value.AsInt())
//        return
//    } else if (sqlType == java.sql.Types.BIGINT) {
//        this.setLong(index, param.value.AsLong())
//        return
//    } else if (sqlType == java.sql.Types.SMALLINT) {
//        this.setShort(index, param.value.AsInt().toShort())
//        return
//    } else if (sqlType == java.sql.Types.TINYINT) {
//        this.setByte(index, param.value.AsInt().toByte())
//        return
//    } else if (sqlType == java.sql.Types.BIT) {
//        this.setByte(index, param.value.AsInt().toByte())
//        return
//    } else if (sqlType == java.sql.Types.TIMESTAMP) {
//        var v = param.value.AsLocalDateTime()
//        if (v == null) {
//            this.setTimestamp(index, null);
//        } else {
//            this.setTimestamp(index, java.sql.Timestamp.valueOf(v))
//        }
//        return
//    } else if (sqlType == java.sql.Types.DATE) {
//        var v = param.value.AsDate()
//        if (v == null) {
//            this.setDate(index, null);
//        } else {
//            this.setDate(index, java.sql.Date(v.time))
//        }
//        return
//    } else if (sqlType == java.sql.Types.TIME) {
//        var v = param.value.AsLocalTime();
//        if (v == null) {
//            this.setTime(index, null);
//        } else {
//            this.setTime(index, java.sql.Time(v.toSecondOfDay() * 1000L))
//        }
//        return
//    } else if (sqlType == java.sql.Types.FLOAT) {
//        this.setFloat(index, param.value.AsFloat())
//        return
//    } else if (sqlType == java.sql.Types.DOUBLE) {
//        this.setDouble(index, param.value.AsDouble())
//        return
//    } else if (sqlType == java.sql.Types.DECIMAL) {
//        this.setBigDecimal(index, param.value.AsBigDecimal())
//        return
//    }
//
//    throw RuntimeException("不识别的数据类型:${index} , ${sqlType}")
//}


val SqlBaseMetaTable.quoteTableName: String
    get() = "${db.sql.getSqlQuoteName(this.tableName)}"

/**
 * 如果有别名，返回： table as t
 * 否则返回   table
 */
val SqlBaseMetaTable.fromTableName: String
    get() {
        var ret = "${db.sql.getSqlQuoteName(this.tableName)}"
        if (this.getAliaTableName().HasValue && (this.getAliaTableName() != this.tableName)) {
            ret += " as " + db.sql.getSqlQuoteName(this.getAliaTableName());
        }
        return ret;
    }