qtbase64qtscriptsqlitestudio

How to include a Qt Core c++ class for use in QtScript user function in SQLiteStudio 3.1.1?

I'm trying to write a user-defined function within SQLiteStudio (v3.1.1). This function needs to decode a field stored in base64.

I think I can achieve what I want to using the QByteArray class from Qt Core like so:

QByteArray text = QByteArray::fromBase64(base64EncodedString);
return text.data();

But how can I include/import the QByteArray class, so I can access it's methods inside my user-defined function? Is this even possible within SQLiteStudio?

Solution

  • I'm not sure if it is possible in SQLiteStudio, but you should be able to use SQLS' own base64_decode(arg) function.