module Wiki (
+ Backend (getCurrent,getList,get,setCurrent,update)
+ ,PGB
+ ,createPGB
+ ,Markup (Text, Paragraph, Link)
+ ,Document
+ ,wikiParser
) where
-class WikiBackend a where
- --Keyword -> Full text
- getCurrent :: a -> String -> IO String
+import Dbconnect
+import Data.Char
+import Text.ParserCombinators.Parsec
- --Keyword -> [(id,date)]
- getList :: a -> String -> IO [(Int, String)]
+class Backend a where
+ --Keyword -> (Full text,date)
+ getCurrent :: a -> String -> IO (Maybe (String,String))
+
+ --Keyword -> [(id,date,author,comment)]
+ getList :: a -> String -> IO [(String, String, String, String)]
--Keyword -> id -> Full text
- get :: a -> String -> Int -> IO String
+ get :: a -> String -> String -> IO String
--Keyword -> id -> ()
- setCurrent :: a -> String -> Int -> IO ()
+ setCurrent :: a -> String -> String -> IO Bool
--Keyword -> Full text -> id
- addNew :: String -> String -> IO Int
+ update :: a -> String -> String -> String -> String -> IO String
+
+data Markup = Text String
+ | Paragraph
+ | Link String String
+
+type Document = [Markup]
+
+wikiParser :: GenParser Char st Document
+wikiParser = do
+ s <- (try (pPara)
+ <|> pOneEol
+ <|> try (pLinkLong)
+ <|> pLink
+ <|> pText)
+ ss <- (wikiParser <|> return [])
+ return (s:ss)
+
+pPara = do
+ pEol
+ pEol
+ return (Paragraph)
+
+pOneEol = do
+ pEol
+ return (Text " ")
+
+pEol = char '\n' <|> do
+ char '\r'
+ char '\n'
+
+pLinkLong = do
+ string "[["
+ l <- many1 $ noneOf ['|','[',']']
+ char '|'
+ d <- many1 $ noneOf ['|','[',']']
+ string "]]"
+ return (Link l d)
+pLink = do
+ string "[["
+ l <- many1 $ noneOf ['|','[',']']
+ string "]]"
+ return (Link l l)
+
+pText = do
+ t <- many1 (noneOf ['\n','\r','[',']'])
+ return (Text t)
+
+newtype PGB = PGB DBService
+
+createPGB :: String -> String -> String -> String -> IO PGB
+createPGB host database user password = let db = createDBService host database "" user password Nothing in return (PGB db)
+
+
+testDB = createPGB "wave" "wiki" "wiki" "12wiki34db"
+
+instance Backend PGB where
+
+ getCurrent (PGB db) key = do
+ result <- selectReturnTuples db $ "SELECT fulltext,timestamp FROM curtexts WHERE keyword="++tov key
+ case result of
+ [text,date]:_ -> return (Just (text,date))
+ _ -> return Nothing
+
+ getList (PGB db) key = do
+ list <- selectReturnTuples db $ "SELECT id, timestamp, author, comment from fulltexts WHERE keyword = "++tov key
+ return $ map (\[id,date,author,comment] -> (id,date,author,comment)) list
+
+ get (PGB db) key id = return ""
+
+ setCurrent (PGB db) key id = do
+ full <- selectReturnTuples db $ "SELECT keyword FROM fulltexts WHERE keyword="++tov key++" AND id='"++id++"'"
+ cur <- selectReturnTuples db $ "SELECT keyword FROM curtexts WHERE keyword="++tov key
+ case full of
+ [[]] -> do
+ return False
+ _ -> do
+ rows <- case cur of
+ [[]] -> do
+ execute db $ "INSERT INTO current (keyword, id) VALUES ("++tov key++","++tov id++")"
+ _ -> do
+ execute db $ "UPDATE current SET id = "++tov id++" WHERE keyword = "++tov key
+ if rows == 1 then return True
+ else return False
+
+ update (PGB db) key text author comment = do
+ rows <- execute db $ "INSERT INTO fulltexts (keyword,fulltext, author, comment) VALUES ("++tov key++","++tov text++","++tov author++","++tov comment++")"
+ if rows == 0 then return ""
+ else do
+ [[id]] <- selectReturnTuples db $ "SELECT currval('fulltexts_id_seq')"
+ setCurrent (PGB db) key id
+ return id
+
+
+tov :: String -> String
+tov s = '\'':escapeQuery s++"'"
+