private QvDataContractResponse GetDatabases(UserParameter parameter)
{
var databaseList = new List <QlikView.Qvx.QvxLibrary.Database>();
try
{
var config = QlikApp.CreateConfig(parameter);
var qlikApp = new QlikApp(parameter);
var apps = qlikApp.GetAllApps(config);
var appNames = apps.Select(s => s.qDocName).ToList();
foreach (var app in appNames)
{
databaseList.Add(new QlikView.Qvx.QvxLibrary.Database()
{
qName = app
});
}
return(new QvDataContractDatabaseListResponse {
qDatabases = databaseList.ToArray()
});
}
catch (Exception ex)
{
logger.Error(ex, $"databases not loaded.");
return(new QvDataContractDatabaseListResponse {
qDatabases = databaseList.ToArray()
});
}
}
private QvDataContractResponse GetPreview(UserParameter parameter, string appId, string objectId)
{
q2gconhypercubemain.Connection connection = null;
try
{
var oId = GetObjectId(objectId);
if (String.IsNullOrEmpty(oId))
{
throw new Exception("no object id for preview table found.");
}
var config = QlikApp.CreateConfig(parameter, appId);
var qlikApp = new QlikApp(parameter);
connection = qlikApp.CreateNewConnection(config);
var script = ScriptCode.Create(appId, oId);
var resultTable = tableFunctions.GetTableInfosFromApp("PreviewTable", script, connection.CurrentApp);
if (resultTable == null)
{
throw new Exception("no preview table found.");
}
return(PreviewResponse.Create(resultTable.Preview));
}
catch (Exception ex)
{
logger.Error(ex, $"fields from app {appId} and table {objectId} not loaded.");
return(new PreviewResponse());
}
finally
{
connection?.Close();
}
}
private void CreateAppThumbs(QlikApp qlikApp, Uri uri)
{
var appName = qlikApp.Name;
var appId = qlikApp.Id;
var streamName = qlikApp.StreamName;
_counterHashSet.Add("STREAM/" + streamName);
_counterHashSet.Add("APP/" + appId);
_log.Information("Creating thumbs for {0}", appName);
var appDir = _thumbOutputPath + Path.DirectorySeparatorChar
+ FileNameUtility.EscapeFilenameWindows(streamName)
+ Path.DirectorySeparatorChar +
FileNameUtility.EscapeFilenameWindows(appName);
if (Directory.Exists(appDir) == false)
{
Directory.CreateDirectory(appDir);
}
var retrieveAppSheets = _qlikEngineService.RetrieveAppSheets(qlikApp.Id, qlikApp.Name);
foreach (QlikSheet qlikSheet in retrieveAppSheets)
{
var sheetPath = qlikSheet.EngineObjectId;
var sheetName = qlikSheet.Name;
_counterHashSet.Add("SHEET/" + sheetPath);
string url = uri.AbsoluteUri + "sense/app/" + appId + "/sheet/" + sheetPath + "/state/analysis";
_webDriver.Navigate().GoToUrl(url);
((IJavaScriptExecutor)_webDriver).ExecuteScript(QlikThumbProcessorJs.WaitForSheetLoadJsChrome);
var wait = new WebDriverWait(_webDriver, TimeSpan.FromSeconds(20));
wait.Until(s =>
((IJavaScriptExecutor)_webDriver).ExecuteScript("return window.oneSecondPastLastEvent();")
.Equals(true));
var fileName = FileNameUtility.EscapeFilenameWindows(streamName + "_" + appName + "_" + sheetName);
var filePath = appDir + Path.DirectorySeparatorChar + fileName + ".jpg";
_log.Information("Writing out the thumb for Stream:{0}, App:{1}, Sheet:{2}", streamName, appName,
sheetName);
ITakesScreenshot scrShot = ((ITakesScreenshot)_webDriver);
scrShot.GetScreenshot().SaveAsFile(filePath);
if (string.IsNullOrWhiteSpace(_qlikThumbModel.TaskType) == false &&
_qlikThumbModel.TaskType.Equals(QlikThumbModel.TaskContentDirectorySave))
{
_log.Information("Uploading the thumb for Stream:{0}, App:{1}, Sheet:{2} Content Library {3}",
streamName, appName, sheetName, _qlikThumbModel.ContentLibrary.Name);
_qlikEngineService.UploadFileToContentDirectory(_qlikThumbModel.ContentLibrary.Name, filePath);
}
}
}
public QlikStreamApp(QlikApp qlikApp)
{
QlikApp = qlikApp;
Name = qlikApp.Name;
StreamName = qlikApp.Stream?.Name;
Order = 0;
}
private ResultTable GetData(ScriptCode script, UserParameter parameter)
{
q2gconhypercubemain.Connection connection = null;
try
{
var config = QlikApp.CreateConfig(parameter, script.AppId);
var qlikApp = new QlikApp(parameter);
connection = qlikApp.CreateNewConnection(config);
if (!connection.Connect())
{
return(null);
}
foreach (var filter in script.Filter)
{
logger.Debug($"Filter: {filter}");
foreach (var value in filter.Values)
{
var selection = new QlikSelections(connection.CurrentApp);
var result = selection.SelectValue(filter.Name, value);
if (result == false)
{
logger.Error($"The Dimension \"{filter.Name}\" could not found.");
return(null);
}
}
}
var resultTable = tableFunctions.GetTableInfosFromApp($"Table_{script.AppId}_{script.ObjectId}", script, connection.CurrentApp);
return(resultTable.QvxTable);
}
catch (Exception ex)
{
logger.Error(ex, "The table script can not be executed.");
return(null);
}
finally
{
connection?.Close();
}
}
private QvDataContractResponse GetFields(UserParameter parameter, string appId, string objectId)
{
q2gconhypercubemain.Connection connection = null;
using (MappedDiagnosticsLogicalContext.SetScoped("connectionId", connection?.ConnId))
{
try
{
var oId = GetObjectId(objectId);
if (String.IsNullOrEmpty(oId))
{
throw new Exception("no object id for field table found.");
}
var script = ScriptCode.Create(appId, oId);
var config = QlikApp.CreateConfig(parameter, appId);
var qlikApp = new QlikApp(parameter);
connection = qlikApp.CreateNewConnection(config);
var resultTable = tableFunctions.GetTableInfosFromApp("FieldTable", script, connection.CurrentApp);
if (resultTable == null)
{
throw new Exception("no field table found.");
}
var qvxTable = TableUtilities.ConvertTable(resultTable.QvxTable);
return(new QvDataContractFieldListResponse {
qFields = qvxTable.Fields
});
}
catch (Exception ex)
{
logger.Error(ex, $"fields from app {appId} and table {objectId} not loaded.");
return(new QvDataContractFieldListResponse {
qFields = new QvxField[0]
});
}
finally
{
connection?.Close();
}
}
}
public TableHelper GetTableInfosFromApp(string tableName, ScriptCode script, ConnectorParameter parameter, QlikApp qlikApp = null)
{
try
{
var resultTable = new QvxTable()
{
TableName = tableName,
};
HyperCubePager pager = null;
IEnumerable <int> columnOrder = null;
var fields = new List <QvxField>();
var rows = new List <QvxDataRow>();
var size = new Size();
if (qlikApp == null)
{
qlikApp = AppInstance.GetQlikInstance(parameter, script.AppId);
}
if (qlikApp == null)
{
return(null);
}
var masterObject = qlikApp.FirstSession.CurrentApp.GetMasterObjectAsync(script.ObjectId).Result;
if (masterObject != null)
{
logger.Debug($"find master object: {script.ObjectId}");
var genericObject = qlikApp.FirstSession.CurrentApp.CreateGenericSessionObjectAsync(masterObject.Properties).Result;
pager = genericObject.GetAllHyperCubePagers().FirstOrDefault() ?? null;
var tableLayout = genericObject.GetLayout().As <TableLayout>();
var hyperCube = tableLayout.HyperCube;
columnOrder = hyperCube.ColumnOrder;
size = hyperCube.Size;
fields.AddRange(GetHyperCubeFields(hyperCube.DimensionInfo, hyperCube.MeasureInfo, script));
}
var table = qlikApp.FirstSession.CurrentApp.GetObjectAsync <Table>(script.ObjectId).Result;
if (table != null)
{
logger.Debug($"table object: {script.ObjectId}");
pager = table.HyperCubePager;
columnOrder = table.ColumnOrder;
size = table.Size;
fields.AddRange(GetHyperCubeFields(table.DimensionInfo, table.MeasureInfo, script));
}
var preview = new PreviewResponse()
{
MaxCount = 15,
};
if (script != null)
{
var initalPage = new NxPage {
Top = 0, Left = 0, Width = size.cx, Height = preview.MaxCount
};
var allPages = new List <IEnumerable <NxDataPage> >();
allPages.Add(pager.GetData(new List <NxPage>()
{
initalPage
}));
if (script.Full)
{
var pageHeight = Math.Min(size.cy * size.cx, 5000) / size.cx;
logger.Debug($"read data - column count: {size.cx}");
initalPage = new NxPage {
Top = 0, Left = 0, Width = size.cx, Height = pageHeight
};
allPages = pager.IteratePages(new[] { initalPage }, Pager.Next).ToList();
preview.MaxCount = 0;
}
if (allPages == null)
{
throw new Exception($"no dimension in table {script.ObjectId} exits.");
}
logger.Debug($"read pages - count {allPages.Count}");
foreach (var page in allPages)
{
var allMatrix = page?.SelectMany(p => p.Matrix);
foreach (var matrix in allMatrix)
{
var row = new QvxDataRow();
var hrow = new PreviewRow();
var drow = new PreviewRow();
foreach (var order in columnOrder)
{
if (order < fields.Count)
{
var field = fields[order];
row[field] = matrix[order].Text;
if (!preview.qPreview.Any(s => s.qValues.Contains(field.FieldName)))
{
hrow.qValues.Add(field.FieldName);
}
if (preview.qPreview.Count <= preview.MaxCount)
{
drow.qValues.Add(matrix[order].Text);
}
}
}
rows.Add(row);
if (hrow.qValues.Count > 0)
{
preview.qPreview.Add(hrow);
}
if (drow.qValues.Count > 0)
{
preview.qPreview.Add(drow);
}
}
}
}
resultTable.Fields = fields.ToArray();
resultTable.GetRows = () => { return(rows); };
logger.Debug($"return table {resultTable.TableName}");
return(new TableHelper(resultTable, preview));
}
catch (Exception ex)
{
logger.Error(ex, "can´t read table infos.");
return(null);
}
}
private QvDataContractResponse GetTables(UserParameter parameter, string appName)
{
var tables = new List <QvxTable>();
q2gconhypercubemain.Connection connection = null;
using (MappedDiagnosticsLogicalContext.SetScoped("connectionId", connection?.ConnId))
{
try
{
var config = QlikApp.CreateConfig(parameter, appName);
var qlikApp = new QlikApp(parameter);
var appId = qlikApp.GetAllApps(config).FirstOrDefault(a => a.qDocName == appName).qDocId;
config = QlikApp.CreateConfig(parameter, appId);
connection = qlikApp.CreateNewConnection(config);
var options = new NxGetObjectOptions()
{
qTypes = new List <string> {
"table"
}
};
var tablesObjects = connection.CurrentApp.GetObjectsAsync(options).Result;
foreach (var obj in tablesObjects)
{
var tableObject = connection.CurrentApp.GetObjectAsync(obj.qInfo.qId).Result;
dynamic layout = tableObject.GetLayoutAsync <JObject>().Result;
tables.Add(new QvxTable()
{
TableName = $"{layout.title} [{obj.qInfo.qId}]"
});
}
options = new NxGetObjectOptions()
{
qTypes = new List <string> {
"masterobject"
}
};
var visualisations = connection.CurrentApp.GetObjectsAsync(options).Result;
foreach (var element in visualisations)
{
var tableObject = connection.CurrentApp.GetObjectAsync(element.qInfo.qId).Result;
dynamic layout = tableObject.GetLayoutAsync <JObject>().Result;
tables.Add(new QvxTable()
{
TableName = $"{layout.qMeta.title} [{element.qInfo.qId}]"
});
}
return(new QvDataContractTableListResponse {
qTables = tables
});
}
catch (Exception ex)
{
logger.Error(ex, $"tables form app {appName} not loaded.");
return(new QvDataContractTableListResponse {
qTables = tables
});
}
finally
{
connection?.Close();
}
}
}