use rusqlite::{Connection, Result};
use crate::structs::*;
pub fn get_race_value(db_path:&str, name:&str) -> Result<Six, rusqlite::Error> {
let conn = Connection::open(db_path)?;
let race_value = conn.query_row(
"SELECT name, hp, atk, m_atk, dfe, m_dfe, spd FROM sprite WHERE name=?1", [name], |row| {
Ok(Six{
hp: row.get(1)?,
atk: row.get(2)?,
m_atk: row.get(3)?,
dfe: row.get(4)?,
m_dfe: row.get(5)?,
spd: row.get(6)?,
})
},
)?;
Ok(race_value)
}