EclipseとMavenの統合

継続的インテグレーションツールとの統合

• Hudson


• Continuum


• CruiseControl


• Luntbuild

Mavenとは

mvn eclipse:eclipse

Mavenの仕組み

mvn package

mvn clean:clean

まとめ

調査データ

PostgreSQL GIN

CREATE TABLE gin_test_table
(
  id integer NOT NULL, 
  original_text text, -- もともとのテキスト
  array_text text[],  -- 形態素解析を行ったものを格納
  CONSTRAINT pk_test_table PRIMARY KEY (id)
)

CREATE INDEX gin_index
  ON gin_test_table
  USING gin
  (array_text);

select count(*) from gin_test_table

select count(*) from gin_test_table
where original_text like '%吾輩%'

select count(*) from gin_test_table
where array_text && ARRAY['吾輩']

Lucene

package jp.canetrash.sample.ibatis3.mapper;

import java.util.List;

import jp.canetrash.sample.ibatis3.domain.Emp;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

public interface EmpMapper {

    @Select("SELECT * FROM emp ")
    List selectAllEmp();

    Emp selectEmp(int id);

    @Insert("insert into emp (id, name, title ) values (#{id}, #{name}, #{title})")
    void insertEmp(Emp emp);

    @Delete("delete from emp where id = #{id}")
    int deleteEmp(int id);

    int updateEmp(Emp emp);

    @Update("create table emp (id integer, name varchar(128), title varchar(128)) ")
    void createTable();

    @Update("drop table emp")
    void dropTable();
}

<iftest="title != null">
  AND title like #{title}
</if>
<choose>
  <when test="title != null">
    AND title like #{title}
  </when>
  <when test="author != null && author.name != null">
    AND title like #{author.name}
  </when>
  <otherwise>
    AND featured = 1
  </otherwise>
</choose>

import static org.apache.ibatis.jdbc.SelectBuilder.*;
...
private String selectPersonSql() {
    BEGIN(); // Clears ThreadLocal variable
    SELECT("P.ID, P.USERNAME, P.PASSWORD, P.FULL_NAME");
    SELECT("P.LAST_NAME, P.CREATED_ON, P.UPDATED_ON");
    FROM("PERSON P");
    FROM("ACCOUNT A");
    INNER_JOIN("DEPARTMENT D on D.ID = P.DEPARTMENT_ID");
    INNER_JOIN("COMPANY C on D.COMPANY_ID = C.ID");
    WHERE("P.ID = A.ID");
    WHERE("P.FIRST_NAME like ?");
    OR();
    WHERE("P.LAST_NAME like ?");
    GROUP_BY("P.ID");
    HAVING("P.LAST_NAME like ?");
    OR();
    HAVING("P.FIRST_NAME like ?");
    ORDER_BY("P.ID");
    ORDER_BY("P.FULL_NAME");
    return SQL();
}

mvn sysdeo-tomcat:m2eclipse

[INFO] Finished at: Tue Apr 07 10:07:51 JST 2009

つかいかた

  mvn bijint:touch