public void DatabaseUpgradeBefore(int ixVersionFrom, int ixVersionTo, CDatabaseUpgradeApi apiUpgrade) { if (ixVersionFrom <= DB_CHANGE_VERSION_EVENTUTC) { apiUpgrade.ChangeColumnDefinition(ExtendedEventEntity.GetPluginTableName(this.api.Database), "dtEventUtc"); } }
public void DatabaseUpgradeAfter(int ixVersionFrom, int ixVersionTo, CDatabaseUpgradeApi apiUpgrade) { if (ixVersionFrom <= DB_CHANGE_VERSION_MESSAGES_HTML_SANITIZE) { var sanitizer = HtmlSanitizer.SimpleHtml5Sanitizer(); var selectQuery = this.api.Database.NewSelectQuery(ExtendedEventEntity.GetPluginTableName(this.api.Database)); selectQuery.AddSelect("ixExtendedEvent, sMessage"); selectQuery.AddWhere("sEventType <> @sEventType"); selectQuery.SetParamString("@sEventType", "commit"); var ds = selectQuery.GetDataSet(); if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { var sMessage = row["sMessage"] as string; if (!String.IsNullOrEmpty(sMessage)) { sMessage = sanitizer.Sanitize(sMessage); var ixExtendedEvent = Convert.ToInt32(row["ixExtendedEvent"]); var updateQuery = this.api.Database.NewUpdateQuery(ExtendedEventEntity.GetPluginTableName(this.api.Database)); updateQuery.UpdateString("sMessage", sMessage); updateQuery.AddWhere("ixExtendedEvent = @ixExtendedEvent"); updateQuery.SetParamInt("@ixExtendedEvent", ixExtendedEvent); updateQuery.Execute(); } } } } }
public void DatabaseUpgradeAfter(int ixVersionFrom, int ixVersionTo, CDatabaseUpgradeApi apiUpgrade) { //For the first revision, provide locking info for all users. //if admin, set allowAccess = true SetDefaultAdmins(); //if normal, set allow = false SetDefaultNormalUsers(); }
public void DatabaseUpgradeBefore(int ixVersionFrom, int ixVersionTo, CDatabaseUpgradeApi apiUpgrade) { }
public void DatabaseUpgradeAfter(int ixVersionFrom, int ixVersionTo, CDatabaseUpgradeApi apiUpgrade) { /* Create 5 different awesomeness levels. Note that we'll have a "None * specified" level, which our plugin will treat the same as NULL. */ for (int i = 0; i < rgsAwesomenessLevels.Length; i++) { CInsertQuery iq = api.Database.NewInsertQuery(sAwesomenessTableName); iq.InsertString("sAwesomenessLevel", rgsAwesomenessLevels[i]); iq.Execute(); } }