/// <summary>
/// Merge multiple .db files into a single .db file.
/// </summary>
/// <param name="fileSpec">The file specification for the .db files to merge.</param>
/// <param name="recurse">Recursively search for matching .db files in child directories?</param>
/// <param name="outFileName">The name of the new output file.</param>
public static void MergeFiles(string fileSpec, bool recurse, string outFileName)
{
File.Delete(outFileName);
string[] filesToMerge = DirectoryUtilities.FindFiles(fileSpec, recurse);
if (filesToMerge.Length > 1)
{
File.Copy(filesToMerge[0], outFileName, overwrite: true);
var destination = new SQLite();
destination.OpenDatabase(outFileName, readOnly: false);
try
{
foreach (var sourceFileName in filesToMerge.Where(file => file != filesToMerge[0]))
{
var source = new SQLite();
source.OpenDatabase(sourceFileName, readOnly: true);
try
{
Merge(source, destination);
}
finally
{
source.CloseDatabase();
}
}
}
finally
{
destination.CloseDatabase();
}
}
}
/// <summary>
/// Merge multiple .db files into a single .db file.
/// </summary>
/// <param name="fileSpec">The file specification for the .db files to merge.</param>
/// <param name="outFileName">The name of the new output file.</param>
public static void MergeFiles(string fileSpec, string outFileName)
{
File.Delete(outFileName);
string path = Path.GetDirectoryName(fileSpec);
if (path == "")
{
path = Directory.GetCurrentDirectory();
}
var filesToMerge = Directory.GetFiles(path, Path.GetFileName(fileSpec)).ToList();
if (filesToMerge.Count > 1)
{
File.Copy(filesToMerge[0], outFileName, overwrite: true);
var destination = new SQLite();
destination.OpenDatabase(outFileName, readOnly: false);
try
{
foreach (var sourceFileName in filesToMerge.Where(file => file != filesToMerge[0]))
{
var source = new SQLite();
source.OpenDatabase(sourceFileName, readOnly: true);
try
{
Merge(source, destination);
}
finally
{
source.CloseDatabase();
}
}
}
finally
{
destination.CloseDatabase();
}
}
}
/// <summary>
/// Merge multiple .db files into a single .db file.
/// </summary>
/// <param name="fileSpec">The file specification for the .db files to merge.</param>
/// <param name="recurse">Recursively search for matching .db files in child directories?</param>
/// <param name="outFileName">The name of the new output file.</param>
public static void MergeFiles(string fileSpec, bool recurse, string outFileName)
{
File.Delete(outFileName);
string[] filesToMerge = DirectoryUtilities.FindFiles(fileSpec, recurse);
if (filesToMerge.Length > 1)
{
File.Copy(filesToMerge[0], outFileName, overwrite: true);
var destination = new SQLite();
destination.OpenDatabase(outFileName, readOnly: false);
try
{
foreach (var sourceFileName in filesToMerge.Where(file => file != filesToMerge[0]))
{
var source = new SQLite();
// If readOnly is true then .db-shm files are not removed on close. Bug in SqLite.
// http://sqlite.1065341.n5.nabble.com/journal-files-not-always-removed-td83700.html
source.OpenDatabase(sourceFileName, readOnly: false);
try
{
Merge(source, destination);
}
finally
{
source.CloseDatabase();
}
}
}
finally
{
destination.CloseDatabase();
}
}
else if (filesToMerge.Length == 1)
{
File.Copy(filesToMerge[0], outFileName, true);
}
}
/// <summary>Connect to the SQLite database.</summary>
/// <param name="forWriting">if set to <c>true</c> [for writing].</param>
/// <exception cref="Models.Core.ApsimXException">Cannot find name of .db file</exception>
private void Open(bool forWriting)
{
lock (Locks)
{
if (Filename == null)
{
Simulations simulations = Apsim.Parent(this, typeof(Simulations)) as Simulations;
if (simulations != null)
Filename = Path.ChangeExtension(simulations.FileName, ".db");
}
if (Filename != null &&
(Connection == null ||
(ForWriting == false && forWriting == true)))
{
if (Filename == null)
throw new ApsimXException(this, "Cannot find name of .db file");
Disconnect();
ForWriting = forWriting;
if (!Locks.ContainsKey(Filename))
Locks.Add(Filename, new DbMutex());
Locks[Filename].Aquire();
try
{
if (!File.Exists(Filename))
{
Connection = new SQLite();
Connection.OpenDatabase(Filename, readOnly: false);
Connection.ExecuteNonQuery("CREATE TABLE Simulations (ID INTEGER PRIMARY KEY ASC, Name TEXT COLLATE NOCASE)");
Connection.ExecuteNonQuery("CREATE TABLE Messages (SimulationID INTEGER, ComponentName TEXT, Date TEXT, Message TEXT, MessageType INTEGER)");
if (!forWriting)
{
Connection.CloseDatabase();
Connection.OpenDatabase(Filename, readOnly: !forWriting);
}
}
else
{
Connection = new SQLite();
Connection.OpenDatabase(Filename, readOnly: !forWriting);
}
}
finally
{
Locks[Filename].Release();
}
}
}
}
/// <summary>
/// Return the simulation id (from the simulations table) for the specified name.
/// If this name doesn't exist in the table then append a new row to the table and
/// returns its id.
/// </summary>
/// <param name="simulationName">Name of the simulation.</param>
/// <returns></returns>
private int GetSimulationID(string simulationName)
{
if (!TableExists("Simulations"))
return -1;
string selectSQL = "SELECT ID FROM Simulations WHERE Name = '" + simulationName + "'";
int ID = Connection.ExecuteQueryReturnInt(selectSQL, 0);
if (ID == -1)
{
Locks[Filename].Aquire();
ID = Connection.ExecuteQueryReturnInt(selectSQL, 0);
if (ID == -1)
{
if (ForWriting == false)
{
Disconnect();
Connection = new SQLite();
Connection.OpenDatabase(Filename, readOnly: false);
ForWriting = true;
}
Connection.ExecuteNonQuery("INSERT INTO [Simulations] (Name) VALUES ('" + simulationName + "')");
ID = Connection.ExecuteQueryReturnInt("SELECT ID FROM Simulations WHERE Name = '" + simulationName + "'", 0);
}
Locks[Filename].Release();
}
return ID;
}