ubuntu-bots team mailing list archive

[m4v <lambdae2@xxxxxxxxx>]

fixed foreign keys and now work with MySQL, Sqlite will have to go
without foreign keys, due to that bug in Storm.

** Changed in: ubuntu-bots
   Importance: Medium => Low

** Summary changed:

- [stormyfacts] The code doesn't enforce foreign keys anywhere
+ [stormyfacts] The code doesn't enforce foreign keys in Sqlite

-- 
You received this bug notification because you are a member of Ubuntu
IRC Bots, which is subscribed to Ubuntu IRC Bots.
https://bugs.launchpad.net/bugs/990919

Title:
  [stormyfacts] The code doesn't enforce foreign keys in Sqlite

Status in The official Ubuntu IRC bots:
  Triaged

Bug description:
  So until now I have been working thinking that SQLite and MySQL were
  enforcing foreign keys, but it turns out they weren't. "PRAGMA
  foreign_keys = ON" doesn't work with storm
  (https://bugs.launchpad.net/storm/+bug/676702) and apparently I was
  using MyISAM with my MySQL server.

  The result is that the code can't even create a table without
  upsetting the constraint rules, if you're using InnoDB with MySQL then
  you aren't going to go far with Stormyfacts.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu-bots/+bug/990919/+subscriptions