• Home
• net.oschina.durcframework
• fastmybatis-core
• 2.11.0
• source code
• microsoftsqlserver.vm

×

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.

fastmybatis.tpl.microsoftsqlserver.vm Maven / Gradle / Ivy

#set($jq="$")



    
        #foreach($column in $allColumns)
            
        #end
        #foreach($association in $associations)
            
        #end
    

    
        
            ORDER BY ${query.order}
            ORDER BY t.[${pk.columnName}]
        
    

    
    
        #set ($i=0)
        #foreach($column in $columns)
            #if($i > 0),#end t.[${column.columnName}]
            #set($i=$i +1)
        #end
    

    
    
        
            
                SELECT t0.* FROM (
                SELECT row_number() over(
                
                ) _row_number,
            
            SELECT
        

        

        FROM ${table.tableName} t
        
        
            
            #if(${table.hasLogicDeleteColumn})
                
                    AND t.${table.logicDeleteColumn.columnName} ${table.logicDeleteColumn.logicNotDeleteValueExpression}
                
            #end
        
        
            
        
        
            ) t0 WHERE t0._row_number BETWEEN (#{query.start,jdbcType=INTEGER} + 1) AND
            (#{query.start,jdbcType=INTEGER} + #{query.limit,jdbcType=INTEGER})
        
    

    
        
            
                SELECT t0.* FROM (
                SELECT row_number() over(
                
                ) _row_number,
            
            SELECT
        

        
            ${column}
        
        FROM ${table.tableName} t
        
        
            
            #if(${table.hasLogicDeleteColumn})
                
                    AND t.${table.logicDeleteColumn.columnName} ${table.logicDeleteColumn.logicNotDeleteValueExpression}
                
            #end
        
        
            
        
        
            ) t0 WHERE t0._row_number BETWEEN (#{query.start,jdbcType=INTEGER} + 1) AND
            (#{query.start,jdbcType=INTEGER} + #{query.limit,jdbcType=INTEGER})
        
    

    
    
        
            
                SELECT t0.* FROM (
                SELECT row_number() over(
                
                ) _row_number,
            
            SELECT
        

        
            ${column}
        
        FROM ${table.tableName} t
        
        
            
            #if(${table.hasLogicDeleteColumn})
                
                    AND t.${table.logicDeleteColumn.columnName} ${table.logicDeleteColumn.logicNotDeleteValueExpression}
                
            #end
        
        
            
        
        
            ) t0 WHERE t0._row_number BETWEEN (#{query.start,jdbcType=INTEGER} + 1) AND
            (#{query.start,jdbcType=INTEGER} + #{query.limit,jdbcType=INTEGER})
        
    

    
    
        SELECT ${countExpression} FROM [${table.tableName}] t
        
        
            
            #if(${table.hasLogicDeleteColumn})
                
                    AND t.${table.logicDeleteColumn.columnName} ${table.logicDeleteColumn.logicNotDeleteValueExpression}
                
            #end
        
    

    
    
        SELECT TOP 1
        
        FROM [${table.tableName}] t
        WHERE t.[${pk.columnName}] = #{value}
        #if(${table.hasLogicDeleteColumn})
            AND t.${table.logicDeleteColumn.columnName} ${table.logicDeleteColumn.logicNotDeleteValueExpression}
        #end
    

    
    
        SELECT TOP 1
        
        FROM [${table.tableName}] t
        
        
            
            #if(${table.hasLogicDeleteColumn})
                
                    AND t.${table.logicDeleteColumn.columnName} ${table.logicDeleteColumn.logicNotDeleteValueExpression}
                
            #end
        
        
    

    
    
        SELECT TOP 1
        
        FROM ${table.tableName} t
        WHERE t.[${jq}{column}] = #{value}
        #if(${table.hasLogicDeleteColumn})
            AND t.${table.logicDeleteColumn.columnName} ${table.logicDeleteColumn.logicNotDeleteValueExpression}
        #end
    

    
    
        SELECT
        
        FROM [${table.tableName}] t
        WHERE t.[${jq}{column}] = #{value}
        #if(${table.hasLogicDeleteColumn})
            AND t.${table.logicDeleteColumn.columnName} ${table.logicDeleteColumn.logicNotDeleteValueExpression}
        #end
    

    
    
        #if(${pk.isUuid})
            
                SELECT NEWID()
            
        #end
        #if(${pk.isCustomIdFill})
            
                SELECT ${pk.customIdTypeHandlerValue}
            
        #end
        INSERT INTO [${table.tableName}]
        (
        #set ($i=0)
        #foreach($column in $columns)
            #if(${column.isInsertColumn})
                #if($i > 0),#end [${column.columnName}]
                #set($i=$i +1)
            #end
        #end
        )
        VALUES (
        #set ($i=0)
        #foreach($column in $columns)
            #if(${column.isInsertColumn})
                #if($i > 0),#end ${column.mybatisInsertValue}
                #set($i=$i +1)
            #end
        #end

        )
    

    
    
        #if(${pk.isUuid})
            
                SELECT NEWID()
            
        #end
        #if(${pk.isCustomIdFill})
            
                SELECT ${pk.customIdTypeHandlerValue}
            
        #end
        INSERT INTO [${table.tableName}]

        
            #foreach($column in $columns)
                #if(${column.isCustomFill})
                    [${column.columnName}],
                #elseif(${column.isInsertColumn})
                    
                        [${column.columnName}],
                    
                #end
            #end
        
        
            #foreach($column in $columns)
                #if(${column.isCustomFill})
                    ${column.mybatisInsertValue},
                #elseif(${column.isInsertColumn})
                    
                        ${column.mybatisInsertValue},
                    
                #end
            #end
        
    

    
    
        INSERT INTO [${table.tableName}]
        
        #foreach($column in $columns)
            #if(${column.isInsertColumn})
                [${column.columnName}],
            #end
        #end
        
        VALUES
        
            
            #foreach($column in $columns)
                #if(${column.isInsertColumn})
                    ${column.mybatisInsertValuePrefix},
                #end
            #end
            
        
    

    
    
        INSERT INTO [${table.tableName}]
        
            #foreach($column in $columns)
                
                    [${column.columnName}],
                
            #end
        
        VALUES
        
            
                #foreach($column in $columns)
                    
                        ${column.mybatisInsertValuePrefix},
                    
                #end
            
        
    

    
    
        INSERT INTO [${table.tableName}]
        
        #foreach($column in $columns)
            #if(${column.isInsertColumn})
                [${column.columnName}],
            #end
        #end
        
        
            SELECT
            
                #foreach($column in $columns)
                    #if(${column.isInsertColumn})
                        ${column.mybatisInsertValuePrefix},
                    #end
                #end
            
        
    

    
    
        UPDATE [${table.tableName}]
        
            #foreach($column in $columns)
                #if(${column.isUpdateColumn})
                    [${column.columnName}]=${column.mybatisUpdateValue},
                #end
            #end
        
        WHERE [${pk.columnName}] = #{${pk.javaFieldName}}
        #if(${table.hasVersionColumn})
            AND [${table.versionColumn.columnName}] = #{${table.versionColumn.javaFieldName}}
        #end
    

    
    
        UPDATE [${table.tableName}]
        
            #foreach($column in $columns)
                #if(${column.isCustomFillUpdate})
                    [${column.columnName}]=${column.mybatisUpdateValue},
                #elseif(${column.isUpdateColumn})
                    
                        [${column.columnName}]=${column.mybatisUpdateValue},
                    
                #end
            #end
        
        WHERE [${pk.columnName}] = #{${pk.javaFieldName}}
        #if(${table.hasVersionColumn})
            AND [${table.versionColumn.columnName}] = #{${table.versionColumn.javaFieldName}}
        #end
    

    
    
        UPDATE ${table.tableName}
        
            #foreach($column in $columns)
                #if(${column.isUpdateColumn})
                    #if(${column.hasTypeHandlerUpdate})
                        ${column.columnName}=${column.mybatisUpdateValuePrefix},
                    #else
                        
                          
                            ${column.columnName}=${column.mybatisUpdateValuePrefix},
                          
                        
                    #end
                #end
            #end
        
        
        #if(${table.hasLogicDeleteColumn})
            
                AND ${table.logicDeleteColumn.columnName} ${table.logicDeleteColumn.logicNotDeleteValueExpression}
            
        #end
    

    
    
        UPDATE ${table.tableName}
        
            
                ${key} = #{entity[${key}]}
            
        
        
    

    
        #if(${table.hasLogicDeleteColumn})
        
            UPDATE ${table.tableName}
            
                #foreach($column in $columns)
                    #if(${column.isPk})
                    #elseif(${column.isLogicDelete})
                        #if($column.logicDeleteStrategy == 'fixed_value')
                            ${table.logicDeleteColumn.columnName} = ${table.logicDeleteColumn.logicDeleteValueString},
                        #elseif($column.logicDeleteStrategy == 'id_fill')
                            ${table.logicDeleteColumn.columnName} = ${pk.columnName},
                        #end
                    #end
                #end
            
            WHERE ${pk.columnName} = #{${pk.javaFieldName}}
            AND ${table.logicDeleteColumn.columnName} ${table.logicDeleteColumn.logicNotDeleteValueExpression}
            #if(${table.hasVersionColumn})
                AND ${table.versionColumn.columnName} = #{${table.versionColumn.javaFieldName}}
            #end
        
        #else
        
            DELETE FROM ${table.tableName}
            WHERE ${pk.columnName} = #{${pk.javaFieldName}}
        
        #end

    
        #if(${table.hasLogicDeleteColumn})
        
            UPDATE ${table.tableName}
            
                #foreach($column in $columns)
                    #if(${column.isPk})
                    #elseif(${column.isLogicDelete})
                        #if($column.logicDeleteStrategy == 'fixed_value')
                            ${table.logicDeleteColumn.columnName} = ${table.logicDeleteColumn.logicDeleteValueString},
                        #elseif($column.logicDeleteStrategy == 'id_fill')
                            ${table.logicDeleteColumn.columnName} = ${pk.columnName},
                        #end
                    #end
                #end
            
            WHERE ${pk.columnName} = #{value}
            AND ${table.logicDeleteColumn.columnName} ${table.logicDeleteColumn.logicNotDeleteValueExpression}
            #if(${table.hasVersionColumn})
                AND ${table.versionColumn.columnName} = #{${table.versionColumn.javaFieldName}}
            #end
        
        #else
        
            DELETE FROM ${table.tableName}
            WHERE ${pk.columnName} = #{value}
        
        #end


    
    #if(${table.hasLogicDeleteColumn})
        
            
                
                    DELETE FROM ${table.tableName}
                    
                
                
                    UPDATE ${table.tableName}
                    
                        #foreach($column in $columns)
                            #if(${column.isPk})
                            #elseif(${column.isLogicDelete})
                                #if($column.logicDeleteStrategy == 'fixed_value')
                                    ${table.logicDeleteColumn.columnName} = ${table.logicDeleteColumn.logicDeleteValueString},
                                #elseif($column.logicDeleteStrategy == 'id_fill')
                                    ${table.logicDeleteColumn.columnName} = ${pk.columnName},
                                #end
                            #end
                        #end
                        
                            
                                ${block.columnName} = #{block.value},
                            
                        
                    
                    
                    AND ${table.logicDeleteColumn.columnName} ${table.logicDeleteColumn.logicNotDeleteValueExpression}
                
            
        
    #else
        
            DELETE FROM ${table.tableName}
            
        
    #end