/// <summary> Updates the database to the required version. </summary>
private string UpdateDatabase(string strVersion)
{
string result = "";
VersionHandler.TryParseVersion(strVersion, out VersionHandler.Version requiredVersion);
if (VersionHandler.TryGetCurrentDatabaseVersion(out VersionHandler.Version currentVersion))
{
if (currentVersion < requiredVersion)
{
if (VersionHandler.IsThereVersion(requiredVersion))
{
result += "Need to run scripts:\n";
string[] fileNames = VersionHandler.GetFilesByPattern();
List <string> updateScripts = new List <string>();
for (int i = 0; i < fileNames.Length; i++)
{
if (VersionHandler.TryGetVersionFromPath(fileNames[i], out VersionHandler.Version version))
{
if (currentVersion < version && version <= requiredVersion)
{
updateScripts.Add(fileNames[i]);
result += $"{Path.GetFileName(fileNames[i])}\n";
}
}
}
result += "\nScript execution begins...\n";
for (int i = 0; i < updateScripts.Count; i++)
{
result += $"\nExecuting {Path.GetFileName(updateScripts[i])}...\n";
string file = File.ReadAllText(updateScripts[i]);
// I did not manage to run the * .sql file due to the fact that the ExecuteNonQuery() method can perform only 1 query.
// Now I have solved this problem by splitting the file into separate requests and sequentially performing them.
List <string> queries = SQLCommandsUtils.GetQueriesFromString(file);
if (MyDataBase.GetDB().ExecuteQueries(queries.ToArray()))
{
if (VersionHandler.TryGetVersionFromPath(Path.GetFileName(updateScripts[i]), out VersionHandler.Version version))
{
VersionHandler.TrySetCurrentDatabaseVersion(version);
result += $"Script {Path.GetFileName(updateScripts[i])} executed successfully.";
}
}
else
{
result = $"E: An error occurred while executing the script {Path.GetFileName(updateScripts[i])}.";
}
}
}
else
{
result = $"E: Version {requiredVersion} does not exist.";
}
}
else if (currentVersion > requiredVersion)
{
result = "E: You cannot update the database to a version that is smaller than the version of the current database. Use rollback command.";
}
else
{
result = "E: Your database already has this version.";
}
}
else
{
result = "E: Failed to get current database version.";
}
return(result);
}
/// <summary> Updates the database to the required version. </summary>
private void UpdateDatabase(double requiredVersion)
{
if (VersionHandler.TryGetCurrentDatabaseVersion(out double currentVersion))
{
if (currentVersion < requiredVersion)
{
if (VersionHandler.IsThereVersion(requiredVersion))
{
ConsoleUtility.WriteLine("Need to run scripts:", Program.TextColor);
string[] fileNames = Program.GetUpdateScriptNames();
List <string> updateScripts = new List <string>();
for (int i = 0; i < fileNames.Length; i++)
{
if (VersionHandler.TryGetVersionFromPath(fileNames[i], out double version))
{
if (currentVersion < version && version <= requiredVersion)
{
updateScripts.Add(fileNames[i]);
ConsoleUtility.WriteLine(Path.GetFileName(fileNames[i]), Program.TextColor);
}
}
}
ConsoleUtility.WriteLine("\nScript execution begins...", Program.TextColor);
for (int i = 0; i < updateScripts.Count; i++)
{
ConsoleUtility.WriteLine($"\nExecuting {Path.GetFileName(updateScripts[i])}...", Program.TextColor);
string file = File.ReadAllText(updateScripts[i]);
// I did not manage to run the * .sql file due to the fact that the ExecuteNonQuery() method can perform only 1 query.
// Now I have solved this problem by splitting the file into separate requests and sequentially performing them.
// Probably, it's a temporary solution.
List <string> queries = Program.GetQueriesFromString(file);
if (MyDataBase.GetDB().ExecuteQueries(queries.ToArray()))
{
if (VersionHandler.TryGetVersionFromPath(Path.GetFileName(updateScripts[i]), out double version))
{
MyDataBase.GetDB().ExecuteQueryWithoutAnswer($"UPDATE db_version SET version = {version}");
ConsoleUtility.WriteLine($"Script {Path.GetFileName(updateScripts[i])} executed successfully.", Program.TextColor);
}
}
else
{
ConsoleUtility.WriteLine($"An error occurred while executing the script {Path.GetFileName(updateScripts[i])}.", Program.ErrorColor);
}
}
}
else
{
ConsoleUtility.WriteLine($"Version {requiredVersion} does not exist.", Program.ErrorColor);
}
}
else if (currentVersion > requiredVersion)
{
ConsoleUtility.WriteLine("You cannot update the database to a version that is smaller than the version of the current database. Use rollback command.", Program.ErrorColor);
}
else
{
ConsoleUtility.WriteLine("Your database already has this version.", Program.ErrorColor);
}
}
else
{
ConsoleUtility.WriteLine("Failed to get current database version.", Program.ErrorColor);
}
}