// 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);
}
