Possible to list and get old revisions

[yawbih.git] / Wiki.hs

diff --git a/Wiki.hs b/Wiki.hs
index 916829e11a872db3fd7b99d37fb5e68954bf844e..7d337c9f679b3b14ce01e1bf6716864a3390fb6d 100644 (file)
--- a/Wiki.hs
+++ b/Wiki.hs
@@ -1,21 +1,136 @@
 module Wiki (
+       Backend (getCurrent,getList,get,setCurrent,update)
+       ,PGB
+       ,createPGB
+       ,Markup (Text, Paragraph, Link)
+       ,Document
+       ,wikiParser
 
 ) where
 
-import Graphics.UI.WXCore.Db
+import Dbconnect
+import Data.Char
+import Text.ParserCombinators.Parsec
 
-{-Keyword -> Full text
-getCurrent :: String -> IO String
+class Backend a where
+       --Keyword -> (Full text,date)
+       getCurrent :: a -> String -> IO (Maybe (String,String))
 
---Keyword -> (id,date)
-getList :: String -> IO (Int, String)
+       --Keyword -> [(id,date,author,comment)]
+       getList :: a -> String -> IO [(String, String, String, String)]
 
---Keyword -> id -> Full Text
-get :: String -> Int -> IO String
+       --Keyword -> id -> Full text
+       get :: a -> String -> String -> IO (Maybe String)
 
---Keyword -> id -> ()
-setCurrent :: String -> Int -> IO ()
+       --Keyword -> id -> ()
+       setCurrent :: a -> String -> String -> IO Bool
+
+       --Keyword -> Full text -> id
+       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) 
+               <|> pSpace 
+               <|> try (pLinkLong)
+               <|> try (pLink)
+               <|> pOtherChar
+               <|> pText)
+       ss <- (wikiParser <|> return [])
+       return (s:ss)
+
+pPara = do
+       pEol
+       pEol
+       return (Paragraph)
+
+
+pSpace = do
+       space 
+       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)
+pOtherChar = do
+       c <- oneOf ",;.:!?[]()\'\"=-%$£<>/\\|"
+       return (Text (c:[]))
+
+pText = do
+       t <- many1 alphaNum--(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 = do
+               list <- selectReturnTuples db $ "SELECT fulltext from fulltexts WHERE id = "++tov id    
+               case list of
+                       [s]:_ -> return (Just s)
+                       _ -> return Nothing
+
+       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++"'"
+               
 
---Keyword -> Full text -> id
-addNew :: String -> String -> IO Int
--}