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

License:Apache License

/**
 * ?name?/* w w w . j ava2 s  .co  m*/
 *
 * @param parameter
 * @return
 */
public String deleteAdHocByName(Map<String, Object> parameter) {
    return new SQL() {
        {
            DELETE_FROM(TABLE_NAME);
            WHERE("`project_id` = #{projectId}");
            WHERE("`name` = #{name}");
        }
    }.toString();
}

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

License:Apache License

/**
 * ??? <p>/*from   www .j  a va  2s  .co  m*/
 *
 * @return sql?
 */
public String insert(Map<String, Object> parameter) {
    return new SQL() {
        {
            INSERT_INTO(TABLE_NAME);
            VALUES("exec_id", "#{adHocResult.execId}");
            VALUES("`index`", "#{adHocResult.index}");
            VALUES("stm", "#{adHocResult.stm}");
            VALUES("result", "#{adHocResult.result}");
            VALUES("status", EnumFieldUtil.genFieldStr("adHocResult.status", FlowStatus.class));
            VALUES("create_time", "#{adHocResult.createTime}");
        }
    }.toString();
}

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

License:Apache License

/**
 * ?? <p>//from   w w w .j a  va  2s  . c o m
 *
 * @return sql?
 */
public String update(Map<String, Object> parameter) {
    return new SQL() {
        {
            UPDATE(TABLE_NAME);
            SET("result = #{adHocResult.result}");
            SET("start_time = #{adHocResult.startTime}");
            SET("end_time = #{adHocResult.endTime}");
            SET("status = " + EnumFieldUtil.genFieldStr("adHocResult.status", FlowStatus.class));
            WHERE("exec_id = #{adHocResult.execId}");
            WHERE("`index` = #{adHocResult.index}");
        }
    }.toString();
}

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

License:Apache License

public String delete(Map<String, Object> parameter) {
    return new SQL() {
        {/*from  ww w  . j  av  a  2s .c  om*/
            DELETE_FROM(TABLE_NAME);
            WHERE("exec_id = #{execId}");
        }
    }.toString();
}

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

License:Apache License

/**
 * ?? <p>//w w w.j av  a 2 s . c  o m
 *
 * @return sql?
 */
public String selectByAdHocId(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("*");
            FROM(TABLE_NAME);
            WHERE("exec_id = #{execId}");
            ORDER_BY("create_time DESC ");
        }
    }.toString();
}

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

License:Apache License

public String selectByAdHocIdAndIndex(Map<String, Object> parameter) {
    return new SQL() {
        {/*from  w w  w  .  j  a  va2  s  .  c  om*/
            SELECT("*");
            FROM(TABLE_NAME);
            WHERE("exec_id = #{execId}");
            WHERE("`index` = #{index}");
            ORDER_BY("create_time DESC limit 1");
        }
    }.toString();
}

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

License:Apache License

/**
 * ???/*from   w  w  w . j av  a2  s. co  m*/
 *
 * @param parameter
 * @return
 */
public String insert(Map<String, Object> parameter) {
    DataSource dataSource = (DataSource) parameter.get("dataSource");
    int type = dataSource.getType().ordinal();

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

            VALUES("`name`", "#{dataSource.name,jdbcType=VARCHAR}");
            VALUES("`desc`", "#{dataSource.desc}");
            VALUES("`type`", "" + type);
            VALUES("`owner`", "#{dataSource.ownerId}");
            VALUES("`project_id`", "#{dataSource.projectId}");
            VALUES("`parameter`", "#{dataSource.parameter}");
            VALUES("`create_time`", "#{dataSource.createTime}");
            VALUES("`modify_time`", "#{dataSource.modifyTime}");
        }
    }.toString();
}

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

License:Apache License

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

            SET("`desc` = #{dataSource.desc}");
            SET("`owner` = #{dataSource.ownerId}");
            SET("`project_id` = #{dataSource.projectId}");
            SET("`parameter` = #{dataSource.parameter}");
            SET("`modify_time` = #{dataSource.modifyTime}");

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

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

License:Apache License

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

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

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

License:Apache License

/**
 * ???/* w  w w.  j  a  va  2 s.  c  om*/
 *
 * @param parameter
 * @return
 */
public String getByProjectId(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("r.*, r.owner as owner_id");
            SELECT("u.name as owner,p.name as project_name");

            FROM(TABLE_NAME + " r");

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

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