[server] change order of entities table modification vs entity creation/deletion In order to have a foreign key referencing the entities table, the insertion into entities must happen first, and the deletion must happen last. For the deletion case, this means we need to: 1. delete all relations (cascade) 2. delete the entities themselves 3. delete the corresponding lines from the entities table This means the _delete_info{,_multi} methods can't keep doing 1 and 3. Thankfully the "public" delete_info method appears to be unused, so drop it. Related to #4846892.

     1

from datetime import datetime

     2

     3

for rtype in ('cw_support', 'cw_dont_cross', 'cw_may_cross'):

     4

    drop_relation_type(rtype)

     5

     6

add_entity_type('CWSourceSchemaConfig')

     7

     8

if not 'url' in schema['CWSource'].subjrels:

     9

    add_attribute('CWSource', 'url')

    10

    add_attribute('CWSource', 'parser')

    11

    add_attribute('CWSource', 'latest_retrieval')