Have just started using "populate" which is a really useful tool.
However I have a couple of questions:
1) It seems to ignore the length specified for string fields. For
example it fills my postcode field with 100 characters of text despite
it having length of 8. Is there a way of restricting the text to 8
characters?
2) Sometimes it fails with a sqlite error saying "column name is not
unique". Does it not recognise unique constraints?
My tabledef is:
db.define_table('customer',
Field('title', requires=IS_IN_SET(["Mr", "Mrs", "Ms"],
zero=None)),
Field('name', length=256, requires=[IS_NOT_EMPTY(),
IS_NOT_IN_DB(db,
'customer.name')], unique=True),
Field('address1', length=256),
Field('address2', length=256),
Field('postcode', length=8, requires=IS_LENGTH(8))
