How to decode the data in binary_data column in the file_sources table

We are trying to find out the relation between submitter and codes. So we tried to decode this data with python. And the data is head of “LZ4Block”, so we are tring to decompress this data using LZ4 module. But failed.

Hey there.

The database is really meant to be a black-box, only interfaced with via SonarQube itself.

I don’t quite understand what you mean here. Can you go into more detail about what you’re trying to accomplish?

We are trying to analyze our developer’s code quality. We can find out the submitter of each issues in Sonar website. So we want to get these relations from database to analyze it.
I have saw some useful information from another topic——How you are encrypting code? - #7 by felipebz;
But I am not familiar with java. Can I use python to decode these binary data?

I won’t be much help with navgiating the inner workings of the Sonar database (although if it’s a good hint, the data is stored as BLOBs – binary large objects).

You should know you can also pull source data from SonarQube itself using the Web API, documentation linked in the footer of your instance. /api/sources is a good place to start.

It really sounds like SonarQube should be able to fulfill this need without advanced data mining. What’s missing from SonarQube’s out-of-the-box features?

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.