Method exportTableToJSON_

src/openms/source/FORMAT/OMSFileLoad.cpp:1104–1140

  QJsonArray OMSFileLoad::exportTableToJSON_(const QString& table, const QString& order_by)
  {
    // code based on: https://stackoverflow.com/a/18067555
    String sql = "SELECT * FROM " + table;
    if (!order_by.isEmpty())
    {
      sql += " ORDER BY " + order_by;
    }

    SQLite::Statement query(*db_, sql);

    QJsonArray array;
    while (query.executeStep())
    {
      QJsonObject record;
      for (int i = 0; i < query.getColumnCount(); ++i)
      {
        // @TODO: this will repeat field names for every row -
        // avoid this with separate "header" and "rows" (array)?

        // sqlite stores each cell based on the actual value, not the declared column type;
        // thus, we could use query.getColumnDeclaredType(i), but it would incur conversion
        switch (query.getColumn(i).getType())
        {
          case SQLITE_INTEGER: record.insert(query.getColumnName(i), qint64(query.getColumn(i).getInt64())); break;
          case SQLITE_FLOAT: record.insert(query.getColumnName(i), query.getColumn(i).getDouble()); break;
          case SQLITE_BLOB: record.insert(query.getColumnName(i), query.getColumn(i).getText()); break;
          case SQLITE_NULL: record.insert(query.getColumnName(i), ""); break;
          case SQLITE3_TEXT: record.insert(query.getColumnName(i), query.getColumn(i).getText()); break;
          default:
            throw Exception::NotImplemented(__FILE__, __LINE__, OPENMS_PRETTY_FUNCTION);
        }
      }
      array.push_back(record);
    }
    return array;
  }


  void OMSFileLoad::exportToJSON(ostream& output)