25#include <drizzled/algorithm/crc32.h>
26#include <drizzled/gettext.h>
27#include <drizzled/replication_services.h>
38#include <drizzled/message/transaction.pb.h>
40#include <google/protobuf/io/coded_stream.h>
41#include <google/protobuf/io/zero_copy_stream_impl.h>
43#include <drizzled/gettext.h>
51using namespace google;
53static uint32_t server_id= 1;
54static uint64_t transaction_id= 1;
56static uint64_t getNanoTimestamp()
59 clock_gettime(CLOCK_REALTIME, &tp);
60 return (uint64_t) tp.tv_sec * 10000000
61 + (uint64_t) tp.tv_nsec;
64static void initTransactionContext(message::Transaction &transaction)
66 message::TransactionContext *ctx= transaction.mutable_transaction_context();
67 ctx->set_transaction_id(transaction_id++);
68 ctx->set_start_timestamp(getNanoTimestamp());
69 ctx->set_server_id(server_id);
72static void finalizeTransactionContext(message::Transaction &transaction)
74 message::TransactionContext *ctx= transaction.mutable_transaction_context();
75 ctx->set_end_timestamp(getNanoTimestamp());
78static void doCreateTable1(message::Transaction &transaction)
80 message::Statement *statement= transaction.add_statement();
82 statement->set_type(message::Statement::RAW_SQL);
83 statement->set_sql(
"CREATE TABLE t1 (a VARCHAR(32) NOT NULL, PRIMARY KEY a) ENGINE=InnoDB");
84 statement->set_start_timestamp(getNanoTimestamp());
85 statement->set_end_timestamp(getNanoTimestamp());
88static void doCreateTable2(message::Transaction &transaction)
90 message::Statement *statement= transaction.add_statement();
92 statement->set_type(message::Statement::RAW_SQL);
93 statement->set_sql(
"CREATE TABLE t2 (a INTEGER NOT NULL, PRIMARY KEY a) ENGINE=InnoDB");
94 statement->set_start_timestamp(getNanoTimestamp());
95 statement->set_end_timestamp(getNanoTimestamp());
98static void doCreateTable3(message::Transaction &transaction)
100 message::Statement *statement= transaction.add_statement();
102 statement->set_type(message::Statement::RAW_SQL);
103 statement->set_sql(
"CREATE TABLE t3 (a INTEGER NOT NULL, b BLOB NOT NULL, PRIMARY KEY a) ENGINE=InnoDB");
104 statement->set_start_timestamp(getNanoTimestamp());
105 statement->set_end_timestamp(getNanoTimestamp());
108static void doSimpleInsert(message::Transaction &transaction)
110 message::Statement *statement= transaction.add_statement();
113 statement->set_type(message::Statement::INSERT);
114 statement->set_sql(
"INSERT INTO t1 (a) VALUES (\"1\"), (\"2\")");
115 statement->set_start_timestamp(getNanoTimestamp());
118 message::InsertHeader *header= statement->mutable_insert_header();
121 message::TableMetadata *t_meta= header->mutable_table_metadata();
122 t_meta->set_schema_name(
"test");
123 t_meta->set_table_name(
"t1");
125 message::FieldMetadata *f_meta= header->add_field_metadata();
126 f_meta->set_name(
"a");
127 f_meta->set_type(message::Table::Field::VARCHAR);
130 message::InsertData *data= statement->mutable_insert_data();
131 data->set_segment_id(1);
132 data->set_end_segment(
true);
134 message::InsertRecord *record1= data->add_record();
135 message::InsertRecord *record2= data->add_record();
137 record1->add_insert_value(
"1");
138 record2->add_insert_value(
"2");
140 statement->set_end_timestamp(getNanoTimestamp());
143static void doNonVarcharInsert(message::Transaction &transaction)
145 message::Statement *statement= transaction.add_statement();
148 statement->set_type(message::Statement::INSERT);
149 statement->set_sql(
"INSERT INTO t2 (a) VALUES (1), (2)");
150 statement->set_start_timestamp(getNanoTimestamp());
153 message::InsertHeader *header= statement->mutable_insert_header();
156 message::TableMetadata *t_meta= header->mutable_table_metadata();
157 t_meta->set_schema_name(
"test");
158 t_meta->set_table_name(
"t2");
160 message::FieldMetadata *f_meta= header->add_field_metadata();
161 f_meta->set_name(
"a");
162 f_meta->set_type(message::Table::Field::INTEGER);
165 message::InsertData *data= statement->mutable_insert_data();
166 data->set_segment_id(1);
167 data->set_end_segment(
true);
169 message::InsertRecord *record1= data->add_record();
170 message::InsertRecord *record2= data->add_record();
172 record1->add_insert_value(
"1");
173 record2->add_insert_value(
"2");
175 statement->set_end_timestamp(getNanoTimestamp());
178static void doBlobInsert(message::Transaction &transaction)
180 message::Statement *statement= transaction.add_statement();
183 statement->set_type(message::Statement::INSERT);
184 statement->set_sql(
"INSERT INTO t3 (a, b) VALUES (1, 'test\0me')", 43);
185 statement->set_start_timestamp(getNanoTimestamp());
188 message::InsertHeader *header= statement->mutable_insert_header();
191 message::TableMetadata *t_meta= header->mutable_table_metadata();
192 t_meta->set_schema_name(
"test");
193 t_meta->set_table_name(
"t3");
195 message::FieldMetadata *f_meta= header->add_field_metadata();
196 f_meta->set_name(
"a");
197 f_meta->set_type(message::Table::Field::INTEGER);
199 f_meta= header->add_field_metadata();
200 f_meta->set_name(
"b");
201 f_meta->set_type(message::Table::Field::BLOB);
204 message::InsertData *data= statement->mutable_insert_data();
205 data->set_segment_id(1);
206 data->set_end_segment(
true);
208 message::InsertRecord *record1= data->add_record();
210 record1->add_insert_value(
"1");
211 record1->add_insert_value(
"test\0me", 7);
213 statement->set_end_timestamp(getNanoTimestamp());
216static void doSimpleDelete(message::Transaction &transaction)
218 message::Statement *statement= transaction.add_statement();
221 statement->set_type(message::Statement::DELETE);
222 statement->set_sql(
"DELETE FROM t1 WHERE a = \"1\"");
223 statement->set_start_timestamp(getNanoTimestamp());
226 message::DeleteHeader *header= statement->mutable_delete_header();
229 message::TableMetadata *t_meta= header->mutable_table_metadata();
230 t_meta->set_schema_name(
"test");
231 t_meta->set_table_name(
"t1");
233 message::FieldMetadata *f_meta= header->add_key_field_metadata();
234 f_meta->set_name(
"a");
235 f_meta->set_type(message::Table::Field::VARCHAR);
238 message::DeleteData *data= statement->mutable_delete_data();
239 data->set_segment_id(1);
240 data->set_end_segment(
true);
242 message::DeleteRecord *record1= data->add_record();
244 record1->add_key_value(
"1");
246 statement->set_end_timestamp(getNanoTimestamp());
249static void doSimpleUpdate(message::Transaction &transaction)
251 message::Statement *statement= transaction.add_statement();
254 statement->set_type(message::Statement::UPDATE);
255 statement->set_sql(
"UPDATE t1 SET a = \"5\" WHERE a = \"1\"");
256 statement->set_start_timestamp(getNanoTimestamp());
259 message::UpdateHeader *header= statement->mutable_update_header();
262 message::TableMetadata *t_meta= header->mutable_table_metadata();
263 t_meta->set_schema_name(
"test");
264 t_meta->set_table_name(
"t1");
266 message::FieldMetadata *kf_meta= header->add_key_field_metadata();
267 kf_meta->set_name(
"a");
268 kf_meta->set_type(message::Table::Field::VARCHAR);
270 message::FieldMetadata *sf_meta= header->add_set_field_metadata();
271 sf_meta->set_name(
"a");
272 sf_meta->set_type(message::Table::Field::VARCHAR);
275 message::UpdateData *data= statement->mutable_update_data();
276 data->set_segment_id(1);
277 data->set_end_segment(
true);
279 message::UpdateRecord *record1= data->add_record();
281 record1->add_after_value(
"5");
282 record1->add_key_value(
"1");
284 statement->set_end_timestamp(getNanoTimestamp());
287static void doMultiKeyUpdate(message::Transaction &transaction)
289 message::Statement *statement= transaction.add_statement();
292 statement->set_type(message::Statement::UPDATE);
293 statement->set_sql(
"UPDATE t1 SET a = \"5\"");
294 statement->set_start_timestamp(getNanoTimestamp());
297 message::UpdateHeader *header= statement->mutable_update_header();
300 message::TableMetadata *t_meta= header->mutable_table_metadata();
301 t_meta->set_schema_name(
"test");
302 t_meta->set_table_name(
"t1");
304 message::FieldMetadata *kf_meta= header->add_key_field_metadata();
305 kf_meta->set_name(
"a");
306 kf_meta->set_type(message::Table::Field::VARCHAR);
308 message::FieldMetadata *sf_meta= header->add_set_field_metadata();
309 sf_meta->set_name(
"a");
310 sf_meta->set_type(message::Table::Field::VARCHAR);
313 message::UpdateData *data= statement->mutable_update_data();
314 data->set_segment_id(1);
315 data->set_end_segment(
true);
317 message::UpdateRecord *record1= data->add_record();
318 message::UpdateRecord *record2= data->add_record();
320 record1->add_after_value(
"5");
321 record1->add_key_value(
"1");
322 record2->add_after_value(
"5");
323 record2->add_key_value(
"2");
325 statement->set_end_timestamp(getNanoTimestamp());
328static void writeTransaction(protobuf::io::CodedOutputStream *output, message::Transaction &transaction)
330 std::string buffer(
"");
331 finalizeTransactionContext(transaction);
332 transaction.SerializeToString(&buffer);
334 size_t length= buffer.length();
336 output->WriteLittleEndian32(
static_cast<uint32_t
>(ReplicationServices::TRANSACTION));
337 output->WriteLittleEndian32(
static_cast<uint32_t
>(length));
338 output->WriteString(buffer);
339 output->WriteLittleEndian32(drizzled::algorithm::crc32(buffer.c_str(), length));
342int main(
int argc,
char* argv[])
344 GOOGLE_PROTOBUF_VERIFY_VERSION;
349 fprintf(stderr, _(
"Usage: %s TRANSACTION_LOG\n"), argv[0]);
353 if ((file= open(argv[1], O_APPEND|O_CREAT|O_SYNC|O_WRONLY, S_IRWXU)) == -1)
355 fprintf(stderr, _(
"Cannot open file: %s\n"), argv[1]);
359 protobuf::io::ZeroCopyOutputStream *raw_output=
new protobuf::io::FileOutputStream(file);
360 protobuf::io::CodedOutputStream *coded_output=
new protobuf::io::CodedOutputStream(raw_output);
363 message::Transaction transaction;
366 initTransactionContext(transaction);
367 doCreateTable1(transaction);
368 writeTransaction(coded_output, transaction);
371 initTransactionContext(transaction);
372 doCreateTable2(transaction);
373 writeTransaction(coded_output, transaction);
377 initTransactionContext(transaction);
378 doSimpleInsert(transaction);
379 writeTransaction(coded_output, transaction);
383 initTransactionContext(transaction);
384 doSimpleDelete(transaction);
385 doSimpleUpdate(transaction);
386 writeTransaction(coded_output, transaction);
390 initTransactionContext(transaction);
391 doNonVarcharInsert(transaction);
392 writeTransaction(coded_output, transaction);
396 initTransactionContext(transaction);
397 doMultiKeyUpdate(transaction);
398 writeTransaction(coded_output, transaction);
402 initTransactionContext(transaction);
403 doCreateTable3(transaction);
404 doBlobInsert(transaction);
405 writeTransaction(coded_output, transaction);
TODO: Rename this file - func.h is stupid.