#pragma once

#include <odb/core.hxx>

#include <xdb/test/item.h>
#include <xdb/test/data.h>

#pragma db namespace pointer(std::shared_ptr) \
                     table("ns1_")
namespace ns1 {

#pragma db object no_id
  class item_data
  {
  public:
    item_data(const std::shared_ptr<item>& anchor,
      const std::shared_ptr<ns2::data>& data)
      : m_anchor(anchor)
      , m_data(data)
    {
    }

    std::shared_ptr<item> anchor() const { return m_anchor; }
    void anchor(const std::shared_ptr<item>& anchor) { m_anchor = anchor; }

    std::shared_ptr<ns2::data> data() const { return m_data; }
    void data(const std::shared_ptr<ns2::data>& data) { m_data = data; }

  private:
    friend class odb::access;

    item_data() {}

  private:
#pragma db not_null
    std::shared_ptr<item> m_anchor;
#pragma db not_null
    std::shared_ptr<ns2::data> m_data;
  };

#pragma db view object(item_data = m) \
                object(item = i : i::m_id == m::m_anchor) \
                object(ns2::data = d : d::m_id == m::m_data) \
                query((?), distinct)
  struct assembly_item_metadata_view
  {
    std::shared_ptr<item> i;
    std::shared_ptr<ns2::data> d;
  };

}