web2py

Merge lp:~lysunkin/web2py/ora-db-impr into lp:~mdipierro/web2py/devel

  1. ora-db-impr
  2. Merge into devel
Proposed by Slava_L
Status: Needs review
Proposed branch: lp:~lysunkin/web2py/ora-db-impr
Merge into: lp:~mdipierro/web2py/devel
Diff against target: None lines
To merge this branch: bzr merge lp:~lysunkin/web2py/ora-db-impr
Reviewer Review Type Date Requested Status
Massimo Pending
Review via email: mp+5423@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Slava_L (lysunkin) wrote :

I made a little change in file gluon\sql.py:
Oracle constraint name should be as short as possible (to avoid 31 symbol limitation)

Reply

Unmerged revisions

644. By Slava_L

A quick fix was made to avoid error with too long constraint name in Oracle DB

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'gluon/sql.py'
2--- gluon/sql.py 2009-04-08 04:09:12 +0000
3+++ gluon/sql.py 2009-04-08 19:00:27 +0000
4@@ -173,7 +173,7 @@
5 'time': 'CHAR(8)',
6 'datetime': 'DATE',
7 'id': 'NUMBER PRIMARY KEY',
8- 'reference': 'NUMBER, CONSTRAINT %(table_name)s_%(field_name)s__constraint FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)s',
9+ 'reference': 'NUMBER, CONSTRAINT %(table_name)s_%(field_name)s_ct FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)s',
10 'lower': 'LOWER(%(field)s)',
11 'upper': 'UPPER(%(field)s)',
12 'is null': 'IS NULL',