Method createIndexes

src/utilities/sql/SqlFile_Impl.cpp:272–310

  }

  void SqlFile_Impl::createIndexes() {
    if (m_connectionOpen) {
      try {
        execAndThrowOnError("CREATE INDEX IF NOT EXISTS rddMTR ON ReportDataDictionary (IsMeter);");
      } catch (const std::runtime_error& e) {
        LOG(Trace, "Error adding index: " + std::string(e.what()));
      }

      try {
        execAndThrowOnError("CREATE INDEX IF NOT EXISTS redRD ON ReportExtendedData (ReportDataIndex);");
      } catch (const std::runtime_error& e) {
        LOG(Trace, "Error adding index: " + std::string(e.what()));
      }

      try {
        execAndThrowOnError("CREATE INDEX IF NOT EXISTS rdTI ON ReportData (TimeIndex ASC);");
      } catch (const std::runtime_error& e) {
        LOG(Trace, "Error adding index: " + std::string(e.what()));
      }

      try {
        execAndThrowOnError("CREATE INDEX IF NOT EXISTS rdDI ON ReportData (ReportDataDictionaryIndex ASC);");
      } catch (const std::runtime_error& e) {
        LOG(Trace, "Error adding index: " + std::string(e.what()));
      }

      try {
        execAndThrowOnError("CREATE INDEX IF NOT EXISTS dmhdHRI ON DaylightMapHourlyData (HourlyReportIndex ASC);");
      } catch (const std::runtime_error& e) {
        LOG(Trace, "Error adding index: " + std::string(e.what()));
      }

      try {
        execAndThrowOnError("CREATE INDEX IF NOT EXISTS dmhrMNI ON DaylightMapHourlyReports (MapNumber);");
      } catch (const std::runtime_error& e) {
        LOG(Trace, "Error adding index: " + std::string(e.what()));
      }
    }
  }

  SqlFile_Impl::~SqlFile_Impl() {
    close();