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.data;
021    
022    import org.mactor.framework.MactorException;
023    import org.mactor.framework.data.jdbc.JdbcUtil;
024    import org.mactor.framework.data.jdbc.SqlCommandUtil;
025    import org.mactor.framework.spec.ProjectContext;
026    
027    public class SqlDataProvider implements DataProvider {
028            private String dataSourceConnectionSpec;
029            SqlDataProvider(String dataSourceConnectionSpec) {
030                    this.dataSourceConnectionSpec = dataSourceConnectionSpec;
031            }
032            public DataTable loadData() throws MactorException {
033                    SqlCommandUtil cu = new SqlCommandUtil(dataSourceConnectionSpec, ProjectContext.getGlobalInstance().loadGlobalConfig());
034                    JdbcUtil db = cu.getDb();
035                    if (cu.getSqlExpression().endsWith(".sql")) {
036                            return db.execScriptQuery(ProjectContext.getGlobalInstance().getAbsolutePath(cu.getSqlExpression()));
037                    } else {
038                            return db.execQuerySql(cu.getSqlExpression());
039                    }
040            }
041    }