Villefort.Database

Documentation

type Query = String

type Path = String

type Subject = String

getSubjects :: (MonadReader VConfig m, MonadIO m) => m [Subject]

path' :: (MonadReader VConfig m, MonadIO m) => m FilePath

getDb :: (MonadReader VConfig m, MonadIO m) => m Connection

convRow :: [[SqlValue]] -> [[String]]

makeQuery :: (MonadReader VConfig m, MonadIO m) => String -> m [[String]]

execQuery :: (Convertible a SqlValue, MonadIO m, MonadReader VConfig m) => String -> [a] -> m ()

getNextId :: (MonadReader VConfig m, MonadIO m) => m Integer

delTask :: (MonadReader VConfig m, MonadIO m) => Int -> m ()

updateTask :: (MonadReader VConfig m, MonadIO m) => Int -> Int -> m ()

addTask :: (MonadReader VConfig m, MonadIO m) => String -> String -> String -> String -> m ()

addDaily :: (MonadReader VConfig m, MonadIO m) => [String] -> m ()

getDone :: (MonadReader VConfig m, MonadIO m) => m [[String]]

getDoneDay :: (MonadReader VConfig m, MonadIO m) => String -> m [[String]]

getAvg :: (MonadReader VConfig m, MonadIO m) => m [[String]]

Query to get average of subjects getAvg :: IO (Maybe [String])

getSum :: (MonadReader VConfig m, MonadIO m) => m [[String]]

Query to get sum of subjects getSum :: IO (Maybe [String])

getSubWeek :: (MonadReader VConfig m, MonadIO m) => String -> String -> m [[String]]