Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

import_from_csv_file fails if export_to_csv_file with ref id column with gaps #711

Open
mkostrikin opened this issue Jun 26, 2023 · 0 comments

Comments

@mkostrikin
Copy link

Let say we have two tables, where one refs on other

db.define_table('first', Field('name'))
db.define_table('second',Field('first','reference first')

If first table populated with data, and sometimes DB rejects inserts bc of some constrains, but id will count up and on next insert gap appears.
export_to_csv_file will generate files with id, but import_from_csv_file ignores id column creating them automatically.

If necessary, I will create a test_app to reproduce the issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant