protected internal static SQLiteConnection FetchDbConn()
{
if (dbConn == null)
{
dbConn = new SQLiteConnection("Data Source=" + Path.Combine(FileUtils.GetAppDataFolder(), "store.db") + ";Version=3;New=False");
dbConn.Open();
}
return(dbConn);
}
protected internal static SQLiteConnection FetchDbConn()
{
if (dbConn == null)
{
dbConn = new SQLiteConnection("Data Source=" + Path.Combine(FileUtils.GetAppDataFolder(), "store.db") + ";Version=3;New=False");
dbConn.Open();
using (SQLiteCommand command = new SQLiteCommand("pragma foreign_keys = on", FetchDbConn()))
{
command.ExecuteNonQuery();
}
}
return(dbConn);
}
protected internal static SQLiteConnection FetchDbConn()
{
if (dbConn == null)
{
string storePath = ConfigurationManager.AppSettings["DatabasePath"];
if (string.IsNullOrEmpty(storePath) || !File.Exists(storePath))
{
storePath = Path.Combine(FileUtils.GetAppDataFolder(), "store.db");
}
dbConn = new SQLiteConnection("Data Source=" + storePath + ";Version=3;New=False");
dbConn.Open();
}
return(dbConn);
}
public static bool Startup()
{
const string DbFileName = "store.db";
string specDbPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, DbFileName);
string appDbPath = Path.Combine(FileUtils.GetAppDataFolder(), DbFileName);
// Ensure that the template database exists
if (!File.Exists(specDbPath))
{
MessageBox.Show("The Radio Downloader template database was not found at '" + specDbPath + "'." + Environment.NewLine + Environment.NewLine + "Try repairing the Radio Downloader installation or installing the latest version from nerdoftheherd.com", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Stop);
return(false);
}
using (SQLiteConnection specConn = new SQLiteConnection("Data Source=" + specDbPath + ";Version=3;New=False;Read Only=True"))
{
specConn.Open();
using (SQLiteCommand command = new SQLiteCommand("pragma integrity_check(1)", specConn))
{
string result = (string)command.ExecuteScalar();
if (result.ToUpperInvariant() != "OK")
{
MessageBox.Show("The Radio Downloader template database at '" + specDbPath + "' appears to be corrupted." + Environment.NewLine + Environment.NewLine + "Try repairing the Radio Downloader installation or installing the latest version from nerdoftheherd.com", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Stop);
return(false);
}
}
// Migrate old (pre 0.26) version databases from www.nerdoftheherd.com -> NerdoftheHerd.com
string oldDbPath = Path.Combine(Path.Combine(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), "www.nerdoftheherd.com"), Application.ProductName), DbFileName);
if (File.Exists(oldDbPath) && !File.Exists(appDbPath))
{
File.Move(oldDbPath, appDbPath);
}
// Test if there is an existing application database
if (!File.Exists(appDbPath))
{
// Start with a copy of the template database
File.Copy(specDbPath, appDbPath);
// Set the current database version in the new database
Settings.DatabaseVersion = Database.CurrentDbVersion;
}
else
{
using (SQLiteCommand command = new SQLiteCommand("pragma integrity_check(1)", FetchDbConn()))
{
string result = (string)command.ExecuteScalar();
if (result.ToUpperInvariant() != "OK")
{
if (MessageBox.Show("Unfortunately Radio Downloader cannot start because your database has become corrupted." + Environment.NewLine + Environment.NewLine + "Would you like to view some help about resolving this issue?", Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Stop) == DialogResult.Yes)
{
OsUtils.LaunchUrl(new Uri("https://nerdoftheherd.com/tools/radiodld/help/corrupt-database"), "corruptdb");
}
return(false);
}
}
// Start a transaction so we can roll back a half-completed upgrade on error
using (SQLiteMonTransaction transMon = new SQLiteMonTransaction(FetchDbConn().BeginTransaction()))
{
try
{
// Perform a check and automatic update of the database table structure
UpdateStructure(specConn, Database.FetchDbConn());
// Perform any updates required which were not handled by UpdateStructure
switch (Settings.DatabaseVersion)
{
case 4:
// Clear error details previously serialised as XML
using (SQLiteCommand command = new SQLiteCommand("update downloads set errordetails=null where errortype=@errortype", FetchDbConn()))
{
command.Parameters.Add(new SQLiteParameter("errortype", ErrorType.UnknownError));
command.ExecuteNonQuery();
}
break;
case Database.CurrentDbVersion:
// Nothing to do, this is the current version.
break;
}
// Set the current database version
Settings.DatabaseVersion = Database.CurrentDbVersion;
}
catch (SQLiteException)
{
transMon.Trans.Rollback();
throw;
}
transMon.Trans.Commit();
}
}
}
// Prune the database once a week
if (Settings.LastPrune.AddDays(7) < DateTime.Now)
{
using (Status status = new Status())
{
status.ShowDialog(delegate
{
Prune(status);
});
}
}
// Vacuum the database every three months
if (Settings.LastVacuum.AddMonths(3) < DateTime.Now)
{
using (Status status = new Status())
{
status.ShowDialog(delegate
{
Vacuum(status);
});
}
}
return(true);
}
private string DatabasePath()
{
return(Path.Combine(FileUtils.GetAppDataFolder(), "searchindex.db"));
}
