Package it.eng.spagobi.tools.dataset.common.datastore

Examples of it.eng.spagobi.tools.dataset.common.datastore.IDataStoreMetaData

163
164
165
166
167
168
169
170
171
172
173
174
175
176
    config.put("columnsOverflow", columnsOverflow);
    dataMatrix = getDataMatrix(columnsSpecification, rowsSpecification, columnCordinates, rowCordinates, data, measuresOnColumns, measuresCount, columnsRoot.getLeafsNumber());
   
    // put measures' info into measures variable
    measures = new ArrayList<CrossTab.MeasureInfo>();
    IDataStoreMetaData meta = dataStore.getMetaData();
    for(int i = meta.getFieldCount() - measuresCount; i < meta.getFieldCount(); i++){
      // the field number i contains the measure number (i - <number of dimensions>)
      // but <number of dimension> is <total fields count> - <total measures count>
      IFieldMetaData fieldMeta = meta.getFieldMeta(i);
      Measure relevantMeasure = crosstabDefinition.getMeasures().get( i - (meta.getFieldCount() - measuresCount));
      measures.add(getMeasureInfo(fieldMeta, relevantMeasure));
    }
  }
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
   
    GeoReportEngineInstance engineInstance;
   
    IDataSet dataSet;
    IDataStore dataStore;
    IDataStoreMetaData dataStoreMeta;
   
    logger.debug("IN");
   
    try {
     
      featureSourceType = servletIOManager.getParameterAsString(FEATURE_SOURCE_TYPE);
      logger.debug("Parameter [" + FEATURE_SOURCE_TYPE + "] is equal to [" + featureSourceType + "]");
     
      featureSource = servletIOManager.getParameterAsString(FEATURE_SOURCE);
      logger.debug("Parameter [" + FEATURE_SOURCE + "] is equal to [" + featureSourceType + "]");
     
      layerName = servletIOManager.getParameterAsString(LAYER_NAME);
      logger.debug("Parameter [" + LAYER_NAME + "] is equal to [" + layerName + "]");
     
      businessIdPName = servletIOManager.getParameterAsString(BUSINESSID_PNAME);
      logger.debug("Parameter [" + BUSINESSID_PNAME + "] is equal to [" + businessIdPName + "]");
     
      geoIdPName = servletIOManager.getParameterAsString(GEOID_PNAME);
      logger.debug("Parameter [" + GEOID_PNAME + "] is equal to [" + geoIdPName + "]");
     
     
     
     
      engineInstance =  (GeoReportEngineInstance)servletIOManager.getHttpSession().getAttribute(EngineConstants.ENGINE_INSTANCE);
     
      //DataSet
      dataSet = engineInstance.getDataSet();
      dataSet.setParamsMap(engineInstance.getEnv());
      dataSet.loadData();
     
      //Datastore
      dataStore = dataSet.getDataStore();
      dataStoreMeta = dataStore.getMetaData();
           
      // # COL NUMBER
      int nc = dataStoreMeta.getFieldCount();

     
     
      //Create Output Collection of Features
      Collection outputFeatureCollection = new ArrayList();
     
      // used to avoid multiple creation of the same geographical feature
      Set geoIdPValues = new HashSet();
     

      // for each row
      Iterator it = dataStore.iterator();

      IFeaturesProviderDAO featuresProvider = FeaturesProviderDAOFactory.getFeaturesProviderDAO(featureSourceType);
     
      while(it.hasNext()) {
            
        IRecord record = (IRecord)it.next();
          IField field;
        field = record.getFieldAt( dataStoreMeta.getFieldIndex(businessIdPName) );
             
             
             
          //IDfetaure
        geoIdPValue = "" + field.getValue();

       
        if(geoIdPValues.contains(geoIdPValue)) {
          continue;
        } else {
          geoIdPValues.add(geoIdPValue);
        }
       
          Map parameters = new HashMap();
          parameters.put("layerName", layerName);
          parameters.put("geoIdPName", geoIdPName);
          parameters.put("geoIdPValue", geoIdPValue);
                 
        // geoserver call
          try {
           
              MfFeatureCollection featureCollection = featuresProvider.getFeatures(featureSource, parameters);
              List featureList = new ArrayList(featureCollection.getCollection());
              MfFeature feature = (MfFeature) featureList.get(0);
             
              //Geometry from GeoServer
              MfGeometry geom = feature.getMfGeometry();
             
             
              // JSON creation
              JSONObject jsonProperties = new JSONObject();
         
              //for each col
              for(int j=0; j<nc; j++){
                jsonProperties.accumulate(
                    dataStoreMeta.getFieldName(j),
                    record.getFieldAt( dataStoreMeta.getFieldIndex(dataStoreMeta.getFieldName(j)) ).getValue()
                ); 
              }
             
              //for each prop
              if(feature instanceof SbiFeature) {
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
   * @return the table object
   * @throws BadElementException
   */
  public PdfPTable buildTableHeader(IDataStore dataStore) throws BadElementException{ 
    logger.debug("IN: building the headers of the table");
    IDataStoreMetaData dataStoreMetaData = dataStore.getMetaData(); 
      int colunum = dataStoreMetaData.getFieldCount();
      int visibleColumns=0;
      List<String> columnsName = new ArrayList<String>();
     
      //reads the names of the visible table columns
      for(int j = 0; j < colunum; j++){
          String fieldName = dataStoreMetaData.getFieldName(j);
          IFieldMetaData fieldMetaData = dataStoreMetaData.getFieldMeta(j);
//          String format = (String) fieldMetaData.getProperty("format");
          String alias = (String) fieldMetaData.getAlias();
          Boolean visible = (Boolean) fieldMetaData.getProperty("visible");

          if (visible != null && visible.booleanValue()) {
View Full Code Here
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
    boolean oddRows  = true;
    PdfPCell cell;
   
    Iterator it = dataStore.iterator();
     
      IDataStoreMetaData d = dataStore.getMetaData(); 
   
    while(it.hasNext()){//for each record
      IRecord record =(IRecord)it.next();
      List fields = record.getFields();
      int length = fields.size();
      //build the row
      for(int fieldIndex =0; fieldIndex<length; fieldIndex++){
        IField f = (IField)fields.get(fieldIndex);
        IFieldMetaData fieldMetaData = d.getFieldMeta(fieldIndex);
          Boolean visible = (Boolean) fieldMetaData.getProperty("visible");
         
          if(visible){
            if (f == null || f.getValue()== null) {
              cell = new PdfPCell(new Phrase(""));
            }else{
            Class c = d.getFieldType(fieldIndex);
            cell = new PdfPCell(new Phrase(formatPDFCell(c, f)));
            if(oddRows){
              cell.setBackgroundColor(oddrowsBackgroundColor);
            }else{
              cell.setBackgroundColor(evenrowsBackgroundColor);
View Full Code Here
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
    IDataStore dataStore = dataSet.getDataStore();
    logger.debug("Got the datastore");

    if (dataStore != null && !dataStore.isEmpty()) {
      // Transform result into KPIValue (I suppose that the result has a unique value)
      IDataStoreMetaData d = dataStore.getMetaData();   
      int indexRes = d.getFieldIndex(RESOURCE);

      if(indexRes!=-1){
        Iterator it = dataStore.iterator();
        while(it.hasNext()){
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
  }
 
  public CellStyle[] fillSheetHeader(Sheet sheet,Workbook wb, CreationHelper createHelper, int beginRowHeaderData, int beginColumnHeaderData) { 
    CrosstabXLSExporter xlsExp = new CrosstabXLSExporter();
    CellStyle hCellStyle = xlsExp.buildHeaderCellStyle(sheet);
    IDataStoreMetaData d = dataStore.getMetaData(); 
      int colnum = d.getFieldCount();
      Row row = sheet.getRow(beginRowHeaderData);
      CellStyle[] cellTypes = new CellStyle[colnum]; // array for numbers patterns storage
      for(int j = 0; j < colnum; j++){
        Cell cell = row.createCell(j + beginColumnHeaderData);
          cell.setCellType(HSSFCell.CELL_TYPE_STRING);
          String fieldName = d.getFieldName(j);
          IFieldMetaData fieldMetaData = d.getFieldMeta(j);
          String format = (String) fieldMetaData.getProperty("format");
          String alias = (String) fieldMetaData.getAlias();
          Boolean visible = (Boolean) fieldMetaData.getProperty("visible");
            if (extractedFields != null && extractedFields.get(j) != null) {
            Field field = (Field) extractedFields.get(j);
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
     
    CellStyle cellStyleDate = wb.createCellStyle(); // cellStyleDate is the default cell style for dates
    cellStyleDate.cloneStyleFrom(dCellStyle);
    cellStyleDate.setDataFormat(createHelper.createDataFormat().getFormat("m/d/yy"));
   
    IDataStoreMetaData d = dataStore.getMetaData(); 
   
    while(it.hasNext()){
      Row rowVal = sheet.getRow(rownum);
      IRecord record =(IRecord)it.next();
      List fields = record.getFields();
      int length = fields.size();
      for(int fieldIndex =0; fieldIndex<length; fieldIndex++){
        IField f = (IField)fields.get(fieldIndex);
        if (f != null && f.getValue()!= null) {
              IFieldMetaData fieldMetaData = d.getFieldMeta(fieldIndex);
              Boolean visible = (Boolean) fieldMetaData.getProperty("visible");
              if(visible){
            Class c = d.getFieldType(fieldIndex);
            logger.debug("Column [" + (fieldIndex) + "] class is equal to [" + c.getName() + "]");
            if(rowVal==null){
              rowVal = sheet.createRow(rownum);
            }
            Cell cell = rowVal.createCell(fieldIndex + beginColumnData);
View Full Code Here
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
    logger.debug("IN");
    if(dataStore==null || dataStore.getMetaData()==null){
      logger.error("Data Store is null, cannot recover metadata because Data Store or Data Store metadata is null");
      return null;
    }
    IDataStoreMetaData dataStoreMetaData=dataStore.getMetaData();

    HashMap<String , Class> metadataMap=new HashMap<String, Class>();
    for (int i = 0; i < dataStoreMetaData.getFieldCount(); i++) {
      IFieldMetaData fieldMetaData=dataStoreMetaData.getFieldMeta(i);
      String name = fieldMetaData.getAlias() != null ? fieldMetaData.getAlias() : fieldMetaData.getName();
      Class type = fieldMetaData.getType();
      if(!metadataMap.containsKey(name)){
        metadataMap.put(name, type);
      }
View Full Code Here
210
211
212
213
214
215
216
217
218
219
220
221
222
223
        dataSource.setPwd(connection.getPassword());
        dataSet.setDataSource(dataSource);
        dataSet.setQuery(sqlQuery);
        dataSet.loadData(start, limit, -1);
        dataStore = dataSet.getDataStore();
        IDataStoreMetaData dataStoreMetadata = dataStore.getMetaData();
        for(int i = 0; i < dataStoreMetadata.getFieldCount(); i++) {
          ISelectField queryField = (ISelectField)queryFields.get(i);
          dataStoreMetadata.changeFieldAlias(i, queryField.getAlias());
        }
      } catch (Exception e) {
        logger.debug("Query execution aborted because of an internal exceptian");
        SpagoBIEngineServiceException exception;
        String message;
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
    Object propertyRawValue;
   
    Assert.assertNotNull(dataStore, "Object to be serialized connot be null");
   
    try {
      IDataStoreMetaData dataStoreMeta = dataStore.getMetaData();
      valueField = "Values";
      displayField = "Values";
      descriptionField = "Values";
     
      result = new JSONObject();
View Full Code Here
TOP

Related Classes of it.eng.spagobi.tools.dataset.common.datastore.IDataStoreMetaData

  • it.eng.qbe.query.serializer.json.LookupStoreJSONSerializer
  • it.eng.qbe.statement.AbstractQbeDataSet
  • it.eng.spagobi.engines.geo.datamart.provider.AddLinkFieldsTransformer
  • it.eng.spagobi.engines.geo.datamart.provider.DataMartProvider
  • it.eng.spagobi.engines.geo.map.renderer.InteractiveMapRenderer
  • it.eng.spagobi.engines.georeport.services.MapOlAction
  • it.eng.spagobi.engines.kpi.SpagoBIKpiInternalEngine
  • it.eng.spagobi.engines.qbe.crosstable.CrossTab
  • it.eng.spagobi.engines.qbe.query.Exporter
  • it.eng.spagobi.engines.qbe.services.formviewer.ExecuteDetailQueryAction
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.