use core::ptr::{null, null_mut, NonNull};

use std::collections::HashMap;
use std::convert::TryInto;
use std::ffi::CString;

use futures_core::future::BoxFuture;
use futures_util::future;
use libsqlite3_sys::{
    sqlite3, sqlite3_close, sqlite3_extended_result_codes, sqlite3_open_v2, SQLITE_OK,
    SQLITE_OPEN_CREATE, SQLITE_OPEN_NOMUTEX, SQLITE_OPEN_READWRITE, SQLITE_OPEN_SHAREDCACHE,
};

use crate::connection::{Connect, Connection};
use crate::executor::Executor;
use crate::sqlite::statement::Statement;
use crate::sqlite::worker::Worker;

use crate::sqlite::SqliteError;
use crate::url::Url;

/// Thin wrapper around [sqlite3] to impl `Send`.

#[derive(Clone, Copy,Debug)]
pub(super) struct SqliteConnectionHandle(pub(super) NonNull<sqlite3>);

/// A connection to a [Sqlite](struct.Sqlite.html) database.

#[derive(Debug)]
pub struct SqliteConnection {
    pub(super) handle: SqliteConnectionHandle,
    pub(super) worker: Worker,
    // Storage of the most recently prepared, non-persistent statement

    pub(super) statement: Option<Statement>,
    // Storage of persistent statements

    pub(super) statements: Vec<Statement>,
    pub(super) statement_by_query: HashMap<String, usize>,
}

// A SQLite3 handle is safe to send between threads, provided not more than

// one is accessing it at the same time. This is upheld as long as [SQLITE_CONFIG_MULTITHREAD] is

// enabled and [SQLITE_THREADSAFE] was enabled when sqlite was compiled. We refuse to work

// if these conditions are not upheld.


// <https://www.sqlite.org/c3ref/threadsafe.html>


// <https://www.sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfigmultithread>


unsafe impl Send for SqliteConnectionHandle {}

async fn establish(url: Result<Url, url::ParseError>) -> crate::Result<SqliteConnection> {
    let mut worker = Worker::new();

    let url = url?;
    let url = url
        .as_str()
        .trim_start_matches("sqlite:")
        .trim_start_matches("//");

    // By default, we connect to an in-memory database.

    // TODO: Handle the error when there are internal NULs in the database URL

    let filename = CString::new(url).unwrap();

    let handle = worker
        .run(move || -> crate::Result<SqliteConnectionHandle> {
            let mut handle = null_mut();

            // [SQLITE_OPEN_NOMUTEX] will instruct [sqlite3_open_v2] to return an error if it

            // cannot satisfy our wish for a thread-safe, lock-free connection object

            let flags = SQLITE_OPEN_READWRITE
                | SQLITE_OPEN_CREATE
                | SQLITE_OPEN_NOMUTEX
                | SQLITE_OPEN_SHAREDCACHE;

            // <https://www.sqlite.org/c3ref/open.html>

            let status = unsafe { sqlite3_open_v2(filename.as_ptr(), &mut handle, flags, null()) };

            if handle.is_null() {
                // Failed to allocate memory

                panic!("SQLite is unable to allocate memory to hold the sqlite3 object");
            }

            if status != SQLITE_OK {
                // Close the handle if there was an error here

                // https://sqlite.org/c3ref/close.html

                unsafe {
                    let _ = sqlite3_close(handle);
                }

                return Err(SqliteError::from_connection(handle).into());
            }

            // Enable extended result codes

            // https://www.sqlite.org/c3ref/extended_result_codes.html

            unsafe {
                sqlite3_extended_result_codes(handle, 1);
            }

            Ok(SqliteConnectionHandle(NonNull::new(handle).unwrap()))
        })
        .await?;

    Ok(SqliteConnection {
        worker,
        handle,
        statement: None,
        statements: Vec::with_capacity(10),
        statement_by_query: HashMap::with_capacity(10),
    })
}

impl SqliteConnection {
    #[inline]
    pub(super) fn handle(&mut self) -> *mut sqlite3 {
        self.handle.0.as_ptr()
    }
}

impl Connect for SqliteConnection {
    fn connect<T>(url: T) -> BoxFuture<'static, crate::Result<SqliteConnection>>
    where
        T: TryInto<Url, Error = url::ParseError>,
        Self: Sized,
    {
        let url = url.try_into();

        Box::pin(async move {
            let mut conn = establish(url).await?;

            // https://www.sqlite.org/wal.html


            // language=SQLite

            conn.execute(
                r#"
PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;
                "#,
            )
            .await?;

            Ok(conn)
        })
    }
}

impl Connection for SqliteConnection {
    fn close(self) -> BoxFuture<'static, crate::Result<()>> {
        // All necessary behavior is handled on drop

        Box::pin(future::ok(()))
    }

    fn ping(&mut self) -> BoxFuture<crate::Result<()>> {
        // For SQLite connections, PING does effectively nothing

        Box::pin(future::ok(()))
    }
}

impl Drop for SqliteConnection {
    fn drop(&mut self) {
        // Drop all statements first

        self.statements.clear();

        // Next close the statement

        // https://sqlite.org/c3ref/close.html

        unsafe {
            let _ = sqlite3_close(self.handle());
        }
    }
}