Method readTransitions_

src/openms/source/FORMAT/OSWFile.cpp:615–655

    }

    void OSWFile::readTransitions_(OSWData& swath_result)
    {
      swath_result.clear();

      Size count = conn_.countTableRows("RUN");
      if (count != 1)
      {
        throw Exception::Precondition(__FILE__, __LINE__, OPENMS_PRETTY_FUNCTION, "Database '" + filename_ + "' contains more than one RUN. This is currently not supported!");
      }

      // Grab transitions first
      // We do this separately, because the full sql query below will show transitions in duplicates, because many features might use the same XIC at different positions
      const StringList colnames_tr = { "ID", "PRODUCT_MZ", "TYPE", "DECOY", "ANNOTATION" };
      enum COLIDs
      {
        ID,
        PRODUCT_MZ,
        TYPE,
        DECOY,
        ANNOTATION
      };

      // does not make the query below any faster...
      //conn.executeStatement("ANALYZE");

      String select_transitions = "SELECT " + ListUtils::concatenate(colnames_tr, ",") + " FROM TRANSITION ORDER BY ID;";
      sqlite3_stmt* stmt;
      conn_.prepareStatement(&stmt, select_transitions);
      Sql::SqlState rc = Sql::nextRow(stmt);
      while (rc == Sql::SqlState::SQL_ROW)
      {
        OSWTransition tr(Sql::extractString(stmt, COLIDs::ANNOTATION),
          Sql::extractInt(stmt, COLIDs::ID),
          Sql::extractFloat(stmt, COLIDs::PRODUCT_MZ),
          Sql::extractChar(stmt, COLIDs::TYPE),
          Sql::extractInt(stmt, COLIDs::DECOY));
        swath_result.addTransition(std::move(tr));
        rc = Sql::nextRow(stmt);
      }
      sqlite3_finalize(stmt);
    }

} // namespace OpenMS