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

Introduction

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

Prototype

public void setCreateSQL(String createSQL) 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");
            }/*from w ww.  j  a v  a  2s. co  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 ww  w .  ja  v a 2  s .c o  m
}

---

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.  j a  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");
        }/* w ww  . j ava2s . c  om*/

        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();
}

---

From source file:com.liferay.sync.model.upgrade.SyncDLObjectUpgradeTableListener.java

License:Open Source License

@Override
public void onBeforeUpdateTable(ServiceComponent previousServiceComponent, UpgradeTable upgradeTable)
        throws Exception {

    if (previousServiceComponent.getBuildNumber() >= 2) {
        return;//w w  w.  j a  va  2s  .c om
    }

    String createSQL = upgradeTable.getCreateSQL();

    createSQL = StringUtil.replace(createSQL, " primary key", StringPool.BLANK);

    upgradeTable.setCreateSQL(createSQL);

    _syncDLObjectIds = getSyncDLObjectIds();
}

---