/// <summary> /// Deletes the rdmp metadata objects (but not the actual <see cref="BulkDataTable"/>) /// </summary> public void DeleteCatalogue() { var creds = (DataAccessCredentials)tableInfo.GetCredentialsIfExists(DataAccessContext.InternalDataProcessing); if (tableInfo.Exists()) { tableInfo.DeleteInDatabase(); } if (creds != null) { try { creds.DeleteInDatabase(); } catch (CredentialsInUseException e) { Console.WriteLine("Ignored Potential Exception:" + e); } } if (catalogue.Exists()) { catalogue.DeleteInDatabase(); } }
private void AddToExistingCatalogue(Catalogue addToInstead, ExtractionInformation[] eis) { //move all the CatalogueItems to the other Catalogue instead foreach (ExtractionInformation ei in eis) { var ci = ei.CatalogueItem; ci.Catalogue_ID = addToInstead.ID; ci.SaveToDatabase(); } _choicesFinalised = true; _catalogue.DeleteInDatabase(); _catalogue = null; Activator.RefreshBus.Publish(this, new RefreshObjectEventArgs(addToInstead)); Close(); }
public void Destroy() { var credentials = (DataAccessCredentials)TableInfoCreated.GetCredentialsIfExists(DataAccessContext.InternalDataProcessing); TableInfoCreated.DeleteInDatabase(); if (credentials != null) { credentials.DeleteInDatabase(); } Cata.DeleteInDatabase(); }
public void EndToEndTest() { var cohortDatabaseNameWillBe = TestDatabaseNames.GetConsistentName("TbvCohort"); _discoveredCohortDatabase = DiscoveredServerICanCreateRandomDatabasesAndTablesOn.ExpectDatabase(cohortDatabaseNameWillBe); //cleanup if (_discoveredCohortDatabase.Exists()) { _discoveredCohortDatabase.Drop(); } //create a normal catalogue CreateANormalCatalogue(); //create a cohort database using wizard CreateNewCohortDatabaseWizard cohortDatabaseWizard = new CreateNewCohortDatabaseWizard(_discoveredCohortDatabase, CatalogueRepository, DataExportRepository, false); _externalCohortTable = cohortDatabaseWizard.CreateDatabase( new PrivateIdentifierPrototype(_nonTvfExtractionIdentifier) , new ThrowImmediatelyCheckNotifier()); //create a table valued function CreateTvfCatalogue(cohortDatabaseNameWillBe); //Test 1 TestThatQueryBuilderWithoutParametersBeingSetThrowsQueryBuildingException(); PopulateCohortDatabaseWithRecordsFromNonTvfCatalogue(); //Test 2 TestWithParameterValueThatRowsAreReturned(); //Test 3 TestUsingTvfForAggregates(); //Test 4 TestAddingTvfToCIC(); //Test 5 TestDataExportOfTvf(); //tear down DataExportRepository.GetAllObjects <ExtractableCohort>().Single().DeleteInDatabase(); _externalCohortTable.DeleteInDatabase(); _database.ExpectTable("NonTVFTable").Drop(); _database.ExpectTableValuedFunction("GetTopXRandom").Drop(); //delete global parameter ((AnyTableSqlParameter)_aggregate.GetAllParameters().Single()).DeleteInDatabase(); //delete aggregate _aggregate.DeleteInDatabase(); ((AnyTableSqlParameter)_cicAggregate.GetAllParameters().Single()).DeleteInDatabase(); //delete aggregate _cicAggregate.DeleteInDatabase(); //get rid of the cohort identification configuration _cic.DeleteInDatabase(); _pipe.DeleteInDatabase(); //get rid of the cohort database _discoveredCohortDatabase.Drop(); _nonTvfCatalogue.DeleteInDatabase(); _nonTvfTableInfo.DeleteInDatabase(); _tvfCatalogue.DeleteInDatabase(); _tvfTableInfo.DeleteInDatabase(); }