Project

General

Profile

Bug #7215

Wrong usage of DB array in mentat_main/settings_reporting/emails

Added by Radko Krkoš 2 months ago. Updated 2 months ago.

Status:
New
Priority:
Low
Assignee:
-
Category:
Development - Database
Target version:
Start date:
04/15/2021
Due date:
% Done:

0%

Estimated time:
To be discussed:
No

Description

As was discussed in VC, the emails column of table settings_reporting in the database mentat_main is declared as a character varying array, however the upper layer implementation based on Python/SQLAlchemy stores a single string value inside the array, containing comma separated emails. This was identified as a result of an oversight and should be fixed.
In addition, there are both NULL values and empty arrays present in this column, while logically equivalent, they are still distinct values; and although this might be abstracted in the upper layer, it could be improved for consistency in the DB.


Related issues

Related to Mentat - Feature #7221: Referential integrity for database arraysNewRadko Krkoš04/16/2021

Actions
#1

Updated by Radko Krkoš 2 months ago

  • Assignee deleted (Jan Mach)
#2

Updated by Radko Krkoš 2 months ago

  • Category set to Development - Database
#3

Updated by Radko Krkoš 2 months ago

  • Related to Feature #7221: Referential integrity for database arrays added

Also available in: Atom PDF