• Home
• org.glamey
• scaffold-autocode
• 2.0.5
• source code
• Mapper.ftl

×

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.

template.autocode.Mapper.ftl Maven / Gradle / Ivy

${r''}
${r''}
${r''}
    ${r''}
        INSERT INTO ${classModel.schema!''}.${classModel.tableName!''}
        (
        <#list propertyModelList as model>
            ${model.columnName!''}<#if model_has_next>,
        
        )VALUES(
        <#list propertyModelList as model>
            ${r'#{'}${model.lname!''}${r'}'}<#if model_has_next>,
        
        )
    ${r''}

    ${r''}
        INSERT INTO ${classModel.schema!''}.${classModel.tableName!''}
        (
        <#list propertyModelList as model>
            ${model.columnName!''}<#if model_has_next>,
        
        )VALUES
        ${r''}
        (<#list propertyModelList as model>
            ${r'#{item.'}${model.lname!''}${r'}'}<#if model_has_next>,
         )
        ${r''}
    ${r''}

    ${r''}
        DELETE FROM ${classModel.schema!''}.${classModel.tableName!''} ${r'WHERE id = #{id}'}
    ${r''}

    ${r''}
        DELETE FROM ${classModel.schema!''}.${classModel.tableName!''} ${r'WHERE id IN('}
        ${r''}
            ${r'#{item}'}
        ${r')'}
    ${r''}

    ${r''}
        UPDATE
            ${classModel.schema!''}.${classModel.tableName!''}
        SET
        <#list propertyModelList as model>
            ${model.columnName!''} = ${r'#{'}${model.lname!''}${r'}'}<#if model_has_next>,
        
        ${r'WHERE id = #{id}'}
    ${r''}

    ${r''}
        SELECT
        <#list propertyModelList as model>
            ${model.columnName!''} as ${model.lname!''} <#if model_has_next>,
        
        FROM
            ${classModel.schema!''}.${classModel.tableName!''}
        ${r'WHERE id = #{id}'}
    ${r''}

    ${r''}
        SELECT
            <#list propertyModelList as model>
            ${model.columnName!''} as ${model.lname!''} <#if model_has_next>,
            
        FROM
            ${classModel.schema!''}.${classModel.tableName!''}
        ORDER BY id
        LIMIT ${r'#{offset},#{rowsPerPage}'}
    ${r''}

    ${r''}
        SELECT
        count(*)
        FROM
        ${classModel.schema!''}.${classModel.tableName!''}
    ${r''}
${r''}