SQL : Support for batch in DML clauses

[Timo Westkämper]

Support for batch in DML clauses

[FilipVercauteren (filip-vercauteren-agfa)]

I will be out of the office starting 21/07/2010 and will not return until
09/08/2010.

[Timo Westkämper (timo-westkamper)]

Related thread : http://source.mysema.com/forum/mvnforum/viewthread_thread,112

[Timo Westkämper (timo-westkamper)]

Support for batch in SQLInsertClause has been added

[Timo Westkämper (timo-westkamper)]

Batch support for INSERT, DELETE and UPDATE is available.

[Timo Westkämper (timo-westkamper)]

UPDATE :

    @Test
    public void batch() throws SQLException{
        insert(survey).values(2, "A").execute();
        insert(survey).values(3, "B").execute();

        SQLUpdateClause update = update(survey);
        update.set(survey.name, "AA").where(survey.name.eq("A")).addBatch();
        update.set(survey.name, "BB").where(survey.name.eq("B")).addBatch();
        assertEquals(2, update.execute());
    }

DELETE :

    @Test
    public void batch() throws SQLException{
        insert(survey).values(2, "A").execute();
        insert(survey).values(3, "B").execute();

        SQLDeleteClause delete = delete(survey);
        delete.where(survey.name.eq("A")).addBatch();
        delete.where(survey.name.eq("B")).addBatch();
        assertEquals(2, delete.execute());
    }

INSERT :

    @Test
    public void batch(){
        SQLInsertClause insert = insert(survey);
        insert.set(survey.id, 5).set(survey.name, "5").addBatch();
        insert.set(survey.id, 6).set(survey.name, "6").addBatch();
        assertEquals(2, insert.execute());
    }

[Timo Westkämper (timo-westkamper)]

Released in 1.9.1