Example usage for com.liferay.portal.kernel.upgrade.util UpgradeTable updateTable

Introduction

In this page you can find the example usage for com.liferay.portal.kernel.upgrade.util UpgradeTable updateTable.

Prototype

public void updateTable() throws Exception;

Source Link

Usage

From source file:com.liferay.invitation.invite.members.internal.upgrade.v1_0_0.UpgradeNamespace.java

License:Open Source License

protected void renameTable(String oldTableName, String newTableName, Object[][] tableColumns,
        String tableSqlCreate, String tableSqlDrop) throws Exception {

    try (LoggingTimer loggingTimer = new LoggingTimer(newTableName)) {
        boolean hasNewTable = hasTable(newTableName);

        if (hasNewTable && hasRows(newTableName)) {
            if (_log.isWarnEnabled()) {
                _log.warn("Not renaming " + oldTableName + " to " + newTableName + " because " + newTableName
                        + " has data");
            }//w w  w.j  av  a2s.  c  o m

            return;
        }

        boolean hasOldTable = hasTable(oldTableName);

        if (hasOldTable && !hasRows(oldTableName)) {
            if (_log.isWarnEnabled()) {
                _log.warn("Not renaming " + oldTableName + " to " + newTableName + " because " + oldTableName
                        + " has no data");
            }

            return;
        }

        if (!hasNewTable && !hasOldTable) {
            runSQL(tableSqlCreate);

            return;
        }

        if (hasNewTable) {
            runSQL(tableSqlDrop);
        }

        UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(oldTableName, tableColumns);

        upgradeTable.setCreateSQL(tableSqlCreate);

        upgradeTable.updateTable();
    }
}

---

From source file:com.liferay.knowledgebase.hook.upgrade.v1_1_0.UpgradeKBArticle.java

License:Open Source License

protected void renameTable(String oldTableName, Object[][] tableColumns, String tableSqlCreate)
        throws Exception {

    UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(oldTableName, tableColumns);

    upgradeTable.setCreateSQL(tableSqlCreate);

    upgradeTable.updateTable();
}

---

From source file:com.liferay.knowledgebase.hook.upgrade.v1_1_0.UpgradeKBArticle.java

License:Open Source License

protected void updateTable(String newTableName, Object[][] tableColumns, String tableSqlCreate)
        throws Exception {

    UpgradeColumn kbArticleIdColumn = new TempUpgradeColumnImpl("kbArticleId");

    UpgradeColumn resourcePrimKeyColumn = new TempUpgradeColumnImpl("resourcePrimKey");

    KBArticleRootResourcePrimKeyUpgradeColumnImpl rootResourcePrimKeyColumn = new KBArticleRootResourcePrimKeyUpgradeColumnImpl(
            resourcePrimKeyColumn);/*from w  w w  .  ja  v  a  2 s. c o  m*/

    KBArticleLatestUpgradeColumnImpl latestColumn = new KBArticleLatestUpgradeColumnImpl(kbArticleIdColumn,
            resourcePrimKeyColumn);

    KBArticleMainUpgradeColumnImpl mainColumn = new KBArticleMainUpgradeColumnImpl(kbArticleIdColumn,
            resourcePrimKeyColumn);

    UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(newTableName, tableColumns,
            kbArticleIdColumn, resourcePrimKeyColumn, rootResourcePrimKeyColumn, latestColumn, mainColumn);

    upgradeTable.setCreateSQL(tableSqlCreate);

    upgradeTable.updateTable();
}

---

From source file:com.liferay.socialcoding.hook.upgrade.v1_0_0.UpgradeNamespace.java

License:Open Source License

protected void renameTable(String oldTableName, String newTableName, Object[][] tableColumns,
        String tableSqlCreate, String tableSqlDrop) throws Exception {

    if (tableHasData(newTableName)) {
        if (_log.isWarnEnabled()) {
            _log.warn("Not renaming " + oldTableName + " to " + newTableName + " because " + newTableName
                    + " has data");
        }//from ww  w.ja  v  a2  s .  c  o m

        return;
    }

    if (!tableHasData(oldTableName)) {
        if (_log.isWarnEnabled()) {
            _log.warn("Not renaming " + oldTableName + " to " + newTableName + " because " + oldTableName
                    + " has no data");
        }

        return;
    }

    runSQL(tableSqlDrop);

    UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(oldTableName, tableColumns);

    upgradeTable.setCreateSQL(tableSqlCreate);

    upgradeTable.updateTable();
}

---