protected void doUpgrade() throws Exception {
// WikiNode
UpgradeColumn upgradeGroupIdColumn =
new SwapUpgradeColumnImpl("groupId", AvailableMappersUtil.getGroupIdMapper());
UpgradeColumn upgradeUserIdColumn =
new SwapUpgradeColumnImpl(
"userId", new Integer(Types.VARCHAR), AvailableMappersUtil.getUserIdMapper());
PKUpgradeColumnImpl upgradePKColumn = new PKUpgradeColumnImpl("nodeId", true);
UpgradeTable upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(
WikiNodeTable.TABLE_NAME,
WikiNodeTable.TABLE_COLUMNS,
upgradePKColumn,
upgradeGroupIdColumn,
upgradeUserIdColumn);
upgradeTable.setCreateSQL(WikiNodeTable.TABLE_SQL_CREATE);
upgradeTable.updateTable();
ValueMapper nodeIdMapper = upgradePKColumn.getValueMapper();
AvailableMappersUtil.setWikiNodeIdMapper(nodeIdMapper);
UpgradeColumn upgradeNodeIdColumn = new SwapUpgradeColumnImpl("nodeId", nodeIdMapper);
// WikiPage
UpgradeColumn upgradeTitleColumn = new TempUpgradeColumnImpl("title");
WikiPageIdUpgradeColumnImpl upgradePageIdColumn =
new WikiPageIdUpgradeColumnImpl(upgradeNodeIdColumn, upgradeTitleColumn);
UpgradeColumn upgradePageResourcePrimKeyColumn =
new WikiPageResourcePrimKeyUpgradeColumnImpl(upgradePageIdColumn);
upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(
WikiPageTable.TABLE_NAME,
WikiPageTable.TABLE_COLUMNS,
upgradeNodeIdColumn,
upgradeTitleColumn,
upgradePageIdColumn,
upgradePageResourcePrimKeyColumn,
upgradeUserIdColumn);
upgradeTable.setCreateSQL(WikiPageTable.TABLE_SQL_CREATE);
upgradeTable.updateTable();
ValueMapper pageIdMapper = upgradePageIdColumn.getValueMapper();
AvailableMappersUtil.setWikiPageIdMapper(pageIdMapper);
}
protected void upgradeTable(
String tableName, Object[][] tableColumns, String sqlCreate, String[] sqlAddIndexes)
throws Exception {
UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(tableName, tableColumns);
upgradeTable.setCreateSQL(sqlCreate);
upgradeTable.setIndexesSQL(sqlAddIndexes);
upgradeTable.updateTable();
}
protected void doUpgrade() throws Exception {
// Company
String[] webIds = WebIdUtil.getWebIds();
for (String webId : webIds) {
runSQL("delete from Image where imageId = '" + webId + "'");
runSQL("delete from Image where imageId = '" + webId + ".wbmp'");
runSQL("update Image set imageId = '" + webId + "' where imageId = '" + webId + ".png'");
}
// Image
PKUpgradeColumnImpl upgradePKColumn =
new PKUpgradeColumnImpl("imageId", new Integer(Types.VARCHAR), true);
ImageTextUpgradeColumnImpl upgradeTextColumn = new ImageTextUpgradeColumnImpl(upgradePKColumn);
ImageTypeUpgradeColumnImpl upgradeTypeColumn =
new ImageTypeUpgradeColumnImpl(upgradeTextColumn);
ImageHeightUpgradeColumnImpl upgradeHeightColumn =
new ImageHeightUpgradeColumnImpl(upgradeTextColumn);
ImageWidthUpgradeColumnImpl upgradeWidthColumn =
new ImageWidthUpgradeColumnImpl(upgradeTextColumn);
ImageSizeUpgradeColumnImpl upgradeSizeColumn =
new ImageSizeUpgradeColumnImpl(upgradeTextColumn);
UpgradeTable upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(
ImageTable.TABLE_NAME,
ImageTable.TABLE_COLUMNS,
upgradePKColumn,
upgradeTextColumn,
upgradeTypeColumn,
upgradeHeightColumn,
upgradeWidthColumn,
upgradeSizeColumn);
upgradeTable.setCreateSQL(ImageTable.TABLE_SQL_CREATE);
upgradeTable.updateTable();
ValueMapper imageIdMapper = new DefaultPKMapper(upgradePKColumn.getValueMapper());
AvailableMappersUtil.setImageIdMapper(imageIdMapper);
}
protected void doUpgrade() throws Exception {
try {
runSQL("alter_column_type CalEvent remindBy INTEGER");
} catch (Exception e) {
// CalEvent
UpgradeTable upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(
CalEventTable.TABLE_NAME, CalEventTable.TABLE_COLUMNS);
upgradeTable.setCreateSQL(CalEventTable.TABLE_SQL_CREATE);
upgradeTable.setIndexesSQL(CalEventTable.TABLE_SQL_ADD_INDEXES);
upgradeTable.updateTable();
}
}
@Override
protected void doUpgrade() throws Exception {
try {
runSQL("alter_column_type ResourceAction name VARCHAR(255) null");
} catch (Exception e) {
// Resource
UpgradeTable upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(
ResourceActionTable.TABLE_NAME, ResourceActionTable.TABLE_COLUMNS);
upgradeTable.setCreateSQL(ResourceActionTable.TABLE_SQL_CREATE);
upgradeTable.setIndexesSQL(ResourceActionTable.TABLE_SQL_ADD_INDEXES);
upgradeTable.updateTable();
}
}
protected void upgradeTable(
String tableName,
Object[][] tableColumns,
String createSQL,
String[] indexesSQL,
UpgradeColumn... upgradeColumns)
throws Exception {
try (LoggingTimer loggingTimer = new LoggingTimer(tableName)) {
UpgradeTable upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(tableName, tableColumns, upgradeColumns);
upgradeTable.setCreateSQL(createSQL);
upgradeTable.setIndexesSQL(indexesSQL);
upgradeTable.updateTable();
}
}
protected void doUpgrade() throws Exception {
// JournalArticle
UpgradeColumn upgradeCompanyIdColumn =
new SwapUpgradeColumnImpl(
"companyId", new Integer(Types.VARCHAR), AvailableMappersUtil.getCompanyIdMapper());
UpgradeColumn upgradeGroupIdColumn =
new SwapUpgradeColumnImpl("groupId", AvailableMappersUtil.getGroupIdMapper());
UpgradeColumn upgradeUserIdColumn =
new SwapUpgradeColumnImpl(
"userId", new Integer(Types.VARCHAR), AvailableMappersUtil.getUserIdMapper());
UpgradeColumn upgradeApprovedByUserIdColumn =
new SwapUpgradeColumnImpl(
"approvedByUserId", new Integer(Types.VARCHAR), AvailableMappersUtil.getUserIdMapper());
JournalArticlePKUpgradeColumnImpl upgradeArticlePKColumn =
new JournalArticlePKUpgradeColumnImpl(upgradeCompanyIdColumn, upgradeGroupIdColumn);
UpgradeColumn upgradeArticleResourcePrimKeyColumn =
new JournalArticleResourcePrimKeyUpgradeColumnImpl(upgradeArticlePKColumn);
UpgradeColumn upgradeArticleIdColumn = new TempUpgradeColumnImpl("articleId");
UpgradeColumn upgradeVersionColumn =
new TempUpgradeColumnImpl("version", new Integer(Types.DOUBLE));
UpgradeColumn upgradeStructureIdColumn = new TempUpgradeColumnImpl("structureId");
UpgradeColumn upgradeContentColumn =
new JournalArticleContentUpgradeColumnImpl(
upgradeCompanyIdColumn,
upgradeGroupIdColumn,
upgradeArticleIdColumn,
upgradeVersionColumn,
upgradeStructureIdColumn,
AvailableMappersUtil.getImageIdMapper());
UpgradeTable upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(
JournalArticleTable.TABLE_NAME,
JournalArticleTable.TABLE_COLUMNS,
upgradeCompanyIdColumn,
upgradeGroupIdColumn,
upgradeUserIdColumn,
upgradeApprovedByUserIdColumn,
upgradeArticlePKColumn,
upgradeArticleResourcePrimKeyColumn,
upgradeArticleIdColumn,
upgradeVersionColumn,
upgradeStructureIdColumn,
upgradeContentColumn);
upgradeTable.setCreateSQL(JournalArticleTable.TABLE_SQL_CREATE);
upgradeTable.setIndexesSQL(JournalArticleTable.TABLE_SQL_ADD_INDEXES);
upgradeTable.updateTable();
ValueMapper articleIdMapper = new DefaultPKMapper(upgradeArticlePKColumn.getValueMapper());
AvailableMappersUtil.setJournalArticleIdMapper(articleIdMapper);
// JournalStructure
PKUpgradeColumnImpl upgradeStructurePKColumn =
new JournalStructurePKUpgradeColumnImpl(upgradeCompanyIdColumn, upgradeGroupIdColumn);
UpgradeColumn upgradeXSDColumn = new JournalStructureXSDUpgradeColumnImpl();
upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(
JournalStructureTable.TABLE_NAME,
JournalStructureTable.TABLE_COLUMNS,
upgradeCompanyIdColumn,
upgradeGroupIdColumn,
upgradeStructurePKColumn,
upgradeUserIdColumn,
upgradeXSDColumn);
upgradeTable.setCreateSQL(JournalStructureTable.TABLE_SQL_CREATE);
upgradeTable.setIndexesSQL(JournalStructureTable.TABLE_SQL_ADD_INDEXES);
upgradeTable.updateTable();
ValueMapper structureIdMapper = new DefaultPKMapper(upgradeStructurePKColumn.getValueMapper());
AvailableMappersUtil.setJournalStructureIdMapper(structureIdMapper);
// JournalTemplate
PKUpgradeColumnImpl upgradeTemplatePKColumn =
new JournalTemplatePKUpgradeColumnImpl(upgradeCompanyIdColumn, upgradeGroupIdColumn);
UpgradeColumn upgradeTemplateIdColumn = new TempUpgradeColumnImpl("templateId");
UpgradeColumn upgradeXSLColumn =
new JournalTemplateXSLUpgradeColumnImpl(upgradeTemplateIdColumn);
UpgradeColumn upgradeSmallImageIdColumn =
new JournalTemplateSmallImageIdUpgradeColumnImpl(
upgradeCompanyIdColumn,
upgradeGroupIdColumn,
upgradeTemplatePKColumn,
AvailableMappersUtil.getImageIdMapper());
upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(
JournalTemplateTable.TABLE_NAME,
JournalTemplateTable.TABLE_COLUMNS,
upgradeCompanyIdColumn,
upgradeGroupIdColumn,
upgradeTemplatePKColumn,
upgradeUserIdColumn,
upgradeTemplateIdColumn,
upgradeXSLColumn,
upgradeSmallImageIdColumn);
upgradeTable.setCreateSQL(JournalTemplateTable.TABLE_SQL_CREATE);
upgradeTable.setIndexesSQL(JournalTemplateTable.TABLE_SQL_ADD_INDEXES);
upgradeTable.updateTable();
ValueMapper templateIdMapper = new DefaultPKMapper(upgradeTemplatePKColumn.getValueMapper());
AvailableMappersUtil.setJournalTemplateIdMapper(templateIdMapper);
// JournalContentSearch
PropsUtil.set(PropsKeys.JOURNAL_SYNC_CONTENT_SEARCH_ON_STARTUP, "true");
}
protected void doUpgrade() throws Exception {
// ShoppingCategory
UpgradeColumn upgradeGroupIdColumn =
new SwapUpgradeColumnImpl("groupId", AvailableMappersUtil.getGroupIdMapper());
UpgradeColumn upgradeUserIdColumn =
new SwapUpgradeColumnImpl(
"userId", new Integer(Types.VARCHAR), AvailableMappersUtil.getUserIdMapper());
PKUpgradeColumnImpl upgradePKColumn = new PKUpgradeColumnImpl("categoryId", true);
UpgradeTable upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(
ShoppingCategoryTable.TABLE_NAME,
ShoppingCategoryTable.TABLE_COLUMNS,
upgradePKColumn,
upgradeGroupIdColumn,
upgradeUserIdColumn);
upgradeTable.setCreateSQL(ShoppingCategoryTable.TABLE_SQL_CREATE);
upgradeTable.updateTable();
ValueMapper categoryIdMapper = new DefaultPKMapper(upgradePKColumn.getValueMapper());
AvailableMappersUtil.setShoppingCategoryIdMapper(categoryIdMapper);
UpgradeColumn upgradeParentCategoryIdColumn =
new SwapUpgradeColumnImpl("parentCategoryId", categoryIdMapper);
upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(
ShoppingCategoryTable.TABLE_NAME,
ShoppingCategoryTable.TABLE_COLUMNS,
upgradeParentCategoryIdColumn);
upgradeTable.updateTable();
UpgradeColumn upgradeCategoryIdColumn =
new SwapUpgradeColumnImpl("categoryId", categoryIdMapper);
// ShoppingItem
upgradePKColumn = new PKUpgradeColumnImpl("itemId", true);
upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(
ShoppingItemTable.TABLE_NAME,
ShoppingItemTable.TABLE_COLUMNS,
upgradePKColumn,
upgradeCategoryIdColumn,
upgradeUserIdColumn);
upgradeTable.setCreateSQL(ShoppingItemTable.TABLE_SQL_CREATE);
upgradeTable.updateTable();
ValueMapper itemIdMapper = upgradePKColumn.getValueMapper();
AvailableMappersUtil.setShoppingItemIdMapper(itemIdMapper);
UpgradeColumn upgradeItemIdColumn = new SwapUpgradeColumnImpl("itemId", itemIdMapper);
// ShoppingItemField
upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(
ShoppingItemTable.TABLE_NAME,
ShoppingItemTable.TABLE_COLUMNS,
new PKUpgradeColumnImpl("itemFieldId", false),
upgradeItemIdColumn);
upgradeTable.setCreateSQL(ShoppingItemTable.TABLE_SQL_CREATE);
upgradeTable.updateTable();
// ShoppingItemPrice
upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(
ShoppingItemPriceTable.TABLE_NAME,
ShoppingItemPriceTable.TABLE_COLUMNS,
new PKUpgradeColumnImpl("itemPriceId", false),
upgradeItemIdColumn);
upgradeTable.setCreateSQL(ShoppingItemPriceTable.TABLE_SQL_CREATE);
upgradeTable.updateTable();
// ShoppingOrder
upgradePKColumn = new PKUpgradeColumnImpl("orderId", new Integer(Types.VARCHAR), true);
upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(
ShoppingOrderTable.TABLE_NAME,
ShoppingOrderTable.TABLE_COLUMNS,
upgradePKColumn,
upgradeGroupIdColumn,
upgradeUserIdColumn);
upgradeTable.setCreateSQL(ShoppingOrderTable.TABLE_SQL_CREATE);
upgradeTable.updateTable();
ValueMapper orderIdMapper = upgradePKColumn.getValueMapper();
UpgradeColumn upgradeOrderIdColumn =
new SwapUpgradeColumnImpl("orderId", new Integer(Types.VARCHAR), orderIdMapper);
// ShoppingOrderItem
UpgradeColumn upgradeCartItemIdColumn = new ShoppingCartItemIdUpgradeColumnImpl(itemIdMapper);
upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(
ShoppingOrderItemTable.TABLE_NAME,
ShoppingOrderItemTable.TABLE_COLUMNS,
new PKUpgradeColumnImpl("orderItemId", false),
upgradeOrderIdColumn,
upgradeCartItemIdColumn);
upgradeTable.setCreateSQL(ShoppingOrderItemTable.TABLE_SQL_CREATE);
upgradeTable.updateTable();
// ShoppingCart
UpgradeColumn upgradeItemIdsColumn = new ShoppingCartItemIdsUpgradeColumnImpl(itemIdMapper);
upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(
ShoppingCartTable.TABLE_NAME,
ShoppingCartTable.TABLE_COLUMNS,
new PKUpgradeColumnImpl("cartId", new Integer(Types.VARCHAR), false),
upgradeGroupIdColumn,
upgradeUserIdColumn,
upgradeItemIdsColumn);
upgradeTable.setCreateSQL(ShoppingCartTable.TABLE_SQL_CREATE);
upgradeTable.updateTable();
// ShoppingCoupon
UpgradeColumn upgradeLimitCategoriesColumn =
new ShoppingCouponLimitCategoriesUpgradeColumnImpl(categoryIdMapper);
upgradeTable =
UpgradeTableFactoryUtil.getUpgradeTable(
ShoppingCouponTable.TABLE_NAME,
ShoppingCouponTable.TABLE_COLUMNS,
new PKUpgradeColumnImpl("couponId", new Integer(Types.VARCHAR), false),
upgradeGroupIdColumn,
upgradeUserIdColumn,
upgradeLimitCategoriesColumn);
upgradeTable.setCreateSQL(ShoppingCouponTable.TABLE_SQL_CREATE);
upgradeTable.updateTable();
}