projects / dbsrgits/DBIx-Class-Schema-Loader.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: f839d33)
introspect ON DELETE/UPDATE for SQL Anywhere
authorRafael Kitover <rkitover@cpan.org>
Tue, 16 Oct 2012 18:45:13 +0000 (14:45 -0400)
committerRafael Kitover <rkitover@cpan.org>
Tue, 16 Oct 2012 18:45:13 +0000 (14:45 -0400)
commit4b5eca90f633645050d77e5d0c98d05a6cc37502
tree4bb0f9ba30744e7d58f6589c97523c97cd487799tree | snapshot
parentf839d33b5268c9396dc7cbc6432143d2f4eb5ea1commit | diff
introspect ON DELETE/UPDATE for SQL Anywhere

The default seems to be RESTRICT, but it's hard to tell, because the
actions are implemented as triggers and you have to query the catalog
triggers view to get at them. At least if you specify RESTRICT there is
no trigger generated.

SQL Anywhere does not support DEFERRABLE constraints. It has something
called CHECK ON COMMIT but that does not seem to have the same full
functionality, so for now we leave is_deferrable at 1.
Changes diff | blob | blame | history
lib/DBIx/Class/Schema/Loader/DBI/SQLAnywhere.pm diff | blob | blame | history
t/10_08sqlanywhere_common.t diff | blob | blame | history
Generate DBIx::Class Schemas from a Database