Example usage for com.liferay.portal.kernel.util PortalUtil transformSQL

Introduction

In this page you can find the example usage for com.liferay.portal.kernel.util PortalUtil transformSQL.

Prototype

public static String transformSQL(String sql)

Source Link

Usage

From source file:jorgediazest.util.modelquery.DatabaseUtil.java

License:Open Source License

public static Set<Data> queryTable(Model model, TableInfo tableInfo, String[] attributesName)
        throws SQLException {

    Set<Data> dataSet = new HashSet<>();

    Connection con = null;//  ww  w .  j  a v  a  2  s.  c  o m
    PreparedStatement ps = null;
    ResultSet rs = null;

    try {
        con = DataAccess.getConnection();

        String attributes = (String) attributesName[0];

        for (int i = 1; i < attributesName.length; i++) {
            attributes += ", " + (String) attributesName[i];
        }

        String sql = "SELECT " + attributes + " FROM " + tableInfo.getName();

        sql = PortalUtil.transformSQL(sql);

        if (_log.isDebugEnabled()) {
            _log.debug("SQL: " + sql);
        }

        ps = con.prepareStatement(sql);

        rs = ps.executeQuery();

        while (rs.next()) {
            Object[] result = new Object[attributesName.length];

            for (int i = 0; i < attributesName.length; i++) {
                result[i] = rs.getObject(i + 1);
            }

            Data data = DataUtil.createDataObject(model, tableInfo, dataComparatorMap, attributesName, result);
            dataSet.add(data);
        }
    } finally {
        DataAccess.cleanUp(con, ps, rs);
    }

    return dataSet;
}

From source file:monthly.trading.service.base.MonthlyTradingLocalServiceBaseImpl.java

License:Open Source License

/**
 * Performs a SQL query./*from ww w . ja v a 2 s  .  c o m*/
 *
 * @param sql the sql query
 */
protected void runSQL(String sql) {
    try {
        DataSource dataSource = monthlyTradingPersistence.getDataSource();

        DB db = DBManagerUtil.getDB();

        sql = db.buildSQL(sql);
        sql = PortalUtil.transformSQL(sql);

        SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql);

        sqlUpdate.update();
    } catch (Exception e) {
        throw new SystemException(e);
    }
}

From source file:net.indaba.lostandfound.service.base.ItemLocalServiceBaseImpl.java

License:Open Source License

/**
 * Performs a SQL query./*from ww w  .  j av  a2 s . c  om*/
 *
 * @param sql the sql query
 */
protected void runSQL(String sql) {
    try {
        DataSource dataSource = itemPersistence.getDataSource();

        DB db = DBManagerUtil.getDB();

        sql = db.buildSQL(sql);
        sql = PortalUtil.transformSQL(sql);

        SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql);

        sqlUpdate.update();
    } catch (Exception e) {
        throw new SystemException(e);
    }
}

From source file:net.indaba.lostandfound.service.base.LFImageLocalServiceBaseImpl.java

License:Open Source License

/**
 * Performs a SQL query.//from w  w  w  .  j ava  2  s  .  c  o  m
 *
 * @param sql the sql query
 */
protected void runSQL(String sql) {
    try {
        DataSource dataSource = lfImagePersistence.getDataSource();

        DB db = DBManagerUtil.getDB();

        sql = db.buildSQL(sql);
        sql = PortalUtil.transformSQL(sql);

        SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql);

        sqlUpdate.update();
    } catch (Exception e) {
        throw new SystemException(e);
    }
}

From source file:org.javasavvy.student.service.base.StudentLocalServiceBaseImpl.java

License:Open Source License

/**
 * Performs a SQL query.//from w  w w . j  ava  2 s . co  m
 *
 * @param sql the sql query
 */
protected void runSQL(String sql) {
    try {
        DataSource dataSource = studentPersistence.getDataSource();

        DB db = DBManagerUtil.getDB();

        sql = db.buildSQL(sql);
        sql = PortalUtil.transformSQL(sql);

        SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql);

        sqlUpdate.update();
    } catch (Exception e) {
        throw new SystemException(e);
    }
}

From source file:priv.barrow.service.base.ExamDataLocalServiceBaseImpl.java

License:Open Source License

/**
 * Performs a SQL query.//  w  w w.  j av  a  2s  . c  o m
 *
 * @param sql the sql query
 */
protected void runSQL(String sql) {
    try {
        DataSource dataSource = examDataPersistence.getDataSource();

        DB db = DBManagerUtil.getDB();

        sql = db.buildSQL(sql);
        sql = PortalUtil.transformSQL(sql);

        SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql);

        sqlUpdate.update();
    } catch (Exception e) {
        throw new SystemException(e);
    }
}

From source file:priv.barrow.service.base.ExamQuestionLinkLocalServiceBaseImpl.java

License:Open Source License

/**
 * Performs a SQL query./*from   w ww . java2s  .c o  m*/
 *
 * @param sql the sql query
 */
protected void runSQL(String sql) {
    try {
        DataSource dataSource = examQuestionLinkPersistence.getDataSource();

        DB db = DBManagerUtil.getDB();

        sql = db.buildSQL(sql);
        sql = PortalUtil.transformSQL(sql);

        SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql);

        sqlUpdate.update();
    } catch (Exception e) {
        throw new SystemException(e);
    }
}

From source file:priv.barrow.service.base.QuestionRecordLinkLocalServiceBaseImpl.java

License:Open Source License

/**
 * Performs a SQL query.//from   www  .j a v a 2 s.c  o  m
 *
 * @param sql the sql query
 */
protected void runSQL(String sql) {
    try {
        DataSource dataSource = questionRecordLinkPersistence.getDataSource();

        DB db = DBManagerUtil.getDB();

        sql = db.buildSQL(sql);
        sql = PortalUtil.transformSQL(sql);

        SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql);

        sqlUpdate.update();
    } catch (Exception e) {
        throw new SystemException(e);
    }
}

From source file:priv.barrow.service.base.StudentExamLinkLocalServiceBaseImpl.java

License:Open Source License

/**
 * Performs a SQL query./* w ww.  j av  a 2 s  .  com*/
 *
 * @param sql the sql query
 */
protected void runSQL(String sql) {
    try {
        DataSource dataSource = studentExamLinkPersistence.getDataSource();

        DB db = DBManagerUtil.getDB();

        sql = db.buildSQL(sql);
        sql = PortalUtil.transformSQL(sql);

        SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql);

        sqlUpdate.update();
    } catch (Exception e) {
        throw new SystemException(e);
    }
}

From source file:priv.barrow.service.base.StudentTeacherLinkLocalServiceBaseImpl.java

License:Open Source License

/**
 * Performs a SQL query.//from   w  w w  .j a  v  a2s  .c o  m
 *
 * @param sql the sql query
 */
protected void runSQL(String sql) {
    try {
        DataSource dataSource = studentTeacherLinkPersistence.getDataSource();

        DB db = DBManagerUtil.getDB();

        sql = db.buildSQL(sql);
        sql = PortalUtil.transformSQL(sql);

        SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql);

        sqlUpdate.update();
    } catch (Exception e) {
        throw new SystemException(e);
    }
}