SQL : Add support for special options in DML clauses

[Marko Lavikainen]

MySQL supports a number of options while using INSERT. See manual at http://dev.mysql.com/doc/refman/5.1/en/insert-select.html. From the options case INSERT IGNORE INTO is needed.

[Timo Westkämper (timo-westkamper)]

Fixed in SVN trunk. The DML clause implementations of the SQL module support now START, START_OVERRIDE and END flags. Use them like this :

    @Test
    public void insert_with_special_options(){
        SQLInsertClause clause = insert(survey)
            .columns(survey.id, survey.name)
            .values(3, "Hello");

        clause.addFlag(Position.START_OVERRIDE, "INSERT IGNORE INTO ");

        assertEquals("INSERT IGNORE INTO SURVEY(ID, NAME) values (?, ?)", clause.toString());
        clause.execute();
    }

[Timo Westkämper (timo-westkamper)]

Released in 1.9.0