/*
 * Copyright 2016-2018 shardingsphere.io.
 * <p>
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 * </p>
 */

package io.shardingsphere.core.parsing.parser.dialect.mysql.sql;

import io.shardingsphere.core.constant.transaction.TransactionOperationType;
import io.shardingsphere.core.parsing.lexer.LexerEngine;
import io.shardingsphere.core.parsing.lexer.token.Symbol;
import io.shardingsphere.core.parsing.parser.sql.tcl.TCLStatement;
import io.shardingsphere.core.parsing.parser.sql.tcl.set.autocommit.AbstractSetAutoCommitParser;

/**
 * Set auto commit parser for MySQL.
 *
 * @author maxiaoguang
 */
public final class MySQLSetAutoCommitParser extends AbstractSetAutoCommitParser {
    
    public MySQLSetAutoCommitParser(final LexerEngine lexerEngine) {
        super(lexerEngine);
    }
    
    @Override
    public TCLStatement parse() {
        boolean autoCommit;
        getLexerEngine().nextToken();
        getLexerEngine().accept(Symbol.EQ);
        if ("1".equals(getLexerEngine().getCurrentToken().getLiterals())) {
            autoCommit = true;
        } else {
            autoCommit = false;
        }
        return autoCommit ? new TCLStatement(TransactionOperationType.IGNORE) : new TCLStatement(TransactionOperationType.BEGIN);
    }
}

@@ -813,16 +813,82 @@
 Engine;%0A
+import io.shardingsphere.core.parsing.lexer.token.DefaultKeyword;%0A
 import i
@@ -1442,18 +1442,74 @@
 toCommit
+ = false
 ;%0A
+        while (!getLexerEngine().isEnd()) %7B%0A    
         
@@ -1538,16 +1538,20 @@
 oken();%0A
+    
         
@@ -1594,16 +1594,20 @@
         
+    
 if (%221%22.
@@ -1670,32 +1670,36 @@
 ) %7B%0A            
+    
 autoCommit = tru
@@ -1709,16 +1709,20 @@
         
+  
+  
 %7D else %7B
@@ -1722,16 +1722,20 @@
  else %7B%0A
+    
         
@@ -1750,32 +1750,113 @@
 Commit = false;%0A
+            %7D%0A            getLexerEngine().skipUntil(DefaultKeyword.AUTOCOMMIT);%0A
         %7D%0A      

support sql like (set autocommit = 1, autocommit = 0)