qtforum.de

Code: Alles auswählen

  QByteArray coond = query.value(7).toByteArray();
                     QString tmploadin = QString("%1curl/%2" ).arg(WORK_CACHEDIR).arg(filenamevieni);
                     QFile f(tmploadin);
                            if ( f.open( QIODevice::WriteOnly ) ) {
                                fsize = f.write(coond);
                                f.close();
                                if (fsize > 0) {
                                  AppendImage(tmploadin,desctitel,direct_int(dbid));
                                  /////qt_unlink(tmploadin);
                                }
                            }

Code: Alles auswählen

void  Db_Box::PackTakeZip( const QString file , int idmg )
{
    if (!is_file(file)) {
    QMessageBox::warning(0, tr("User File error"),tr("User id %2 not found a valid file %2.").arg(file).arg(idmg));
    return;
    }
    
    QApplication::setOverrideCursor(QCursor(Qt::WaitCursor));

    QByteArray inside;
    QFile f(file);
    f.open(QIODevice::ReadOnly);
    inside = f.readAll();
    const QString blobzip = inside.toBase64();
    
    const QString sd = QString("REPLACE INTO USERFILE_0 VALUES (%1, 'zip', 'attach' ,'%2',%3)")
    .arg(idmg)
    .arg(blobzip)
    .arg(QTime_Null());
     QSqlQuery query(db_0);
     bool esx = query.exec(sd);
    
    if (!esx) {
              QApplication::restoreOverrideCursor();
              QMessageBox::warning(0, tr("User File error"),tr("User id %2 file %1 DB insert fail! DB error %3")
                 .arg(file)
                 .arg(idmg)
                 .arg(query.lastError().text())); 
    }
    
    
    f.close();
    f.remove();
     QApplication::restoreOverrideCursor();
             /*
CREATE TABLE `USERFILE_0` (
  `ID` int(32) NOT NULL default '0',
  `TIPO` enum('zip','pdf','txt','doc') default NULL,
  `TITEL` varchar(255) default NULL,
  `PIC` longblob NOT NULL,
  `EPOCHE` int(32) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
             */
    
}