Hello, I've got a table like this:
db._common_fields.append(auth.signature) db.define_table('locations', Field('title', 'string'), Field('capacity', 'integer'), Field('celcat_code', 'string'), Field('is_external', 'boolean', default=False), format = lambda row: f"{row.title}") I'm trying to populate that with legacy data using: filepath = os.path.join(request.folder, 'static', 'data', 'teaching_staff.csv') with open(filepath, encoding="utf8") as csvfile: db.teaching_staff.import_from_csv_file(csvfile) And I get a ticket: IntegrityError(FOREIGN KEY constraint failed) I think what is going on is that - because no-one is logged in when that import is run - the `auth.signature` fields are None and so that is the constraint that is failing. Is there a canonical way to handle this? I had a quick look at the code and couldn't see an option for inserting default values. I can write a loop and add default values myself to individual record inserts but is there a standard way? Many thanks, David -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/5ff89449-5883-4310-af1b-d419949acb84o%40googlegroups.com.