Examples with CSVReader com.talend.csv.CSVReader used on opensource projects

Example 16 with CSVReader

use of com.talend.csv.CSVReader in project tdi-studio-se by Talend.

the class palocubes method createCube.

public palocube createCube(String strCubeName, String[] strArrDimensions, int iType) throws paloexception {
    palodimensions plDIMs = plDB.getDimensions(iType);
    StringBuilder sbDimensionsToCreate = new StringBuilder();
    int iPos = 0;
    for (String strDimensionName : strArrDimensions) {
        if (iPos > 0) {
            sbDimensionsToCreate.append(",");
        }
        palodimension plDIM = plDIMs.getDimension(strDimensionName);
        if (null == plDIM) {
            sbDimensionsToCreate.append("-1");
        } else {
            sbDimensionsToCreate.append(plDIMs.getDimension(strDimensionName).getDimensionId());
        }
        iPos++;
    }
    List<NameValuePair> qparams = new ArrayList<NameValuePair>();
    qparams.add(new BasicNameValuePair("sid", this.plConn.getPaloToken()));
    qparams.add(new BasicNameValuePair("database", String.valueOf(this.plDB.getDatabaseId())));
    qparams.add(new BasicNameValuePair("new_name", strCubeName));
    qparams.add(new BasicNameValuePair("type", String.valueOf(iType)));
    qparams.add(new BasicNameValuePair("dimensions", sbDimensionsToCreate.toString()));
    try {
        palocube plCube = null;
        HttpEntity entity = this.plConn.sendToServer(qparams, "/cube/create");
        CSVReader csv = new CSVReader(entity.getContent(), ';', "UTF-8");
        csv.setQuoteChar('"');
        while (csv.readNext()) {
            // System.out.println(csv.getRawRecord());
            plCube = new palocube(plConn, plDB.getDatabaseId(), palohelpers.StringToInt(csv.get(0)), csv.get(1), palohelpers.StringToInt(csv.get(2)), palohelpers.StringToIntArray(csv.get(3), palohelpers.StringToInt(csv.get(2))), palohelpers.StringToLong(csv.get(4)), palohelpers.StringToLong(csv.get(5)), palohelpers.StringToInt(csv.get(6)), palohelpers.StringToInt(csv.get(7)), palohelpers.StringToInt(csv.get(8)));
            paloCubes.add(plCube);
        }
        csv.close();
        entity.consumeContent();
        return plCube;
    } catch (Exception e) {
        throw new paloexception(e.getMessage());
    }
}

Example 17 with CSVReader

use of com.talend.csv.CSVReader in project tdi-studio-se by Talend.

the class palodatabase method rename.

public void rename(String strNewName) throws paloexception {
    List<NameValuePair> qparams = new ArrayList<NameValuePair>();
    qparams.add(new BasicNameValuePair("sid", this.plConn.getPaloToken()));
    qparams.add(new BasicNameValuePair("database", String.valueOf(this.lDatabaseId)));
    qparams.add(new BasicNameValuePair("new_name", strNewName));
    try {
        HttpEntity entity = this.plConn.sendToServer(qparams, "/database/rename");
        CSVReader csv = new CSVReader(entity.getContent(), ';', "UTF-8");
        csv.setQuoteChar('"');
        csv.readNext();
        this.strDatabaseName = csv.get(1);
        this.iNumberOfDimensions = Integer.valueOf(csv.get(2));
        this.iNumberOfCubes = Integer.valueOf(csv.get(3));
        this.iStatus = Integer.valueOf(csv.get(4));
        this.iType = Integer.valueOf(csv.get(5));
        csv.close();
        entity.consumeContent();
    } catch (Exception e) {
        throw new paloexception(e.getMessage());
    }
}

Example 18 with CSVReader

use of com.talend.csv.CSVReader in project tdi-studio-se by Talend.

the class palodatabases method createDatabase.

public palodatabase createDatabase(String strDatabaseName) throws paloexception {
    List<NameValuePair> qparams = new ArrayList<NameValuePair>();
    qparams.add(new BasicNameValuePair("sid", this.plConn.getPaloToken()));
    qparams.add(new BasicNameValuePair("new_name", strDatabaseName));
    try {
        HttpEntity entity = this.plConn.sendToServer(qparams, "/database/create");
        CSVReader csv = new CSVReader(entity.getContent(), ';', "UTF-8");
        csv.setQuoteChar('"');
        csv.readNext();
        palodatabase plDB = new palodatabase(this.plConn, csv.get(1), Long.parseLong(csv.get(0)), Integer.valueOf(csv.get(2)), Integer.valueOf(csv.get(3)), Integer.valueOf(csv.get(4)), Integer.valueOf(csv.get(5)), "");
        csv.close();
        entity.consumeContent();
        plDB.refreshDatabaseInfo();
        paloDatabases.add(plDB);
        return plDB;
    } catch (Exception e) {
        throw new paloexception(e.getMessage());
    }
}

Example 19 with CSVReader

use of com.talend.csv.CSVReader in project tdi-studio-se by Talend.

the class palodimension method rename.

public void rename(String strDimensionNewName) throws paloexception {
    if (null != strDimensionNewName && strDimensionNewName.length() > 0 && !strDimensionName.equals(strDimensionNewName)) {
        List<NameValuePair> qparams = new ArrayList<NameValuePair>();
        qparams.add(new BasicNameValuePair("sid", this.plConn.getPaloToken()));
        qparams.add(new BasicNameValuePair("database", String.valueOf(lDatabaseId)));
        qparams.add(new BasicNameValuePair("dimension", String.valueOf(this.iDimensionId)));
        qparams.add(new BasicNameValuePair("new_name", strDimensionNewName));
        try {
            HttpEntity entity = this.plConn.sendToServer(qparams, "/dimension/rename");
            CSVReader csv = new CSVReader(entity.getContent(), ';', "UTF-8");
            csv.setQuoteChar('"');
            csv.readNext();
            this.strDimensionName = csv.get(1);
            csv.close();
            entity.consumeContent();
        } catch (Exception e) {
            throw new paloexception(e.getMessage());
        }
    }
}

Example 20 with CSVReader

use of com.talend.csv.CSVReader in project tdi-studio-se by Talend.

the class palodata method getValue.

public palodatavalue getValue(long[] lDimensionElementIdentifierArray) throws paloexception {
    List qparams = new ArrayList();
    qparams.add(new BasicNameValuePair("sid", plConn.getPaloToken()));
    qparams.add(new BasicNameValuePair("database", String.valueOf(lDatabaseId)));
    qparams.add(new BasicNameValuePair("cube", String.valueOf(plCube.getCubeId())));
    StringBuilder sbCoordinates = new StringBuilder();
    int iPos = 0;
    long[] al;
    int j = (al = lDimensionElementIdentifierArray).length;
    for (int i = 0; i < j; i++) {
        long lDimensionElementIdentifier = al[i];
        if (iPos > 0) {
            sbCoordinates.append(",");
        }
        sbCoordinates.append(lDimensionElementIdentifier);
        iPos++;
    }
    qparams.add(new BasicNameValuePair("path", sbCoordinates.toString()));
    palodatavalue rcDataValue = null;
    try {
        HttpEntity entity = plConn.sendToServer(qparams, "/cell/value");
        CSVReader csv = new CSVReader(entity.getContent(), ';', "UTF-8");
        csv.setQuoteChar('"');
        while (csv.readNext()) {
            if (palohelpers.StringToInt(csv.get(0)) == 1) {
                if (palohelpers.StringToInt(csv.get(1)) > 0) {
                    rcDataValue = new palodatavalue(palohelpers.StringToDouble(csv.get(2)));
                } else {
                    rcDataValue = new palodatavalue(0.0D);
                }
            } else if (palohelpers.StringToInt(csv.get(0)) == 0) {
                rcDataValue = new palodatavalue(csv.get(2));
            }
        }
        csv.close();
        entity.consumeContent();
        return rcDataValue;
    } catch (Exception e) {
        throw new paloexception(e.getMessage());
    }
}