[web-devel] Yesod, Sqlite, Enabling Foreign Key Support
acheshkov at gmail.com
Wed Apr 27 11:38:19 CEST 2011
I trying this
*helperSqliteForeignON :: MonadIO m => SqlPersist m ()*
*helperSqliteForeignON = execute "PRAGMA foreign_keys = ON" *
*-- How to run database actions.*
*instance YesodPersist Pomoguy where*
* type YesodDB Pomoguy = SqlPersist*
* runDB db = liftIOHandler*
* $ fmap connPool getYesod >>= Settings.runConnectionPool
(helperSqliteForeignON >> db)*
But it does not work. I do not understand why
What is the second argument for *'execute'* function ?
2011/4/27 Michael Snoyman <michael at snoyman.com>
> Looks like the docs just got generated, at least for persistent.
> You'll likely want the execute function from
> On Wed, Apr 27, 2011 at 9:12 AM, Anton Cheshkov <acheshkov at gmail.com>
> > I think helper function is good variant. I wanted to make it on yesod
> > but i do not see hackage documentation for newly packages.
> > When documentation will refreshed i can try to make 'foreign enabling'
> > framework level ;)
> > Thanks.
> > 2011/4/27 Michael Snoyman <michael at snoyman.com>
> >> I'm not sure we want to enable this by default. What about just
> >> providing a helper function that enables the pragma? There's already
> >> enough available from the public API to execute arbitrary SQL
> >> statements. I don't use SQLite for production deployments personally,
> >> so if others have an opinion on this, I'd like to hear it.
> >> Michael
> >> On Tue, Apr 26, 2011 at 1:31 PM, Anton Cheshkov <acheshkov at gmail.com>
> >> wrote:
> >> > Hi Michael.
> >> > Please show the way to enable foreign key support from sqlite
> >> > connection.
> >> > Now foreign key constrints does not work for sqlite from Yesod.
> >> > Thanks.
> >> >
> >> > http://www.sqlite.org/foreignkeys.html
> >> > --
> >> > Best regards,
> >> > Cheshkov Anton
> >> > Phone: +7 909 005 18 82
> >> > Skype: cheshkov_anton
> >> >
> > --
> > Best regards,
> > Cheshkov Anton
> > Phone: +7 909 005 18 82
> > Skype: cheshkov_anton
Phone: +7 909 005 18 82
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the web-devel