Program Listing for File database_connection.hpp

↰ Return to documentation for file (/tmp/ws/src/warehouse_ros_sqlite/include/warehouse_ros_sqlite/database_connection.hpp)

// Copyright 2020 Bjarne von Horn
//
// Redistribution and use in source and binary forms, with or without
// modification, are permitted provided that the following conditions are met:
//
//    * Redistributions of source code must retain the above copyright
//      notice, this list of conditions and the following disclaimer.
//
//    * Redistributions in binary form must reproduce the above copyright
//      notice, this list of conditions and the following disclaimer in the
//      documentation and/or other materials provided with the distribution.
//
//    * Neither the name of the copyright holder nor the names of its
//      contributors may be used to endorse or promote products derived from
//      this software without specific prior written permission.
//
// THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
// AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
// IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
// ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
// LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
// CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
// SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
// INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
// CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
// ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
// POSSIBILITY OF SUCH DAMAGE.

// SPDX-License-Identifier: BSD-3-Clause

#ifndef WAREHOUSE_ROS_SQLITE__DATABASE_CONNECTION_HPP_
#define WAREHOUSE_ROS_SQLITE__DATABASE_CONNECTION_HPP_

#include <warehouse_ros/database_connection.h>
#include <warehouse_ros/message_collection.h>
#include <warehouse_ros_sqlite/utils.hpp>
#include <warehouse_ros_sqlite/warehouse_ros_sqlite_export.hpp>

#include <string>
#include <utility>
#include <vector>

namespace warehouse_ros_sqlite
{
class WAREHOUSE_ROS_SQLITE_EXPORT DatabaseConnection : public warehouse_ros::DatabaseConnection
{
  sqlite3_ptr db_;
  std::string uri_;

public:
  DatabaseConnection() = default;
  explicit DatabaseConnection(sqlite3_ptr db)
  : db_(std::move(db))
  {
  }
  bool setParams(const std::string & host, unsigned /*port*/, float /*timeout*/ = 60.0) override
  {
    uri_ = host;
    return true;
  }

  bool setTimeout(float /*timeout*/) override
  {
    return true;
  }

  bool connect() override;

  bool isConnected() override;

  void dropDatabase(const std::string & db_name) override;

  std::string messageType(
    const std::string & db_name,
    const std::string & collection_name) override;

  static const int BUSY_WAIT_MILLISECS = 20;
  static const int BUSY_MAX_RETRIES = 10;

protected:
  warehouse_ros::MessageCollectionHelper::Ptr openCollectionHelper(
    const std::string & db_name,
    const std::string & collection_name) override;
  void initDb();
  std::vector<std::string> getTablesOfDatabase(const std::string & db_name);
  bool schemaVersionSet();
};
}  // namespace warehouse_ros_sqlite

#endif  // WAREHOUSE_ROS_SQLITE__DATABASE_CONNECTION_HPP_