typr.yaml

boundaries:
  grpc-services:
    proto_path: testers/grpc/protos
    type: grpc
  oracle:
    service: FREEPDB1
    host: localhost
    sql_scripts: sql-scripts/oracle
    username: typr
    types:
      Email:
        db:
          column: email
    selectors:
      exclude_tables:
      - test_genkeys_1767399918202
      - test_genkeys_1767491891912
      - test_json_rt_1767496451381
      - test_table_1767489875539
      precision_types:
      - PRECISION_TYPES
      - PRECISION_TYPES_NULL
    schema_mode: single_schema:TYPR
    port: 1521
    type: oracle
    password: typr_password
  avro-events:
    default_header_schema: standard
    header_schemas:
      standard:
        fields:
        - name: correlationId
          required: true
          type: uuid
        - name: timestamp
          required: true
          type: instant
        - name: source
          required: false
          type: string
    schemas:
    - testers/avro/schemas
    enable_precise_types: true
    type: avro
    topic_headers:
      order-events: standard
    generate_kafka_rpc: true
  postgres:
    schemas:
    - humanresources
    - person
    - production
    - public
    - sales
    password: password
    type: postgresql
    username: postgres
    port: 6432
    types:
      LastName:
        db:
          column: lastname
      Description:
        db:
          column: description
      CurrentFlag:
        db:
          column: currentflag
      MiddleName:
        db:
          column: middlename
      FirstName:
        db:
          column: firstname
      OnlineOrderFlag:
        db:
          column: onlineorderflag
      SalariedFlag:
        db:
          column: salariedflag
      ActiveFlag:
        db:
          column: activeflag
    type_override:
      sales.creditcard.creditcardid: adventureworks.userdefined.CustomCreditcardId
    selectors:
      open_enums:
      - title
      - title_domain
      - issue142
      precision_types:
      - precision_types
      - precision_types_null
      tables:
      - department
      - employee
      - employeedepartmenthistory
      - shift
      - vemployee
      - address
      - addresstype
      - businessentity
      - businessentityaddress
      - countryregion
      - emailaddress
      - password
      - person
      - stateprovince
      - product
      - productcategory
      - productcosthistory
      - productmodel
      - productsubcategory
      - unitmeasure
      - flaff
      - identity-test
      - issue142
      - issue142_2
      - only_pk_columns
      - pgtest
      - pgtestnull
      - title
      - title_domain
      - titledperson
      - users
      - salesperson
      - salesterritory
      - precision_types
      - precision_types_null
    database: Adventureworks
    sql_scripts: sql-scripts/postgres
    host: localhost
  sqlserver:
    database: typr
    port: 1433
    schema_mode: single_schema:dbo
    host: localhost
    selectors:
      precision_types:
      - precision_types
      - precision_types_null
    username: sa
    password: YourStrong@Passw0rd
    types:
      Email:
        db:
          column:
          - email
          - '*_email'
    type: sqlserver
    sql_scripts: sql-scripts/sqlserver
  mariadb:
    selectors:
      precision_types:
      - precision_types
      - precision_types_null
    sql_scripts: sql-scripts/mariadb
    host: localhost
    schema_mode: single_schema:typr
    port: 3307
    types:
      IsDefault:
        db:
          column: is_default
      IsVerifiedPurchase:
        db:
          column: is_verified_purchase
      Email:
        db:
          column:
          - email
          - contact_email
      LastName:
        db:
          column: last_name
      IsPrimary:
        db:
          column: is_primary
      IsActive:
        db:
          column: is_active
      FirstName:
        db:
          column: first_name
      IsApproved:
        db:
          column: is_approved
    username: typr
    type: mariadb
    database: typr
    password: password
  api:
    generate_models: true
    generate_server: true
    spec: testers/combined/specs/combined-api.yaml
    type: openapi
  duckdb:
    schema_sql: sql-init/duckdb/00-schema.sql
    selectors:
      precision_types:
      - precision_types
      - precision_types_null
    sql_scripts: sql-scripts/duckdb
    path: ':memory:'
    types:
      Email:
        db:
          column: email
    type: duckdb
  sqlite:
    schema_sql: sql-init/sqlite/00-schema.sql
    selectors:
      precision_types:
      - precision_types
      - precision_types_null
    sql_scripts: sql-scripts/sqlite
    path: ':memory:'
    types:
      Email:
        db:
          column: email
    type: sqlite
  db2:
    username: db2inst1
    password: password
    schema_mode: single_schema:DB2INST1
    host: localhost
    sql_scripts: sql-scripts/db2
    type: db2
    database: typr
    port: 50000
outputs:
  postgres-scala-scalatypes:
    matchers:
      mock_repos:
        exclude:
        - purchaseorderdetail
      primary_key_types:
        exclude:
        - billofmaterials
      readonly:
      - purchaseorderdetail
      test_inserts: all
    path: testers/pg/scala/scalatypes/generated-and-checked-in
    json: jackson
    language: scala
    package: adventureworks
    sources: postgres
    db_lib: foundations
    scala:
      dialect: scala3
      dsl: scala
  duckdb-java:
    path: testers/duckdb/java/generated-and-checked-in
    package: testdb
    json: jackson
    sources: duckdb
    language: java
    db_lib: foundations
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
  grpc-java-spring:
    package: com.example.grpc
    path: testers/grpc/java-spring/generated-and-checked-in
    framework: spring
    language: java
    sources: grpc-services
  grpc-kotlin-quarkus:
    framework: quarkus
    package: com.example.grpc
    language: kotlin
    sources: grpc-services
    path: testers/grpc/kotlin-quarkus/generated-and-checked-in
    effect_type: mutiny_uni
  postgres-anorm-scala3:
    path: testers/pg/scala/anorm/generated-and-checked-in-3
    json: play-json
    scala:
      dialect: scala3
      dsl: legacy
    package: adventureworks
    sources: postgres
    language: scala
    db_lib: anorm
    matchers:
      mock_repos:
        exclude:
        - purchaseorderdetail
      primary_key_types:
        exclude:
        - billofmaterials
      readonly:
      - purchaseorderdetail
      test_inserts: all
  oracle-kotlin:
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
    language: kotlin
    path: testers/oracle/kotlin/generated-and-checked-in
    db_lib: foundations
    package: oracledb
    json: jackson
    sources: oracle
  postgres-scala-javatypes:
    db_lib: foundations
    package: adventureworks
    path: testers/pg/scala/javatypes/generated-and-checked-in
    json: jackson
    language: scala
    matchers:
      mock_repos:
        exclude:
        - purchaseorderdetail
      primary_key_types:
        exclude:
        - billofmaterials
      readonly:
      - purchaseorderdetail
      test_inserts: all
    scala:
      dialect: scala3
      dsl: java
      use_native_types: false
    sources: postgres
  avro-scala-cats:
    effect_type: cats_io
    language: scala
    path: testers/avro/scala-cats/generated-and-checked-in
    package: com.example.events
    framework: cats
    scala:
      dialect: scala3
      dsl: scala
    sources: avro-events
  postgres-zio-jdbc-scala3:
    json: zio-json
    path: testers/pg/scala/zio-jdbc/generated-and-checked-in-3
    db_lib: zio-jdbc
    package: adventureworks
    language: scala
    matchers:
      mock_repos:
        exclude:
        - purchaseorderdetail
      primary_key_types:
        exclude:
        - billofmaterials
      readonly:
      - purchaseorderdetail
      test_inserts: all
    sources: postgres
    scala:
      dialect: scala3
      dsl: legacy
  duckdb-scala:
    json: jackson
    db_lib: foundations
    package: testdb
    sources: duckdb
    language: scala
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
    path: testers/duckdb/scala/generated-and-checked-in
    scala:
      dialect: scala3
      dsl: scala
  grpc-kotlin:
    language: kotlin
    package: com.example.grpc
    path: testers/grpc/kotlin/generated-and-checked-in
    sources: grpc-services
  duckdb-kotlin:
    language: kotlin
    db_lib: foundations
    package: testdb
    json: jackson
    sources: duckdb
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
    path: testers/duckdb/kotlin/generated-and-checked-in
  mariadb-java:
    json: jackson
    package: testdb
    language: java
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
    db_lib: foundations
    path: testers/mariadb/java/generated-and-checked-in
    sources: mariadb
  mariadb-kotlin:
    package: testdb
    json: jackson
    sources: mariadb
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
    path: testers/mariadb/kotlin/generated-and-checked-in
    language: kotlin
    db_lib: foundations
  db2-java:
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
    package: testdb
    db_lib: foundations
    language: java
    json: jackson
    sources: db2
    path: testers/db2/java/generated-and-checked-in
  sqlserver-scala:
    language: scala
    json: jackson
    sources: sqlserver
    path: testers/sqlserver/scala/generated-and-checked-in
    scala:
      dialect: scala3
      dsl: scala
    db_lib: foundations
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
    package: testdb
  mariadb-scala:
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
    db_lib: foundations
    path: testers/mariadb/scala/generated-and-checked-in
    package: testdb
    json: jackson
    scala:
      dialect: scala3
      dsl: scala
    sources: mariadb
    language: scala
  db2-scala:
    db_lib: foundations
    path: testers/db2/scala/generated-and-checked-in
    package: testdb
    language: scala
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
    scala:
      dialect: scala3
      dsl: scala
    sources: db2
    json: jackson
  sqlserver-kotlin:
    sources: sqlserver
    package: testdb
    language: kotlin
    json: jackson
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
    path: testers/sqlserver/kotlin/generated-and-checked-in
    db_lib: foundations
  postgres-anorm-scala2:
    sources: postgres
    package: adventureworks
    path: testers/pg/scala/anorm/generated-and-checked-in-2.13
    db_lib: anorm
    matchers:
      mock_repos:
        exclude:
        - purchaseorderdetail
      primary_key_types:
        exclude:
        - billofmaterials
      readonly:
      - purchaseorderdetail
      test_inserts: all
    scala:
      dialect: scala2
      dsl: legacy
    json: play-json
    language: scala
  db2-kotlin:
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
    path: testers/db2/kotlin/generated-and-checked-in
    json: jackson
    language: kotlin
    package: testdb
    sources: db2
    db_lib: foundations
  oracle-scala-new:
    path: testers/oracle/scala-new/generated-and-checked-in
    language: scala
    sources: oracle
    package: oracledb
    json: jackson
    scala:
      dialect: scala3
      dsl: scala
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
    db_lib: foundations
  postgres-zio-jdbc-scala2:
    sources: postgres
    scala:
      dialect: scala2
      dsl: legacy
    language: scala
    json: zio-json
    matchers:
      mock_repos:
        exclude:
        - purchaseorderdetail
      primary_key_types:
        exclude:
        - billofmaterials
      readonly:
      - purchaseorderdetail
      test_inserts: all
    db_lib: zio-jdbc
    package: adventureworks
    path: testers/pg/scala/zio-jdbc/generated-and-checked-in-2.13
  oracle-scala:
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
    scala:
      dialect: scala3
      dsl: java
      use_native_types: false
    json: jackson
    language: scala
    sources: oracle
    db_lib: foundations
    path: testers/oracle/scala/generated-and-checked-in
    package: oracledb
  postgres-java:
    package: adventureworks
    sources: postgres
    language: java
    matchers:
      mock_repos:
        exclude:
        - purchaseorderdetail
      primary_key_types:
        exclude:
        - billofmaterials
      readonly:
      - purchaseorderdetail
      test_inserts: all
    path: testers/pg/java/generated-and-checked-in
    db_lib: foundations
    json: jackson
  postgres-doobie-scala3:
    json: circe
    language: scala
    matchers:
      mock_repos:
        exclude:
        - purchaseorderdetail
      primary_key_types:
        exclude:
        - billofmaterials
      readonly:
      - purchaseorderdetail
      test_inserts: all
    scala:
      dialect: scala3
      dsl: legacy
    sources: postgres
    package: adventureworks
    db_lib: doobie
    path: testers/pg/scala/doobie/generated-and-checked-in-3
  grpc-java-quarkus:
    package: com.example.grpc
    sources: grpc-services
    framework: quarkus
    path: testers/grpc/java-quarkus/generated-and-checked-in
    language: java
  sqlserver-java:
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
    language: java
    path: testers/sqlserver/java/generated-and-checked-in
    db_lib: foundations
    sources: sqlserver
    package: testdb
    json: jackson
  grpc-scala:
    path: testers/grpc/scala/generated-and-checked-in
    language: scala
    scala:
      dialect: scala3
      dsl: scala
    package: com.example.grpc
    sources: grpc-services
  grpc-scala-cats:
    package: com.example.grpc
    sources: grpc-services
    scala:
      dialect: scala3
      dsl: scala
    effect_type: cats_io
    path: testers/grpc/scala-cats/generated-and-checked-in
    framework: cats
    language: scala
  combined-kotlin:
    language: kotlin
    package: combined
    matchers:
      mock_repos: all
      primary_key_types: all
    json: jackson
    path: testers/combined/kotlin/generated-and-checked-in
    db_lib: foundations
    sources:
    - postgres
    - mariadb
    - api
    - avro-events
    effect_type: mutiny_uni
  combined-java:
    json: jackson
    sources:
    - postgres
    - mariadb
    - api
    - avro-events
    path: testers/combined/java/generated-and-checked-in
    package: combined
    language: java
    db_lib: foundations
    matchers:
      mock_repos: all
      primary_key_types: all
    effect_type: completable_future
  postgres-kotlin:
    json: jackson
    package: adventureworks
    matchers:
      mock_repos:
        exclude:
        - purchaseorderdetail
      primary_key_types:
        exclude:
        - billofmaterials
      readonly:
      - purchaseorderdetail
      test_inserts: all
    sources: postgres
    path: testers/pg/kotlin/generated-and-checked-in
    db_lib: foundations
    language: kotlin
  postgres-doobie-scala2:
    language: scala
    matchers:
      mock_repos:
        exclude:
        - purchaseorderdetail
      primary_key_types:
        exclude:
        - billofmaterials
      readonly:
      - purchaseorderdetail
      test_inserts: all
    db_lib: doobie
    package: adventureworks
    json: circe
    scala:
      dialect: scala2
      dsl: legacy
    path: testers/pg/scala/doobie/generated-and-checked-in-2.13
    sources: postgres
  oracle-java:
    sources: oracle
    json: jackson
    db_lib: foundations
    language: java
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
    package: oracledb
    path: testers/oracle/java/generated-and-checked-in
  grpc-java:
    language: java
    package: com.example.grpc
    path: testers/grpc/java/generated-and-checked-in
    sources: grpc-services
  sqlite-java:
    path: testers/sqlite/java/generated-and-checked-in
    package: testdb
    json: jackson
    sources: sqlite
    language: java
    db_lib: foundations
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
  sqlite-kotlin:
    path: testers/sqlite/kotlin/generated-and-checked-in
    package: testdb
    json: jackson
    sources: sqlite
    language: kotlin
    db_lib: foundations
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
  sqlite-scala:
    path: testers/sqlite/scala/generated-and-checked-in
    package: testdb
    json: jackson
    sources: sqlite
    language: scala
    db_lib: foundations
    scala:
      dialect: scala3
      dsl: scala
    matchers:
      mock_repos: all
      primary_key_types: all
      test_inserts: all
types:
  Customer:
    fields:
      created_at:
        array: false
        nullable: true
        type: String
      customer_id:
        array: false
        nullable: false
        type: String
      email:
        array: false
        nullable: true
        type: String
    alignedSources:
      duckdb:customers:
        entity: customers
        mode: superset
      mariadb:customers:
        entity: customers
        mode: superset
    primary: sqlserver:customers
    kind: domain
version: 1