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

License:Apache License

/**
 * ?workflow <p>/*from ww w .j  a  v  a2s  . co  m*/
 *
 * @param parameter
 * @return sql ?
 */
public String deleteById(Map<String, Object> parameter) {
    return new SQL() {
        {
            DELETE_FROM(TABLE_NAME);

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

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

License:Apache License

/**
 * ? owner ?//from   ww  w .j a v  a2  s . c om
 *
 * @param parameter
 * @return
 */
public String queryFlowOwner(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("u.id, u.name, u.email");

            FROM(TABLE_NAME + " as f");

            INNER_JOIN("user as u on u.id = f.owner");

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

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

License:Apache License

/**
 * ??//w  ww.  jav  a 2  s . c o  m
 *
 * @param parameter
 * @return
 */
public String updateProjectConf(Map<String, Object> parameter) {
    String queue = parameter.get("queue").toString();
    String desc = parameter.get("proxyUser").toString();

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

            if (!StringUtils.isEmpty(queue)) {
                SET("`queue`=#{queue}");
            }

            if (!StringUtils.isEmpty(desc)) {
                SET("proxy_user=#{proxyUser}");
            }

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

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

License:Apache License

/**
 * ?//from w ww.  ja v a 2 s. co  m
 *
 * @param parameter
 * @return
 */
public String countProjectFlows(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.ProjectMapperProvider.java

License:Apache License

/**
 * ??/*w  w w. jav  a 2s.c o m*/
 *
 * @param parameter
 * @return
 */
public String insert(Map<String, Object> parameter) {
    return new SQL() {
        {
            INSERT_INTO(TABLE_NAME);

            VALUES("`name`", "#{newProject.name,jdbcType=VARCHAR}");
            VALUES("`desc`", "#{newProject.desc}");
            VALUES("`create_time`", "#{newProject.createTime}");
            VALUES("`modify_time`", "#{newProject.modifyTime}");
            VALUES("`owner`", "#{newProject.ownerId}");
        }
    }.toString();
}

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

License:Apache License

/**
 * ?//from  w  w w  . j  a v  a  2s.com
 *
 * @param parameter
 * @return
 */
public String updateById(Map<String, Object> parameter) {
    return new SQL() {
        {
            UPDATE(TABLE_NAME);

            SET("`desc`=#{project.desc}");
            SET("`modify_time`=#{project.modifyTime}");

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

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

License:Apache License

/**
 * ?/*from w w w . jav a  2s .  co m*/
 *
 * @param parameter
 * @return
 */
public String deleteById(Map<String, Object> parameter) {
    return new SQL() {
        {
            DELETE_FROM(TABLE_NAME);

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

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

License:Apache License

/**
 * /*from   w  w  w  . j  a v  a  2s.com*/
 *
 * @param parameter
 * @return
 */
public String queryAllProject(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("p.owner as owner_id");
            SELECT("u.name as owner");
            SELECT("p.*");

            FROM(TABLE_NAME + " p");

            LEFT_OUTER_JOIN("user u on p.owner = u.id");
        }
    }.toString();
}

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

License:Apache License

/**
 * ? id /*from  w  w  w .  ja v  a  2  s  .com*/
 *
 * @param parameter
 * @return
 */
public String queryProjectByUser(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("p.owner as owner_id");
            SELECT("u.name as owner");
            SELECT("p.*");

            FROM(TABLE_NAME + " p");

            LEFT_OUTER_JOIN("project_user p_u on p.id = p_u.project_id");
            JOIN("user u on p.owner = u.id");

            WHERE("p_u.user_id = #{userId} or p.owner = #{userId}");
        }
    }.toString();
}

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

License:Apache License

/**
 * ???/*from   w w w .ja va 2 s. c  o m*/
 *
 * @param parameter
 * @return
 */
public String queryByName(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("p.owner as owner_id");
            SELECT("u.name as owner");
            SELECT("p.*");

            FROM(TABLE_NAME + " p");

            JOIN("user u on p.owner = u.id");

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