Method illuminanceMapIndex

src/utilities/sql/SqlFile_Impl.cpp:4244–4252

find the illuminance map index by name

  // find the illuminance map index by name
  boost::optional<int> SqlFile_Impl::illuminanceMapIndex(const std::string& name) const {
    // TODO: haven't figured out how to bind properly to the LIKE statement, tried
    // LIKE ?
    // LIKE %?%  => sqlite3_prepare_v2 fails
    // LIKE %%?%%
    // LIKE '%?%' (not recognized as a placeholder)
    const std::string& s = "SELECT MapNumber FROM DaylightMaps WHERE MapName LIKE '%" + name + "%'";
    return execAndReturnFirstInt(s);
  }

  void SqlFile_Impl::mf_makeConsistent(std::vector<SqlFileTimeSeriesQuery>& queries) {
    // make each query consistent, or delete it if there is no possibility of a matching TimeSeries