ToxBatch duplicates check doesnt work

[r7butler]

For some reason, the checkDuplicatesInProduction check for ToxBatch is not catching errors, if the submission contains records already in the database
tox_demo.xlsx

[r7butler]

The reason it didnt work is because apparently the table was renamed, but the constraint was not renamed. This is obviously a major flaw with the application which must be changed in the original template repository

The issue was with the get_primary_key function in core. i had to adjust the query to get the primary key according to the answer on this stack overflow post

I had to adjust the query to this
SELECT
c.column_name,
c.data_type
FROM information_schema.table_constraints tc
JOIN information_schema.constraint_column_usage AS ccu USING (constraint_schema, constraint_name)
JOIN information_schema.columns AS c ON c.table_schema = tc.constraint_schema
AND tc.table_name = c.table_name AND ccu.column_name = c.column_name
WHERE constraint_type = 'PRIMARY KEY' and tc.table_name = '{tablename}';