76_upgrade branch - issues with preliminary_sql/search_filters.sql and post_sql/create_spatial_views.sql

[SDScandrettKint]

Errors in the SQL files when loading up the AfHER app package on the 76_upgrade branch.

1. preliminary_sql/search_filters.sql

loading preliminary sql
  /home/samuel/arches_dev/arches_her/AfHER_application/arches_her/arches_her/pkg/preliminary_sql/search_filters.sql
column "sortorder" of relation "search_component" does not exist
LINE 10:                 sortorder,
                         ^

Failed to load sql files

Looks like sortorder is not a column in the search_component db table anymore, same with enabled, as of this PR and these lines. Similarly, config is now a column in the table.

Solution would be to remove these lines from the search_filters.sql insert, and add an empty config object.

2. post_sql/create_spatial_views.sql

loading post sql
  /home/samuel/arches_dev/arches_her/AfHER_application/arches_her/arches_her/pkg/post_sql/create_spatial_views.sql
null value in column "languageid" of relation "spatial_views" violates not-null constraint
DETAIL:  Failing row contains (289d89bb-47ad-40ef-89fe-3df03c265135, public, maritime, Used to record the details of historic vessels which are either ..., f, [{"nodeid": "656c68c4-3ec0-11eb-859a-f875a44e0e11", "description..., f, 9f07fa25-f457-11eb-98c7-a87eeabdefba, null).

Failed to load sql files

This looks to be caused by the missing languageid column (added here). Solution would be to add "en" as a languagecode to all sp_views.