Repository navigation
Expand file tree
/
Copy pathdump_json.rs
More file actions
116 lines (100 loc) · 3.97 KB
/
Copy pathdump_json.rs
File metadata and controls
116 lines (100 loc) · 3.97 KB
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
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
use std::io::prelude::*;
use std::io::SeekFrom;
use std::fs::File;
use std::convert::TryInto;
use sqlite_database_file_dissect::components::database_header::DatabaseHeader;
use sqlite_database_file_dissect::utils::convert::TryFromBytes;
use sqlite_database_file_dissect::components::page::Page;
fn travel_btree_page(f: &mut File,
page_size: usize,
page_index: usize,
buffer: &mut [u8],
page_parents: &mut Vec<i32>,
pages: &mut Vec<Page>,
btree_id: usize,
btree_level: usize) {
if page_parents[page_index] == -100{
page_parents[page_index] = -1;
}
let page_start_offset: u64 = (page_index * page_size).try_into().unwrap();
f.seek(SeekFrom::Start(page_start_offset)).unwrap();
let _r = f.read(buffer);
let page_start_offset;
if page_index == 0 {
let _ = DatabaseHeader::try_from_be_bytes(&buffer[0..100]).unwrap();
page_start_offset = 100;
} else {
page_start_offset = 0;
}
let page = Page::try_from_be_bytes(&buffer, Some(page_start_offset)).unwrap();
for cell_idx in 0..page.cells.len() {
let cell = &page.cells[cell_idx];
match cell.left_child_page_number {
Some(left_child_page_number) => {
page_parents[(left_child_page_number-1) as usize] = page_index as i32;
},
None => (),
};
}
match page.header.right_most_pointer {
Some(right_most_pointer) => page_parents[(right_most_pointer -1) as usize] = page_index as i32,
None => (),
}
for cell_idx in 0..page.cells.len() {
let cell = &page.cells[cell_idx];
match cell.left_child_page_number {
Some(left_child_page_number) => travel_btree_page(f,
page_size,
(left_child_page_number -1).try_into().unwrap(),
buffer,
page_parents,
pages,
btree_id,
btree_level +1),
None => (),
}
}
match page.header.right_most_pointer {
Some(right_most_pointer) => travel_btree_page(
f,
page_size,
(right_most_pointer -1) as usize,
buffer,
page_parents,
pages,
btree_id,
btree_level +1),
None => (),
}
pages.push(page);
}
fn main(){
let mut f = File::open("test-data/Chinook.db.4.analyze").unwrap();
const PAGE_SIZE: usize = 4096;
let mut buffer: [u8; PAGE_SIZE] = [0; PAGE_SIZE];
let f_length: usize = f.metadata().unwrap().len().try_into().unwrap();
let page_num: usize = f_length/PAGE_SIZE;
let mut page_parents: Vec<i32> = Vec::with_capacity(page_num);
let mut pages: Vec<Page> = Vec::with_capacity(page_num);
for _ in 0..page_num {
page_parents.push(-100);
}
for page_index in 0..page_parents.len() {
let is_traveled = page_parents[page_index];
if is_traveled != -100 {
continue;
}
// read the page
travel_btree_page(
&mut f,
PAGE_SIZE,
page_index,
&mut buffer,
&mut page_parents,
&mut pages,
page_index,
0);
}
let r = serde_json::to_string_pretty(&pages).unwrap();
println!("{}", r);
}