001 /******************************************************************************
002 * Copyright (C) MActor Developers. All rights reserved. *
003 * ---------------------------------------------------------------------------*
004 * This file is part of MActor. *
005 * *
006 * MActor is free software; you can redistribute it and/or modify *
007 * it under the terms of the GNU General Public License as published by *
008 * the Free Software Foundation; either version 2 of the License, or *
009 * (at your option) any later version. *
010 * *
011 * MActor is distributed in the hope that it will be useful, *
012 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
013 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
014 * GNU General Public License for more details. *
015 * *
016 * You should have received a copy of the GNU General Public License *
017 * along with MActor; if not, write to the Free Software *
018 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA *
019 ******************************************************************************/
020 package org.mactor.framework.commandexecutors.sql;
021
022 import java.util.List;
023
024 import org.mactor.framework.MactorException;
025 import org.mactor.framework.TestContextImpl;
026 import org.mactor.framework.commandexecutors.ActionCommandExecutor;
027 import org.mactor.framework.data.jdbc.SqlCommandUtil;
028 import org.mactor.framework.spec.ProjectContext;
029
030 public class SqlActionCommandExecutor implements ActionCommandExecutor {
031 private String command;
032 private List<String> params;
033 public SqlActionCommandExecutor(String command, List<String> params) {
034 this.command = command;
035 this.params = params;
036 }
037 public void perform(TestContextImpl context) throws MactorException {
038 boolean ignoreSqlErrors = false;
039 if (params != null && params.size() > 0)
040 ignoreSqlErrors = Boolean.parseBoolean(params.get(0));
041 SqlCommandUtil sqlUtil = new SqlCommandUtil(command, context.getGlobalConfig());
042 if (sqlUtil.getSqlExpression().trim().toLowerCase().endsWith(".sql"))
043 sqlUtil.getDb().execScript(ProjectContext.getGlobalInstance().getAbsolutePath(sqlUtil.getSqlExpression()), ignoreSqlErrors);
044 else
045 sqlUtil.getDb().execUpdateSql(sqlUtil.getSqlExpression());
046 }
047 }