| # |
Feb 19th 2020, 14:33 |
 spriz |
just to you can at least track back end figure out when `user_id`'s data was suddenly all `0`'s |
| # |
Feb 19th 2020, 14:33 |
spriz |
like which `user_id`, `organization_id`, `account_id` or whatever it might be related to |
| # |
Feb 19th 2020, 14:33 |
spriz |
but maybe something like `gdpr_removal_requests` that contains whatever meta data you are allowed to save about it :) |
| # |
Feb 19th 2020, 14:32 |
spriz |
Yeah, but nothing identifiable in that |
| # |
Feb 19th 2020, 14:32 |
neon1024 |
So you know how many you’ve actioned and when etc |
| # |
Feb 19th 2020, 14:32 |
neon1024 |
@spriz Would you also store the GDPR removal request? As a record I mean? |
| # |
Feb 19th 2020, 14:27 |
spriz |
I would have expected the same @dereuromark |
| # |
Feb 19th 2020, 14:27 |
neon1024 |
True, but I should think about building it into my bake them |
| # |
Feb 19th 2020, 14:26 |
spriz |
Ah, not until someone wants to exercise the right @neon1024;P |
| # |
Feb 19th 2020, 14:26 |
dereuromark |
Depending on `'dependent' => false` and nullable key I would probably expect this to be taken on by the application if no DB constraint has been set up. But sounds sure like manual opt in kind of behavior. |
| # |
Feb 19th 2020, 14:26 |
neon1024 |
@spriz Yeah, I need to build a button for that :) |
| # |
Feb 19th 2020, 14:25 |
spriz |
@neon1024 you can "just" blank out that - so if an user wants to exercise the "right to be forgotten" you just put `00000000000000` in names/emails/whatever |
| # |
Feb 19th 2020, 14:25 |
spriz |
but why/how did was the parent removed? you mean like in `DELETE FROM tbl WHERE`-removed? |
| # |
Feb 19th 2020, 14:24 |
dereuromark |
cake itself doesnt do this it seems, would need some specific afterDelete logic |
| # |
Feb 19th 2020, 14:24 |
dereuromark |
as I said, the belongsTo parent has been removed, thus leaving the hasMany items with a bad key in place. to this optional relation. |
| # |
Feb 19th 2020, 14:23 |
spriz |
I might be - but what is the case - why did you end up with orphans in the first place @dereuromark? |
| # |
Feb 19th 2020, 14:23 |
neon1024 |
..and GDPR removal notices and how to action them effectively |
| # |
Feb 19th 2020, 14:23 |
neon1024 |
I should spend more time on deletion than I do, and more thinking about cascading and dependant deletes |
| # |
Feb 19th 2020, 14:22 |
dereuromark |
I outlined the word optional :) earlier. Which clarifies the use case and why this is just data integrity. |
| # |
Feb 19th 2020, 14:22 |
neon1024 |
Orphan data might go unnoticed |
| # |
Feb 19th 2020, 14:22 |
dereuromark |
I think you misunderstand this specific case. |
| # |
Feb 19th 2020, 14:22 |
neon1024 |
I think I’d rather it fail the delete |
| # |
Feb 19th 2020, 14:21 |
spriz |
If someone by accident had an option to delete stuff, I would rather have bad data integrity than deleted data |
| # |
Feb 19th 2020, 14:21 |
neon1024 |
We had a long discussion in the office once about this kind of thing, then it drifted into overly normalising your data, and into NoSQL, and from there into … |
| # |
Feb 19th 2020, 14:20 |
neon1024 |
Semantics I guess, as long as it works that’s good enough for me! |
| # |
Feb 19th 2020, 14:20 |
neon1024 |
I mean, sure, it’s data integrity too, but the way the database is designed would be dictated by the objects I’d say :) |
| # |
Feb 19th 2020, 14:19 |
neon1024 |
I see it as business logic as a sale would have an invoice kinda thing |
| # |
Feb 19th 2020, 14:14 |
dereuromark |
I wonder if cake could be doing this for us internally, auto-set to null, those relations as post hook via behavior or alike? |
| # |
Feb 19th 2020, 14:14 |
dereuromark |
also way more performant this way, especially on larger datasets. |
| # |
Feb 19th 2020, 14:13 |
dereuromark |
this is not business logic, but low level data integrety. big difference. |
| # |
Feb 19th 2020, 14:11 |
neon1024 |
:P |
| # |
Feb 19th 2020, 14:10 |
neon1024 |
Ooh, now we’re talking |
| # |
Feb 19th 2020, 14:10 |
spriz |
it can also whack ya up! :v: |
| # |
Feb 19th 2020, 14:10 |
spriz |
Although same issue appears when default finder is excluding "soft deleted" ones :shrug: |
| # |
Feb 19th 2020, 14:10 |
neon1024 |
At least then my DB can save me from myself in some instances |
| # |
Feb 19th 2020, 14:10 |
neon1024 |
..but then I think why not both? |
| # |
Feb 19th 2020, 14:10 |
neon1024 |
I feel a bit bad putting what I’d think was more business logic into the database |
| # |
Feb 19th 2020, 14:09 |
spriz |
but also generally I do not delete rows at all :) :) |
| # |
Feb 19th 2020, 14:09 |
spriz |
it's all app-logic |
| # |
Feb 19th 2020, 14:09 |
spriz |
Yeah, true PITA @dereuromark Related to discussion last week - I'm not putting FKs in DB at all currently :shrug: |
| # |
Feb 19th 2020, 14:08 |
khalid |
not sure if its the correct solution but best i could come around is: ```public static function setUpBeforeClass() { Configure::write('Acl.database', 'test');``` |