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

Example 6 with CSVReader

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

the class paloconnection method getRulefunctions.

public String getRulefunctions() throws paloexception {
    List<NameValuePair> qparams = new ArrayList<NameValuePair>();
    qparams.add(new BasicNameValuePair("sid", getPaloToken()));
    try {
        StringBuilder sb = new StringBuilder();
        HttpEntity entity = sendToServer(qparams, "/rule/functions");
        CSVReader csv = new CSVReader(entity.getContent(), ';', "UTF-8");
        csv.setQuoteChar('"');
        while (csv.readNext()) {
            sb.append(csv.get(0));
        }
        csv.close();
        entity.consumeContent();
        return sb.toString();
    } catch (Exception e) {
        throw new paloexception(e.getMessage());
    }
}

Example 7 with CSVReader

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

the class paloconnection method sendToServerSingleRC.

// Retrieves only true or false based on the given connection
public boolean sendToServerSingleRC(List<NameValuePair> qparams, String strAPIUrl) throws paloexception {
    try {
        HttpEntity entity = sendToServer(qparams, strAPIUrl);
        CSVReader csv = new CSVReader(entity.getContent(), ';', "UTF-8");
        // CsvReader csv = new CsvReader(sendToServer(qparams, strAPIUrl).getContent(), Charset.defaultCharset());
        csv.setQuoteChar('"');
        csv.readNext();
        boolean bStatus = Boolean.getBoolean(csv.get(0));
        csv.close();
        entity.consumeContent();
        return bStatus;
    } catch (Exception e) {
        throw new paloexception(e.getMessage());
    }
}

Example 8 with CSVReader

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

the class paloconnection method sendToServer.

public HttpEntity sendToServer(List<NameValuePair> qparams, String strAPIUrl) throws paloexception {
    try {
        URI uri = URIUtils.createURI("http", strServer, Integer.valueOf(strPort), strAPIUrl, URLEncodedUtils.format(qparams, "UTF-8"), null);
        HttpGet req = new HttpGet(uri);
        // System.out.println(req.getURI());
        // Send to Server
        HttpResponse rsp = paloHttpClient.execute(paloTargetHost, req);
        HttpEntity entity = rsp.getEntity();
        if (rsp.getStatusLine().getStatusCode() != 200) {
            // Error had been occured
            // Close Connection and thend raise paloexception error
            CSVReader csv = new CSVReader(entity.getContent(), ';', "UTF-8");
            csv.setQuoteChar('"');
            csv.readNext();
            paloexception plX = new paloexception(csv.get(0), csv.get(1), csv.get(2));
            csv.close();
            entity.consumeContent();
            // paloHttpClient.getConnectionManager().shutdown();
            throw (plX);
        } else {
            return entity;
        }
    } catch (Exception e) {
        // if(paloHttpClient!=null)paloHttpClient.getConnectionManager().shutdown();
        throw new paloexception(e.getMessage());
    }
}

Example 9 with CSVReader

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

the class palocube method refreshCubeInfo.

public void refreshCubeInfo() 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("cube", String.valueOf(iCubeId)));
    try {
        HttpEntity entity = this.plConn.sendToServer(qparams, "/cube/info");
        CSVReader csv = new CSVReader(entity.getContent(), ';', "UTF-8");
        csv.setQuoteChar('"');
        csv.readNext();
        this.iCubeId = palohelpers.StringToInt(csv.get(0));
        this.strCubeName = csv.get(1);
        this.iNumberOfDimensions = palohelpers.StringToInt(csv.get(2));
        this.iArrDimensionsIdentifier = palohelpers.StringToIntArray(csv.get(3), palohelpers.StringToInt(csv.get(2)));
        this.iNumberOfCells = palohelpers.StringToLong(csv.get(4));
        this.lNumberOfFilledCells = palohelpers.StringToLong(csv.get(5));
        this.iCubeStatus = palohelpers.StringToInt(csv.get(6));
        this.iCubeType = palohelpers.StringToInt(csv.get(7));
        this.iCubeToken = palohelpers.StringToInt(csv.get(8));
        csv.close();
        entity.consumeContent();
    } catch (Exception e) {
        throw new paloexception(e.getMessage());
    }
}

Example 10 with CSVReader

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

the class palocube method rename.

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