2 Backend (getCurrent,getList,get,setCurrent,update,listKeys)
5 ,Markup (Text, Paragraph, Font, Link, Heading, Url, Pre,List)
6 ,FontOp (Bold, Emph, Mono, Underline, Strike)
15 import Text.ParserCombinators.Parsec
18 --Keyword -> (Full text,date)
19 getCurrent :: a -> String -> IO (Maybe (String,String))
21 --Keyword -> [(id,date,author,comment)]
22 getList :: a -> String -> IO [(String, String, String, String)]
24 --Keyword -> id -> Full text
25 get :: a -> String -> String -> IO (Maybe String)
28 setCurrent :: a -> String -> String -> IO Bool
30 --Keyword -> Full text -> id
31 update :: a -> String -> String -> String -> String -> IO String
34 listKeys :: a -> IO [String]
36 data Markup = Text String
39 | Font FontOp [Markup]
40 | Heading Int [Markup]
43 | List Bool [[Markup]]
45 data FontOp = Bold | Emph | Mono | Underline | Strike
47 type Document = [Markup]
49 wikiParser :: Parser Document
50 wikiParser = many1 pMain
52 pPara :: Parser Markup
53 pPara = count 2 pEol >> return (Paragraph)
55 pLink :: Parser Markup
60 [] -> return (Link l l)
61 _ -> return (Link l d)
63 pList :: Bool -> Parser Markup
65 list <- many1 $ try $ pListItem enum
66 return (List enum list)
68 pListItem :: Bool -> Parser [Markup]
77 pHeading :: Parser Markup
80 level <- many1 $ char '='
82 return (Heading (length level) s)
88 s <- many1 (alphaNum <|> oneOf "?.:&-/~%=\\_")
89 return (Url (proto++"://"++s))
91 pMail :: Parser Markup
93 user <- many1 (alphaNum <|> oneOf ".-_")
95 server <- many1 (alphaNum <|> oneOf ".-_")
96 return (Url ("mailto:"++user++"@"++server))
100 pPre = string "<pre>" >> do
101 s <- pUntil (pOneLine <|> pEol) "</pre>"
104 pBold,pEmph,pUnderline,pStrike :: Parser Markup
105 pBold = pFont "**" Bold
106 pEmph = pFont "//" Emph
107 pUnderline = pFont "__" Underline
108 pStrike = pFont "--" Strike
109 pMono = pFont "||" Mono
111 pFont s o = string s >> do
115 pOtherChar :: Parser Markup
120 pText :: Parser Markup
125 pLinkContent :: Parser (String, String)
126 pLinkContent = do try (string "]]" >> return ([],[]))
133 (l,d) <- pLinkContent
136 pStopAt :: String -> Parser Document
137 pStopAt xs = pUntil pOneLine xs
139 pString :: String -> Parser String
140 pString xs = pUntil anyChar xs
142 pEol :: Parser Markup
144 (string "\n" <|> string "\r\n")
147 pUntil :: Parser a -> String -> Parser [a]
148 pUntil p xs = manyTill p (try $ string xs)
150 pMain :: Parser Markup
183 newtype PGB = PGB DBService
185 createPGB :: String -> String -> String -> String -> IO PGB
186 createPGB host database user password = let db = createDBService host database "" user password Nothing in return (PGB db)
188 instance Backend PGB where
190 getCurrent (PGB db) key = do
191 result <- selectReturnTuples db $ "SELECT fulltext,timestamp FROM curtexts WHERE keyword="++tov key
193 [text,date]:_ -> return (Just (text,date))
196 getList (PGB db) key = do
197 list <- selectReturnTuples db $ "SELECT id, timestamp, author, comment from fulltexts WHERE keyword = "++tov key
200 _ -> return $ map (\[id,date,author,comment] -> (id,date,author,comment)) list
202 get (PGB db) key id = do
203 list <- selectReturnTuples db $ "SELECT fulltext from fulltexts WHERE id = "++tov id
205 [s]:_ -> return (Just s)
208 setCurrent (PGB db) key id = do
209 full <- selectReturnTuples db $ "SELECT keyword FROM fulltexts WHERE keyword="++tov key++" AND id='"++id++"'"
210 cur <- selectReturnTuples db $ "SELECT keyword FROM curtexts WHERE keyword="++tov key
217 execute db $ "INSERT INTO current (keyword, id) VALUES ("++tov key++","++tov id++")"
219 execute db $ "UPDATE current SET id = "++tov id++" WHERE keyword = "++tov key
220 if rows == 1 then return True
223 update (PGB db) key text author comment = do
224 rows <- execute db $ "INSERT INTO fulltexts (keyword,fulltext, author, comment) VALUES ("++tov key++","++tov text++","++tov author++","++tov comment++")"
225 if rows == 0 then return ""
227 [[id]] <- selectReturnTuples db $ "SELECT currval('fulltexts_id_seq')"
228 setCurrent (PGB db) key id
231 listKeys (PGB db) = do
232 list <- selectReturnTuples db $ "SELECT keyword FROM current keyword ORDER BY lower(keyword)"
235 _ -> mapM (\[key] -> return key) list
237 tov :: String -> String
238 tov s = '\'':escapeQuery s++"'"
240 toHtml :: [Markup] -> String
242 toHtml ((Paragraph):xs) = "<p>\n"++toHtml xs
243 toHtml ((Text s):xs) = s++toHtml xs
244 toHtml ((Link l d):xs) = "<link: "++l++" desc: "++d++">"++toHtml xs
245 toHtml ((Font o d):xs) = "<"++fontOp o++">"++toHtml d++"</"++fontOp o++">"++toHtml xs
246 toHtml ((Heading n d):xs) = "\n<h"++show n++">"++toHtml d++"</h"++show n++">\n"++toHtml xs
247 toHtml ((Url l):xs) = "<link: "++l++">"++toHtml xs
248 toHtml ((Pre s):xs) = "<pre>"++toHtml s++"</pre>"++toHtml xs
249 toHtml ((List o l):xs) = "<"++listType o++">\n"++(unlines $ map (\s -> "<li>"++toHtml s++"</li>\n") l) ++ "</"++listType o++">"++toHtml xs
252 listType False = "ul"
257 fontOp Underline = "u"
258 fontOp Strike = "strike"
260 htmlOutput s = case parse wikiParser "" s of
261 Right n -> putStr (toHtml n)