309 Deleting a Row

[MaximeJoanisse]

Related to #309

Changes

• There is now a deleting option for rows in the tables

• if the table has no dependencies then it will be deleted and be logged in the settings for Action Logs:

• if there are dependencies and no cascading, the table will show an error in the UI explaining which dependencies there are:

extra:

• added test for the delete button
• changed the columns view with new columns in meta.sql
• changed the folder in test and component from slidingcomponent to TableListViewComponent

[github-actions[bot]]

Coverage Report

Status	Category	Percentage	Covered / Total
🔵	Lines	39.44%	914 / 2317
🔵	Statements	39.72%	949 / 2389
🔵	Functions	31.82%	211 / 663
🔵	Branches	25.77%	240 / 931

File Coverage

File	Stmts	% Branch	% Funcs	% Lines	Uncovered Lines
Changed Files
UInnovateApp/src/components/TableListView.tsx	54.41%	29.16%	40.2%	54.81%	144, 169, 198-201, 200, 202, 212-213, 239, 249, 256, 266, 272, 276, 279, 283, 287, 290, 294, 300, 306, 337-339, 347, 353-354, 359, 369-402, 389-401, 401, 403-405, 404, 406-408, 407, 409, 413-436, 429-435, 430-434, 437, 437-439, 446, 458-460, 459, 461-463, 462, 464-480, 467-468, 470-479, 471-479, 474-475, 477-478, 482-485, 482-485, 490, 492-496, 494-495, 498-505, 507-509, 511-520, 519, 521-522, 542, 542-543, 556-567, 557-558, 560-564, 561, 563, 566, 573, 586, 633, 637-639, 671-812, 672-679, 682-812, 683-690, 693-812, 694-701, 704-812, 705-718, 711, 720-812, 721-734, 727, 736-812, 737-757, 746-747, 753-755, 759-812, 760-771, 768-769, 774-812, 775-782, 785-812, 786-809, 795-796, 802-808, 839, 842, 847, 858, 863-865, 864, 883, 890, 900-920, 913, 915, 926-927, 936-955, 948, 950, 961-962, 996, 1010, 1033-1036, 1035, 1037-1049, 1073, 1126-1131, 1162-1166, 1204
UInnovateApp/src/components/TableListViewComponents/DeleteRowButton.tsx	74.35%	38.46%	100%	72.97%	25-26, 56-61, 63-79, 65-73, 75-77, 76, 82, 99-105
UInnovateApp/src/virtualmodel/DataAccessor.tsx	1.23%	0%	6.25%	1.25%	17-20, 26-42, 27, 29-33, 35-37, 36, 39, 41, 48-66, 49-53, 52, 54-57, 59-61, 60, 63, 65, 72-80, 73-75, 77, 79, 86-94, 87-89, 91, 93, 100-110, 101-104, 106, 108-109, 118-128, 119-122, 124, 126-127, 134-144, 135-138, 140, 142-143, 148-149, 151-152, 155, 157, 157, 159-187, 160-162, 161, 164-183, 165-167, 166, 169-182, 170-177, 171-176, 172-175, 179-181, 185-186, 190-204, 191-193, 192, 194-202, 195-201, 197, 199-200, 203, 208
UInnovateApp/src/virtualmodel/VMD.tsx	24.81%	8.79%	23.23%	24.9%	23, 29, 29, 37-39, 38, 38, 45-47, 46, 53, 59-61, 60, 67-72, 69-71, 70, 73, 83, 89, 99, 105-107, 106, 113-115, 114, 121-126, 124-125, 129, 135, 143-146, 145, 152, 161, 170-197, 173-178, 176-177, 181-186, 184-185, 189-196, 200-202, 204, 206-222, 208-213, 211-212, 216-221, 219-220, 224, 236, 244, 246-300, 248, 250-253, 252, 256, 258-261, 260, 263-265, 264, 267-269, 268, 272-299, 276-279, 282-283, 285-286, 288-289, 291-292, 294-295, 297-298, 301, 314-318, 324-332, 327-329, 331, 343-354, 346-351, 353, 368-390, 373-387, 389, 400-401, 403-412, 404-409, 411, 418-419, 421-434, 422-431, 433, 440-441, 443-456, 444-453, 455, 468-469, 471-484, 472-481, 483, 494-495, 497-510, 498-507, 509, 522-523, 525-531, 527-528, 533-546, 535-543, 545, 557-576, 560-566, 562-563, 567-573, 575, 585-593, 588-590, 592, 605-606, 608-634, 609-631, 610-615, 618-623, 621-622, 624-630, 633, 644-662, 646-656, 648-655, 657-659, 661, 680, 685, 685, 689, 694, 694, 741, 741, 753, 753, 759, 759, 802, 814, 820, 826, 832, 838, 850, 856, 862, 892, 898, 910, 922, 934, 946, 961-962
UInnovateApp/src/virtualmodel/__mocks__/VMD.tsx	88.88%	100%	84.61%	88.88%	47-48, 55
Unchanged Files
UInnovateApp/src/api/AxiosCustom.ts	33.33%	50%	50%	33.33%	11, 20-33
UInnovateApp/src/components/AddRowPopup.tsx	57.14%	25%	60%	55%	23-26, 30-34, 32-33, 36-42, 44-48, 50-51
UInnovateApp/src/components/Dropzone.tsx	24.44%	8%	9.09%	25%	16, 20-43, 26-38, 40-42, 41, 47-53, 50-52, 54, 58-66, 70-76, 80-81, 114-157, 119, 129
UInnovateApp/src/components/FunctionLoadPopup.tsx	4.76%	0%	0%	4.76%	15-16, 18-22, 19-21, 24-41, 25-40, 26, 29-39, 30-31, 33, 35-36, 38, 43, 45-58, 60-63, 65-106
UInnovateApp/src/components/FunctionPopup.tsx	66.66%	100%	0%	66.66%	31-51, 56-74
UInnovateApp/src/components/NavBar.tsx	56.25%	84.61%	33.33%	61.53%	28-29, 31-35, 34, 36
UInnovateApp/src/components/ScriptLoadPopup.tsx	4.54%	0%	0%	4.54%	15-16, 18-22, 19-21, 24-42, 25-41, 26, 29-40, 30-32, 34, 36-37, 39, 44, 46-59, 61-64, 66-107
UInnovateApp/src/components/ScriptPopup.tsx	66.66%	100%	0%	66.66%	31-51, 56-74
UInnovateApp/src/components/TableEnumView.tsx	67.64%	50%	33.33%	67.64%	35, 42, 54-56, 63, 71, 85-90, 88, 105, 112
UInnovateApp/src/components/UnauthorizedScreen.tsx	20%	100%	0%	20%	6, 8-10, 9, 11-21
UInnovateApp/src/components/Schema/DisplayType.tsx	100%	100%	100%	100%
UInnovateApp/src/components/Schema/MenuSchemaSelector.tsx	77.77%	61.53%	83.33%	76.47%	35, 39-41
UInnovateApp/src/components/Schema/SchemaSelector.tsx	52%	28.57%	30%	52%	26-28, 33, 36-57, 45, 51, 61-75, 70-72, 79-93, 88-90, 124
UInnovateApp/src/components/TableListViewComponents/LookUpTableDetails.tsx	35.29%	8.69%	23.07%	36.73%	32, 42-48, 43-44, 47, 57-94, 59-92, 60-63, 62, 64-67, 66, 68-69, 69-80, 79, 82-89, 84-87, 86, 88, 90, 90, 93, 96-135, 114, 120-126, 122-124
UInnovateApp/src/components/settingsPage/ColumnConfig.tsx	47.36%	33.33%	71.42%	47.36%	57-69, 65, 68, 74-86, 82, 85
UInnovateApp/src/components/settingsPage/CronJobsTab.tsx	28.72%	17.64%	21.21%	27.9%	49-61, 51-52, 54, 56-58, 57, 60, 65-69, 71-83, 72-82, 75-76, 80-81, 87-90, 92-104, 93-103, 96-97, 101-102, 108, 108, 110-112, 114-115, 118, 118, 120, 124-125, 127-130, 128-129, 132-135, 137-140, 143-145, 148-166, 151, 151, 153-165, 154-164, 155-163, 167-177, 168, 171-176, 180, 182, 191-193, 198, 203-204, 217, 220-222, 239, 247, 247-248, 248, 265-269, 288-292
UInnovateApp/src/components/settingsPage/DisplayTab.tsx	100%	100%	100%	100%
UInnovateApp/src/components/settingsPage/EnvVarCreator.tsx	56.75%	44.44%	25%	56.75%	25, 28, 31-34, 40, 44-46, 51, 82-85, 97-100, 107-115, 115, 151-163
UInnovateApp/src/components/settingsPage/EnvVarValueEditor.tsx	11.11%	100%	0%	11.11%	14-16, 18, 20-35, 26, 30-31
UInnovateApp/src/components/settingsPage/ExecuteProcedures.tsx	50%	64.28%	31.81%	47.61%	38, 55, 59, 63-67, 69-71, 74-85, 80, 83-84, 89-102, 91-92, 94, 96-99, 97-98, 101, 105-111, 108-109, 111, 132-135, 139-141, 152-155, 166-169, 194-198, 214-218
UInnovateApp/src/components/settingsPage/FunctionViewer.tsx	6.25%	0%	0%	6.25%	28-29, 31-33, 35-42, 36-39, 37-38, 41, 43-70, 44, 46-59, 48-49, 51-52, 54-55, 57-58, 61, 63-67, 69, 72-136, 83, 91, 94-97, 113, 125
UInnovateApp/src/components/settingsPage/GeneralTab.tsx	100%	100%	100%	100%
UInnovateApp/src/components/settingsPage/InternationalizationTab.tsx	38.88%	12.96%	36.36%	39.71%	51-60, 52, 54-57, 54-57, 59, 76, 80, 106-134, 107-111, 109-110, 113-120, 122, 122, 124-127, 129-130, 133, 158, 160, 167-193, 168-176, 179, 181-190, 182-183, 185-189, 187-188, 192, 197, 201-202, 206, 243, 259-270, 260-267, 271, 339, 375-376, 378-382, 379-381, 380, 384-389, 385-388, 386-387, 391-395, 392, 394, 397-403, 398-402, 399-401, 405-411, 406-410, 408-409, 414-444, 415-443, 416-422, 425, 428-440, 430, 432, 435-439, 437-438, 442, 446-458, 447-456, 448-452, 450-451, 455, 460-465, 461-464, 463, 467-493, 489
UInnovateApp/src/components/settingsPage/LookupSetting.tsx	11.29%	4.54%	6.66%	11.66%	28-34, 29-30, 33, 45-49, 46, 48, 52-62, 53-59, 54, 57-58, 66-86, 67-84, 75-77, 89-91, 90, 93-103, 94-102, 101, 105-116, 106-115, 114, 120-127, 120-127, 121-126, 130-139, 131-138, 132, 135-137, 141-151, 142-149, 143-146, 149-150, 153-160, 154-159, 164-203, 173-175, 199
UInnovateApp/src/components/settingsPage/MultiSelect.tsx	33.33%	50%	22.22%	36.36%	15, 22, 22, 26-43, 28-40, 32-34, 33, 38
UInnovateApp/src/components/settingsPage/ScriptEditor.tsx	6.66%	0%	0%	6.66%	29-30, 32-34, 36-63, 37, 39-52, 41-42, 44-45, 47-48, 50-51, 54, 56-60, 62, 65-150, 76, 84, 87-90, 106, 114, 119-123, 134
UInnovateApp/src/components/settingsPage/Scripting.tsx	100%	100%	100%	100%
UInnovateApp/src/components/settingsPage/ScriptingTab.tsx	55.88%	25%	30%	55.88%	26, 43, 47, 51-55, 57-59, 74-80, 80-94, 88-91, 118-122, 138-142
UInnovateApp/src/components/settingsPage/SignupModal.tsx	26.17%	14.4%	8.33%	24.3%	64, 68-72, 77-80, 85-89, 97-99, 98, 100-123, 105, 109-122, 110-118, 112-117, 121, 129-132, 130-131, 137-140, 138-139, 145-146, 150-152, 151, 154-155, 157-191, 158-180, 162-168, 170-171, 174-176, 179, 181-191, 184-190, 188-189, 196, 199-257, 201-211, 202-211, 206-207, 210, 213-219, 214-215, 218, 222-237, 223-237, 227-237, 231-237, 235-236, 240-245, 241, 243-244, 248-254, 249-250, 253, 256, 431-439, 436-437, 440-496, 456-457, 463-464, 479-488
UInnovateApp/src/components/settingsPage/TableConfigTab.tsx	50%	20%	50%	50%	22, 40-47, 43, 46, 51-58, 54, 57, 62-69, 65, 68, 80
UInnovateApp/src/components/settingsPage/UserLogs.tsx	8.33%	0%	0%	9.09%	17, 19-30, 20-23, 25-29, 27, 27-28, 32-34, 33, 36-39
UInnovateApp/src/components/settingsPage/Users/AddUserModal.tsx	82.92%	83.33%	75%	82.5%	55-56, 85-88, 87, 89, 128
UInnovateApp/src/components/settingsPage/Users/RolesTab.tsx	39.68%	52.38%	47.61%	36.66%	31-33, 32, 34-35, 98-99, 101-114, 107-109, 112-113, 116-118, 117, 122-123, 125-156, 127-138, 131-133, 136-137, 142-155, 148-150, 153-154, 166, 184
UInnovateApp/src/components/settingsPage/Users/UserManagementTab.tsx	43.9%	27.77%	41.66%	44.73%	32, 79-86, 80-85, 87, 113-115, 115-117, 117, 120-123, 127-129, 133-139, 134, 136-138, 137, 142-154
UInnovateApp/src/components/settingsPage/additionalView/AdditionalViewEditor.tsx	43.24%	22.72%	16.66%	44.44%	20, 22-25, 23-24, 27-36, 54, 57-63, 59-62, 66-67, 67, 79, 109-159, 132-135, 151-153, 152, 172
UInnovateApp/src/components/settingsPage/additionalView/AdditionalViewModal.tsx	43.58%	40%	30.76%	42.1%	36-40, 43-44, 48-51, 55-64, 60-61, 65-67, 66, 83, 92, 102, 117
UInnovateApp/src/components/settingsPage/additionalView/AdditionalViewTab.tsx	100%	100%	100%	100%
UInnovateApp/src/enums/ErrMsg.ts	100%	100%	100%	100%
UInnovateApp/src/enums/ViewTypeEnum.tsx	61.53%	33.33%	50%	58.33%	10-15, 11-14
UInnovateApp/src/helper/RolesHelpers.ts	0%	0%	0%	0%	10-21, 13-16, 14-15, 17, 19-20, 29-37, 32-33, 35-36
UInnovateApp/src/helper/SettingsHelpers.ts	27.27%	50%	33.33%	27.27%	37-41, 43-47, 54-79, 60-64, 68-72, 74-78, 81
UInnovateApp/src/pages/Settings.tsx	64%	54.16%	35.71%	62.5%	63, 91, 94, 97, 101, 105, 110, 115, 147
UInnovateApp/src/redux/AdditionalViewSlice.tsx	71.42%	100%	0%	71.42%	20-24
UInnovateApp/src/redux/AuthSlice.tsx	25.8%	50%	16.66%	23.33%	37-38, 41-44, 47, 50-55, 57, 59-60, 63-64, 67-68, 72-74
UInnovateApp/src/redux/LoadingSlice.tsx	66.66%	100%	0%	66.66%	15
UInnovateApp/src/redux/NotificationSlice.tsx	55.55%	100%	33.33%	55.55%	24-26, 29
UInnovateApp/src/redux/SchemaSlice.tsx	100%	100%	100%	100%
UInnovateApp/src/redux/Store.ts	100%	100%	100%	100%
UInnovateApp/src/redux/UserDataSlice.tsx	15.38%	0%	0%	15.38%	15, 18-28, 21-27, 22-23, 26, 29-31, 30, 32
UInnovateApp/src/virtualmodel/AdditionalViewsDataAccessor.ts	41.86%	20%	40%	43.9%	30, 30, 49-89, 51-84, 52-62, 65, 68-81, 83, 87-88, 93-122, 95-100, 102-116, 103-111, 114-115, 117, 119-121
UInnovateApp/src/virtualmodel/Config.ts	81.81%	100%	42.85%	80.64%	33-41, 43-55, 46-48, 51-54, 68
UInnovateApp/src/virtualmodel/ConfigProperties.ts	100%	100%	100%	100%
UInnovateApp/src/virtualmodel/EnvVarAccessor.ts	14.28%	100%	0%	14.28%	5-22, 6-14, 17-18, 20-21, 26-44, 27-36, 39-40, 42-43
UInnovateApp/src/virtualmodel/FunctionAccessor.tsx	55.55%	100%	66.66%	55.55%	25-34, 26-29, 31, 33
UInnovateApp/src/virtualmodel/FunctionHandler.ts	0%	0%	0%	0%	12-13, 15-16, 19-21, 23-28, 24-27, 32-43, 33-36, 38-42, 39, 41, 46-53, 52
UInnovateApp/src/virtualmodel/Logger.ts	0%	100%	0%	0%	12-24
UInnovateApp/src/virtualmodel/PlatformFunctions.ts	2.77%	0%	0%	2.85%	16-30, 17-20, 22-24, 23-24, 26, 28-29, 34-37, 39-44, 49, 49-51, 54-55, 60, 63-67, 69, 74, 76-79, 81
UInnovateApp/src/virtualmodel/ScriptHandler.ts	0%	0%	0%	0%	12-13, 15-16, 19-21, 23-28, 24-27, 32-43, 33-36, 38-42, 39, 41, 47-59, 48-52, 54, 56, 58, 63-66, 68-72, 69, 71
UInnovateApp/src/virtualmodel/__mocks__/DataAccessor.tsx	100%	100%	100%	100%
UInnovateApp/src/virtualmodel/__mocks__/FunctionAccessor.tsx	100%	100%	100%	100%

Generated in workflow #328