// 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();
if let Some(Ok(row)) = cursor.next() {
println!("lang is {}",
row.get::<String, _>(0));
println!("percent is {}",
row.get::<f64, _>(1));
}