infisical icon indicating copy to clipboard operation
infisical copied to clipboard

Function CreateJunctionTable is not checking, if the table already exists or not

Open Ayush-Dutt-Sharma opened this issue 1 year ago • 0 comments

Describe the bug

backend/src/db/utils.js createJunctionTable --> it is not checking if the table already exists or not, Table1PrimaryKey and Table2PrimaryKey can be dynamic, for bigger files optional Indexing can make querying faster.

dropOnUpdateTrigger, createOnUpdateTrigger, dropUpdatedAtTriggerFunction, createUpdateAtTriggerFunction --> needs better error handling

To Reproduce

Steps to reproduce the behavior:

  1. Go to backend/src/db/utils.js

Screenshots

Screenshot 2024-08-12 at 5 43 13 PM

Platform you are having the issue on:

Code

Ayush-Dutt-Sharma avatar Aug 12 '24 12:08 Ayush-Dutt-Sharma