public void TestSqliteConnectionCannotBeEstablished()
{
string connectionString = $"Data Source={Guid.NewGuid()};FailIfMissing=true;";
var xQuery = new XQuerySqlite(connectionString);
Assert.IsFalse(xQuery.TestConnection());
}
private void App_OnStartup(object sender, StartupEventArgs e)
{
var defaultPath = DatabasePath = $@"{Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData)}\{Assembly.GetExecutingAssembly().GetName().Name}";
DatabaseFilePath = $@"{defaultPath}\ba.sqlite";
var connectionString = $@"Data Source={DatabaseFilePath};Version=3;UTF8Encoding=True;foreign keys=true;FailIfMissing=true;";
try
{
connectionString = ConfigurationManager.ConnectionStrings["SqliteConnection"].ConnectionString;
DatabaseFilePath = ExtractFilePathFromConnectionString(connectionString);
DatabasePath = ExtractPathFromFilePath(DatabaseFilePath);
}
catch (NullReferenceException)
{
// ignored
}
try
{
BackupRemoteFolderId = ConfigurationManager.AppSettings["BackupRemoteFolderId"];
}
catch (NullReferenceException)
{
// ignored
}
if (Sqlite.TestConnection(connectionString))
{
Sqlite.ConnectionString = connectionString;
}
else
{
MessageBox.Show($"Не удалось установить соединение с базой данных.{Environment.NewLine}Детали: {Sqlite.LastErrorMessage}",
"Business Accounting", MessageBoxButton.OK, MessageBoxImage.Stop);
Current.Shutdown();
}
}
public void TestNoErrorWhileCheckingTheConnectionWithNull()
{
var xQuery = new XQuerySqlite();
Assert.IsFalse(xQuery.TestConnection());
}
public void TestSqliteConnectionCanBeEstablished()
{
var xQuery = new XQuerySqlite(SetUp.SqliteConnectionString);
Assert.IsTrue(xQuery.TestConnection());
}
