qtforum.de

Code: Alles auswählen

void Gui_Main::PrepareDump()
{
       QString dumpfile = "sqlinsert.sql"; /* put to file */
       QSqlQuery query;
       QString table_name;
       QString table_typ;
       QString table_sqlinsert;
       QString tablequery ="SELECT name, type, sql  FROM sqlite_master WHERE type!='meta' AND sql NOT NULL ORDER BY name";
       query.exec(tablequery);
       
       QSqlRecord rec = query.record();  /* nummer col */
       file_put_contents(dumpfile,"BEGIN TRANSACTION;\n"); /* reset file */
       while (query.next()) {
            table_name = query.value(rec.indexOf("name")).toString();
            table_typ = query.value(rec.indexOf("type")).toString();
            table_sqlinsert = query.value(rec.indexOf("sql")).toString();
            file_put_contents_append(dumpfile,table_sqlinsert+";");
            TablesDump(table_name,dumpfile);
        }
        file_put_contents_append(dumpfile,"COMMIT;"); /* last line append end \n */
}

void Gui_Main::TablesDump(QString t,QString file)
{
     QString tablequery ="SELECT * FROM "+t;
     QString line;
     QString rowone;
     QSqlQuery query;
     query.exec(tablequery);
     QSqlRecord rec = query.record();  /* nummer col */
     int numcol = rec.count();
     int loop;
          while (query.next()) {
            line="";
              for(loop=0; loop < numcol; loop++) {
                  rowone = query.value(loop).toString();
                  if (loop !=numcol-1) {
                  line = line+QString( "'%1'," ).arg( rowone );
                  } else {
                  line = line+QString( "'%1'" ).arg( rowone );   
                  }
              }
                line.prepend("INSERT INTO "+t+" VALUES (");
                line.append(");");                
            file_put_contents_append(file,line);
        }
}

Code: Alles auswählen

float QString::toFloat ( bool * ok = 0 ) const
Returns the string converted to a float value.
Returns 0.0 if the conversion fails.
If ok is not 0: if a conversion error occurs, *ok is set to false; otherwise *ok is set to true.
Example:
    QString str1 = "1234.56";
    str1.toFloat();             // returns 1234.56

    bool ok;
    QString str2 = "R2D2";
    str2.toFloat(&ok);          // returns 0.0, sets ok to false

Code: Alles auswählen

bool is_numeric(QString incomming)
{
    incomming.replace(QString(" "), QString("")); /* trimm */
    QString str2 = incomming;
    bool ok; 
    str2.toFloat(&ok); 
return ok;
}

Code: Alles auswählen

QFileInfo fi("/tmp/archive.tar.gz");
    QString ext = fi.completeSuffix();  // ext = "tar.gz"