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

The second argument is the list of replacements for question marks. Passing in an empty list is the correct thing to do here. Can you clarify what you mean by not working? Is it a compile time error, a runtime exception, or everything goes along just fine but foreign keys are not really enabled? Michael On Wed, Apr 27, 2011 at 12:38 PM, Anton Cheshkov wrote:

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 ? Thanks. 2011/4/27 Michael Snoyman

...

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

-- Best regards, Cheshkov Anton Phone: +7 909 005 18 82 Skype: cheshkov_anton