You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The current behaviour supports skipping primary keys, which are always of serial data type. These are auto-generated by the database. Going forward, serial data type is optional and a user can chose whatever type and name they prefer for the primary key.
Describe the solution you'd like
We should make csv upload behaviour such that:
Throw error 'Primary key required for column' if data is missing and the column is not of serial data type
For serial data type column, regardless of whether data exists or not within the csv the value should always be autogenerated on the insert
akshaysasidrn
changed the title
TJDB: When user bulk uploads CSV, server should verify all primary keys are made mandatory except serial data type
TJDB: When user bulk uploads CSV, server should verify data for all primary keys are made mandatory except serial data type
Mar 12, 2024
Is your proposal related to a problem?
The current behaviour supports skipping primary keys, which are always of serial data type. These are auto-generated by the database. Going forward, serial data type is optional and a user can chose whatever type and name they prefer for the primary key.
Describe the solution you'd like
We should make csv upload behaviour such that:
This is currently handled here: https://github.com/ToolJet/ToolJet/blob/develop/server/src/services/tooljet_db_bulk_upload.service.ts
The text was updated successfully, but these errors were encountered: