about summary refs log blame commit diff stats
path: root/src/app.rs
blob: 14b85a3ac33a0254b5ed699403b3f4dc7edb1fa3 (plain) (tree)





































                                                                          
// 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 anyhow::{Context, Result};
use sqlx::{query, sqlite::SqliteConnectOptions, SqlitePool};

use crate::constants;

pub struct App {
    pub database: SqlitePool,
}

impl App {
    pub async fn new() -> Result<Self> {
        let db_name = constants::database()?;

        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 })
    }
}