nbcp.myoql.db.sql.define.SqlSect.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.define


import nbcp.myoql.db.sql.enums.SqlKeyEnum

/**
 * Sql片断基类
 */
open abstract class SqlBaseSect @JvmOverloads constructor(
    val key: SqlKeyEnum,
    var expression: String = ""
) {
}


/**
 * Select 片断
 */
class SelectSqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.SELECT, expression) {
    var columns = mutableListOf()
}

/**
 * From 片断
 */
class FromSqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.FROM, expression) {
    var tableName = ""
    var alias = ""
}

/**
 * Join 片断
 */
class JoinSqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.JOIN, expression) {
    var tableName = ""
    var alias = ""
    var onWhere: WhereSqlSect? = null
}

/**
 * Where 片断
 */
class WhereSqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.WHERE, expression) {
    var column: String = "";
    var op: String = "";
    var value: String = "";

    var linker: String = ""
    var child: WhereSqlSect? = null;
    var next : WhereSqlSect? = null
    //额外的 tables,如 in 语句。
    var extra_tables = mutableListOf()
}

/**
 * GroupBy片断
 */
class GroupBySqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.GROUP_BY, expression) {
    var columns = mutableListOf()
}

/**
 * OrderBy片断
 */
class OrderBySqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.ORDER_BY, expression) {
    var groups = mutableListOf()
}

/**
 * Having 片断
 */
class HavingSqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.HAVING, expression) {
    var where: WhereSqlSect? = null
}

/**
 * limit 片断
 */
class LimitSqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.LIMIT, expression) {
    var skip = ""
    var take = ""
}

/**
 * offset 片断
 */
class OffsetSqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.OFFSET, expression) {
    var skip = ""
    var take = ""
}

/**
 * with 片断
 */
class WithSqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.WITH, expression) {
    var name = ""
    var columns = mutableListOf()
    var asSelect: SelectSqlSect? = null

    var next: WithSqlSect? = null
}

/**
 * call 片断
 */
class CallSqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.CALL, expression) {
    var name = ""
    var parameters = mutableListOf()
}

/**
 * into 片断
 */
class IntoSqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.INTO, expression) {
    var name = ""
}

/**
 * insert 片断
 */
class InsertSqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.INSERT, expression) {
    var tableName = ""
    var columns = mutableListOf()
}

/**
 * values 片断
 */
class ValuesSqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.VALUES, expression) {
    var values = mutableListOf()

    var next: ValuesSqlSect? = null
}

/**
 * update 片断
 */
class UpdateSqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.UPDATE, expression) {
    var tableName = ""
    var alias = ""
}

/**
 * set 片断
 */
class SetSqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.SET, expression) {
    var column = ""
    var value = ""
    var next: SetSqlSect? = null
}

/**
 * delete 片断
 */
class DeleteSqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.DELETE, expression) {
    var tableName = ""
    var alias = ""
}

/**
 * union 片断
 */
class UnionSqlSect @JvmOverloads constructor(expression: String = "") : SqlBaseSect(SqlKeyEnum.UNION, expression) {
}