Bug 210874

Summary: All ITP database tables should reference the ObservedDomains table on DELETE CASCADE
Product: WebKit Reporter: Kate Cheney <katherine_cheney>
Component: WebKit Misc.Assignee: Kate Cheney <katherine_cheney>
Status: RESOLVED FIXED    
Severity: Normal CC: beidson, bfulgham, webkit-bug-importer, wilander
Priority: P2 Keywords: InRadar
Version: WebKit Nightly Build   
Hardware: Unspecified   
OS: Unspecified   
Attachments:
Description Flags
Patch
none
Patch
none
Patch
none
Patch none

Description Kate Cheney 2020-04-22 14:08:17 PDT
This will make deleting individual ITP entries from the database very simple.
Comment 1 Radar WebKit Bug Importer 2020-04-22 14:08:43 PDT
<rdar://problem/62209438>
Comment 2 Kate Cheney 2020-04-22 14:21:22 PDT
Created attachment 397260 [details]
Patch
Comment 3 Kate Cheney 2020-04-22 17:25:18 PDT
Created attachment 397295 [details]
Patch
Comment 4 Kate Cheney 2020-04-22 17:25:26 PDT
+ test case
Comment 5 Brady Eidson 2020-04-22 19:47:07 PDT
Comment on attachment 397295 [details]
Patch

This seems reasonable, but every bot is sad.
Comment 6 Kate Cheney 2020-04-23 08:16:53 PDT
(In reply to Brady Eidson from comment #5)
> Comment on attachment 397295 [details]
> Patch
> 
> This seems reasonable, but every bot is sad.

Hopefully just needs a rebase
Comment 7 Kate Cheney 2020-04-23 09:31:26 PDT
Created attachment 397348 [details]
Patch
Comment 8 Kate Cheney 2020-04-23 12:48:11 PDT
Created attachment 397376 [details]
Patch
Comment 9 Kate Cheney 2020-04-23 12:49:36 PDT
Realized this should call createUniqueIndices() again after creating the new schema (they get deleted when migrating the data). Added this and updated the test case to check for it.
Comment 10 EWS 2020-04-23 13:17:53 PDT
Committed r260594: <https://trac.webkit.org/changeset/260594>

All reviewed patches have been landed. Closing bug and clearing flags on attachment 397376 [details].