web2py/web2py — pull request #13 by davidk01 (2012-07-04 02:55:03+00:00)
Title: custom_qualifier for Field constructor

Yesterday I was trying to create an SQLite database with a field that had an 'ON CONFLICT IGNORE' but I couldn't figure out how to do it. Looking at the source code I found the places where `Field` was used and I believe I have made the right modifications to make adding 'ON CONFLICT IGNORE' possible through the use of the extra attribute `custom_qualifier`. So if the `Field` constructor is passed `custom_qualifier = 'SOME QUALIFIER'` then that string will be tacked onto `ftype` by `ftype += (' %s' % field.custom_qualifier)` so that the generated SQL for creating the table will have the added qualifier.