ios 0.2.1

Light-weight CLI tool to extract iOS backup
Documentation 
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

use crate::squire;
use rusqlite::Connection;
use std::path::Path;

/// Function to get the columns of a table
///
/// # Arguments
///
/// * `manifest_db_path` - The path to the manifest database
/// * `limit` - The number of rows to limit the output to
///
/// # Returns
///
/// * `Ok` - If the function completes successfully
/// * `Err` - If the function encounters an error
#[allow(dead_code)]
pub fn get_columns(manifest_db_path: &Path) -> rusqlite::Result<(), Box<dyn std::error::Error>> {
    let conn = Connection::open(manifest_db_path)?;
    let mut col_smt = conn.prepare("PRAGMA table_info(Files)")?;
    let columns: Vec<String> = col_smt
        .query_map([], |row| {
            // The column name is in the second column (index 1)
            let col_name: String = row.get(1)?;
            Ok(col_name)
        })?
        .collect::<Result<Vec<String>, _>>()?;
    for col in columns {
        println!("{}", col);
    }
    Ok(())
}

/// Function to get the table data
///
/// # Arguments
///
/// * `manifest_db_path` - The path to the manifest database
/// * `limit` - The number of rows to limit the output to
///
/// # Returns
///
/// * `Ok` - If the function completes successfully
/// * `Err` - If the function encounters an error
#[allow(dead_code)]
pub fn get_table(
    manifest_db_path: &Path,
    limit: Option<usize>,
) -> rusqlite::Result<(), Box<dyn std::error::Error>> {
    let conn = Connection::open(manifest_db_path)?;
    let statement = match limit {
        Some(head) => format!(
            "SELECT * FROM Files {} LIMIT {}",
            squire::media_filter(),
            head
        ),
        None => format!("SELECT * FROM Files {}", squire::media_filter()),
    };
    let mut col_smt = conn.prepare(&statement)?;
    let columns: Vec<String> = col_smt
        .column_names()
        .iter()
        .map(|&s| s.to_string())
        .collect();
    let mut rows = col_smt.query([])?;
    println!("{:<20} {:<50}", "Column Name", "Value");
    while let Some(row) = rows.next()? {
        for (i, col_name) in columns.iter().enumerate() {
            let value: String = row.get::<_, String>(i).unwrap_or_default();
            println!("{:<20} {:<50}", col_name, value);
        }
        println!();
    }
    Ok(())
}