search

WillTrem / UInnovate

MIT License
3 stars 1 forks source link

276 foreign dropdown for Adding a Row #337

Closed MaximeJoanisse closed 3 months ago

MaximeJoanisse commented 3 months ago

Major Changes

For example: Let's say we add a table, for Contact: image

For column company_id it now says Company as its label to show what table its foreign key is from. The Select now displays all the rows from the display field column of the table. So, in this case, it is the column "Company_name" since that's the comment on the table "Company". image

Now the selected will store it as a number, for when we save it in the Row.

github-actions[bot] commented 3 months ago

Coverage Report

Status Category Percentage Covered / Total
🔵 Lines 53.33% 1465 / 2747
🔵 Statements 53.69% 1524 / 2838
🔵 Functions 49.04% 384 / 783
🔵 Branches 38.51% 446 / 1158
File Coverage
File Stmts % Branch % Funcs % Lines Uncovered Lines
Changed Files
UInnovateApp/src/components/AddRowPopup.tsx 79.31% 88.23% 70% 80.7% 58-62, 72-73, 90-93, 99-100, 102-108, 110-113, 110-113, 120-121
UInnovateApp/src/components/TableEnumView.tsx 82.35% 50% 66.66% 82.35% 32, 39, 60, 72, 106, 114
UInnovateApp/src/components/TableListView.tsx 53.44% 30.76% 43.63% 53.75% 175, 208, 241, 266-267, 292, 309, 325, 329, 332, 336, 340, 343, 347, 353, 359, 390-392, 400, 406-407, 412, 415-416, 426-459, 446-458, 458, 460-462, 461, 463-465, 464, 466, 470-493, 486-492, 487-491, 494, 494-496, 504-506, 505, 507-509, 508, 510-526, 513-514, 516-525, 517-525, 520-521, 523-524, 528-531, 528-531, 538, 540-544, 542-543, 546-553, 555-557, 559-568, 567, 569-570, 591, 591-592, 602-603, 605-609, 606, 608, 611, 618, 629, 659-660, 662-665, 663-664, 666-672, 667-671, 673, 675-682, 687, 705-750, 706, 706, 708-709, 711-715, 713-714, 717-723, 725, 727, 729-748, 730-739, 738, 741-743, 747, 749, 752-758, 761-763, 762, 766-767, 772, 796-937, 797-804, 807-937, 808-815, 818-937, 819-826, 829-937, 830-843, 836, 845-937, 846-859, 852, 861-937, 862-882, 871-872, 878-880, 884-937, 885-896, 893-894, 899-937, 900-907, 910-937, 911-934, 920-921, 927-933, 964, 972, 984, 1000, 1008, 1018-1038, 1031, 1033, 1044-1045, 1054-1073, 1066, 1068, 1079-1080, 1118, 1139, 1174, 1212, 1219, 1229, 1232, 1243, 1272, 1310-1315, 1360-1365, 1408
UInnovateApp/src/components/settingsPage/LookupSetting.tsx 86.66% 56.41% 94.11% 86.11% 41, 46, 62-63, 143-148, 150-155, 161, 185
UInnovateApp/src/virtualmodel/VMD.tsx 23.69% 4.04% 25.49% 23.74% 23, 29, 29, 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, 158, 160-191, 161-163, 165-187, 168-186, 169, 171-174, 172-173, 176, 178-183, 179-182, 184-185, 188, 190, 200, 209-236, 212-217, 215-216, 220-225, 223-224, 228-235, 239-241, 243, 245-261, 247-252, 250-251, 255-260, 258-259, 263, 275, 283, 285-339, 287, 289-292, 291, 295, 297-300, 299, 302-304, 303, 306-308, 307, 311-338, 315-318, 321-322, 324-325, 327-328, 330-331, 333-334, 336-337, 340, 353-357, 363-371, 366-368, 370, 382-393, 385-390, 392, 407-429, 412-426, 428, 439-440, 442-451, 443-448, 450, 457-458, 460-473, 461-470, 472, 479-480, 482-495, 483-492, 494, 507-508, 510-523, 511-520, 522, 533-534, 536-549, 537-546, 548, 561-562, 564-570, 566-567, 572-585, 574-582, 584, 596-615, 599-605, 601-602, 606-612, 614, 624-632, 627-629, 631, 644-645, 647-673, 648-670, 649-654, 657-662, 660-661, 663-669, 672, 683-701, 685-695, 687-694, 696-698, 700, 719, 724, 724, 728, 733, 733, 782, 782, 788, 794, 800, 800, 812-817, 815-816, 819, 843, 855, 867, 873, 891, 897, 909, 939, 957, 969, 981, 993, 1008-1009
UInnovateApp/src/virtualmodel/__mocks__/VMD.tsx 89.18% 100% 87.87% 89.18% 56-60, 196-197, 204-205, 212-213
Unchanged Files
UInnovateApp/src/api/AxiosCustom.ts 73.33% 100% 50% 73.33% 11, 31-33
UInnovateApp/src/components/Dropzone.tsx 22.72% 8% 9.09% 23.25% 15, 19-46, 25-41, 43-45, 44, 50-56, 53-55, 57, 61-69, 73-79, 83-84, 117-160, 122, 132
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 68.75% 92.3% 66.66% 61.53% 31-35, 34, 36
UInnovateApp/src/components/PrimaryKeyErrorPopup.tsx 75% 100% 0% 75% 25-38
UInnovateApp/src/components/SavePopup.tsx 75% 100% 0% 75% 25-33
UInnovateApp/src/components/ScriptLoadPopup.tsx 81.81% 66.66% 75% 81.81% 19-21, 34
UInnovateApp/src/components/ScriptPopup.tsx 83.33% 100% 50% 83.33% 56-74
UInnovateApp/src/components/UnauthorizedScreen.tsx 80% 100% 50% 80% 9
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/DeleteRowButton.tsx 74.35% 38.46% 100% 72.97% 27-28, 58-63, 65-81, 67-75, 77-79, 78, 84, 101-107
UInnovateApp/src/components/TableListViewComponents/LookUpTableDetails.tsx 79.66% 61.53% 73.33% 78.94% 45, 56, 76, 80, 93, 98-101, 100, 102, 112, 144-157, 149-155
UInnovateApp/src/components/settingsPage/AuditTrails.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/ColumnConfig.tsx 47.82% 20% 75% 45.45% 62-74, 70, 73, 76-81, 86-98, 94, 97, 100-105
UInnovateApp/src/components/settingsPage/CronJobsTab.tsx 29.59% 15.78% 23.52% 28.08% 51-63, 53-54, 56, 58-60, 59, 62, 67-71, 73-93, 74-92, 77-78, 80-86, 90-91, 97-100, 102-122, 103-121, 106-107, 109-115, 119-120, 126, 126, 128-130, 132-133, 136, 136, 138, 142-143, 145-148, 146-147, 150-153, 155-158, 161-163, 166-184, 169, 169, 171-183, 172-182, 173-181, 185-195, 186, 189-194, 198, 200, 209-211, 216, 221-222, 235, 238-240, 257, 265, 265-266, 266, 283-287, 306-310
UInnovateApp/src/components/settingsPage/DisplayTab.tsx 100% 100% 100% 100%
UInnovateApp/src/components/settingsPage/EnvVarCreator.tsx 62.5% 58.33% 38.46% 61.53% 29, 32, 36-46, 52, 56-58, 63, 94-97, 109-112, 163-175
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 30.67% 8.03% 29.82% 30.7% 76-82, 77-80, 77-81, 89-106, 90-93, 95-103, 97-100, 97-100, 102, 105, 111-120, 112-117, 114-115, 115-116, 119, 144, 157, 163-173, 164-169, 166-167, 167-168, 172, 177-197, 178-181, 183-194, 185-191, 185-191, 193, 196, 222-244, 223-227, 225-226, 229-236, 238, 238-240, 243, 271, 284-309, 285-293, 296, 298-306, 299, 301-305, 303-304, 308, 311-317, 321, 325-326, 330-332, 335, 341-350, 342-347, 344, 344-345, 345-346, 349, 376, 412-427, 413-424, 428, 496, 535-538, 538, 540-541, 543-572, 544-571, 547-548, 551-563, 566-568, 567, 570, 574-578, 575-577, 576, 580-585, 581-584, 582-583, 587-590, 588-589, 592-597, 593-596, 594-595, 599-602, 600-601, 604-610, 605-609, 606-608, 612-618, 613-617, 614-616, 620-630, 621-629, 623-629, 627-628, 633-668, 634-659, 635-641, 644, 647-656, 648, 651-655, 653-654, 658, 661-667, 670-680, 671-678, 672-674, 673, 677, 682-690, 683-689, 684-686, 685, 688, 692-694, 693, 696-698, 697, 700-705, 701-704, 703, 707-771, 738, 756
UInnovateApp/src/components/settingsPage/MultiSelect.tsx 66.66% 75% 66.66% 72.72% 15, 22, 22, 38
UInnovateApp/src/components/settingsPage/ScriptEditor.tsx 73.52% 70% 70% 72.72% 45-47, 49-50, 98, 128, 133-137
UInnovateApp/src/components/settingsPage/Scripting.tsx 100% 100% 100% 100%
UInnovateApp/src/components/settingsPage/ScriptingTab.tsx 72.97% 71.42% 63.63% 72.22% 30, 47, 51, 55-59, 61-63, 65-71, 92, 100-103
UInnovateApp/src/components/settingsPage/SignupModal.tsx 68.45% 50.84% 70.83% 67.36% 98, 105, 112-113, 116-117, 145-146, 151, 179, 181-191, 184-190, 188-189, 202-203, 206-207, 214-215, 222-237, 223-237, 227-237, 231-237, 235-236, 240-245, 241, 243-244, 248-254, 249-250, 253, 256, 462-463, 479-488
UInnovateApp/src/components/settingsPage/TableConfigTab.tsx 50% 22.22% 57.14% 48.71% 26, 44-51, 47, 50, 53-58, 62-69, 65, 68, 71-76, 80-87, 83, 86, 89-94, 105
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 84.09% 78.57% 76.92% 83.33% 59-60, 89-92, 91, 93, 139
UInnovateApp/src/components/settingsPage/Users/RolesTab.tsx 82.08% 76% 81.81% 80.95% 115-116, 120, 138-149, 142-144, 147-148, 164-165
UInnovateApp/src/components/settingsPage/Users/UserManagementTab.tsx 86.66% 59.09% 92.3% 85.36% 88, 135-137, 139-144, 152
UInnovateApp/src/components/settingsPage/additionalView/AdditionalViewEditor.tsx 44.18% 19.23% 28.57% 45% 25-26, 26-38, 28-29, 31-37, 40-49, 67, 71-77, 73-76, 79-85, 88-89, 89, 131-181, 154-157, 173-175, 174, 194
UInnovateApp/src/components/settingsPage/additionalView/AdditionalViewModal.tsx 45.23% 33.33% 35.71% 42.5% 39-43, 46-47, 51-61, 65-74, 70-71, 75-77, 76, 93, 102, 112, 127
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 75% 50% 100% 75% 19-20, 35-36
UInnovateApp/src/helper/SettingsHelpers.ts 54.54% 50% 66.66% 54.54% 37-41, 43-47, 68-72, 74-78
UInnovateApp/src/pages/Settings.tsx 61.53% 54.16% 33.33% 61.53% 66, 95, 103, 111, 121, 130, 138, 146, 154, 191
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 47.61% 41.66% 60% 47.5% 35, 56-95, 58-90, 59-69, 72, 75-87, 89, 94, 99-128, 101-106, 108-122, 109-117, 120-121, 123, 125-127
UInnovateApp/src/virtualmodel/Audits.ts 100% 100% 100% 100%
UInnovateApp/src/virtualmodel/Config.ts 84.84% 100% 57.14% 83.87% 33-41, 43-55, 46-48, 51-54
UInnovateApp/src/virtualmodel/ConfigProperties.ts 100% 100% 100% 100%
UInnovateApp/src/virtualmodel/DataAccessor.tsx 21.25% 8.33% 25% 20.25% 34, 46-64, 47-51, 50, 52-55, 57-59, 58, 61, 63, 70-78, 71-73, 75, 77, 84-92, 85-87, 89, 91, 98-108, 99-102, 104, 106-107, 116-126, 117-120, 122, 124-125, 132-142, 133-136, 138, 140-141, 161-191, 162-164, 163, 166-187, 167-169, 168, 171-186, 172-181, 173-180, 174-179, 183-185, 189-190, 194-210, 195-197, 196, 198-208, 199-207, 203, 205-206, 209, 214
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 100% 100% 100% 100%
UInnovateApp/src/virtualmodel/PlatformFunctions.ts 2.77% 0% 0% 2.77% 16-30, 17-20, 22-24, 23-24, 26, 28-29, 37-43, 45-50, 56-58, 57, 59-63, 66-67, 74, 77-84, 86, 93, 95-101, 103
UInnovateApp/src/virtualmodel/ScriptHandler.ts 88.57% 83.33% 100% 88.57% 41, 54, 56, 75
UInnovateApp/src/virtualmodel/__mocks__/DataAccessor.tsx 96.87% 91.66% 100% 96.87% 50-56
UInnovateApp/src/virtualmodel/__mocks__/FunctionAccessor.tsx 93.75% 84.61% 100% 93.75% 29
UInnovateApp/src/virtualmodel/__mocks__/ScriptHandler.tsx 96.07% 100% 100% 96.07% 47, 78
Generated in workflow #388