[Haskell-cafe] ORM for haskell?
Jochem Berndsen
jochem at functor.nl
Fri Jul 3 05:28:14 EDT 2009
Chris Eidhof wrote:
> I've something working that sort of does this. You define your model in
> the following way:
>
> data User = User {name :: String, password :: String, age :: Int, post
> :: BelongsTo Post}
> data Post = Post {title :: String, body :: String}
>
> Then there's some boilerplate code (that ultimately will be generated by
> TH), and from that moment on you can do things like this:
>
> test = do
> conn <- connectSqlite3 "example.sqlite3"
> runDB conn $ do
> user <- fromJust <$> find typeUser 1
> user' <- fillBelongsTo user relPost
> return (post user')
> By default, no relations will be fetched, but by doing the fillBelongsTo
> the user will be updated. I currently have support for new, update and
> find. All of this code is very alpha, and only works using HDBC and
> Sqlite3, but still.
So in this example, both user and user' are of type User, but if I ask
for "post user", this is undefined?
I have done something similar as you, except that I filled the related
field with an unsafePerformIO fetching the related data from the database.
Regards,
--
Jochem Berndsen | jochem at functor.nl
GPG: 0xE6FABFAB
More information about the Haskell-Cafe
mailing list