public void ExecuteQuery_InvalidQuery_ThrowsSQLiteException() { // Setup string filename = Path.GetRandomFileName(); string filePath = TestHelper.GetScratchPadPath(nameof(ExecuteQuery_InvalidQuery_ThrowsSQLiteException) + filename); using (new FileDisposeHelper(filePath)) using (var databaseFile = new ProjectDatabaseFile(filePath)) { databaseFile.OpenDatabaseConnection(); // Call TestDelegate call = () => databaseFile.ExecuteQuery("THIS WILL FAIL"); // Assert Assert.Throws <SQLiteException>(call); } }
public void ExecuteQuery_QueryIsNullOrWhiteSpace_ThrowsArgumentException(string query) { // Setup string filename = Path.GetRandomFileName(); string filePath = TestHelper.GetScratchPadPath(nameof(ExecuteQuery_QueryIsNullOrWhiteSpace_ThrowsArgumentException) + filename); using (new FileDisposeHelper(filePath)) using (var databaseFile = new ProjectDatabaseFile(filePath)) { databaseFile.OpenDatabaseConnection(); // Call TestDelegate call = () => databaseFile.ExecuteQuery(query); // Assert TestHelper.AssertThrowsArgumentExceptionAndTestMessage <ArgumentException>(call, "Parameter must be a valid database script."); } }
public void ExecuteQuery_ValidQuery_CreatesFile() { // Setup string filename = Path.GetRandomFileName(); string filePath = TestHelper.GetScratchPadPath(filename); using (var databaseFile = new ProjectDatabaseFile(filePath)) { databaseFile.OpenDatabaseConnection(); // Call databaseFile.ExecuteQuery(";"); // Assert Assert.IsTrue(File.Exists(filePath)); } using (new FileDisposeHelper(filePath)) {} }
public void Dispose_AlreadyDisposed_DoesNotThrowException() { // Setup string filename = Path.GetRandomFileName(); string filePath = TestHelper.GetScratchPadPath(filename); // Call TestDelegate call = () => { using (var databaseFile = new ProjectDatabaseFile(filePath)) { databaseFile.Dispose(); } }; using (new FileDisposeHelper(filePath)) { // Assert Assert.DoesNotThrow(call); } }