2 Backend (getCurrent,getList,get,setCurrent,update,listKeys)
5 ,Markup (Text, Paragraph, Link, Bold, Emph, Heading, Url, Underline, Strike, Pre)
14 import Text.ParserCombinators.Parsec
17 --Keyword -> (Full text,date)
18 getCurrent :: a -> String -> IO (Maybe (String,String))
20 --Keyword -> [(id,date,author,comment)]
21 getList :: a -> String -> IO [(String, String, String, String)]
23 --Keyword -> id -> Full text
24 get :: a -> String -> String -> IO (Maybe String)
27 setCurrent :: a -> String -> String -> IO Bool
29 --Keyword -> Full text -> id
30 update :: a -> String -> String -> String -> String -> IO String
33 listKeys :: a -> IO [String]
35 data Markup = Text String
40 | Heading Int [Markup]
46 type Document = [Markup]
48 wikiParser :: GenParser Char st Document
51 ss <- (wikiParser <|> return [])
64 pEol = char '\n' <|> do
68 pLinkParser = do try (string "]]" >> return ([],[]))
82 [] -> return (Link l l)
83 _ -> return (Link l d)
85 pBold = pS "**" (\s -> Bold s)
86 pEmph = pS "//" (\s -> Emph s)
87 pUnderline = pS "__" (\s -> Underline s)
88 pStrike = pS "--" (\s -> Strike s)
96 try (string xs >> return []) <|> (do
102 try (string xs >> return []) <|> (do
109 level <- many1 $ char '='
111 s <- pStopAt (' ':level)
112 return (Heading (length level) s)
115 proto <- many1 letter
117 s <- many1 (alphaNum <|> oneOf "?.:&-/")
118 return (Url (proto++"://"++s))
122 s <- pString "</pre>"
125 pMain = try (pHeading)
139 c <- oneOf "*,;.:!?[]()'\"=-%$£<>/\\|"
143 t <- many1 alphaNum--(noneOf ['\n','\r','[',']'])
147 newtype PGB = PGB DBService
149 createPGB :: String -> String -> String -> String -> IO PGB
150 createPGB host database user password = let db = createDBService host database "" user password Nothing in return (PGB db)
153 testDB = createPGB "wave" "wiki" "wiki" "12wiki34db"
155 instance Backend PGB where
157 getCurrent (PGB db) key = do
158 result <- selectReturnTuples db $ "SELECT fulltext,timestamp FROM curtexts WHERE keyword="++tov key
160 [text,date]:_ -> return (Just (text,date))
163 getList (PGB db) key = do
164 list <- selectReturnTuples db $ "SELECT id, timestamp, author, comment from fulltexts WHERE keyword = "++tov key
167 _ -> return $ map (\[id,date,author,comment] -> (id,date,author,comment)) list
169 get (PGB db) key id = do
170 list <- selectReturnTuples db $ "SELECT fulltext from fulltexts WHERE id = "++tov id
172 [s]:_ -> return (Just s)
175 setCurrent (PGB db) key id = do
176 full <- selectReturnTuples db $ "SELECT keyword FROM fulltexts WHERE keyword="++tov key++" AND id='"++id++"'"
177 cur <- selectReturnTuples db $ "SELECT keyword FROM curtexts WHERE keyword="++tov key
184 execute db $ "INSERT INTO current (keyword, id) VALUES ("++tov key++","++tov id++")"
186 execute db $ "UPDATE current SET id = "++tov id++" WHERE keyword = "++tov key
187 if rows == 1 then return True
190 update (PGB db) key text author comment = do
191 rows <- execute db $ "INSERT INTO fulltexts (keyword,fulltext, author, comment) VALUES ("++tov key++","++tov text++","++tov author++","++tov comment++")"
192 if rows == 0 then return ""
194 [[id]] <- selectReturnTuples db $ "SELECT currval('fulltexts_id_seq')"
195 setCurrent (PGB db) key id
198 listKeys (PGB db) = do
199 list <- selectReturnTuples db $ "SELECT keyword FROM fulltexts ORDER BY lower(keyword)"
202 _ -> mapM (\[key] -> return key) list
206 tov :: String -> String
207 tov s = '\'':escapeQuery s++"'"
209 toHtml :: [Markup] -> String
211 toHtml ((Paragraph):xs) = "<p>\n"++toHtml xs
212 toHtml ((Text s):xs) = s++toHtml xs
213 toHtml ((Link l d):xs) = "<link: "++l++" desc: "++d++">"++toHtml xs
214 toHtml ((Bold d):xs) = "<b>"++toHtml d++"</b>"++toHtml xs
215 toHtml ((Emph d):xs) = "<em>"++toHtml d++"</em>"++toHtml xs
216 toHtml ((Underline d):xs) = "<u>"++toHtml d++"</u>"++toHtml xs
217 toHtml ((Strike d):xs) = "<strike>"++toHtml d++"</strike>"++toHtml xs
218 toHtml ((Heading n d):xs) = "\n<h"++show n++">"++toHtml d++"</h"++show n++">\n"++toHtml xs
219 toHtml ((Url l):xs) = "<link: "++l++">"++toHtml xs
220 toHtml ((Pre s):xs) = "<pre>"++s++"</pre>"++toHtml xs
223 htmlOutput s = case parse wikiParser "" s of