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.ResourceMapperProvider.java

License:Apache License

/**
 * ?//www  .  j a v  a  2s . c o  m
 *
 * @param parameter
 * @return
 */
public String update(Map<String, Object> parameter) {
    return new SQL() {
        {
            UPDATE(TABLE_NAME);

            SET("`origin_filename` = #{resource.originFilename}");
            SET("`desc` = #{resource.desc}");
            SET("`owner` = #{resource.ownerId}");
            SET("`origin_filename` = #{resource.originFilename}");
            SET("`modify_time` = #{resource.modifyTime}");

            WHERE("`id` = #{resource.id}");
        }
    }.toString();
}

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

License:Apache License

/**
 * ?? id //from   ww w .ja  va 2s  . co m
 *
 * @param parameter
 * @return
 */
public String delete(Map<String, Object> parameter) {
    return new SQL() {
        {
            DELETE_FROM(TABLE_NAME);

            WHERE("`id` = #{resourceId}");
        }
    }.toString();
}

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

License:Apache License

/**
 * ?/*from w  w w .j  a  v a 2s  . c  o m*/
 *
 * @param parameter
 * @return
 */
public String deleteResource(Map<String, Object> parameter) {
    return new SQL() {
        {
            DELETE_FROM(TABLE_NAME);

            WHERE("`project_id` = #{project_id}");
            WHERE("`name` = #{name}");
        }
    }.toString();
}

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

License:Apache License

/**
 * ?/*w  w  w.j av  a 2 s.co m*/
 *
 * @param parameter
 * @return
 */
public String queryResourceDetail(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("u.name as owner_name, p.name as project_name");
            SELECT("r.*");

            FROM(TABLE_NAME + " r");

            JOIN("user as u on u.id = r.owner");
            JOIN("project p on r.project_id = p.id");

            WHERE("r.project_id = #{projectId} and r.name = #{name}");
        }
    }.toString();
}

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

License:Apache License

/**
 * ?/* w  w  w.  ja v a  2 s.  c  o m*/
 *
 * @param parameter
 * @return
 */
public String queryResourceDetails(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("u.name as owner_name, p.name as project_name");
            SELECT("r.*");

            FROM(TABLE_NAME + " r");

            JOIN("user as u on u.id = r.owner");
            JOIN("project p on r.project_id = p.id");

            WHERE("p.project_id = #{projectId}");
        }
    }.toString();
}

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

License:Apache License

/**
 * ?//w  w  w  .  j  a  v a 2s. c o m
 * @param parameter
 * @return
 */
public String countProjectRes(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("count(0)");

            FROM(TABLE_NAME);

            WHERE("project_id = #{projectId}");
        }
    }.toString();
}

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

License:Apache License

public String insert(Map<String, Object> parameter) {
    return new SQL() {
        {//from  w  w w  . jav  a 2  s. co m
            INSERT_INTO(DB_NAME);

            VALUES("`flow_id`", "#{schedule.flowId}");
            VALUES("`start_date`", "#{schedule.startDate}");
            VALUES("`end_date`", "#{schedule.endDate}");
            VALUES("`crontab`", "#{schedule.crontab}");
            VALUES("`dep_workflows`", "#{schedule.depWorkflowsStr}");
            VALUES("`dep_policy`", EnumFieldUtil.genFieldStr("schedule.depPolicy", DepPolicyType.class));
            VALUES("`failure_policy`",
                    EnumFieldUtil.genFieldStr("schedule.failurePolicy", FailurePolicyType.class));
            VALUES("`max_try_times`", "#{schedule.maxTryTimes}");
            VALUES("`notify_type`", EnumFieldUtil.genFieldStr("schedule.notifyType", NotifyType.class));
            VALUES("`notify_mails`", "#{schedule.notifyMailsStr}");
            VALUES("`timeout`", "#{schedule.timeout}");
            VALUES("`create_time`", "#{schedule.createTime}");
            VALUES("`modify_time`", "#{schedule.modifyTime}");
            VALUES("`owner`", "#{schedule.ownerId}");
            VALUES("`schedule_status`",
                    EnumFieldUtil.genFieldStr("schedule.scheduleStatus", ScheduleStatus.class));
        }
    }.toString();
}

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

License:Apache License

public String update(Map<String, Object> parameter) {
    return new SQL() {
        {//from w ww .j  a va 2s  .c  o m
            UPDATE(DB_NAME);

            SET("`start_date`=#{schedule.startDate}");
            SET("`end_date`=#{schedule.endDate}");
            SET("`crontab`=#{schedule.crontab}");
            SET("`dep_workflows`=#{schedule.depWorkflowsStr}");
            SET("`dep_policy`=" + EnumFieldUtil.genFieldStr("schedule.depPolicy", DepPolicyType.class));
            SET("`failure_policy`="
                    + EnumFieldUtil.genFieldStr("schedule.failurePolicy", FailurePolicyType.class));
            SET("`max_try_times`=#{schedule.maxTryTimes}");
            SET("`notify_type`=" + EnumFieldUtil.genFieldStr("schedule.notifyType", NotifyType.class));
            SET("`notify_mails`=#{schedule.notifyMailsStr}");
            SET("`timeout`=#{schedule.timeout}");
            SET("`create_time`=#{schedule.createTime}");
            SET("`modify_time`=#{schedule.modifyTime}");
            SET("`owner`=#{schedule.ownerId}");
            SET("`schedule_status`="
                    + EnumFieldUtil.genFieldStr("schedule.scheduleStatus", ScheduleStatus.class));

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

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

License:Apache License

public String selectByFlowId(Map<String, Object> parameter) {
    return new SQL() {
        {/*from   w ww  . java 2 s.co  m*/
            SELECT("p_f.name as project_flow_name");
            SELECT("p.name as project_name");
            SELECT("u.name as owner_name");
            SELECT("s.*");

            FROM(DB_NAME + " as s");

            JOIN("project_flows as p_f on s.flow_id = p_f.id");
            JOIN("project as p on p_f.project_id = p.id");
            JOIN("user as u on s.owner = u.id");

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

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

License:Apache License

public String selectByProject(Map<String, Object> parameter) {
    return new SQL() {
        {//from   w w w .j  a v a  2s.c o  m
            SELECT("p_f.name as workflow_name");
            SELECT("p_f.desc as `desc`");
            SELECT("p.name as project_name");
            SELECT("u.name as owner_name");
            SELECT("s.*");

            FROM(DB_NAME + " as s");

            JOIN("project_flows as p_f on s.flow_id = p_f.id");
            JOIN("project as p on p_f.project_id = p.id");
            JOIN("user as u on s.owner = u.id");

            WHERE("p.name = #{projectName}");
        }
    }.toString();
}