// TODO - allow "*" wildcard for all sites, implement logging if package name doesn't exist or if package mapping file specifies files that aren't added? public void prioritizeConfigs(String sites, String packageName) { PackageTranslator pt = new PackageTranslator(); IList <String> fileNames = pt.getFilesInPackage(packageName); IList <String> siteCodes = sites.Split(new char[] { ';' }).ToList(); ISqlDao sqlDao = new SqlDaoFactory().getSqlDao(new SqlConnectionFactory().getConnection( ConfigurationManager.AppSettings[config.AppConfigSettingsConstants.SqlProvider], ConfigurationManager.AppSettings[config.AppConfigSettingsConstants.SqlConnectionString])); IList <ExtractorConfiguration> configsFromDb = sqlDao.getActiveExtractorConfigurations(); IList <ExtractorConfiguration> configsToPrioritize = new List <ExtractorConfiguration>(); foreach (String fileName in fileNames) { foreach (ExtractorConfiguration ec in configsFromDb) { if (String.Equals(fileName, ec.QueryConfigurations.RootNode.Value.File)) { foreach (String site in siteCodes) { ExtractorConfiguration newConfig = ec.Clone(); // need to clone because we're giving each config a unique site code! newConfig.SiteCode = site; configsToPrioritize.Add(newConfig); } } } } // finally ready to send to orchestrator! prioritizeConfigs(configsToPrioritize); }
static ExtractorConfiguration getExtractorConfigFromDb(String vistaFile) { ISqlDao sqlDao = new SqlDaoFactory().getSqlDao(new SqlConnectionFactory().getConnection( ConfigurationManager.AppSettings[config.AppConfigSettingsConstants.SqlProvider], ConfigurationManager.AppSettings[config.AppConfigSettingsConstants.SqlConnectionString])); IList <ExtractorConfiguration> allConfigs = sqlDao.getActiveExtractorConfigurations(); ExtractorConfiguration selected = null; foreach (ExtractorConfiguration ec in allConfigs) { if (String.Equals(ec.QueryConfigurations.RootNode.Value.File, vistaFile)) { selected = ec; break; } } return(selected); }