This question is being updated every time I act on someone's suggestion here. Unfortunately though, non of the minor housekeeping suggestions helped enough, so the problem remains. In the nutshell: I have a viewController (secondVC) with a tableView in it…
I am trying to rewrite a Postgres schema to fit the MySQL (8.0.32) dialect. As you know, MySQL does not support partial indexes. In the following situation, there exists an index that enforces unique data on customer_group.name only when deleted_at…
I have tables variable and variable_variable. The last one holds 2 columns: variable_id_from variable_id_from Look at the schema below: If variable_variable has row with values {variable_id_from = 1, variable_id_to = 2}, it means that variable with id = 1 references…
I have UILabel which I am showing and hiding on tapGesture. I have created label programatically and set constraint programatically only. by default UILabel is visible with heightConstraint = 230 on tapGesture method I am making heightConstraint = 0 and…
I'm trying to do an upsert on a table with two constraints. One is that the column a is unique, the other is that the columns b, c, d and e are unique together. What I don't want is that…
I have a SQL table that can reference another record in the table as its parent but should not reference itself. I have attempted to enforce this with a CHECK constraint but my attempts have failed as the id is…
I need to temporarily disable all constraints and triggers of a schema in order to anonymize data in several tables. As there are dependencies between tables, I prefer to disable everything and once the anonymization treatment is over I can…
I need to put a constraint which will restrict DUPLICATE entries in combination of 2 columns. So I have a customers table, with the below mentioned columns id, first_name, last_name, date_of_birth, gender, email_address, primary_number, secondary_number. What I am expecting is…
I came across a strange problem with Symfony validation. Seems that "nested" constraints don't work properly. For example, I create a string variable $data which needs to be validated. $data = 'string'; $constraint = new AssertType('integer'); $violations = $validator->validate($data, $constraint);…
I am trying to make a custom BottomNavigationBar in Flutter, and here is the code. bottomNavigationBar: Container( margin: const EdgeInsets.fromLTRB(25, 0, 25, 25), padding: const EdgeInsets.all(8), decoration: BoxDecoration( borderRadius: BorderRadius.circular(50), color: const Color.fromARGB(255, 25, 30, 32), ), child: Row( mainAxisSize:…