Thanks Annet for suitably describing my issue. The issue is that, I
cannot have a default value in the column. I would prefer an error is
raised if the value is not provided... Nevertheless I will try to use
the default for now.
@Massimo, At first I did add the NOT NULL later. But then i tried
afresh with a new database, but that too did not work. I was wondering
whether a default is essential with a notnull, since the databases do
not really need the default.
Thanks
On May 28, 10:33 am, annet.verm...@gmail.com wrote:
> Massimo,
>
> Vihang is right. In my model I defined the following table:
>
> db.define_table('adres',
> SQLField('bedrijf', db.bedrijf, default='', notnull=True),
> SQLField('adressoort', length=30, default='Vestigingsadres',
> notnull=True),
> SQLField('straat', length=42, default='', notnull=True),
> SQLField('huisnummer', length=6, default='', notnull=True),
> SQLField('huisnummerextensie', length=6),
> SQLField('postcode_cijferdeel', type='integer'),
> SQLField('postcode_letterdeel'),
> SQLField('plaats', length=42, default='', notnull=True),
> migrate='adres.table')
>
> db.adres.bedrijf.requires=IS_IN_DB(db, db.bedrijf.id, '%(bedrijfsnaam)
> s')
> db.adres.adressoort.requires=IS_IN_SET(['Statutair
> vestigingsadres','Vestigingsadres','Postadres'])
> db.adres.straat.requires=[IS_LENGTH(42,error_message=T('length exceeds
> 42')), IS_NOT_EMPTY()]
> db.adres.huisnummer.requires=[IS_LENGTH(6,error_message=T('length
> exceeds 6')), IS_NOT_EMPTY()]
> db.adres.huisnummerextensie.requires=IS_LENGTH(6,error_message=T
> ('length exceeds 6'))
> db.adres.postcode_cijferdeel.requires=IS_NULL_OR(IS_MATCH('\d
> {4}',error_message=T('no match 4 digits')))
> db.adres.postcode_letterdeel.requires=IS_NULL_OR(IS_MATCH('[A-Z]
> {2}',error_message=T('no match 2 capitals')))
> db.adres.plaats.requires=IS_IN_DB(db, db.plaats.plaats, '%(plaats)s')
>
> In pgAdmin the SQL reads like:
>
> CREATE TABLE adres
> (
> id serial NOT NULL,
> bedrijf integer,
> adressoort character varying(30) NOT NULL,
> straat character varying(42) NOT NULL,
> huisnummer character varying(6) NOT NULL,
> huisnummerextensie character varying(6),
> postcode_cijferdeel integer,
> postcode_letterdeel character varying(32),
> plaats character varying(42) NOT NULL,
> CONSTRAINT adres_pkey PRIMARY KEY (id),
> CONSTRAINT adres_bedrijf_fkey FOREIGN KEY (bedrijf)
> REFERENCES bedrijf (id) MATCH SIMPLE
> ON UPDATE NO ACTION ON DELETE CASCADE
> )
> WITH (OIDS=FALSE);
>
> I didn't add the notnull=True later. In my applications this doesn't
> raise any problems, the IS_IN_DB() validator prevents the field from
> being empty. Furthermore, since the field is a foreign key I set
> writable=False, and it gets its value programatically.
>
> db.adres.bedrijf.writable=False
> db.adres.bedrijf.default=auth.user.bedrijf
>
> This is not a generic solution but it works for me. However, when you
> have other applications connecting to the database this is an issue,
> but why not set NOT NULL in pgAdmin using the columns properties
> option?
>
> Vihang,
>
> When you set a notnull=True, you should also set a default='' or
> whatever value. See this thread:
>
> http://groups.google.com/group/web2py/browse_thread/thread/930401c5e2...
>
> Kind regards,
>
> Annet.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
