sqlc.ci.yaml

version: "2"
plugins:
  - name: csharp
    wasm:
      url: file://dist/plugin.wasm
      sha256: SHA_TO_REPLACE
sql:
  # PostgresSQL
  - schema: "examples/config/postgresql/schema.sql"
    queries: "examples/config/postgresql/query.sql"
    engine: "postgresql"
    codegen:
      - plugin: csharp
        out: examples/NpgsqlExample
        options:
          useDapper: false
          targetFramework: net8.0
          generateCsproj: true
          namespaceName: NpgsqlExampleGen
  - schema: "examples/config/postgresql/schema.sql"
    queries: "examples/config/postgresql/query.sql"
    engine: "postgresql"
    codegen:
      - plugin: csharp
        out: examples/NpgsqlDapperExample
        options:
          useDapper: true
          targetFramework: net8.0
          generateCsproj: true
          namespaceName: NpgsqlDapperExampleGen
  - schema: "examples/config/postgresql/schema.sql"
    queries: "examples/config/postgresql/query.sql"
    engine: "postgresql"
    codegen:
      - plugin: csharp
        out: examples/NpgsqlLegacyExample
        options:
          useDapper: false
          targetFramework: netstandard2.0
          generateCsproj: true
          namespaceName: NpgsqlLegacyExampleGen
  - schema: "examples/config/postgresql/schema.sql"
    queries: "examples/config/postgresql/query.sql"
    engine: "postgresql"
    codegen:
      - plugin: csharp
        out: examples/NpgsqlDapperLegacyExample
        options:
          useDapper: true
          targetFramework: netstandard2.0
          generateCsproj: true
          namespaceName: NpgsqlDapperLegacyExampleGen
          
  # MySQL
  - schema: "examples/config/mysql/schema.sql"
    queries: "examples/config/mysql/query.sql"
    engine: "mysql"
    codegen:
      - plugin: csharp
        out: examples/MySqlConnectorExample
        options:
          useDapper: false
          targetFramework: net8.0
          generateCsproj: true
          namespaceName: MySqlConnectorExampleGen
  - schema: "examples/config/mysql/schema.sql"
    queries: "examples/config/mysql/query.sql"
    engine: "mysql"
    codegen:
      - plugin: csharp
        out: examples/MySqlConnectorDapperExample
        options:
          useDapper: true
          targetFramework: net8.0
          generateCsproj: true
          namespaceName: MySqlConnectorDapperExampleGen
  - schema: "examples/config/mysql/schema.sql"
    queries: "examples/config/mysql/query.sql"
    engine: "mysql"
    codegen:
      - plugin: csharp
        out: examples/MySqlConnectorLegacyExample
        options:
          useDapper: false
          targetFramework: netstandard2.0
          generateCsproj: true
          namespaceName: MySqlConnectorLegacyExampleGen
  - schema: "examples/config/mysql/schema.sql"
    queries: "examples/config/mysql/query.sql"
    engine: "mysql"
    codegen:
      - plugin: csharp
        out: examples/MySqlConnectorDapperLegacyExample
        options:
          useDapper: true
          targetFramework: netstandard2.0
          generateCsproj: true
          namespaceName: MySqlConnectorDapperLegacyExampleGen
          
  # Sqlite
  - schema: "examples/config/sqlite/schema.sql"
    queries: "examples/config/sqlite/query.sql"
    engine: "sqlite"
    codegen:
      - plugin: csharp
        out: examples/SqliteExample
        options:
          useDapper: false
          targetFramework: net8.0
          generateCsproj: true
          namespaceName: SqliteExampleGen
  - schema: "examples/config/sqlite/schema.sql"
    queries: "examples/config/sqlite/query.sql"
    engine: "sqlite"
    codegen:
      - plugin: csharp
        out: examples/SqliteDapperExample
        options:
          useDapper: true
          targetFramework: net8.0
          generateCsproj: true
          namespaceName: SqliteDapperExampleGen
  - schema: "examples/config/sqlite/schema.sql"
    queries: "examples/config/sqlite/query.sql"
    engine: "sqlite"
    codegen:
      - plugin: csharp
        out: examples/SqliteLegacyExample
        options:
          useDapper: false
          targetFramework: netstandard2.0
          generateCsproj: true
          namespaceName: SqliteLegacyExampleGen
  - schema: "examples/config/sqlite/schema.sql"
    queries: "examples/config/sqlite/query.sql"
    engine: "sqlite"
    codegen:
      - plugin: csharp
        out: examples/SqliteDapperLegacyExample
        options:
          useDapper: true
          targetFramework: netstandard2.0
          generateCsproj: true
          namespaceName: SqliteDapperLegacyExampleGen