private void SetupLocalOlapEtl(DocumentStore store, string script, string path)
{
var connectionStringName = $"{store.Database} to local";
var configuration = new OlapEtlConfiguration
{
ConnectionStringName = connectionStringName,
RunFrequency = "* * * * *",
Transforms =
{
new Transformation
{
Name = "MonthlyOrders",
Collections = new List <string>{
"Orders"
},
Script = script
}
}
};
var connectionString = new OlapConnectionString
{
Name = connectionStringName,
LocalSettings = new LocalSettings
{
FolderPath = path
}
};
AddEtl(store, configuration, connectionString);
}
private void SetupLocalOlapEtl(DocumentStore store, OlapEtlConfiguration configuration, string path, string connectionStringName)
{
var connectionString = new OlapConnectionString
{
Name = connectionStringName,
LocalSettings = new LocalSettings
{
FolderPath = path
}
};
AddEtl(store, configuration, connectionString);
}
private static AddEtlOperationResult AddEtl(IDocumentStore src, OlapEtlConfiguration configuration, OlapConnectionString connectionString)
{
var putResult = src.Maintenance.Send(new PutConnectionStringOperation <OlapConnectionString>(connectionString));
Assert.NotNull(putResult.RaftCommandIndex);
var addResult = src.Maintenance.Send(new AddEtlOperation <OlapConnectionString>(configuration));
return(addResult);
}
