integration-tests-configuration.yaml

default_schema: "{{template_schema_value}}"
current_tenant_id_property_type:  "VARCHAR(255)"
current_tenant_id_property: "pos.c.ten"
get_current_tenant_id_function_name: "get_ten_id"
set_current_tenant_id_function_name: "set_tenant"
equals_current_tenant_identifier_function_name: "equals_cur_tenant"
tenant_has_authorities_function_name: "_tenant_hast_auth"
force_row_level_security_for_table_owner: false
default_tenant_id_column: "tenant_id"
grantee: "{{template_user_grantee}}"
set_current_tenant_identifier_as_default_value_for_tenant_column_in_all_tables: true
valid_tenant_value_constraint:
  is_tenant_valid_function_name:  is_t_valid
  is_tenant_valid_constraint_name:  "is_tenant_valid_constraint_sdfa"
  tenant_identifiers_blacklist:
    - invalid_tenant
    - "Some strange tenant ID"
tables:
  - name: user_info
    rls_policy:
      name: users_table_rls_policy
      tenant_column:  tenant_id
      create_tenant_column_for_table: true
      primary_key_definition:
        name_for_function_that_checks_if_record_exists_in_table: "is_user_exists"
        pk_columns_name_to_type:
          user_id: uuid
  - name: user_role
    rls_policy:
      name: "user_role_table_rls_policy"
      tenant_column:  tenant_id
      create_tenant_column_for_table: true
      primary_key_definition:
        name_for_function_that_checks_if_record_exists_in_table: "is_user_role_exists"
        pk_columns_name_to_type:
          id: bigint
  - name: posts
    rls_policy:
      name: "posts_table_rls_policy"
      tenant_column:  tenant_id
      create_tenant_column_for_table: true
      primary_key_definition:
        name_for_function_that_checks_if_record_exists_in_table: "is_posts_exists"
        pk_columns_name_to_type:
          id: bigint
    foreign_keys:
      - constraint_name:  "user_info_tenant_constraint"
        table_name: user_info
        foreign_key_primary_key_columns_mappings:
          userId:  user_id
  - name: comments
    rls_policy:
      name: "comments_table_rls_policy"
      tenant_column:  comment_tenant_id
      create_tenant_column_for_table: true
      primary_key_definition:
        name_for_function_that_checks_if_record_exists_in_table: "is_comments_exists"
        pk_columns_name_to_type:
          id: bigint
    foreign_keys:
      - constraint_name:  "user_info_tenant_constraint"
        table_name: user_info
        foreign_key_primary_key_columns_mappings:
          userId:  user_id
      - constraint_name:  "posts_tenant_constraint"
        table_name: posts
        foreign_key_primary_key_columns_mappings:
          post_id:  id
  - name: categories
    rls_policy:
      name: "categories_table_rls_policy"
      tenant_column:  "categorytenantid"
      primary_key_definition:
        name_for_function_that_checks_if_record_exists_in_table: "is_categories_exists"
        pk_columns_name_to_type:
          id: bigint
  - name: posts_categories
    rls_policy:
      name: "posts_categories_table_rls_policy"
      create_tenant_column_for_table: true
    foreign_keys:
      - constraint_name:  "posts_tenant_constraint"
        table_name: "posts"
        foreign_key_primary_key_columns_mappings:
          posts_id:  id
      - constraint_name:  "categories_tenant_constraint"
        table_name: "categories"
        foreign_key_primary_key_columns_mappings:
          categories_id:  id
  - name: categories_category_types
    rls_policy:
      name: "categories_category_types_table_rls_policy"
      create_tenant_column_for_table: true
    foreign_keys:
      - constraint_name:  "categories_tenant_constraint"
        table_name: "categories"
        foreign_key_primary_key_columns_mappings:
          Category_id:  id
  - name: posts_category_types
    rls_policy:
      name: "posts_category_types_table_rls_policy"
      create_tenant_column_for_table: true
    foreign_keys:
      - constraint_name:  "posts_tenant_constraint"
        table_name: "posts"
        foreign_key_primary_key_columns_mappings:
          post_id:  id