main-db.cpp 62.4 KB
Newer Older
Ronan's avatar
Ronan committed
1
/*
2
 * main-db.cpp
Ghislain MARY's avatar
Ghislain MARY committed
3
 * Copyright (C) 2010-2017 Belledonne Communications SARL
Ronan's avatar
Ronan committed
4
 *
Ghislain MARY's avatar
Ghislain MARY committed
5 6 7 8
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version.
Ronan's avatar
Ronan committed
9 10 11 12 13 14 15
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
Ghislain MARY's avatar
Ghislain MARY committed
16 17
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
Ronan's avatar
Ronan committed
18 19
 */

20
#include <algorithm>
21
#include <ctime>
22

Ronan's avatar
Ronan committed
23 24 25 26
#ifdef SOCI_ENABLED
	#include <soci/soci.h>
#endif // ifdef SOCI_ENABLED

27 28
#include "linphone/utils/utils.h"

Ronan's avatar
Ronan committed
29
#include "chat/chat-message/chat-message-p.h"
30
#include "chat/chat-room/chat-room-p.h"
31 32
#include "chat/chat-room/client-group-chat-room.h"
#include "conference/participant-p.h"
33
#include "content/content-type.h"
Ronan's avatar
Ronan committed
34
#include "content/content.h"
Ronan's avatar
Ronan committed
35
#include "core/core-p.h"
36
#include "db/session/db-session-provider.h"
Ronan's avatar
Ronan committed
37
#include "event-log/event-log-p.h"
38
#include "event-log/events.h"
Ronan's avatar
Ronan committed
39
#include "logger/logger.h"
40
#include "main-db-event-key-p.h"
Ronan's avatar
Ronan committed
41
#include "main-db-p.h"
Ronan's avatar
Ronan committed
42 43 44

// =============================================================================

Ronan's avatar
Ronan committed
45 46
using namespace std;

Ronan's avatar
Ronan committed
47 48 49 50
LINPHONE_BEGIN_NAMESPACE

// -----------------------------------------------------------------------------

51
MainDb::MainDb (const shared_ptr<Core> &core) : AbstractDb(*new MainDbPrivate), CoreAccessor(core) {}
Ronan's avatar
Ronan committed
52

53 54
#ifdef SOCI_ENABLED

Ronan's avatar
Ronan committed
55
// -----------------------------------------------------------------------------
56
// Soci backend.
Ronan's avatar
Ronan committed
57 58
// -----------------------------------------------------------------------------

59 60 61 62 63
	template<typename T>
	struct EnumToSql {
		T first;
		const char *second;
	};
64

65 66 67 68 69 70 71
	template<typename T>
	static constexpr const char *mapEnumToSql (const EnumToSql<T> enumToSql[], size_t n, T key) {
		return n == 0 ? "" : (
			enumToSql[n - 1].first == key ? enumToSql[n - 1].second : mapEnumToSql(enumToSql, n - 1, key)
		);
	}

72
	static constexpr EnumToSql<MainDb::Filter> eventFilterToSql[] = {
73
		{ MainDb::ConferenceCallFilter, "3, 4" },
Ronan's avatar
Ronan committed
74
		{ MainDb::ConferenceChatMessageFilter, "5" },
75
		{ MainDb::ConferenceInfoFilter, "1, 2, 6, 7, 8, 9, 10, 11, 12" }
76
	};
77

78
	static constexpr const char *mapEventFilterToSql (MainDb::Filter filter) {
79 80 81
		return mapEnumToSql(
			eventFilterToSql, sizeof eventFilterToSql / sizeof eventFilterToSql[0], filter
		);
82 83
	}

Ronan's avatar
Ronan committed
84 85
// -----------------------------------------------------------------------------

Ronan's avatar
Ronan committed
86 87 88 89 90
	static string buildSqlEventFilter (
		const list<MainDb::Filter> &filters,
		MainDb::FilterMask mask,
		const string &condKeyWord = "WHERE"
	) {
91
		L_ASSERT(
92
			find_if(filters.cbegin(), filters.cend(), [](const MainDb::Filter &filter) {
93 94
				return filter == MainDb::NoFilter;
			}) == filters.cend()
95 96
		);

97
		if (mask == MainDb::NoFilter)
98 99 100 101 102 103 104 105 106 107
			return "";

		bool isStart = true;
		string sql;
		for (const auto &filter : filters) {
			if (!(mask & filter))
				continue;

			if (isStart) {
				isStart = false;
Ronan's avatar
Ronan committed
108
				sql += " " + condKeyWord + " type IN (";
109
			} else
Ronan's avatar
Ronan committed
110
				sql += ", ";
111 112 113
			sql += mapEventFilterToSql(filter);
		}

Ronan's avatar
Ronan committed
114 115 116
		if (!isStart)
			sql += ") ";

117 118 119
		return sql;
	}

120 121
// -----------------------------------------------------------------------------

122
	long long MainDbPrivate::insertSipAddress (const string &sipAddress) {
123 124 125
		L_Q();
		soci::session *session = dbSession.getBackendSession<soci::session>();

126 127
		long long id = selectSipAddressId(sipAddress);
		if (id >= 0)
128 129
			return id;

Ronan's avatar
Ronan committed
130
		lInfo() << "Insert new sip address in database: `" << sipAddress << "`.";
131 132
		*session << "INSERT INTO sip_address (value) VALUES (:sipAddress)", soci::use(sipAddress);
		return q->getLastInsertId();
133 134
	}

135
	void MainDbPrivate::insertContent (long long eventId, const Content &content) {
136
		L_Q();
137 138
		soci::session *session = dbSession.getBackendSession<soci::session>();

139
		long long contentTypeId = insertContentType(content.getContentType().asString());
140
		*session << "INSERT INTO chat_message_content (event_id, content_type_id, body) VALUES"
Ronan's avatar
Ronan committed
141
			"  (:eventId, :contentTypeId, :body)", soci::use(eventId), soci::use(contentTypeId),
142
			soci::use(content.getBodyAsString());
143

144
		long long messageContentId = q->getLastInsertId();
Sylvain Berfini's avatar
Sylvain Berfini committed
145
		if (content.getContentType().isFile()) {
146
			const FileContent &fileContent = static_cast<const FileContent &>(content);
Sylvain Berfini's avatar
Sylvain Berfini committed
147 148
			*session << "INSERT INTO chat_message_file_content (chat_message_content_id, name, size, path) VALUES "
				" (:contentId, :name, :size, :path)",
149 150
				soci::use(messageContentId), soci::use(fileContent.getFileName()),
				soci::use(fileContent.getFileSize()), soci::use(fileContent.getFilePath());
Sylvain Berfini's avatar
Sylvain Berfini committed
151 152
		}

153
		for (const auto &appData : content.getAppDataMap())
Ronan's avatar
Ronan committed
154 155
			*session << "INSERT INTO chat_message_content_app_data (chat_message_content_id, name, data) VALUES"
				"  (:messageContentId, :name, :data)",
156
				soci::use(messageContentId), soci::use(appData.first), soci::use(appData.second);
157 158
	}

159 160 161 162 163 164 165 166 167 168 169 170
	void MainDbPrivate::updateContent (long long eventId, long long messageContentId, const Content &content) {
		soci::session *session = dbSession.getBackendSession<soci::session>();

		long long contentTypeId = insertContentType(content.getContentType().asString());
		*session << "UPDATE chat_message_content SET content_type_id=:contentTypeId, body=:body WHERE event_id=:eventId",
			soci::use(contentTypeId), soci::use(content.getBodyAsString()), soci::use(eventId);

		for (const auto &appData : content.getAppDataMap())
			*session << "UPDATE chat_message_content_app_data SET name=:name, data=:data WHERE chat_message_content_id=:messageContentId",
				soci::use(appData.first), soci::use(appData.second), soci::use(messageContentId);
	}

171
	long long MainDbPrivate::insertContentType (const string &contentType) {
172 173 174
		L_Q();
		soci::session *session = dbSession.getBackendSession<soci::session>();

175
		long long id;
176 177
		*session << "SELECT id FROM content_type WHERE value = :contentType", soci::use(contentType), soci::into(id);
		if (session->got_data())
178 179
			return id;

Ronan's avatar
Ronan committed
180
		lInfo() << "Insert new content type in database: `" << contentType << "`.";
181 182
		*session << "INSERT INTO content_type (value) VALUES (:contentType)", soci::use(contentType);
		return q->getLastInsertId();
183 184
	}

185 186 187 188
	long long MainDbPrivate::insertChatRoom (
		long long peerSipAddressId,
		long long localSipAddressId,
		int capabilities,
189
		const tm &creationTime
190 191 192
	) {
		L_Q();

193 194
		soci::session *session = dbSession.getBackendSession<soci::session>();

195
		long long id = selectChatRoomId(peerSipAddressId, localSipAddressId);
196 197
		if (id >= 0)
			return id;
198

199 200 201 202 203 204 205 206 207
		lInfo() << "Insert new chat room in database: (peer=" << peerSipAddressId <<
			", local=" << localSipAddressId << ", capabilities=" << capabilities << ").";
		*session << "INSERT INTO chat_room ("
			"  peer_sip_address_id, local_sip_address_id, creation_time, last_update_time, capabilities"
			") VALUES (:peerSipAddressId, :localSipAddressId, :creationTime, :lastUpdateTime, :capabilities)",
			soci::use(peerSipAddressId), soci::use(localSipAddressId), soci::use(creationTime), soci::use(creationTime),
			soci::use(capabilities);

		return q->getLastInsertId();
208 209
	}

210 211 212 213 214 215
	long long MainDbPrivate::insertChatRoom (const std::shared_ptr<ChatRoom> &chatRoom) {
		L_Q();

		soci::session *session = dbSession.getBackendSession<soci::session>();

		const ChatRoomId &chatRoomId = chatRoom->getChatRoomId();
216 217
		long long peerSipAddressId = insertSipAddress(chatRoomId.getPeerAddress().asString());
		long long localSipAddressId = insertSipAddress(chatRoomId.getLocalAddress().asString());
218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237

		long long id = selectChatRoomId(peerSipAddressId, localSipAddressId);
		if (id >= 0) {
			lWarning() << "Unable to insert chat room (it already exists): (peer=" << peerSipAddressId <<
				", local=" << localSipAddressId << ").";
			return id;
		}

		lInfo() << "Insert new chat room in database: (peer=" << peerSipAddressId <<
			", local=" << localSipAddressId << ").";

		tm creationTime = Utils::getTimeTAsTm(chatRoom->getCreationTime());

		*session << "INSERT INTO chat_room ("
			"  peer_sip_address_id, local_sip_address_id, creation_time, last_update_time, capabilities, subject"
			") VALUES (:peerSipAddressId, :localSipAddressId, :creationTime, :lastUpdateTime, :capabilities, :subject)",
			soci::use(peerSipAddressId), soci::use(localSipAddressId), soci::use(creationTime), soci::use(creationTime),
			soci::use(static_cast<int>(chatRoom->getCapabilities())), soci::use(chatRoom->getSubject());

		id = q->getLastInsertId();
Ronan's avatar
Ronan committed
238 239
		shared_ptr<Participant> me = chatRoom->getMe();
		insertChatRoomParticipant(id, insertSipAddress(me->getAddress().asString()), me->isAdmin());
240
		for (const auto &participant : chatRoom->getParticipants())
241
			insertChatRoomParticipant(id, insertSipAddress(participant->getAddress().asString()), participant->isAdmin());
242 243

		return id;
244 245
	}

246
	void MainDbPrivate::insertChatRoomParticipant (long long chatRoomId, long long sipAddressId, bool isAdmin) {
247
		soci::session *session = dbSession.getBackendSession<soci::session>();
248 249
		soci::statement statement = (
			session->prepare << "UPDATE chat_room_participant SET is_admin = :isAdmin"
250
				"  WHERE chat_room_id = :chatRoomId AND participant_sip_address_id = :sipAddressId",
251 252 253
				soci::use(static_cast<int>(isAdmin)), soci::use(chatRoomId), soci::use(sipAddressId)
		);
		statement.execute(true);
Ronan's avatar
Ronan committed
254 255
		if (statement.get_affected_rows() == 0) {
			lInfo() << "Insert new chat room participant in database: `" << sipAddressId << "` (isAdmin=" << isAdmin << ").";
256
			*session << "INSERT INTO chat_room_participant (chat_room_id, participant_sip_address_id, is_admin)"
257 258
				"  VALUES (:chatRoomId, :sipAddressId, :isAdmin)",
				soci::use(chatRoomId), soci::use(sipAddressId), soci::use(static_cast<int>(isAdmin));
Ronan's avatar
Ronan committed
259
		}
260 261
	}

262
	void MainDbPrivate::insertChatMessageParticipant (long long eventId, long long sipAddressId, int state) {
263 264
		soci::session *session = dbSession.getBackendSession<soci::session>();
		soci::statement statement = (
265
			session->prepare << "UPDATE chat_message_participant SET state = :state"
266
				"  WHERE event_id = :eventId AND participant_sip_address_id = :sipAddressId",
Ronan's avatar
Ronan committed
267
				soci::use(state), soci::use(eventId), soci::use(sipAddressId)
268 269
		);
		statement.execute(true);
270
		if (statement.get_affected_rows() == 0 && state != static_cast<int>(ChatMessage::State::Displayed))
271
			*session << "INSERT INTO chat_message_participant (event_id, participant_sip_address_id, state)"
Ronan's avatar
Ronan committed
272 273
				"  VALUES (:eventId, :sipAddressId, :state)",
				soci::use(eventId), soci::use(sipAddressId), soci::use(state);
274 275
	}

276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305
	long long MainDbPrivate::selectSipAddressId (const std::string &sipAddress) const {
		soci::session *session = dbSession.getBackendSession<soci::session>();

		long long id;
		*session << "SELECT id FROM sip_address WHERE value = :sipAddress", soci::use(sipAddress), soci::into(id);
		return session->got_data() ? id : -1;
	}

	long long MainDbPrivate::selectChatRoomId (long long peerSipAddressId, long long localSipAddressId) const {
		soci::session *session = dbSession.getBackendSession<soci::session>();

		long long id;
		*session << "SELECT id FROM chat_room"
			"  WHERE peer_sip_address_id = :peerSipAddressId AND local_sip_address_id = :localSipAddressId",
			soci::use(peerSipAddressId), soci::use(localSipAddressId), soci::into(id);
		return session->got_data() ? id : -1;
	}

	long long MainDbPrivate::selectChatRoomId (const ChatRoomId &chatRoomId) const {
		long long peerSipAddressId = selectSipAddressId(chatRoomId.getPeerAddress().asString());
		if (peerSipAddressId < 0)
			return -1;

		long long localSipAddressId = selectSipAddressId(chatRoomId.getLocalAddress().asString());
		if (localSipAddressId < 0)
			return -1;

		return selectChatRoomId(peerSipAddressId, localSipAddressId);
	}

Ronan's avatar
Ronan committed
306 307
// -----------------------------------------------------------------------------

308
	shared_ptr<EventLog> MainDbPrivate::selectGenericConferenceEvent (
309
		long long eventId,
310
		EventLog::Type type,
311
		time_t creationTime,
312
		const ChatRoomId &chatRoomId
313
	) const {
Ronan's avatar
Ronan committed
314 315 316 317 318 319
		switch (type) {
			case EventLog::Type::None:
				return nullptr;

			case EventLog::Type::ConferenceCreated:
			case EventLog::Type::ConferenceDestroyed:
320
				return selectConferenceEvent(eventId, type, creationTime, chatRoomId);
Ronan's avatar
Ronan committed
321

322 323
			case EventLog::Type::ConferenceCallStart:
			case EventLog::Type::ConferenceCallEnd:
324
				return selectConferenceCallEvent(eventId, type, creationTime, chatRoomId);
Ronan's avatar
Ronan committed
325 326

			case EventLog::Type::ConferenceChatMessage:
327
				return selectConferenceChatMessageEvent(eventId, type, creationTime, chatRoomId);
Ronan's avatar
Ronan committed
328 329 330 331 332

			case EventLog::Type::ConferenceParticipantAdded:
			case EventLog::Type::ConferenceParticipantRemoved:
			case EventLog::Type::ConferenceParticipantSetAdmin:
			case EventLog::Type::ConferenceParticipantUnsetAdmin:
333
				return selectConferenceParticipantEvent(eventId, type, creationTime, chatRoomId);
Ronan's avatar
Ronan committed
334 335 336

			case EventLog::Type::ConferenceParticipantDeviceAdded:
			case EventLog::Type::ConferenceParticipantDeviceRemoved:
337
				return selectConferenceParticipantDeviceEvent(eventId, type, creationTime, chatRoomId);
Ronan's avatar
Ronan committed
338 339

			case EventLog::Type::ConferenceSubjectChanged:
340
				return selectConferenceSubjectEvent(eventId, type, creationTime, chatRoomId);
Ronan's avatar
Ronan committed
341 342 343 344 345
		}

		return nullptr;
	}

346
	shared_ptr<EventLog> MainDbPrivate::selectConferenceEvent (
347
		long long,
348
		EventLog::Type type,
349
		time_t creationTime,
350
		const ChatRoomId &chatRoomId
351
	) const {
352 353
		return make_shared<ConferenceEvent>(
			type,
354
			creationTime,
355
			chatRoomId
356
		);
Ronan's avatar
Ronan committed
357 358
	}

359
	shared_ptr<EventLog> MainDbPrivate::selectConferenceCallEvent (
360
		long long eventId,
361
		EventLog::Type type,
362
		time_t creationTime,
363
		const ChatRoomId &chatRoomId
364
	) const {
Ronan's avatar
Ronan committed
365 366 367 368
		// TODO.
		return nullptr;
	}

369
	shared_ptr<EventLog> MainDbPrivate::selectConferenceChatMessageEvent (
370
		long long eventId,
371
		EventLog::Type type,
372
		time_t creationTime,
373
		const ChatRoomId &chatRoomId
374
	) const {
Ronan's avatar
Ronan committed
375 376 377 378
		L_Q();

		shared_ptr<Core> core = q->getCore();

379
		shared_ptr<ChatRoom> chatRoom = core->findChatRoom(chatRoomId);
Ronan's avatar
Ronan committed
380 381 382 383 384
		if (!chatRoom)
			return nullptr;

		// TODO: Use cache, do not fetch the same message twice.

385
		// 1 - Fetch chat message.
386
		shared_ptr<ChatMessage> chatMessage;
387
		{
388 389
			string fromSipAddress;
			string toSipAddress;
390 391 392

			tm messageTime;

393
			string imdnMessageId;
394

395 396 397 398 399
			int state;
			int direction;
			int isSecured;

			soci::session *session = dbSession.getBackendSession<soci::session>();
400
			*session << "SELECT from_sip_address.value, to_sip_address.value, time, imdn_message_id, state, direction, is_secured"
401 402
				"  FROM event, conference_chat_message_event, sip_address AS from_sip_address,"
				"  sip_address AS to_sip_address"
403 404
				"  WHERE event_id = :eventId"
				"  AND event_id = event.id"
405 406
				"  AND from_sip_address_id = from_sip_address.id"
				"  AND to_sip_address_id = to_sip_address.id", soci::into(fromSipAddress), soci::into(toSipAddress),
407 408
				soci::into(messageTime), soci::into(imdnMessageId), soci::into(state), soci::into(direction),
				soci::into(isSecured), soci::use(eventId);
409

410 411 412 413
			chatMessage = shared_ptr<ChatMessage>(new ChatMessage(
				chatRoom,
				static_cast<ChatMessage::Direction>(direction)
			));
414 415 416
			chatMessage->getPrivate()->setState(static_cast<ChatMessage::State>(state), true);
			chatMessage->setIsSecured(static_cast<bool>(isSecured));

417 418
			chatMessage->getPrivate()->forceFromAddress(IdentityAddress(fromSipAddress));
			chatMessage->getPrivate()->forceToAddress(IdentityAddress(toSipAddress));
419 420

			chatMessage->getPrivate()->setTime(Utils::getTmAsTimeT(messageTime));
421
		}
Ronan's avatar
Ronan committed
422

423 424 425
		// 2 - Fetch contents.
		{
			soci::session *session = dbSession.getBackendSession<soci::session>();
426
			const string query = "SELECT chat_message_content.id, content_type.id, content_type.value, body FROM chat_message_content, content_type"
427 428 429
				"  WHERE event_id = :eventId AND content_type_id = content_type.id";
			soci::rowset<soci::row> rows = (session->prepare << query, soci::use(eventId));
			for (const auto &row : rows) {
430
				ContentType contentType(row.get<string>(2));
431 432 433 434 435 436 437 438 439 440 441 442 443 444
				Content *content;

				if (contentType == ContentType::FileTransfer)
					content = new FileTransferContent();
				else if (contentType.isFile()) {
					long long contentId = q->getBackend() == AbstractDb::Sqlite3
						? static_cast<long long>(row.get<int>(0))
						: row.get<long long>(0);

					string name;
					int size;
					string path;

					*session << "SELECT name, size, path FROM chat_message_file_content"
Ronan's avatar
Ronan committed
445
						"  WHERE chat_message_content_id = :contentId",
Ronan's avatar
Ronan committed
446
						soci::into(name), soci::into(size), soci::into(path), soci::use(contentId);
447 448 449 450 451 452 453 454

					FileContent *fileContent = new FileContent();
					fileContent->setFileName(name);
					fileContent->setFileSize(static_cast<size_t>(size));
					fileContent->setFilePath(path);

					content = fileContent;
				} else
Ronan's avatar
Ronan committed
455
					content = new Content();
456 457

				content->setContentType(contentType);
Sylvain Berfini's avatar
Sylvain Berfini committed
458
				content->setBody(row.get<string>(3));
459
				chatMessage->addContent(*content);
460
			}
Ronan's avatar
Ronan committed
461
		}
462 463 464

		// TODO: Use cache.
		return make_shared<ConferenceChatMessageEvent>(
465
			creationTime,
466 467
			chatMessage
		);
Ronan's avatar
Ronan committed
468 469
	}

470
	shared_ptr<EventLog> MainDbPrivate::selectConferenceParticipantEvent (
471
		long long eventId,
472
		EventLog::Type type,
473
		time_t creationTime,
474
		const ChatRoomId &chatRoomId
475
	) const {
476 477 478 479
		unsigned int notifyId;
		string participantAddress;

		soci::session *session = dbSession.getBackendSession<soci::session>();
480 481
		*session << "SELECT notify_id, participant_address.value"
			"  FROM conference_notified_event, conference_participant_event, sip_address as participant_address"
482
			"  WHERE conference_participant_event.event_id = :eventId"
Ronan's avatar
Ronan committed
483
			"    AND conference_notified_event.event_id = conference_participant_event.event_id"
484
			"    AND participant_address.id = participant_sip_address_id",
485 486 487 488
			soci::into(notifyId), soci::into(participantAddress), soci::use(eventId);

		return make_shared<ConferenceParticipantEvent>(
			type,
489
			creationTime,
490
			chatRoomId,
491
			notifyId,
492
			IdentityAddress(participantAddress)
493
		);
Ronan's avatar
Ronan committed
494 495
	}

496
	shared_ptr<EventLog> MainDbPrivate::selectConferenceParticipantDeviceEvent (
497
		long long eventId,
498
		EventLog::Type type,
499
		time_t creationTime,
500
		const ChatRoomId &chatRoomId
501
	) const {
502 503
		unsigned int notifyId;
		string participantAddress;
504
		string deviceAddress;
505 506

		soci::session *session = dbSession.getBackendSession<soci::session>();
507
		*session << "SELECT notify_id, participant_address.value, device_address.value"
508
			"  FROM conference_notified_event, conference_participant_event, conference_participant_device_event,"
509
			"    sip_address AS participant_address, sip_address AS device_address"
510 511
			"  WHERE conference_participant_device_event.event_id = :eventId"
			"    AND conference_participant_event.event_id = conference_participant_device_event.event_id"
512
			"    AND conference_notified_event.event_id = conference_participant_event.event_id"
513 514
			"    AND participant_address.id = participant_sip_address_id"
			"    AND device_address.id = device_sip_address_id",
515
			soci::into(notifyId), soci::into(participantAddress), soci::into(deviceAddress), soci::use(eventId);
516 517 518

		return make_shared<ConferenceParticipantDeviceEvent>(
			type,
519
			creationTime,
520
			chatRoomId,
521
			notifyId,
522 523
			IdentityAddress(participantAddress),
			IdentityAddress(deviceAddress)
524
		);
Ronan's avatar
Ronan committed
525 526
	}

527
	shared_ptr<EventLog> MainDbPrivate::selectConferenceSubjectEvent (
528
		long long eventId,
529
		EventLog::Type type,
530
		time_t creationTime,
531
		const ChatRoomId &chatRoomId
532 533 534 535
	) const {
		unsigned int notifyId;
		string subject;

536 537 538 539 540 541
		soci::session *session = dbSession.getBackendSession<soci::session>();
		*session << "SELECT notify_id, subject"
			"  FROM conference_notified_event, conference_subject_event"
			"  WHERE conference_subject_event.event_id = :eventId"
			"    AND conference_notified_event.event_id = conference_subject_event.event_id",
			soci::into(notifyId), soci::into(subject), soci::use(eventId);
542 543

		return make_shared<ConferenceSubjectEvent>(
544
			creationTime,
545
			chatRoomId,
546 547 548
			notifyId,
			subject
		);
Ronan's avatar
Ronan committed
549 550
	}

551 552
// -----------------------------------------------------------------------------

Ronan's avatar
Ronan committed
553
	long long MainDbPrivate::insertEvent (const shared_ptr<EventLog> &eventLog) {
554 555 556
		L_Q();
		soci::session *session = dbSession.getBackendSession<soci::session>();

557
		*session << "INSERT INTO event (type, creation_time) VALUES (:type, :creationTime)",
558 559
			soci::use(static_cast<int>(eventLog->getType())),
			soci::use(Utils::getTimeTAsTm(eventLog->getCreationTime()));
560
		return q->getLastInsertId();
561 562
	}

Ronan's avatar
Ronan committed
563
	long long MainDbPrivate::insertConferenceEvent (const shared_ptr<EventLog> &eventLog, long long *chatRoomId) {
564 565 566 567 568 569 570 571 572 573 574 575 576
		shared_ptr<ConferenceEvent> conferenceEvent = static_pointer_cast<ConferenceEvent>(eventLog);

		long long eventId = -1;
		long long curChatRoomId = selectChatRoomId(conferenceEvent->getChatRoomId());
		if (curChatRoomId < 0) {
			// A conference event can be inserted in database only if chat room exists.
			// Otherwise it's an error.
			const ChatRoomId &chatRoomId = conferenceEvent->getChatRoomId();
			lError() << "Unable to find chat room storage id of (peer=" +
				chatRoomId.getPeerAddress().asString() +
				", local=" + chatRoomId.getLocalAddress().asString() + "`).";
		} else {
			eventId = insertEvent(eventLog);
577

578 579 580 581
			soci::session *session = dbSession.getBackendSession<soci::session>();
			*session << "INSERT INTO conference_event (event_id, chat_room_id)"
				"  VALUES (:eventId, :chatRoomId)", soci::use(eventId), soci::use(curChatRoomId);

582
			*session << "UPDATE chat_room SET last_update_time = :lastUpdateTime"
583 584 585
				"  WHERE id = :chatRoomId", soci::use(Utils::getTimeTAsTm(eventLog->getCreationTime())),
				soci::use(curChatRoomId);
		}
586 587 588 589 590 591 592

		if (chatRoomId)
			*chatRoomId = curChatRoomId;

		return eventId;
	}

Ronan's avatar
Ronan committed
593
	long long MainDbPrivate::insertConferenceCallEvent (const shared_ptr<EventLog> &eventLog) {
594 595 596 597
		// TODO.
		return 0;
	}

Ronan's avatar
Ronan committed
598 599
	long long MainDbPrivate::insertConferenceChatMessageEvent (const shared_ptr<EventLog> &eventLog) {
		shared_ptr<ChatMessage> chatMessage = static_pointer_cast<ConferenceChatMessageEvent>(eventLog)->getChatMessage();
600 601 602 603 604 605
		shared_ptr<ChatRoom> chatRoom = chatMessage->getChatRoom();
		if (!chatRoom) {
			lError() << "Unable to get a valid chat room. It was removed from database.";
			return -1;
		}

606
		long long eventId = insertConferenceEvent(eventLog);
607 608
		if (eventId < 0)
			return -1;
609

610 611
		long long fromSipAddressId = insertSipAddress(chatMessage->getFromAddress().asString());
		long long toSipAddressId = insertSipAddress(chatMessage->getToAddress().asString());
Ronan's avatar
Ronan committed
612

613
		soci::session *session = dbSession.getBackendSession<soci::session>();
614
		*session << "INSERT INTO conference_chat_message_event ("
615
			"  event_id, from_sip_address_id, to_sip_address_id,"
616
			"  time, state, direction, imdn_message_id, is_secured"
617 618
			") VALUES ("
			"  :eventId, :localSipaddressId, :remoteSipaddressId,"
619
			"  :time, :state, :direction, :imdnMessageId, :isSecured"
620
			")", soci::use(eventId), soci::use(fromSipAddressId), soci::use(toSipAddressId),
621 622 623
			soci::use(Utils::getTimeTAsTm(chatMessage->getTime())), soci::use(static_cast<int>(chatMessage->getState())),
			soci::use(static_cast<int>(chatMessage->getDirection())), soci::use(chatMessage->getImdnMessageId()),
			soci::use(chatMessage->isSecured() ? 1 : 0);
624

625
		for (const Content *content : chatMessage->getContents())
626
			insertContent(eventId, *content);
627

628 629 630
		return eventId;
	}

631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651
	void MainDbPrivate::updateConferenceChatMessageEvent(const std::shared_ptr<EventLog> &eventLog) {
		shared_ptr<ChatMessage> chatMessage = static_pointer_cast<ConferenceChatMessageEvent>(eventLog)->getChatMessage();
		shared_ptr<ChatRoom> chatRoom = chatMessage->getChatRoom();
		if (!chatRoom) {
			lError() << "Unable to get a valid chat room. It was removed from database.";
			return;
		}

		const EventLogPrivate *dEventLog = eventLog->getPrivate();
		MainDbEventKeyPrivate *dEventKey = dEventLog->dbKey.getPrivate();
		long long eventId = dEventKey->storageId;

		soci::session *session = dbSession.getBackendSession<soci::session>();
		*session << "UPDATE conference_chat_message_event SET state=:state WHERE event_id=:eventId"
			, soci::use(static_cast<int>(chatMessage->getState())), soci::use(eventId);

		/*for (const Content *content : chatMessage->getContents())
			updateContent(eventId, *content);*/
		//TODO check if content needs to be inserted, updated or removed
	}

652 653 654 655 656 657
	long long MainDbPrivate::insertConferenceNotifiedEvent (const shared_ptr<EventLog> &eventLog, long long *chatRoomId) {
		long long curChatRoomId;
		long long eventId = insertConferenceEvent(eventLog, &curChatRoomId);
		if (eventId < 0)
			return -1;

Ronan's avatar
Ronan committed
658
		unsigned int lastNotifyId = static_pointer_cast<ConferenceNotifiedEvent>(eventLog)->getNotifyId();
659 660 661

		soci::session *session = dbSession.getBackendSession<soci::session>();
		*session << "INSERT INTO conference_notified_event (event_id, notify_id)"
Ronan's avatar
Ronan committed
662 663
			"  VALUES (:eventId, :notifyId)", soci::use(eventId), soci::use(lastNotifyId);
		*session << "UPDATE chat_room SET last_notify_id = :lastNotifyId WHERE peer_sip_address_id = :chatRoomId",
664 665 666 667
			soci::use(lastNotifyId), soci::use(curChatRoomId);

		if (chatRoomId)
			*chatRoomId = curChatRoomId;
668

669 670 671
		return eventId;
	}

Ronan's avatar
Ronan committed
672
	long long MainDbPrivate::insertConferenceParticipantEvent (const shared_ptr<EventLog> &eventLog) {
673 674
		long long chatRoomId;
		long long eventId = insertConferenceNotifiedEvent(eventLog, &chatRoomId);
675 676 677
		if (eventId < 0)
			return -1;

678 679 680
		shared_ptr<ConferenceParticipantEvent> participantEvent =
			static_pointer_cast<ConferenceParticipantEvent>(eventLog);

681
		long long participantAddressId = insertSipAddress(
682
			participantEvent->getParticipantAddress().asString()
683 684
		);

685
		soci::session *session = dbSession.getBackendSession<soci::session>();
686
		*session << "INSERT INTO conference_participant_event (event_id, participant_sip_address_id)"
687
			"  VALUES (:eventId, :participantAddressId)", soci::use(eventId), soci::use(participantAddressId);
688

689 690 691 692 693 694 695 696 697 698 699 700 701 702 703
		bool isAdmin = eventLog->getType() == EventLog::Type::ConferenceParticipantSetAdmin;
		switch (eventLog->getType()) {
			case EventLog::Type::ConferenceParticipantAdded:
			case EventLog::Type::ConferenceParticipantSetAdmin:
			case EventLog::Type::ConferenceParticipantUnsetAdmin:
				insertChatRoomParticipant(chatRoomId, participantAddressId, isAdmin);
				break;

			case EventLog::Type::ConferenceParticipantRemoved:
				// TODO: Deal with remove.

			default:
				break;
		}

704 705 706
		return eventId;
	}

Ronan's avatar
Ronan committed
707
	long long MainDbPrivate::insertConferenceParticipantDeviceEvent (const shared_ptr<EventLog> &eventLog) {
708
		long long eventId = insertConferenceParticipantEvent(eventLog);
709 710 711 712 713
		if (eventId < 0)
			return -1;

		long long deviceAddressId = insertSipAddress(
			static_pointer_cast<ConferenceParticipantDeviceEvent>(eventLog)->getDeviceAddress().asString()
714 715 716
		);

		soci::session *session = dbSession.getBackendSession<soci::session>();
717
		*session << "INSERT INTO conference_participant_device_event (event_id, device_sip_address_id)"
718
			"  VALUES (:eventId, :deviceAddressId)", soci::use(eventId), soci::use(deviceAddressId);
719

720
		return eventId;
721 722
	}

Ronan's avatar
Ronan committed
723
	long long MainDbPrivate::insertConferenceSubjectEvent (const shared_ptr<EventLog> &eventLog) {
724 725 726 727 728 729
		long long chatRoomId;
		long long eventId = insertConferenceNotifiedEvent(eventLog, &chatRoomId);
		if (eventId < 0)
			return -1;

		const string &subject = static_pointer_cast<ConferenceSubjectEvent>(eventLog)->getSubject();
730 731

		soci::session *session = dbSession.getBackendSession<soci::session>();
732
		*session << "INSERT INTO conference_subject_event (event_id, subject)"
733 734 735 736
			"  VALUES (:eventId, :subject)", soci::use(eventId), soci::use(subject);

		*session << "UPDATE chat_room SET subject = :subject"
			"  WHERE id = :chatRoomId", soci::use(subject), soci::use(chatRoomId);
737

738
		return eventId;
739 740
	}

741 742 743 744 745 746 747 748 749 750 751 752 753
// -----------------------------------------------------------------------------

	shared_ptr<EventLog> MainDbPrivate::getEventFromCache (long long eventId) const {
		auto it = storageIdToEvent.find(eventId);
		if (it == storageIdToEvent.cend())
			return nullptr;

		shared_ptr<EventLog> eventLog = it->second.lock();
		// Must exist. If not, implementation bug.
		L_ASSERT(eventLog);
		return eventLog;
	}

754
	void MainDbPrivate::invalidConferenceEventsFromQuery (const string &query, long long chatRoomId) {
755 756 757
		L_Q();

		soci::session *session = dbSession.getBackendSession<soci::session>();
758
		soci::rowset<soci::row> rows = (session->prepare << query, soci::use(chatRoomId));
759 760 761 762 763 764 765 766 767 768 769 770
		for (const auto &row : rows) {
			shared_ptr<EventLog> eventLog = getEventFromCache(
				q->getBackend() == AbstractDb::Sqlite3 ? static_cast<long long>(row.get<int>(0)) : row.get<long long>(0)
			);
			if (eventLog) {
				const EventLogPrivate *dEventLog = eventLog->getPrivate();
				L_ASSERT(dEventLog->dbKey.isValid());
				dEventLog->dbKey = MainDbEventKey();
			}
		}
	}

771
// -----------------------------------------------------------------------------
Ronan's avatar
Ronan committed
772

773
	void MainDb::init () {
774
		L_D();
775 776

		const string charset = getBackend() == Mysql ? "DEFAULT CHARSET=utf8" : "";
Ronan's avatar
Ronan committed
777
		soci::session *session = d->dbSession.getBackendSession<soci::session>();
778

Ronan's avatar
Ronan committed
779
		*session <<
780
			"CREATE TABLE IF NOT EXISTS sip_address ("
Erwan Croze's avatar
Erwan Croze committed
781
			"  id" + primaryKeyStr("BIGINT UNSIGNED") + ","
Ronan's avatar
Ronan committed
782
			"  value VARCHAR(255) UNIQUE NOT NULL"
783
			") " + charset;
784

785
		*session <<
786
			"CREATE TABLE IF NOT EXISTS content_type ("
Erwan Croze's avatar
Erwan Croze committed
787
			"  id" + primaryKeyStr("SMALLINT UNSIGNED") + ","
Ronan's avatar
Ronan committed
788
			"  value VARCHAR(255) UNIQUE NOT NULL"
789
			") " + charset;
790

Ronan's avatar
Ronan committed
791
		*session <<
792
			"CREATE TABLE IF NOT EXISTS event ("
Erwan Croze's avatar
Erwan Croze committed
793
			"  id" + primaryKeyStr("BIGINT UNSIGNED") + ","
794
			"  type TINYINT UNSIGNED NOT NULL,"
795
			"  creation_time DATE NOT NULL"
796
			") " + charset;
797

Ronan's avatar
Ronan committed
798
		*session <<
799
			"CREATE TABLE IF NOT EXISTS chat_room ("
800 801
			"  id" + primaryKeyStr("BIGINT UNSIGNED") + ","

802
			// Server (for conference) or user sip address.
803
			"  peer_sip_address_id" + primaryKeyRefStr("BIGINT UNSIGNED") + " NOT NULL,"
804

805
			"  local_sip_address_id" + primaryKeyRefStr("BIGINT UNSIGNED") + " NOT NULL,"
806

807 808
			// Dialog creation time.
			"  creation_time DATE NOT NULL,"
809

810 811
			// Last event time (call, message...).
			"  last_update_time DATE NOT NULL,"
812

813
			// ConferenceChatRoom, BasicChatRoom, RTT...
814
			"  capabilities TINYINT UNSIGNED NOT NULL,"
815

816 817