The problem is this, I have for example the following tables and records: db.define_table ('a ', Field ('name', 'string')) db.define_table ('b', Field ('name', 'string '), Field ('a ', db.a)) Table record's a: id-> 1, name-> 'name1' no id-> 2 because such has been removed. id-> 3, name-> 'name3' Table record's b: id-> 1, name-> 'name1', a-> 3
When exported in csv and then import it ignores the record's id of the Table 'a', and are assigned according to the sequence again, first I make a drop_table to start the sequence, so that record with id-> 3 now the id-> 2,because IDs that are assigned consecutively, at this point the record in table 'b' which was linked to that record, their relationship no longer exists because there are none with id = 3. On 2 mayo, 17:16, pbreit <pbreitenb...@gmail.com> wrote: > db.export and db.import should work fine and preserve any relationships. I'm > not sure I understand what problem you are seeing.