/*
 * Copyright © 2016 TIBCO Software,Inc.All rights reserved.
 * http://community.jaspersoft.com/project/jaspermobile-android
 *
 * Unless you have purchased a commercial license agreement from TIBCO Jaspersoft,
 * the following license terms apply:
 *
 * This program is part of TIBCO Jaspersoft Mobile for Android.
 *
 * TIBCO Jaspersoft Mobile is free software:you can redistribute it and/or modify
 * it under the terms of the GNU Lesser General Public License as published by
 * the Free Software Foundation,either version 3of the License,or
 * (at your option)any later version.
 *
 * TIBCO Jaspersoft Mobile is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY;without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.See the
 * GNU Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with TIBCO Jaspersoft Mobile for Android.If not,see
 * <http://www.gnu.org/licenses/lgpl>.
 */

package com.jaspersoft.android.jaspermobile.test.support.db;

import com.jaspersoft.android.jaspermobile.test.support.TestResource;

import java.util.ArrayList;
import java.util.Collection;
import java.util.List;

/**
 * @author Tom Koptel
 * @since 2.1
 */
public class SqlTestResource extends TestResource implements ResourceDatabase.RawSqlStatements {

    private SqlTestResource(String fileName) {
        super(fileName);
    }

    public static SqlTestResource get(String fileName) {
        return new SqlTestResource(fileName);
    }

    @Override
    public Collection<String> getStatements() {
        String rawString = asString();
        String[] statements = rawString.split(";");
        List<String> result = new ArrayList<String>(statements.length);
        for (String statement : statements) {
            statement = statement.replace("\n", "");
            statement = statement.replace("\r", "");
            result.add(statement + ";");
        }
        return result;
    }

}