pretty-sqlite 0.5.0

Simple, Minimalistic Pretty Prints for SQLite using rusqlite (for test & dev)
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

pub type Result<T> = core::result::Result<T, Error>;
pub type Error = Box<dyn std::error::Error>; // For early dev.

use rusqlite::{Connection, params};

pub fn create_test_schema(conn: &Connection) -> Result<()> {
	conn.execute(
		"CREATE TABLE IF NOT EXISTS person (
            id      INTEGER PRIMARY KEY AUTOINCREMENT,
            name    TEXT,
            yob     INTEGER, -- year of birth
            data_t  TEXT,
            data_b  BLOB
        ) STRICT",
		(), // empty list of parameters.
	)?;
	Ok(())
}

pub fn seed_test_data(con: &Connection) -> Result<()> {
	let mut stmt = con.prepare("INSERT INTO person (name, yob, data_t, data_b) VALUES (?, ?, ?, ?)")?;

	for i in 1..=1000 {
		// start at 1 to match sqlite id
		let name = format!("Person {i}",);
		let yob = 1950 + (i % 50);
		let data_t = format!("Data {i}",);
		let data_b = vec![0u8; 10]; // Example binary data

		stmt.execute(params![name, yob, data_t, data_b])?;
	}

	Ok(())
}

// region:    --- XVec

pub trait XVec<T> {
	fn x_get(&self, idx: isize) -> Option<&T>;
}

impl<T> XVec<T> for Vec<T> {
	fn x_get(&self, idx: isize) -> Option<&T> {
		if idx >= 0 {
			self.get(idx as usize)
		} else {
			let adjusted_index = self.len() as isize + idx;
			if adjusted_index >= 0 {
				self.get(adjusted_index as usize)
			} else {
				None
			}
		}
	}
}

// endregion: --- XVec