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