decode_rows/
decode_rows.rs1use mysql_replication::{
3 Error, EventData, Result,
4 events::{RowImage, RowValue, RowsDecoder},
5 file::BinlogFile,
6};
7use std::{collections::BTreeMap, fs::File, io::BufReader};
8
9const STMT_END_F: u16 = 1;
10
11fn print_image(label: &str, image: Option<RowImage<'_>>) -> Result<()> {
12 let Some(image) = image else { return Ok(()) };
13 for field in image.fields() {
14 let field = field?;
15 match field.value {
16 RowValue::Decimal(value) => println!("{label}[{}] = {value}", field.column_index),
17 RowValue::Integer(value) => println!(
19 "{label}[{}] = signed:{} unsigned:{}",
20 field.column_index,
21 value.signed(),
22 value.unsigned()
23 ),
24 value => println!("{label}[{}] = {value:?}", field.column_index),
25 }
26 }
27 Ok(())
28}
29
30fn main() -> Result<()> {
31 let args: Vec<_> = std::env::args().collect();
32 if args.len() != 2 {
33 eprintln!("usage: cargo run -p mysql-replication --example decode_rows -- BINLOG_FILE");
34 return Ok(());
35 }
36 let mut reader = BinlogFile::new(BufReader::new(File::open(&args[1])?))?;
37 let mut tables = BTreeMap::new();
38 while let Some(event) = reader.next_event()? {
39 match event.event {
40 EventData::FormatDescription(_) | EventData::Rotate(_) => tables.clear(),
41 EventData::TableMap(table) => {
42 tables.insert(table.table_id, RowsDecoder::new(&table)?);
44 }
45 EventData::Rows(rows) => {
46 if rows.table_id != 0x00ff_ffff || rows.flags & STMT_END_F == 0 {
48 let decoder = tables.get(&rows.table_id).ok_or_else(|| {
49 Error::Invalid(format!("missing TABLE_MAP for {}", rows.table_id))
50 })?;
51 for row in rows.rows(decoder)? {
52 let row = row?;
53 print_image("before", row.before)?;
54 print_image("after", row.after)?;
55 }
56 }
57 if rows.flags & STMT_END_F != 0 {
58 tables.clear();
59 }
60 }
61 _ => {}
62 }
63 }
64 Ok(())
65}