[DBIx-Class-Devel] [sql-translator] Add deferred FKs to SQLite (#70)

[Rob Kinyon]

> @@ -425,7 +425,7 @@ table_constraint : PRIMARY_KEY parens_field_list conflict_clause(?)
>          }
>      }
>      |
> -    FOREIGN_KEY parens_field_list REFERENCES ref_def cascade_def(?)
> +    FOREIGN_KEY parens_field_list REFERENCES ref_def cascade_def(?) deferrable(?) deferred(?)

I've updated the PR accordingly. All tests are passing.

On Wed, Sep 16, 2015 at 7:12 PM, Dagfinn Ilmari Mannsåker <
notifications at github.com> wrote:

> In lib/SQL/Translator/Parser/SQLite.pm
> <https://github.com/dbsrgits/sql-translator/pull/70#discussion_r39672522>:
>
> > @@ -425,7 +425,7 @@ table_constraint : PRIMARY_KEY parens_field_list conflict_clause(?)
> >          }
> >      }
> >      |
> > -    FOREIGN_KEY parens_field_list REFERENCES ref_def cascade_def(?)
> > +    FOREIGN_KEY parens_field_list REFERENCES ref_def cascade_def(?) deferrable(?) deferred(?)
>
> Unlike PostgreSQL, the INITIALLY (DEFERRED|IMMEDIATE) clause in SQLite is
> part of the (NOT)? DEFERRABLE clause. See
> https://sqlite.org/syntax/foreign-key-clause.html.
>
> —
> Reply to this email directly or view it on GitHub
> <https://github.com/dbsrgits/sql-translator/pull/70/files#r39672522>.
>



-- 
Thanks,
Rob Kinyon
http://greenfishbluefish.com/


---
Reply to this email directly or view it on GitHub:
https://github.com/dbsrgits/sql-translator/pull/70/files#r39744049
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class-devel/attachments/20150917/12718b74/attachment.htm>