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

Example 11 with CSVReader

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

the class palodimension method refreshDimensionInfo.

public void refreshDimensionInfo() throws paloexception {
    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)));
    try {
        HttpEntity entity = this.plConn.sendToServer(qparams, "/dimension/info");
        CSVReader csv = new CSVReader(entity.getContent(), ';', "UTF-8");
        csv.setQuoteChar('"');
        csv.readNext();
        this.strDimensionName = csv.get(1);
        this.iDimensionId = Integer.valueOf(csv.get(0));
        this.iAssocDimension = palohelpers.StringToInt(csv.get(7));
        this.iAttributCube = palohelpers.StringToInt(csv.get(8));
        this.iRightsCube = palohelpers.StringToInt(csv.get(9));
        this.iNumberOfElements = palohelpers.StringToInt(csv.get(2));
        this.iMaximumLevel = palohelpers.StringToInt(csv.get(3));
        this.iMaximumIndent = palohelpers.StringToInt(csv.get(4));
        this.iMaximumDepth = palohelpers.StringToInt(csv.get(5));
        this.iDimensionToken = palohelpers.StringToInt(csv.get(10));
        csv.close();
        entity.consumeContent();
    } catch (Exception e) {
        throw new paloexception(e.getMessage());
    }
}

Example 12 with CSVReader

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

the class palodimensions method createDimension.

public palodimension createDimension(String strDimensionName, int iType) throws paloexception {
    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", strDimensionName));
    qparams.add(new BasicNameValuePair("type", String.valueOf(iType)));
    try {
        HttpEntity entity = this.plConn.sendToServer(qparams, "/dimension/create");
        CSVReader csv = new CSVReader(entity.getContent(), ';', "UTF-8");
        csv.setQuoteChar('"');
        csv.readNext();
        palodimension plDim = new palodimension(this.plConn, this.plDB.getDatabaseId(), csv.get(1), palohelpers.StringToInt(csv.get(0)), palohelpers.StringToInt(csv.get(7)), palohelpers.StringToInt(csv.get(8)), palohelpers.StringToInt(csv.get(9)), palohelpers.StringToInt(csv.get(2)), palohelpers.StringToInt(csv.get(3)), palohelpers.StringToInt(csv.get(4)), palohelpers.StringToInt(csv.get(5)), palohelpers.StringToInt(csv.get(10)));
        paloDimensions.add(plDim);
        csv.close();
        entity.consumeContent();
        return plDim;
    } catch (Exception e) {
        throw new paloexception(e.getMessage());
    }
}

Example 13 with CSVReader

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

the class paloelement method rename.

public void rename(String strElementNewName) throws paloexception {
    if (null != strElementNewName && strElementNewName.length() > 0 && !strElementName.equals(strElementNewName)) {
        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("element", String.valueOf(this.lElementIdentifier)));
        qparams.add(new BasicNameValuePair("new_name", strElementNewName));
        try {
            HttpEntity entity = this.plConn.sendToServer(qparams, "/element/rename");
            CSVReader csv = new CSVReader(entity.getContent(), ';', "UTF-8");
            csv.setQuoteChar('"');
            csv.readNext();
            this.strElementName = csv.get(1);
            csv.close();
            entity.consumeContent();
        } catch (Exception e) {
            throw new paloexception(e.getMessage());
        }
        strElementName = strElementNewName;
    }
}

Example 14 with CSVReader

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

the class paloelement method move.

public void move(long lElementNewPosition) throws paloexception {
    if (lElementNewPosition > -1 && lElementNewPosition != iElementPosition) {
        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("element", String.valueOf(this.lElementIdentifier)));
        qparams.add(new BasicNameValuePair("position", String.valueOf(lElementNewPosition)));
        try {
            HttpEntity entity = this.plConn.sendToServer(qparams, "/element/move");
            CSVReader csv = new CSVReader(entity.getContent(), ';', "UTF-8");
            csv.setQuoteChar('"');
            while (csv.readNext()) {
                this.lElementIdentifier = palohelpers.StringToLong(csv.get(0));
                this.strElementName = csv.get(1);
                this.iElementPosition = palohelpers.StringToInt(csv.get(2));
                this.iElementLevel = palohelpers.StringToInt(csv.get(3));
                this.iElementIndent = palohelpers.StringToInt(csv.get(4));
                this.iElementDepth = palohelpers.StringToInt(csv.get(5));
                this.iElementType = palohelpers.StringToInt(csv.get(6));
                this.iElementNumOfParents = palohelpers.StringToInt(csv.get(7));
                this.iArrElementParents = palohelpers.StringToIntArray(csv.get(8), palohelpers.StringToInt(csv.get(7)));
                this.iElementNumOfChildren = palohelpers.StringToInt(csv.get(9));
                this.iArrElementChildren = palohelpers.StringToIntArray(csv.get(10), palohelpers.StringToInt(csv.get(9)));
                this.dArrElementChildrenWeights = palohelpers.StringToDoubleArray(csv.get(11), palohelpers.StringToInt(csv.get(9)));
            }
            csv.close();
            entity.consumeContent();
        } catch (Exception e) {
            throw new paloexception(e.getMessage());
        }
    }
}

Example 15 with CSVReader

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

the class paloelement method getFatherPaloelement.

// get father paloelement
public paloelement getFatherPaloelement() throws paloexception {
    long identifier = getElementParentIdentifier();
    paloelement plElm = null;
    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("element", String.valueOf(identifier)));
    try {
        HttpEntity entity = this.plConn.sendToServer(qparams, "/element/info");
        CSVReader csv = new CSVReader(entity.getContent(), ';', "UTF-8");
        csv.setQuoteChar('"');
        while (csv.readNext()) {
            if (palohelpers.StringToLong(csv.get(0)) == identifier) {
                plElm = new paloelement(this.plConn, this.lDatabaseId, this.iDimensionId, paloElements, palohelpers.StringToLong(csv.get(0)), csv.get(1), palohelpers.StringToInt(csv.get(2)), palohelpers.StringToInt(csv.get(3)), palohelpers.StringToInt(csv.get(4)), palohelpers.StringToInt(csv.get(5)), palohelpers.StringToInt(csv.get(6)), palohelpers.StringToInt(csv.get(7)), palohelpers.StringToIntArray(csv.get(8), palohelpers.StringToInt(csv.get(7))), palohelpers.StringToInt(csv.get(9)), palohelpers.StringToIntArray(csv.get(10), palohelpers.StringToInt(csv.get(9))), palohelpers.StringToDoubleArray(csv.get(11), palohelpers.StringToInt(csv.get(9))));
            }
        }
        csv.close();
        entity.consumeContent();
    } catch (Exception e) {
        throw new paloexception(e.getMessage());
    }
    return plElm;
}