Example usage for org.apache.ibatis.jdbc SQL SQL

Introduction

In this page you can find the example usage for org.apache.ibatis.jdbc SQL SQL.

Prototype

SQL

Source Link

Usage

From source file:com.baifendian.swordfish.dao.mapper.ExecutionNodeMapperProvider.java

License:Apache License

/**
 * @param parameter//from ww  w. ja  v a 2s  . com
 * @return
 */
public String insert(Map<String, Object> parameter) {
    return new SQL() {
        {
            INSERT_INTO(TABLE_NAME);

            VALUES("exec_id", "#{executionNode.execId}");
            VALUES("name", "#{executionNode.name}");
            VALUES("start_time", "#{executionNode.startTime}");
            VALUES("end_time", "#{executionNode.endTime}");
            VALUES("attempt", "#{executionNode.attempt}");
            VALUES("app_links", "#{executionNode.appLinks}");
            VALUES("job_links", "#{executionNode.jobLinks}");
            VALUES("job_id", "#{executionNode.jobId}");
            VALUES("status", EnumFieldUtil.genFieldStr("executionNode.status", FlowStatus.class));
        }
    }.toString();
}

From source file:com.baifendian.swordfish.dao.mapper.ExecutionNodeMapperProvider.java

License:Apache License

/**
 * @param parameter/*from  w ww  .  ja va2 s.c o m*/
 * @return
 */
public String update(Map<String, Object> parameter) {
    ExecutionNode executionNode = (ExecutionNode) parameter.get("executionNode");

    return new SQL() {
        {
            UPDATE(TABLE_NAME);

            if (executionNode.getAttempt() != null) {
                SET("attempt = #{executionNode.attempt}");
            }

            if (executionNode.getEndTime() != null) {
                SET("end_time = #{executionNode.endTime}");
            }

            if (executionNode.getStatus() != null) {
                SET("status = " + EnumFieldUtil.genFieldStr("executionNode.status", FlowStatus.class));
            }

            if (StringUtils.isNotEmpty(executionNode.getAppLinks())) {
                SET("app_links = #{executionNode.appLinks}");
            }

            if (StringUtils.isNotEmpty(executionNode.getJobLinks())) {
                SET("job_links = #{executionNode.jobLinks}");
            }

            WHERE("exec_id = #{executionNode.execId}");
            WHERE("name = #{executionNode.name}");
        }
    }.toString();
}

From source file:com.baifendian.swordfish.dao.mapper.ExecutionNodeMapperProvider.java

License:Apache License

/**
 * @param parameter/*from   w  ww . j  a v a 2 s  . co m*/
 * @return
 */
public String selectExecNode(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("*");

            FROM(TABLE_NAME);

            WHERE("exec_id = #{execId}");
            WHERE("name = #{name}");
        }
    }.toString();
}

From source file:com.baifendian.swordfish.dao.mapper.ExecutionNodeMapperProvider.java

License:Apache License

/**
 * @param parameter//  www.  ja  v a  2s .c om
 * @return
 */
public String selectExecNodeById(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("*");

            FROM(TABLE_NAME);

            WHERE("exec_id = #{execId}");
        }
    }.toString();
}

From source file:com.baifendian.swordfish.dao.mapper.ExecutionNodeMapperProvider.java

License:Apache License

/**
 * @param parameter/*from www .  j  a  v  a  2 s.  c o m*/
 * @return
 */
public String selectExecNodeByJobId(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("*");

            FROM(TABLE_NAME);

            WHERE("job_id = #{jobId}");
        }
    }.toString();
}

From source file:com.baifendian.swordfish.dao.mapper.ExecutionNodeMapperProvider.java

License:Apache License

/**
 * //  www  .  jav  a2 s .  c  o m
 */
public String deleteExecutionNodes(Map<String, Object> parameter) {
    return new SQL() {
        {
            DELETE_FROM(TABLE_NAME);

            WHERE("exec_id = #{execId}");
        }
    }.toString();
}

From source file:com.baifendian.swordfish.dao.mapper.FlowNodeMapperProvider.java

License:Apache License

/**
 * ??/*from   w  w  w .  ja  v  a2s. c  om*/
 *
 * @param parameter
 * @return
 */
public String insert(Map<String, Object> parameter) {
    return new SQL() {
        {
            INSERT_INTO(TABLE_NAME);

            VALUES("`name`", "#{flowNode.name}");
            VALUES("`desc`", "#{flowNode.desc}");
            VALUES("`type`", "#{flowNode.type}");
            VALUES("`flow_id`", "#{flowNode.flowId}");
            VALUES("`parameter`", "#{flowNode.parameter}");
            VALUES("`extras`", "#{flowNode.extras}");
            VALUES("`dep`", "#{flowNode.dep}");
        }
    }.toString();
}

From source file:com.baifendian.swordfish.dao.mapper.FlowNodeMapperProvider.java

License:Apache License

/**
 * ?/*from   www  . ja  v  a  2s .  com*/
 *
 * @param parameter
 * @return
 */
public String deleteByFlowId(Map<String, Object> parameter) {
    return new SQL() {
        {
            DELETE_FROM(TABLE_NAME);

            WHERE("flow_id = #{flowId}");
        }
    }.toString();
}

From source file:com.baifendian.swordfish.dao.mapper.FlowNodeMapperProvider.java

License:Apache License

/**
 * ? flow id /*from w w w . jav  a 2  s  . c o  m*/
 *
 * @param parameter
 * @return
 */
public String selectByFlowId(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("*");

            FROM(TABLE_NAME);

            WHERE("flow_id = #{flowId}");
        }
    }.toString();
}

From source file:com.baifendian.swordfish.dao.mapper.MasterServerMapperProvider.java

License:Apache License

/**
 *  master ?/*from  w  ww  . ja  v a 2s.com*/
 *
 * @return
 */
public String query() {
    return new SQL() {
        {
            SELECT("*");

            FROM(TABLE_NAME);
        }
    }.toString();
}