Re: [web-devel] Yesod, Sqlite, Enabling Foreign Key Support

Looks like the docs just got generated, at least for persistent. You'll likely want the execute function from Data.Persist.GenericSql.Raw: http://hackage.haskell.org/packages/archive/persistent/0.5.0/doc/html/Databa... . Michael On Wed, Apr 27, 2011 at 9:12 AM, Anton Cheshkov wrote:

I think helper function is good variant. I wanted to make it on yesod level but i do not see hackage documentation for newly packages. When documentation will  refreshed  i can try to make 'foreign enabling' on framework level ;) Thanks.

2011/4/27 Michael Snoyman

...

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 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