public void LoadFactorsFromDMS(ObservableCollection <DatasetInformation> datasets,
FeatureDataAccessProviders providers)
{
if (datasets.Count < 1)
{
return;
}
var sink = new MultiAlignFactorSink(datasets,
providers.DatasetCache,
providers.FactorCache,
providers.FactorAssignmentCache);
foreach (var info in datasets)
{
var query = m_sqlQuery + string.Format(" = '{0}'", info.DatasetName);
var reader = new MSSQLReader();
reader.Server = Server;
reader.Database = Database;
reader.SQLText = query;
var pipeline = ProcessingPipeline.Assemble("PlainFactors", reader, sink);
pipeline.RunRoot(null);
}
sink.CommitChanges();
}
public void LoadFactorsFromDMS(ObservableCollection<DatasetInformation> datasets,
FeatureDataAccessProviders providers)
{
if (datasets.Count < 1)
{
return;
}
var sink = new MultiAlignFactorSink(datasets,
providers.DatasetCache,
providers.FactorCache,
providers.FactorAssignmentCache);
foreach (var info in datasets)
{
var query = m_sqlQuery + string.Format(" = '{0}'", info.DatasetName);
var reader = new MSSQLReader();
reader.Server = Server;
reader.Database = Database;
reader.SQLText = query;
var pipeline = ProcessingPipeline.Assemble("PlainFactors", reader, sink);
pipeline.RunRoot(null);
}
sink.CommitChanges();
}
public static string FindLocationOfDataset(string datasetName)
{
var reader = new MSSQLReader()
{
Server = "gigasax",
Database = "DMS5",
SQLText = "SELECT * FROM V_Mage_Dataset_List WHERE Dataset = '" + datasetName + "'"
};
var fileFilter = new FileListFilter()
{
FileColumnName = "Name",
OutputColumnList = "Item|+|text, Name|+|text, Folder, Dataset, Dataset_ID, *",
FileNameSelector = ".raw" // regex style filter for file names – blank means pass all
};
var sink = new SimpleSink();
var pipeline = ProcessingPipeline.Assemble("test_pipeline", reader, fileFilter, sink);
pipeline.RunRoot(null);
if (sink.Rows == null || sink.Rows.Count != 1)
{
throw new InvalidOperationException("Mage returned invalid results.");
}
var folderColumnIndex = sink.ColumnIndex["Folder"];
var folderName = sink.Rows[0].GetValue(folderColumnIndex).ToString();
return(folderName);
}
public ICollection <InputDatabase> LoadDatabases()
{
m_databases = new List <InputDatabase>();
using (var reader = new MSSQLReader())
{
reader.Server = Server;
reader.Database = Database;
reader.SQLText = CONST_DATABASE_LOAD_QUERY;
var pipeline = ProcessingPipeline.Assemble("Databases", reader, this);
pipeline.RunRoot(null);
}
return(m_databases);
}
public List <string> LoadFiles(string name)
{
m_folders = new List <string>();
using (var reader = new MSSQLReader())
{
reader.Server = Server;
reader.Database = Database;
reader.SQLText = string.Format(CONST_DATABASE_LOAD_QUERY, name);
var pipeline = ProcessingPipeline.Assemble("Results", reader, this);
pipeline.RunRoot(null);
}
return(m_folders);
}
public List<string> LoadFiles(string name)
{
m_folders = new List<string>();
using (var reader = new MSSQLReader())
{
reader.Server = Server;
reader.Database = Database;
reader.SQLText = string.Format(CONST_DATABASE_LOAD_QUERY, name);
var pipeline = ProcessingPipeline.Assemble("Results", reader, this);
pipeline.RunRoot(null);
}
return m_folders;
}
public ICollection<InputDatabase> LoadDatabases()
{
m_databases = new List<InputDatabase>();
using (var reader = new MSSQLReader())
{
reader.Server = Server;
reader.Database = Database;
reader.SQLText = CONST_DATABASE_LOAD_QUERY;
var pipeline = ProcessingPipeline.Assemble("Databases", reader, this);
pipeline.RunRoot(null);
}
return m_databases;
}
