/** Generate the SQL to write a relationship to the DB **/ public static function sqlDelete($relationship) { $relname = TLO::transClassTable($relationship); $location_class = $relationship::relationMany(); $relation_class = $relationship::relationOne(); $location_name = TLO::transClassTable($location_class); $query = new TLOQuery(); $query->update($location_name); foreach (TLO::keyNames($relation_class) as $key) { $query->set('%s = NULL', TLO::developedColName($relname, 'key', $key)); } TLO::concreteClassLoop($relationship, __CLASS__, function ($class) use($relname, $query) { TLO::propertyLoop($class, __CLASS__, function ($p) use($relname, $query) { $query->set('%s = NULL', TLO::developedColName($relname, 'var', $p), $p); }); }); TLO::whereKeys($query, $location_class); return $query; }