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    }