Howto display QPixmap and Text?

[segi]

Hello,

I have a sql database with the following tables:
table content
id integer, content text
table images
id integer, shortname text, data blob

The following snippet is from content.conten:

This is an example text with an image :img1. The text is very senseless. Here another image :img2.

This is an example text with an image :img1. The text is very senseless. Here another image :img2.

To copy to clipboard, switch view to plain text mode 

I have to replace the ":img(id)" keywords by the correct image.
I generate a QPixmap of each image by QPixmap::loadFromData(const QByteArray&). To show them in a QLabel inline the text module doesn't seem possible. I see no way to create a QLabel for each text module and each image. (IMHO would it be very bad design)
Maybe QTextBrowser could be the right GUI element but sometimes I have to replace only the images on user input. Do I use a QTextDocument than?
What other possibilities I have to display the information to the user?

Bye

[wysota]

QLabel is fine - you can use the <img> tag to add images to your text.

[segi]

I know that QLabel supports rich text. But I have a QPixmap object and I don't know how to insert it inline a QLabel.
Something like the following won't work:

QPixmap pixmap;
pixmap.loadFromData(_data);
QLabel *label;
label->setText("some senseless text with an image <img src="+pixmap+"/>");

QPixmap pixmap;
pixmap.loadFromData(_data);
QLabel *label;
label->setText("some senseless text with an image <img src="+pixmap+"/>");

To copy to clipboard, switch view to plain text mode 

Sure it is possible to get the image from the database, create a QPixmap object, save it in a temporary file and include this e.g. <img src="temp.png" />. But isn't there an easier way?

[wysota]

There are many ways You can try embedding the data directly in the URL although I'm not sure if Qt Rich Text supports it or you can use the resource system or a similar system based on QAbstractFileEngine.

[segi]

Embedding in the URL isn't supported by Qt's Rich Text.
I don't want to use the resource system because i have to export the images from database into regular files.
Is subclassing QAbstractFileEngine really necessary?

[wysota]

Is subclassing QAbstractFileEngine really necessary?

No, you can register the data with the resource system dynamically through QResource::registerResource(). Of course you need to properly feed the data.

[segi]

I read much about QResource now. That isn't what I really want.
To subclass QAbstractFileEngine seems the best solution. But IHMO it's a lot of work and the documentation of it is not as good as of the other Qt classes.
I have a some code which not working well:

// sqlfileengine.h
#ifndef SQLFILEENGINE_H
#define SQLFILEENGINE_H
 
#include <QAbstractFileEngine>
#include <QAbstractFileEngineHandler>
 
class QByteArray;
class QString;
 
class SqlFileEngine;
 
class SqlFileEngineHandler : public QAbstractFileEngineHandler
{
  public:
    SqlFileEngineHandler();
    virtual QAbstractFileEngine* create(const QString& filename) const;
};
 
class SqlFileEngine : public QAbstractFileEngine
{
  public:
    SqlFileEngine();
    explicit SqlFileEngine(const QString& file);
 
    virtual QString fileName(FileName file=DefaultName) const;
    virtual void setFileName(const QString& file);
 
    bool open(QIODevice::OpenMode openMode);
    qint64 read(char* data, qint64 maxlen);
    bool atEnd () const;
 
    qint64 size() const;
    qint64 pos() const;
 
  private:
    void init();
 
    QString _filename;
    QByteArray _data;
    qint64 _pos;
};
 
#endif /* end of SQLFILEENGINE_H */
 
// sqlfileengine.cpp
#include "sqlfileengine.h"
 
#include <QByteArray>
#include <QDebug>
#include <QString>
#include <QStringList>
#include <QSqlQuery>
#include <QVariant>
 
// SqlFileEngineHandler
SqlFileEngineHandler::SqlFileEngineHandler()
  : QAbstractFileEngineHandler()
{
}
 
QAbstractFileEngine* SqlFileEngineHandler::create(const QString& filename) const
{
  return filename.toLower().startsWith("sql:") ? new SqlFileEngine(filename) : 0;
}
 
// SqlFileEngine
SqlFileEngine::SqlFileEngine()
{
}
 
SqlFileEngine::SqlFileEngine(const QString& file)
  : _pos(0)
{
  qDebug() << "SqlFileEngine ctor";
  setFileName(file);
  init();
}
 
QString SqlFileEngine::fileName(FileName file) const
{
  Q_UNUSED(file);
  return _filename;
}
 
void SqlFileEngine::setFileName(const QString& file)
{
  _filename=file.section(':', 1);
  qDebug() << "SqlFileEngine::setFileName() " << _filename;
}
 
bool SqlFileEngine::open(QIODevice::OpenMode openMode)
{
  Q_UNUSED(openMode);
  qDebug() << "SqlFileEngine::open() ";
  return true;
}
 
qint64 SqlFileEngine::read(char* data, qint64 maxlen)
{
  qDebug() << "SqlFileEngine::read(" << data << "," << maxlen << ")";
 
  if(atEnd())
    return 0;
 
  if(!_data.isEmpty())
  {
    QByteArray curData=_data.mid(_pos, _pos+maxlen);
    qstrcpy(data, curData.data());
    qDebug() << data;
    _pos+=curData.size();
    qDebug() << _pos;
  }
  return 0;
}
 
bool SqlFileEngine::atEnd() const
{
  return (_pos>=size());
}
 
qint64 SqlFileEngine::size() const
{
  return _data.size();
}
 
qint64 SqlFileEngine::pos() const
{
  return _pos;
}
 
void SqlFileEngine::init()
{
  // filename == table/col/id
  QStringList strl=_filename.split("/");
  QSqlQuery query;
 
  query.prepare("SELECT "+strl.at(1)+" FROM "+strl.at(0)+" WHERE id=:id");
  query.bindValue(":table", strl.at(0));
  query.bindValue(":col", strl.at(1));
  query.bindValue(":id", strl.at(2));
 
  qDebug() << "SELECT " << strl.at(1) << " FROM " << strl.at(0) << " WHERE id=" << strl.at(2);
 
  if(query.exec())
  {
    while(query.next())
    {
      qDebug() << query.value(0).toByteArray();
      _data=query.value(0).toByteArray();
    }
  }
}
 
// main.cpp
#include "sqlfileengine.h"
 
#include <QApplication>
#include <QLabel>
#include <QSqlDatabase>
 
int main(int argc, char* argv[])
{
  QApplication app(argc, argv);
 
  QSqlDatabase db=QSqlDatabase::addDatabase("QSQLITE");
  db.setDatabaseName("/home/segi/user.db");
  if(!db.open())
  {
    qWarning("Couldn't open database.");
    return -1;
  }
 
  SqlFileEngineHandler engine;
 
  QLabel label;
  label.setText("<img src=\"sql:images/image/1\" />");
  label.show();
 
  return app.exec();
}

// sqlfileengine.h
#ifndef SQLFILEENGINE_H
#define SQLFILEENGINE_H

#include <QAbstractFileEngine>
#include <QAbstractFileEngineHandler>

class QByteArray;
class QString;

class SqlFileEngine;

class SqlFileEngineHandler : public QAbstractFileEngineHandler
{
  public:
    SqlFileEngineHandler();
    virtual QAbstractFileEngine* create(const QString& filename) const;
};

class SqlFileEngine : public QAbstractFileEngine
{
  public:
    SqlFileEngine();
    explicit SqlFileEngine(const QString& file);

    virtual QString fileName(FileName file=DefaultName) const;
    virtual void setFileName(const QString& file);

    bool open(QIODevice::OpenMode openMode);
    qint64 read(char* data, qint64 maxlen);
    bool atEnd () const;

    qint64 size() const;
    qint64 pos() const;

  private:
    void init();

    QString _filename;
    QByteArray _data;
    qint64 _pos;
};

#endif /* end of SQLFILEENGINE_H */

// sqlfileengine.cpp
#include "sqlfileengine.h"

#include <QByteArray>
#include <QDebug>
#include <QString>
#include <QStringList>
#include <QSqlQuery>
#include <QVariant>

// SqlFileEngineHandler
SqlFileEngineHandler::SqlFileEngineHandler()
  : QAbstractFileEngineHandler()
{
}

QAbstractFileEngine* SqlFileEngineHandler::create(const QString& filename) const
{
  return filename.toLower().startsWith("sql:") ? new SqlFileEngine(filename) : 0;
}

// SqlFileEngine
SqlFileEngine::SqlFileEngine()
{
}

SqlFileEngine::SqlFileEngine(const QString& file)
  : _pos(0)
{
  qDebug() << "SqlFileEngine ctor";
  setFileName(file);
  init();
}

QString SqlFileEngine::fileName(FileName file) const
{
  Q_UNUSED(file);
  return _filename;
}

void SqlFileEngine::setFileName(const QString& file)
{
  _filename=file.section(':', 1);
  qDebug() << "SqlFileEngine::setFileName() " << _filename;
}

bool SqlFileEngine::open(QIODevice::OpenMode openMode)
{
  Q_UNUSED(openMode);
  qDebug() << "SqlFileEngine::open() ";
  return true;
}

qint64 SqlFileEngine::read(char* data, qint64 maxlen)
{
  qDebug() << "SqlFileEngine::read(" << data << "," << maxlen << ")";

  if(atEnd())
    return 0;

  if(!_data.isEmpty())
  {
    QByteArray curData=_data.mid(_pos, _pos+maxlen);
    qstrcpy(data, curData.data());
    qDebug() << data;
    _pos+=curData.size();
    qDebug() << _pos;
  }
  return 0;
}

bool SqlFileEngine::atEnd() const
{
  return (_pos>=size());
}

qint64 SqlFileEngine::size() const
{
  return _data.size();
}

qint64 SqlFileEngine::pos() const
{
  return _pos;
}

void SqlFileEngine::init()
{
  // filename == table/col/id
  QStringList strl=_filename.split("/");
  QSqlQuery query;

  query.prepare("SELECT "+strl.at(1)+" FROM "+strl.at(0)+" WHERE id=:id");
  query.bindValue(":table", strl.at(0));
  query.bindValue(":col", strl.at(1));
  query.bindValue(":id", strl.at(2));

  qDebug() << "SELECT " << strl.at(1) << " FROM " << strl.at(0) << " WHERE id=" << strl.at(2);

  if(query.exec())
  {
    while(query.next())
    {
      qDebug() << query.value(0).toByteArray();
      _data=query.value(0).toByteArray();
    }
  }
}

// main.cpp
#include "sqlfileengine.h"

#include <QApplication>
#include <QLabel>
#include <QSqlDatabase>

int main(int argc, char* argv[])
{
  QApplication app(argc, argv);

  QSqlDatabase db=QSqlDatabase::addDatabase("QSQLITE");
  db.setDatabaseName("/home/segi/user.db");
  if(!db.open())
  {
    qWarning("Couldn't open database.");
    return -1;
  }

  SqlFileEngineHandler engine;

  QLabel label;
  label.setText("<img src=\"sql:images/image/1\" />");
  label.show();

  return app.exec();
}

To copy to clipboard, switch view to plain text mode 

I only get something like that:

SqlFileEngine::setFileName() images/image/1
SELECT "image" FROM "images" WHERE id="1"
SqlFileEngine::open()
SqlFileEngine::read( ¶ôß3·iø캿ñs·▒ , 1 )                                              
SqlFileEngine::read( PNG                                      
▒                                                             
 , 16384 )                                 
SqlFileEngine::read( ¶ôß3·iø캿ñs·▒ , 1 )                                  
SqlFileEngine::read( PNG                                      
▒                                                             
 , 16384 )                                        
SqlFileEngine::read( ¶ôß3·iø캿ñs·▒8 , 1 )                                    
SqlFileEngine::read( PNG                                      
▒                                                             
 , 16384 )                                          
SqlFileEngine::read( ¶ôß3·iø캿ñs·▒8 , 1 )
SqlFileEngine::read( PNG                                      
▒                                                             
 , 16384 )
...

SqlFileEngine::setFileName() images/image/1
SELECT "image" FROM "images" WHERE id="1"
SqlFileEngine::open()
SqlFileEngine::read( ¶ôß3·iø캿ñs·▒ , 1 )                                              
SqlFileEngine::read( PNG                                      
▒                                                             
 , 16384 )                                 
SqlFileEngine::read( ¶ôß3·iø캿ñs·▒ , 1 )                                  
SqlFileEngine::read( PNG                                      
▒                                                             
 , 16384 )                                        
SqlFileEngine::read( ¶ôß3·iø캿ñs·▒8 , 1 )                                    
SqlFileEngine::read( PNG                                      
▒                                                             
 , 16384 )                                          
SqlFileEngine::read( ¶ôß3·iø캿ñs·▒8 , 1 )
SqlFileEngine::read( PNG                                      
▒                                                             
 , 16384 )
...

To copy to clipboard, switch view to plain text mode 

Is there another method to tell that the end of file is reached than return 0 in SqlFileEngine::read?
What do I wrong?
Where can I find better/more information about subclassing QAbstractFileEngine? (What have i to reimplement and so on.)

Bye

[wysota]

QAbstractFileEngine::extension()

[wysota]

By the way, here is a quick implementation.

[segi]

Thank you very much.
I get it working. But why the read method is called so much times?
I add a debug message to your MemFileHandler::read method and get the following output:

Starting /home/segi/tmp/memfilehandler/memfilehandler...
read: return  2844  counter  0 
read: return  2844  counter  1 
read: return  2844  counter  2 
...
read: return  2844  counter  27

Starting /home/segi/tmp/memfilehandler/memfilehandler...
read: return  2844  counter  0 
read: return  2844  counter  1 
read: return  2844  counter  2 
...
read: return  2844  counter  27

To copy to clipboard, switch view to plain text mode 

Can I avoid these additional calls?
Sadly there are a lot of errors at runtime:
I tried big images: e.g. /usr/share/wallpapers/default-1600x1200.png

Starting /home/segi/tmp/memfilehandler/memfilehandler...
read: return  16384  counter  0 
read: return  16384  counter  1 
read: return  16384  counter  2 
...
read: return  16384  counter  27 
read: return  53  counter  28 
read: return  16384  counter  29 
libpng error: IDAT: CRC error

Starting /home/segi/tmp/memfilehandler/memfilehandler...
read: return  16384  counter  0 
read: return  16384  counter  1 
read: return  16384  counter  2 
...
read: return  16384  counter  27 
read: return  53  counter  28 
read: return  16384  counter  29 
libpng error: IDAT: CRC error

To copy to clipboard, switch view to plain text mode 

What can I do to avoid this error?
On jpeg files I get:

Starting /home/segi/tmp/memfilehandler/memfilehandler...
read: return  378  counter  0 
read: return  378  counter  1 
Not a JPEG file: starts with 0xff 0xd9

Starting /home/segi/tmp/memfilehandler/memfilehandler...
read: return  378  counter  0 
read: return  378  counter  1 
Not a JPEG file: starts with 0xff 0xd9

To copy to clipboard, switch view to plain text mode 

I created a new jpg with gimp (100x100px only a white background).
qDebug() << QImageReader::supportedImageFormats():

Starting /home/sebastian/tmp/memfilehandler/memfilehandler...
("BW", "EPS", "EPSF", "EPSI", "EXR", "PCX", "PSD", "RGB", "RGBA", "SGI", "TGA", "XCF", 
"bmp", "bw", "dds", "eps", "epsf", "epsi", "exr", "gif", "ico", "jp2", "jpeg", "jpg",
"mng", "pbm", "pcx", "pgm", "png", "ppm", "psd", "rgb", "rgba", "sgi", "svg", 
"tga", "tif", "tiff", "xbm", "xcf", "xpm", "xv")

Starting /home/sebastian/tmp/memfilehandler/memfilehandler...
("BW", "EPS", "EPSF", "EPSI", "EXR", "PCX", "PSD", "RGB", "RGBA", "SGI", "TGA", "XCF", 
"bmp", "bw", "dds", "eps", "epsf", "epsi", "exr", "gif", "ico", "jp2", "jpeg", "jpg",
"mng", "pbm", "pcx", "pgm", "png", "ppm", "psd", "rgb", "rgba", "sgi", "svg", 
"tga", "tif", "tiff", "xbm", "xcf", "xpm", "xv")

To copy to clipboard, switch view to plain text mode 

What's the problem?

Bye

[segi]

T
I tried big images: e.g. /usr/share/wallpapers/default-1600x1200.png

...
libpng error: IDAT: CRC error

...
libpng error: IDAT: CRC error

To copy to clipboard, switch view to plain text mode 

What can I do to avoid this error?

Sorry, my fault. I just copied and modified your MemFileHandler::read() method.
I add

m_pos+=maxlen

m_pos+=maxlen

To copy to clipboard, switch view to plain text mode 

and the error on big files is gone.
But why is this method called so often?
Why doesn't work jpg files?

Bye

[wysota]

What does QImageReader::supportedImageFormats() have to do with this?

About the handler - it's probably buggy (although I can't see the bug) or incomplete. You'd have to reimplement every method from the interface and see which methods get called.