//SQLite example
//crate sqlite = "0.27.0"
// Connect to the database
let connection = sqlite::open(
"data.sqlite").unwrap();
let sql = r"
SELECT
Language, Percentage
FROM countrylanguage
WHERE CountryCode = 'RUS'
ORDER BY Percentage DESC";
// SQL query execution
let mut cursor = connection
.prepare(sql)
.unwrap()
.into_cursor();
while let Some(Ok(row)) = cursor.next() {
println!("{}: {}",
row.get::<String, _>(0),
row.get::<f64, _>(1));
}