I have a table companies in which there are some duplicated rows I found with a simple GROUP BY name. This companies table has a PRIMARY KEY id which is referenced in several other tables, under the name company_id, which…
I have a example of cascade delete but it looks too big and complicated, is there a way to shorten this code? protected static function boot() { parent::boot(); static::deleted(function ($parent) { // $versions = $parent->game_versions(); $versions = $parent->game_versions; foreach($versions as…
I am using Flask + MongoEngine (0.22.1). I have 2 document types, where I don't have any circular dependency: from mongoengine import Document, StringField, UUIDField, ListField from openapi_crud_framework import MongoSettings class Idp(Document): meta = { 'auto_create_index': MongoSettings.auto_create_index() } uuid =…
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…