statbus/test/sql at master · statisticsnorway/statbus

History

Name		Name	Last commit message	Last commit date
parent directory ..
001_set_local_role.sql		001_set_local_role.sql
002_generate_mermaid_er_diagram.sql		002_generate_mermaid_er_diagram.sql
003_load_errors.sql		003_load_errors.sql
004_jsonb_stats_to_summary.sql		004_jsonb_stats_to_summary.sql
005_load_users_and_modify_role.sql		005_load_users_and_modify_role.sql
006_merge_example_with_pk_id_extraction.sql		006_merge_example_with_pk_id_extraction.sql
007_test_sql_saga_synchronize_valid_to.sql		007_test_sql_saga_synchronize_valid_to.sql
008_verify_rls_and_grants.sql		008_verify_rls_and_grants.sql
009_prevent_last_admin_removal.sql		009_prevent_last_admin_removal.sql
012_test_default_import_definitions.sql		012_test_default_import_definitions.sql
013_auth.sql		013_auth.sql
014_test_template_for_error_handling.sql		014_test_template_for_error_handling.sql
015_generate_data_model_doc.sql		015_generate_data_model_doc.sql
016_generate_typescript_types_from_db.sql		016_generate_typescript_types_from_db.sql
017_activity_category_code_pattern_cascade.sql		017_activity_category_code_pattern_cascade.sql
018_import_data_column_id_determinism.sql		018_import_data_column_id_determinism.sql
094_read_only_window_worker_recovery_exemption.sql		094_read_only_window_worker_recovery_exemption.sql
095_worker_task_parent_fk_delete_semantics.sql		095_worker_task_parent_fk_delete_semantics.sql
096_worker_recurring_maintenance_survives_failure.sql		096_worker_recurring_maintenance_survives_failure.sql
097_stuck_task_detector.sql		097_stuck_task_detector.sql
098_user_delete_door.sql		098_user_delete_door.sql
099_statbus_304_tag_object_sha_repair.sql		099_statbus_304_tag_object_sha_repair.sql
100_regions_with__itudes.sql		100_regions_with__itudes.sql
101_verify_generated_views.sql		101_verify_generated_views.sql
102_verify_data_tables_for_default_import_jobs.sql		102_verify_data_tables_for_default_import_jobs.sql
103_legal_units_with_data_source.sql		103_legal_units_with_data_source.sql
104_load_establishment_without_legal_unit.sql		104_load_establishment_without_legal_unit.sql
105_legal_units_with_statistics.sql		105_legal_units_with_statistics.sql
106_load_with_status_codes.sql		106_load_with_status_codes.sql
107_load_and_verify_history_functions.sql		107_load_and_verify_history_functions.sql
108_test_code_gen.sql		108_test_code_gen.sql
109_hierarchy_functions.sql		109_hierarchy_functions.sql
110_modify_enterprise_connections.sql		110_modify_enterprise_connections.sql
111_informal_formal_connections.sql		111_informal_formal_connections.sql
112_load_units_errors.sql		112_load_units_errors.sql
113_test_hierarchical_external_identifiers.sql		113_test_hierarchical_external_identifiers.sql
114_image_storage.sql		114_image_storage.sql
115_legal_units_valid_to_from.csv		115_legal_units_valid_to_from.csv
115_region_code_collision.sql		115_region_code_collision.sql
116_worker_structured_concurrency.sql		116_worker_structured_concurrency.sql
117_power_group_fundamentals.sql		117_power_group_fundamentals.sql
118_power_group_worker_derivation.sql		118_power_group_worker_derivation.sql
119_roller_data_power_groups.sql		119_roller_data_power_groups.sql
120_power_group_lifecycle.sql		120_power_group_lifecycle.sql
121_worker_info_and_ordering.sql		121_worker_info_and_ordering.sql
122_crash_recovery.sql		122_crash_recovery.sql
123_worker_maintenance_cleanup.sql		123_worker_maintenance_cleanup.sql
124_duplicate_primary_controller_import.sql		124_duplicate_primary_controller_import.sql
125_statbus_312_import_source_column_reconstruction.sql		125_statbus_312_import_source_column_reconstruction.sql
126_statbus_314_link_lu_priority_drift_fix.sql		126_statbus_314_link_lu_priority_drift_fix.sql
127_statbus_316_normalize_all_sequences.sql		127_statbus_316_normalize_all_sequences.sql
128_statbus_317_upgrade_actor_attribution.sql		128_statbus_317_upgrade_actor_attribution.sql
129_statbus_319_upgrade_policy_symmetry.sql		129_statbus_319_upgrade_policy_symmetry.sql
130_statbus_435_version_first_upgrade_supersession.sql		130_statbus_435_version_first_upgrade_supersession.sql
200_history_legal_units_deaths.sql		200_history_legal_units_deaths.sql
201_history_legal_units_changes_over_time.sql		201_history_legal_units_changes_over_time.sql
202_history_legal_units_births.sql		202_history_legal_units_births.sql
203_legal_units_consecutive_days.sql		203_legal_units_consecutive_days.sql
204_history_two_imports_partition_regression.sql		204_history_two_imports_partition_regression.sql
300_test_error_scenarios.sql		300_test_error_scenarios.sql
301_test_custom_happy_path.sql		301_test_custom_happy_path.sql
302_small_history_load_and_check.sql		302_small_history_load_and_check.sql
303_import_jobs_for_norway_small_history.sql		303_import_jobs_for_norway_small_history.sql
304_test_complex_happy_path.sql		304_test_complex_happy_path.sql
305_load_norwegian_dataset_suitable_for_web_upload.sql		305_load_norwegian_dataset_suitable_for_web_upload.sql
306_load_demo_data.sql		306_load_demo_data.sql
307_test_lu_enterprise_link.sql		307_test_lu_enterprise_link.sql
308_test_import_job_system.sql		308_test_import_job_system.sql
309_load_demo_data_with_source_dates.sql		309_load_demo_data_with_source_dates.sql
310_idempotent_import_source_dates.sql		310_idempotent_import_source_dates.sql
311_partial_update_with_regular_import.sql		311_partial_update_with_regular_import.sql
312_partial_update_establishment_with_regular_import.sql		312_partial_update_establishment_with_regular_import.sql
313_update_triggers_refresh.sql		313_update_triggers_refresh.sql
314_consecutive_demo_loads.sql		314_consecutive_demo_loads.sql
315_activity_for_portion_of_valid.sql		315_activity_for_portion_of_valid.sql
316_update_legal_form_legal_unit.sql		316_update_legal_form_legal_unit.sql
317_update_name_legal_unit.sql		317_update_name_legal_unit.sql
318_facet_drift_self_healing.sql		318_facet_drift_self_healing.sql
319_history_drift_self_healing.sql		319_history_drift_self_healing.sql
319_test_import_job_failure_handling.sql		319_test_import_job_failure_handling.sql
320_test_enterprise_name_preservation.sql		320_test_enterprise_name_preservation.sql
320_test_region_validation_fail_fast.sql		320_test_region_validation_fail_fast.sql
321_import_error_scenarios_for_ui_review.sql		321_import_error_scenarios_for_ui_review.sql
322_statistical_history_facet_derive_recovery.sql		322_statistical_history_facet_derive_recovery.sql
323_test_rls_granular_access_visibility.sql		323_test_rls_granular_access_visibility.sql
324_test_facet_staging_drift_after_orphan_handling.sql		324_test_facet_staging_drift_after_orphan_handling.sql
325_history_facet_dimensional_coherence.sql		325_history_facet_dimensional_coherence.sql
327_test_upgrade_procedures.sql		327_test_upgrade_procedures.sql
328_statbus_382_actor_guarded_upgrade_transitions.sql		328_statbus_382_actor_guarded_upgrade_transitions.sql
328_test_verify_artifacts_terminal_guard.sql		328_test_verify_artifacts_terminal_guard.sql
329_test_upgrade_schema_skew.sql		329_test_upgrade_schema_skew.sql
330_test_upgrade_invariant_trigger.sql		330_test_upgrade_invariant_trigger.sql
331_running_identity.sql		331_running_identity.sql
340_duplicate_tax_ident_small_file.sql		340_duplicate_tax_ident_small_file.sql
341_duplicate_tax_ident_big_file.sql		341_duplicate_tax_ident_big_file.sql
342_hierarchical_ident_import.sql		342_hierarchical_ident_import.sql
343_statistical_unit_hierarchical_ident.sql		343_statistical_unit_hierarchical_ident.sql
344_directional_change_propagation.sql		344_directional_change_propagation.sql
345_duplicate_idents_history_import.sql		345_duplicate_idents_history_import.sql
346_migration_rebuilds_derived_tables.sql		346_migration_rebuilds_derived_tables.sql

FilesExpand file tree

sql

Directory actions

More options

Directory actions

More options

Latest commit

History

sql

Folders and files

parent directory