public DatabaseUpdateStatus PerformUpdates()
{
DatabaseUpdateStatus status = new DatabaseUpdateStatus();
bool bUpdate = true;
List <DatabaseUpdateMessage> lst = new List <DatabaseUpdateMessage>();
if (!DoCMSTablesExist())
{
HandleResponse(lst, "Create Database", CreateCMSDatabase());
}
else
{
HandleResponse(lst, "Database already exists");
}
bUpdate = DatabaseNeedsUpdate();
DataInfo ver = GetDbSchemaVersion();
int iUpdate = 1;
if (bUpdate || (ver.DataValue != DatabaseUpdate.CurrentDbVersion))
{
if (ver.DataValue != DatabaseUpdate.CurrentDbVersion)
{
ver = GetDbSchemaVersion();
if (ver.DataValue != DatabaseUpdate.CurrentDbVersion)
{
ver = GetDbSchemaVersion();
if (ver.DataValue == DatabaseUpdate.DbVersion00 || ver.DataValue.StartsWith("201508") ||
ver.DataValue.StartsWith("201509") || ver.DataValue.StartsWith("201510"))
{
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep01());
}
}
}
else
{
HandleResponse(lst, "Database up-to-date [" + ver.DataValue + "] ");
}
}
else
{
HandleResponse(lst, "Database up-to-date [" + ver.DataValue + "] ");
}
ResetFailedSQL();
ResetSQLState();
bUpdate = DatabaseNeedsUpdate();
status.NeedsUpdate = bUpdate;
status.Messages = lst;
return(status);
}
public DatabaseUpdateStatus PerformUpdates()
{
DatabaseUpdateStatus status = new DatabaseUpdateStatus();
bool bUpdate = true;
List <DatabaseUpdateMessage> lst = new List <DatabaseUpdateMessage>();
lock (updateLocker) {
if (!DoCMSTablesExist())
{
HandleResponse(lst, "Create Database", CreateCMSDatabase());
}
else
{
HandleResponse(lst, "Database already exists");
}
bUpdate = DatabaseNeedsUpdate();
DataInfo ver = GetDbSchemaVersion();
int iUpdate = 1;
if (bUpdate || (ver.DataValue != DatabaseUpdate.CurrentDbVersion))
{
if (ver.DataValue != DatabaseUpdate.CurrentDbVersion)
{
if (!IsPostStep04)
{
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep00());
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep01());
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep02());
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep03());
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep04());
}
if (!IsPostStep09)
{
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep05());
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep06());
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep07());
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep08());
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep09());
}
ver = GetDbSchemaVersion();
if (ver.DataValue != DatabaseUpdate.CurrentDbVersion)
{
if (ver.DataValue.Length < 2 || ver.DataValue.StartsWith("201305") || ver.DataValue.StartsWith("201306"))
{
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep10());
}
ver = GetDbSchemaVersion();
if (ver.DataValue == DatabaseUpdate.DbVersion10 || ver.DataValue.StartsWith("201306") || ver.DataValue.StartsWith("201309"))
{
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep11());
}
ver = GetDbSchemaVersion();
if (ver.DataValue == DatabaseUpdate.DbVersion11 || ver.DataValue.StartsWith("2013") || ver.DataValue.StartsWith("201409") || ver.DataValue.StartsWith("201410"))
{
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep12());
}
if (ver.DataValue == DatabaseUpdate.DbVersion12 || ver.DataValue.StartsWith("2013") || ver.DataValue.StartsWith("2014") || ver.DataValue.StartsWith("2015"))
{
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep13());
}
}
}
else
{
HandleResponse(lst, "Database up-to-date [" + ver.DataValue + "] ");
}
}
else
{
HandleResponse(lst, "Database up-to-date [" + ver.DataValue + "] ");
}
ResetFailedSQL();
ResetSQLState();
bUpdate = DatabaseNeedsUpdate();
status.NeedsUpdate = bUpdate;
status.Messages = lst;
}
return(status);
}
public DatabaseUpdateStatus PerformUpdates()
{
DatabaseUpdateStatus status = new DatabaseUpdateStatus();
bool bUpdate = true;
List<DatabaseUpdateMessage> lst = new List<DatabaseUpdateMessage>();
if (!DoCMSTablesExist()) {
HandleResponse(lst, "Create Database", CreateCMSDatabase());
} else {
HandleResponse(lst, "Database already exists");
}
bUpdate = DatabaseNeedsUpdate();
DataInfo ver = GetDbSchemaVersion();
int iUpdate = 1;
if (bUpdate || (ver.DataValue != DatabaseUpdate.CurrentDbVersion)) {
if (ver.DataValue != DatabaseUpdate.CurrentDbVersion) {
ver = GetDbSchemaVersion();
if (ver.DataValue != DatabaseUpdate.CurrentDbVersion) {
ver = GetDbSchemaVersion();
if (ver.DataValue == DatabaseUpdate.DbVersion00 || ver.DataValue.StartsWith("201508")
|| ver.DataValue.StartsWith("201509") || ver.DataValue.StartsWith("201510")) {
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep01());
}
}
} else {
HandleResponse(lst, "Database up-to-date [" + ver.DataValue + "] ");
}
} else {
HandleResponse(lst, "Database up-to-date [" + ver.DataValue + "] ");
}
ResetFailedSQL();
ResetSQLState();
bUpdate = DatabaseNeedsUpdate();
status.NeedsUpdate = bUpdate;
status.Messages = lst;
return status;
}
public DatabaseUpdateStatus PerformUpdates()
{
DatabaseUpdateStatus status = new DatabaseUpdateStatus();
bool bUpdate = true;
List<DatabaseUpdateMessage> lst = new List<DatabaseUpdateMessage>();
if (!DoCMSTablesExist()) {
HandleResponse(lst, "Create Database", CreateCMSDatabase());
} else {
HandleResponse(lst, "Database already exists");
}
bUpdate = DatabaseNeedsUpdate();
DataInfo ver = GetDbSchemaVersion();
int iUpdate = 1;
if (bUpdate || (ver.DataValue != DatabaseUpdate.CurrentDbVersion)) {
if (ver.DataValue != DatabaseUpdate.CurrentDbVersion) {
if (!IsPostStep04) {
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep00());
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep01());
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep02());
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep03());
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep04());
}
if (!IsPostStep09) {
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep05());
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep06());
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep07());
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep08());
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep09());
}
ver = GetDbSchemaVersion();
if (ver.DataValue != DatabaseUpdate.CurrentDbVersion) {
if (ver.DataValue.Length < 2 || ver.DataValue.StartsWith("201305") || ver.DataValue.StartsWith("201306")) {
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep10());
}
ver = GetDbSchemaVersion();
if (ver.DataValue == DatabaseUpdate.DbVersion10 || ver.DataValue.StartsWith("201306") || ver.DataValue.StartsWith("201309")) {
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep11());
}
ver = GetDbSchemaVersion();
if (ver.DataValue == DatabaseUpdate.DbVersion11 || ver.DataValue.StartsWith("201309") || ver.DataValue.StartsWith("201409") || ver.DataValue.StartsWith("201410")) {
HandleResponse(lst, BuildUpdateString(iUpdate++), AlterStep12());
}
}
} else {
HandleResponse(lst, "Database up-to-date [" + ver.DataValue + "] ");
}
} else {
HandleResponse(lst, "Database up-to-date [" + ver.DataValue + "] ");
}
bUpdate = DatabaseNeedsUpdate();
status.NeedsUpdate = bUpdate;
status.Messages = lst;
return status;
}