Skip to main content

decode_rows/
decode_rows.rs

1//! Inspect raw row images without CDC filtering or transaction delivery.
2use 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            // IntegerValue deliberately requires the caller to choose SQL signedness.
18            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                // Replace the plan on every remap; never reuse a table ID across files.
43                tables.insert(table.table_id, RowsDecoder::new(&table)?);
44            }
45            EventData::Rows(rows) => {
46                // MySQL may send a statement-end marker without row data.
47                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}