예제 #1
0
        public QvDataContractResponse getFields(IQlikConnector driver, string database, string table, Dictionary <string, string> userParameters)
        {
            QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Debug, "+ getFields()");

            QvDataContractResponse retVal;

            try {
                Database db = driver.getDatabases(userParameters).Find(x => x.qName == database);
                QvxTable tb = driver.getTables(db, userParameters).Find(x => x.TableName == table);

                retVal = new QvDataContractFieldListResponse
                {
                    qFields = driver.getFields(db, tb, userParameters).ToArray()
                };
            }
            catch (Exception e)
            {
                QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Error, "getFields() : " + e.Message);
                throw e;
            }

            QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Debug, "- getFields()");

            return(retVal);
        }
예제 #2
0
        public QvDataContractResponse getPreview(IQlikConnector driver, string database, string table, Dictionary <string, string> userParameters)
        {
            QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Debug, "+ getPreview()");

            QvDataContractPreviewResponse retVal;

            try {
                Database db = driver.getDatabases(userParameters).Find(x => x.qName == database);
                QvxTable tb = driver.getTables(db, userParameters).Find(x => x.TableName == table);

                retVal = new QvDataContractPreviewResponse()
                {
                    qPreview = new List <MyQvxDataRow>()
                    {
                        new MyQvxDataRow()
                        {
                            qValues = driver.getFields(db, tb, userParameters).Select(a => a.FieldName).ToList()
                        }
                    }
                };

                retVal.qPreview.AddRange(
                    driver.getPreview(db, tb, userParameters).Select(
                        a => new MyQvxDataRow()
                {
                    qValues = a
                }
                        ).ToList()
                    );
            }
            catch (Exception e)
            {
                QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Error, "getPreview() : " + e.Message);
                throw e;
            }

            QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Debug, "- getPreview()");

            return(retVal);
        }