Javadoc for flexmonster compressor

Hi Dennis,

Unfortunately, we don't have a detailed description of CSVCompressor API, but it doesn't have a complicated structure.
Please find all supported method below:

Compression for CSV files

InputStream compressFile(String fileName, char delimiter)
InputStream compressFile(String fileName)

Compression for strings in CSV format

InputStream compressString(String string, char delimiter)
InputStream compressString(String string)

Compression for streams

InputStream compressStream(InputStream inputStream, char delimiter)
InputStream compressStream(InputStream inputStream)

Compression for Databases

InputStream compressDb(ResultSet resultSet)

Example

import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.flexmonster.compressor.Compressor;

public class CompressorServlet extends HttpServlet {

 public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException {
    
   try {
     Class.forName("com.mysql.jdbc.Driver").newInstance();
     Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/foodmart", "root", "password");
     String query = "SELECT * FROM customer";
     Statement statement = connection.createStatement();
     ResultSet resultSet = statement.executeQuery(query);
 
     InputStream inputStream = Compressor.compressDb(resultSet);
     //InputStream inputStream = Compressor.compressFile(this.getServletContext().getRealPath("/WEB-INF/data.csv"));
 
     response.setContentType("text/plain");
     OutputStream outputStream = response.getOutputStream();
     byte[] buffer = new byte[10240];
     int length = 0;
     while ((length = inputStream.read(buffer)) > 0) {
      outputStream.write(buffer, 0, length);
      outputStream.flush();
     }
   } catch (Exception e) {
     e.printStackTrace();
   }

  }
}

Hi Dennis,

I think in your case it would be enough to set content-type as "text/plain".
Please ask me if you need more help.

Regards,
  Tanya

Hello,
Please find the answer to the question in the following thread: http://www.flexmonster.com/question/error-calling-compressor-compressstringstring/.
Regards,
Dmytro.

Hello Simba, 
Thank you for writing. Yes, you are right, compressing string data is no a very efficient solution. However, we recommend using the ResultSet since it should provide much better performance. As we can see it, the MyBatis is a framework which works over the JDBC level, therefore the ResultSet should be available there. The idea is to path non-mapped data to the compressor. Seems it can be done the following way - https://stackoverflow.com/questions/36025073/get-resultset-from-mybatis.
Please let us know if the suggested approach solves the case.
Regards,
Dmytro

Hello Simba,
Getting non-mapped data means that you should get the object which contains metadata and query result. The possible solution is to write the necessary query using JDBC connector. You can find the tutorial in our documentation - http://www.flexmonster.com/doc/connecting-to-relational-database-with-java/. The other approach is to get ResultSet when using MyBatis. Please find the possible solution here - https://coderanch.com/t/415314/databases/retrieve-metadata-ibatis. You need to implement TypeHandlerCallback interface and then call from ResultGetter object getResultSet() method - https://ibatis.apache.org/docs/java/user/com/ibatis/sqlmap/client/extensions/ResultGetter.html#getResultSet(). After that you can pass ResultSet object to the compressor.
Regards,
Dmytro.