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