about summary refs log blame commit diff stats
path: root/src/app.rs
blob: f9562519e4871045418ace0bebb5dc0d9026dd33 (plain) (tree)
1
2
3
4
5
6
7
8
9
10








                                                                          
                       

                                                            



                             
                                                        














                                                                
// yt - A fully featured command line YouTube client
//
// Copyright (C) 2024 Benedikt Peetz <benedikt.peetz@b-peetz.de>
// SPDX-License-Identifier: GPL-3.0-or-later
//
// This file is part of Yt.
//
// You should have received a copy of the License along with this program.
// If not, see <https://www.gnu.org/licenses/gpl-3.0.txt>.

use std::path::PathBuf;

use anyhow::{Context, Result};
use sqlx::{query, sqlite::SqliteConnectOptions, SqlitePool};

pub struct App {
    pub database: SqlitePool,
}

impl App {
    pub async fn new(db_name: PathBuf) -> Result<Self> {
        let options = SqliteConnectOptions::new()
            .filename(db_name)
            .optimize_on_close(true, None)
            .create_if_missing(true);

        let pool = SqlitePool::connect_with(options)
            .await
            .context("Failed to connect to database!")?;

        query(include_str!("storage/video_database/schema.sql"))
            .execute(&pool)
            .await?;

        Ok(App { database: pool })
    }
}