summaryrefslogtreecommitdiff
path: root/lib/output/pq/updateDatabase.h
blob: 716d7f66dcd79e57fc7b556b512b2b136338cc24 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
#ifndef MYGRATE_OUTPUT_PQ_UPDATEDATABASE_H
#define MYGRATE_OUTPUT_PQ_UPDATEDATABASE_H

#include "pqConn.h"
#include "pqStmt.h"
#include <cstdint>
#include <eventHandlerBase.h>
#include <eventSourceBase.h>
#include <row.h>

namespace MyGrate::Input {
	class MySQLConn;
}
namespace MyGrate::Output::Pq {
	struct ColumnDef {
#ifndef __cpp_aggregate_paren_init
		ColumnDef(std::string, std::size_t, bool);
#endif

		std::string name;
		std::size_t ordinal;
		bool is_pk;
	};
	using ColumnDefPtr = std::unique_ptr<ColumnDef>;

	class TableOutput {
	public:
		TableOutput() = default;
		TableOutput(const RecordSet &, std::string_view name);

		std::vector<ColumnDefPtr> columns;
		std::size_t keys;
		DbPrepStmtPtr update, deleteFrom, insertInto;
	};
	using TableDefPtr = std::unique_ptr<TableOutput>;

	class ConfigError : public std::runtime_error {
		using std::runtime_error::runtime_error;
	};

	class ReplicationError : public std::runtime_error {
		using std::runtime_error::runtime_error;
	};

	class UpdateDatabase : public PqConn, public EventHandlerBase {
	public:
		UpdateDatabase(const char * const str, uint64_t source);

		EventSourceBasePtr getSource();

		static UpdateDatabase createNew(PqConn *, const char * host, const char * un, const char * pw, unsigned short p,
				const char * db, int sid, const char * sc);

		void addTable(Input::MySQLConn *, const char * tableName);

		// Replication events
		void updateRow(MariaDB_Event_Ptr) override;
		void deleteRow(MariaDB_Event_Ptr) override;
		void insertRow(MariaDB_Event_Ptr) override;
		void tableMap(MariaDB_Event_Ptr) override;
		void rotate(MariaDB_Event_Ptr) override;
		void gtid(MariaDB_Event_Ptr) override;
		void xid(MariaDB_Event_Ptr) override;

		const uint64_t source;
		const std::string schema;
		const std::string database;

	protected:
		virtual void beforeEvent(const MariaDB_Event_Ptr & e);
		virtual void afterEvent(const MariaDB_Event_Ptr & e);

	private:
		UpdateDatabase(PqConn &&, uint64_t source);
		UpdateDatabase(PqConn &&, uint64_t source, RecordSetPtr cfg);

		static void verifyRow(const MariaDB_Event_Ptr & e, const TableDefPtr &);
		static void copyKeys(const Row & r, const TableDefPtr &, std::back_insert_iterator<Row> &&);

		void copyTableContent(Input::MySQLConn *, const char * tableName, const TableDefPtr &);

		using Tables = std::map<std::string, TableDefPtr, std::less<>>;
		Tables tables;
		Tables::const_iterator selected;
		MariaDB_Event_Ptr table_map;
		bool intx {false};
	};
}

#endif