X-Git-Url: http://git.euphorik.ch/?a=blobdiff_plain;f=backend%2Fsrc%2Fdb.rs;h=6458c7eb7308d384a695f7af38893d0c0e2fb821;hb=HEAD;hp=f3356d206eb8330027e7d8ab6271f370a3e7b52c;hpb=87bc628b563f61185c4f9ec48627029b17d32bba;p=recipes.git diff --git a/backend/src/db.rs b/backend/src/db.rs deleted file mode 100644 index f3356d2..0000000 --- a/backend/src/db.rs +++ /dev/null @@ -1,39 +0,0 @@ -use std::path::Path; -use std::fs; - -//use rusqlite::types::ToSql; -//use rusqlite::{Connection, Result, NO_PARAMS}; - -const CURRENT_DB_VERSION: u32 = 1; - -struct Connection { - pub sqlite_con : rusqlite::Connection -} - -impl Connection { - fn new() -> Connection { - - // TODO: use a constant in consts module. - let data_dir = Path::new("data"); - - if !data_dir.exists() { - fs::DirBuilder::new().create(data_dir).unwrap(); - } - - Connection { sqlite_con : rusqlite::Connection::open(data_dir.join("recipes.sqlite")).unwrap() } - } -} - -pub fn create_or_update() { - let connection = Connection::new(); - - // let mut stmt = connection.sqlite_con.prepare("SELECT * FROM versions ORDER BY date").unwrap(); - - //let mut stmt = connection.sqlite_con..prepare("SELECT name FROM sqlite_master WHERE type='table' AND name='versions'").unwrap(); - connection.sqlite_con.query_row( - "SELECT name FROM sqlite_master WHERE type='table' AND name='versions'", - rusqlite::NO_PARAMS, - |row| Ok(dbg!("test")) - ) - .unwrap(); -} \ No newline at end of file