hsSqlite3-0.0.1: src/hs_sqlite3_test.hs

import Data.Char
import Database.Sqlite3 (Val (IntV,TextV))
import qualified Database.Sqlite3 as S
import qualified Data.ByteString as B

main = do
 db <- S.open "test"
 S.bind db ins tab
 (st,row) <- S.fetchOne db "SELECT * FROM test_tab" 400
 putStr $ show row
 S.finalize st
 S.close db
 where
  ins = "INSERT INTO test_tab VALUES (?,?,?)"
  tab = replicate 500 row
  row = [TextV "test A",TextV "B test",TextV "test C test"]