SymbolUtil.java

package dbfit.util;

import java.sql.ResultSet;
import java.sql.SQLException;

/** ugly workaround for fit change in release 200807, which internally converts NULL into a string value "null";
 * for db access, we need to make a difference between NULL and "null" so this class provides a centralised
 * place for the change; for dbfit fixtures use this class to access symbols rather than directly fit.fixture
 */
public class SymbolUtil {
    private static final Object dbNull = new Object();

    public static void setSymbol(String name, Object value) {
        fit.Fixture.setSymbol(getSymbolName(name), value == null ? dbNull : value);
    }

    public static Object getSymbol(String name) {
        Object value = fit.Fixture.getSymbol(getSymbolName(name));
        return (value == dbNull) ? null : value;
    }

    public static void clearSymbols() {
        fit.Fixture.ClearSymbols();
    }

    public static DataTable getDataTable(String symbolName) {
        Object o = getSymbol(symbolName);

        if (o == null) {
            throw new UnsupportedOperationException(
                    "Cannot load a stored query from " + symbolName);
        }

        if (o instanceof DataTable) {
            return (DataTable) o;
        }

        try {
            if (o instanceof ResultSet) {
                return new DataTable((ResultSet) o);
            }
        } catch (SQLException e) {
            throw new UnsupportedOperationException(
                    "Cannot load stored query from " + symbolName, e);
        }

        throw new UnsupportedOperationException(
                "Cannot load stored query from " + symbolName +
                " - object type is " + o.getClass().getName());
    }

    public static String getSymbolName(String symbolFullName) {
        return SymbolReference.fromFullName(symbolFullName).getName();
    }

    public static boolean isSymbolGetter(String text) {
        return SymbolReference.fromFullName(text).isSymbolGetter();
    }

    public static boolean isSymbolSetter(String text) {
        return SymbolReference.fromFullName(text).isSymbolSetter();
    }

    public static boolean isSymbolHidden(String text) {
        return SymbolReference.fromFullName(text).isHidden();
    }
}