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 org.mactor.framework.MactorException;
023 import org.mactor.framework.TestContextImpl;
024 import org.mactor.framework.commandexecutors.ValueCommandExecutor;
025 import org.mactor.framework.data.jdbc.SqlCommandUtil;
026 import org.mactor.framework.spec.ProjectContext;
027
028 public class SqlValueCommandExecutor implements ValueCommandExecutor {
029 private String command;
030 public SqlValueCommandExecutor(String command) {
031 this.command = command;
032 }
033 public String extractValue(TestContextImpl context) throws MactorException {
034 SqlCommandUtil sqlUtil = new SqlCommandUtil(command, context.getGlobalConfig());
035 String val = null;
036 if (sqlUtil.getSqlExpression().trim().toLowerCase().endsWith(".sql"))
037 val = sqlUtil.getDb().execSingleCellScriptQuery(ProjectContext.getGlobalInstance().getAbsolutePath(sqlUtil.getSqlExpression()));
038 else
039 val = sqlUtil.getDb().execSingleCellQuerySql(sqlUtil.getSqlExpression());
040 return val;
041 }
042 /*
043 * private boolean same(String v1, String v2) { if (v1 == null && v2 ==
044 * null) return true; if (v1 == null) return false; return v1.equals(v2); }
045 */
046 }