nbcp.myoql.db.sql.component.RawExecuteDdlSqlClip.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!

package nbcp.myoql.db.sql.component

import nbcp.base.comm.JsonMap
import nbcp.base.extend.minus
import nbcp.myoql.db.db
import nbcp.myoql.db.sql.base.SqlParameterData
import nbcp.myoql.db.sql.logExec
import org.slf4j.LoggerFactory
import org.springframework.jdbc.core.PreparedStatementCallback
import org.springframework.jdbc.core.namedparam.MapSqlParameterSource
import java.sql.PreparedStatement
import java.time.LocalDateTime


/**
 * 使用 NamedParameterJdbcTemplate 原生执行 ddl sql (create,drop) 不能传参
 */
class RawExecuteDdlSqlClip(var sqlParameter: SqlParameterData, tableName: String) :
    SqlBaseExecuteClip(tableName) {
    companion object {
        private val logger = LoggerFactory.getLogger(this::class.java.declaringClass)
    }

    constructor(sqlWithVar: String, sqlValue: JsonMap = JsonMap(), tableName: String = "")
            : this(SqlParameterData(sqlWithVar, sqlValue), tableName) {

    }

    override fun toSql(): SqlParameterData {
        return this.sqlParameter;
    }


    override fun exec(): Int {
        db.affectRowCount = -1;
        var sql = toSql()
//        var executeData = sql.toExecuteSqlAndParameters();

        val startAt = LocalDateTime.now()

        var n = -1;
        var error: Exception? = null;




        try {
            var ret = jdbcTemplate.execute(
                sql.expression,
                MapSqlParameterSource(sql.values),
                DefaultPreparedStatementCallback()
            )

            if (ret != null && ret) {
                n = 1;
            }
            db.executeTime = LocalDateTime.now() - startAt
        } catch (e: Exception) {
            error = e;
            throw e;
        } finally {
            logger.logExec(error, tableName, sql, n);
        }


        db.affectRowCount = n
        return n
    }
}