@@ -0,0 +1,2119 @@
+/*%0A * Copyright 2016-2018 shardingsphere.io.%0A * %3Cp%3E%0A * Licensed under the Apache License, Version 2.0 (the %22License%22);%0A * you may not use this file except in compliance with the License.%0A * You may obtain a copy of the License at%0A *%0A *     http://www.apache.org/licenses/LICENSE-2.0%0A *%0A * Unless required by applicable law or agreed to in writing, software%0A * distributed under the License is distributed on an %22AS IS%22 BASIS,%0A * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.%0A * See the License for the specific language governing permissions and%0A * limitations under the License.%0A * %3C/p%3E%0A */%0A%0Apackage io.shardingsphere.dbtest.cases.authority;%0A%0Aimport io.shardingsphere.core.constant.DatabaseType;%0Aimport lombok.Getter;%0A%0Aimport javax.xml.bind.annotation.XmlAccessType;%0Aimport javax.xml.bind.annotation.XmlAccessorType;%0Aimport javax.xml.bind.annotation.XmlAttribute;%0Aimport javax.xml.bind.annotation.XmlElement;%0Aimport java.util.Collection;%0Aimport java.util.LinkedList;%0A%0A/**%0A * Authority SQL set xml entry.%0A *%0A * @author panjuan%0A */%0A@Getter%0A@XmlAccessorType(XmlAccessType.FIELD)%0Apublic final class SQLSet %7B%0A    %0A    @XmlAttribute(name = %22db-types%22)%0A    private String dbTypes;%0A    %0A    @XmlAttribute(name = %22sql-type%22)%0A    private SQLType sqlType;%0A    %0A    @XmlElement(name = %22sql%22)%0A    private Collection%3CSQL%3E SQLs = new LinkedList%3C%3E();%0A    %0A    private Collection%3CDatabaseType%3E getDatabaseTypeList() %7B%0A        Collection%3CDatabaseType%3E result = new LinkedList%3C%3E();%0A        for (String each : dbTypes.split(%22,%22)) %7B%0A            result.add(DatabaseType.valueOf(each));%0A        %7D%0A        return result;%0A    %7D%0A    %0A    /**%0A     * Get all sqls content.%0A     *%0A     * @return sqls content%0A     */%0A    public Collection%3CString%3E getAllSQLContent(final SQLType sqlType, final DatabaseType databaseType ) %7B%0A        Collection%3CString%3E result = new LinkedList%3C%3E();%0A        if (this.sqlType != sqlType %7C%7C !getDatabaseTypeList().contains(databaseType)) %7B%0A            return result;%0A        %7D%0A        for (SQL each : SQLs) %7B%0A            result.add(each.getContent());%0A        %7D%0A        return result;%0A    %7D%0A%7D%0A

add SQLSet.java