static void Main(string[] args)
{
Console.WriteLine("Enter a path, filename, and extension (.xlsx) for where to write the data dictionary. Then press <ENTER>");
string fileName = Console.ReadLine();
// Create the report
DataDictionaryCreationService service = new DataDictionaryCreationService(
new DataDictionaryTableDataProvider(
new GetDbTableColumnInfoService(
new BaseDatabaseConnection()
),
new TableExclusionRulesService(),
new TableModelObjectCreatorService()
),
new DataDictionaryStoredProcFuncDataProvider(
new GetDbStoredProcFuncInfo(
new BaseDatabaseConnection()
),
new StoredProcFuncModelObjectCreatorService()
),
new DataDictionaryCreateClosedXMLReport(
new MissingDescriptionsSheetCreator(),
new StoredProcFuncSheetCreator()
)
);
service.Execute(fileName);
// Test
Console.WriteLine("");
}
public void DataDictionaryCreationService_ctor_ArgumentNullExceptionWithNoIDataDictionaryReportGenerator()
{
// Arrange / Act / Assert
_biz = new DataDictionaryCreationService(
_mockIDataDictionaryTableDataProvider.Object,
_mockIDataDictionaryStoredProcFunctionDataProvider.Object,
null
);
}
public void Setup()
{
_mockIDataDictionaryTableDataProvider = new Mock <IDataDictionaryTableDataProvider>();
_mockIDataDictionaryStoredProcFunctionDataProvider = new Mock <IDataDictionaryStoredProcFuncDataProvider>();
_mockIDataDictionaryReportGenerator = new Mock <IDataDictionaryReportGenerator>();
_biz = new DataDictionaryCreationService(
_mockIDataDictionaryTableDataProvider.Object,
_mockIDataDictionaryStoredProcFunctionDataProvider.Object,
_mockIDataDictionaryReportGenerator.Object
);
}