database.hpp 8.9 KB
Newer Older
1 2
#pragma once

3 4 5
#include <biboumi.h>
#ifdef USE_DATABASE

6 7 8
#include <database/table.hpp>
#include <database/column.hpp>
#include <database/count_query.hpp>
9

louiz’'s avatar
louiz’ committed
10 11
#include <database/engine.hpp>

12 13
#include <utils/optional_bool.hpp>

14
#include <chrono>
15 16 17
#include <string>

#include <memory>
18
#include <map>
19

20 21 22

class Database
{
23
 public:
24
  using time_point = std::chrono::system_clock::time_point;
25
  struct RecordNotFound: public std::exception {};
26

27
  struct Uuid: Column<std::string> { static constexpr auto name = "uuid_"; };
28

29
  struct Owner: Column<std::string> { static constexpr auto name = "owner_"; };
30

louiz’'s avatar
louiz’ committed
31
  struct IrcChanName: Column<std::string> { static constexpr auto name = "ircchanname_"; };
32

33
  struct Channel: Column<std::string> { static constexpr auto name = "channel_"; };
34

louiz’'s avatar
louiz’ committed
35
  struct IrcServerName: Column<std::string> { static constexpr auto name = "ircservername_"; };
36

37
  struct Server: Column<std::string> { static constexpr auto name = "server_"; };
38

39
  struct Date: Column<time_point::rep> { static constexpr auto name = "date_"; };
40

41
  struct Body: Column<std::string> { static constexpr auto name = "body_"; };
42

43
  struct Nick: Column<std::string> { static constexpr auto name = "nick_"; };
44

45
  struct Pass: Column<std::string> { static constexpr auto name = "pass_"; };
46

47 48
  struct Ports: Column<std::string> { static constexpr auto name = "ports_";
    Ports(): Column<std::string>("6667") {} };
49

louiz’'s avatar
louiz’ committed
50
  struct TlsPorts: Column<std::string> { static constexpr auto name = "tlsports_";
51
    TlsPorts(): Column<std::string>("6697;6670") {} };
52

53
  struct Username: Column<std::string> { static constexpr auto name = "username_"; };
54

55
  struct Realname: Column<std::string> { static constexpr auto name = "realname_"; };
56

louiz’'s avatar
louiz’ committed
57
  struct AfterConnectionCommand: Column<std::string> { static constexpr auto name = "afterconnectioncommand_"; };
58

louiz’'s avatar
louiz’ committed
59
  struct TrustedFingerprint: Column<std::string> { static constexpr auto name = "trustedfingerprint_"; };
60

louiz’'s avatar
louiz’ committed
61
  struct EncodingOut: Column<std::string> { static constexpr auto name = "encodingout_"; };
62

louiz’'s avatar
louiz’ committed
63
  struct EncodingIn: Column<std::string> { static constexpr auto name = "encodingin_"; };
64

louiz’'s avatar
louiz’ committed
65
  struct MaxHistoryLength: Column<int> { static constexpr auto name = "maxhistorylength_";
66
    MaxHistoryLength(): Column<int>(20) {} };
67

louiz’'s avatar
louiz’ committed
68
  struct RecordHistory: Column<bool> { static constexpr auto name = "recordhistory_";
69
    RecordHistory(): Column<bool>(true) {}};
70

louiz’'s avatar
louiz’ committed
71
  struct RecordHistoryOptional: Column<OptionalBool> { static constexpr auto name = "recordhistory_"; };
72

louiz’'s avatar
louiz’ committed
73
  struct VerifyCert: Column<bool> { static constexpr auto name = "verifycert_";
74
    VerifyCert(): Column<bool>(true) {} };
75 76

  struct Persistent: Column<bool> { static constexpr auto name = "persistent_";
77
    Persistent(): Column<bool>(false) {} };
78

79 80 81
  struct GlobalPersistent: Column<bool> { static constexpr auto name = "persistent_";
    GlobalPersistent(); };

82 83 84 85 86
  struct LocalJid: Column<std::string> { static constexpr auto name = "local"; };

  struct RemoteJid: Column<std::string> { static constexpr auto name = "remote"; };


87 88 89
  using MucLogLineTable = Table<Id, Uuid, Owner, IrcChanName, IrcServerName, Date, Body, Nick>;
  using MucLogLine = MucLogLineTable::RowType;

90
  using GlobalOptionsTable = Table<Id, Owner, MaxHistoryLength, RecordHistory, GlobalPersistent>;
91 92 93 94 95
  using GlobalOptions = GlobalOptionsTable::RowType;

  using IrcServerOptionsTable = Table<Id, Owner, Server, Pass, AfterConnectionCommand, TlsPorts, Ports, Username, Realname, VerifyCert, TrustedFingerprint, EncodingOut, EncodingIn, MaxHistoryLength>;
  using IrcServerOptions = IrcServerOptionsTable::RowType;

96
  using IrcChannelOptionsTable = Table<Id, Owner, Server, Channel, EncodingOut, EncodingIn, MaxHistoryLength, Persistent, RecordHistoryOptional>;
97 98
  using IrcChannelOptions = IrcChannelOptionsTable::RowType;

99 100 101
  using RosterTable = Table<LocalJid, RemoteJid>;
  using RosterItem = RosterTable::RowType;

102 103 104
  Database() = default;
  ~Database() = default;

louiz’'s avatar
louiz’ committed
105 106 107 108 109
  Database(const Database&) = delete;
  Database(Database&&) = delete;
  Database& operator=(const Database&) = delete;
  Database& operator=(Database&&) = delete;

110 111
  static GlobalOptions get_global_options(const std::string& owner);
  static IrcServerOptions get_irc_server_options(const std::string& owner,
112
                                                     const std::string& server);
113 114 115 116 117 118 119 120 121
  static IrcChannelOptions get_irc_channel_options(const std::string& owner,
                                                   const std::string& server,
                                                   const std::string& channel);
  static IrcChannelOptions get_irc_channel_options_with_server_default(const std::string& owner,
                                                                       const std::string& server,
                                                                       const std::string& channel);
  static IrcChannelOptions get_irc_channel_options_with_server_and_global_default(const std::string& owner,
                                                                                  const std::string& server,
                                                                                  const std::string& channel);
122 123
  /**
   * Get all the lines between (optional) start and end dates, with a (optional) limit.
124
   * If after_id is set, only the records after it will be returned.
125
   */
126
  static std::vector<MucLogLine> get_muc_logs(const std::string& owner, const std::string& chan_name, const std::string& server,
127 128
                                              int limit=-1, const std::string& start="", const std::string& end="",
                                              const Id::real_type after_id=Id::unset_value);
129 130 131 132 133 134

  /**
   * Get the most recent messages from the archive, with optional limit and start date
   */
  static std::vector<MucLogLine> get_muc_most_recent_logs(const std::string& owner, const std::string& chan_name, const std::string& server,
                                              int limit=-1, const std::string& start="");
135 136 137 138 139
  /**
   * Get just one single record matching the given uuid, between (optional) end and start.
   * If it does not exist (or is not between end and start), throw a RecordNotFound exception.
   */
  static MucLogLine get_muc_log(const std::string& owner, const std::string& chan_name, const std::string& server, const std::string& uuid, const std::string& start="", const std::string& end="");
140 141
  static std::string store_muc_message(const std::string& owner, const std::string& chan_name, const std::string& server_name,
                                       time_point date, const std::string& body, const std::string& nick);
142

143 144 145 146 147 148
  static void add_roster_item(const std::string& local, const std::string& remote);
  static bool has_roster_item(const std::string& local, const std::string& remote);
  static void delete_roster_item(const std::string& local, const std::string& remote);
  static std::vector<Database::RosterItem> get_contact_list(const std::string& local);
  static std::vector<Database::RosterItem> get_full_roster();

149
  static void close();
150
  static void open(const std::string& filename);
151

152
  template <typename TableType>
153
  static int64_t count(const TableType& table)
154 155
  {
    CountQuery query{table.get_name()};
louiz’'s avatar
louiz’ committed
156
    return query.execute(*Database::db);
157 158 159 160 161 162
  }

  static MucLogLineTable muc_log_lines;
  static GlobalOptionsTable global_options;
  static IrcServerOptionsTable irc_server_options;
  static IrcChannelOptionsTable irc_channel_options;
163
  static RosterTable roster;
louiz’'s avatar
louiz’ committed
164
  static std::unique_ptr<DatabaseEngine> db;
165

166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198
  /**
   * Some caches, to avoid doing very frequent query requests for a few options.
   */
  using CacheKey = std::tuple<std::string, std::string, std::string>;

  static EncodingIn::real_type get_encoding_in(const std::string& owner,
                                        const std::string& server,
                                        const std::string& channel)
  {
    CacheKey channel_key{owner, server, channel};
    auto it = Database::encoding_in_cache.find(channel_key);
    if (it == Database::encoding_in_cache.end())
      {
        auto options = Database::get_irc_channel_options_with_server_default(owner, server, channel);
        EncodingIn::real_type result = options.col<Database::EncodingIn>();
        if (result.empty())
          result = "ISO-8859-1";
        it = Database::encoding_in_cache.insert(std::make_pair(channel_key, result)).first;
      }
    return it->second;
  }
  static void invalidate_encoding_in_cache(const std::string& owner,
                                           const std::string& server,
                                           const std::string& channel)
  {
    CacheKey channel_key{owner, server, channel};
    Database::encoding_in_cache.erase(channel_key);
  }
  static void invalidate_encoding_in_cache()
  {
    Database::encoding_in_cache.clear();
  }

louiz’'s avatar
louiz’ committed
199 200 201 202 203
  static auto raw_exec(const std::string& query)
  {
    Database::db->raw_exec(query);
  }

204
 private:
205
  static std::string gen_uuid();
206
  static std::map<CacheKey, EncodingIn::real_type> encoding_in_cache;
207 208
};
#endif /* USE_DATABASE */