0f4df23290
Some checks failed
kotlin / test (push) Has been skipped
python / test (push) Has been skipped
typescript / test (push) Has been skipped
go / build darwin/amd64 (push) Has been cancelled
go / build linux/amd64 (push) Has been cancelled
go / build windows/amd64 (push) Has been cancelled
go / build darwin/arm64 (push) Has been cancelled
go / build linux/arm64 (push) Has been cancelled
go / build windows/arm64 (push) Has been cancelled
go / test (push) Has been cancelled
go / vuln_check (push) Has been cancelled
53 lines
1.2 KiB
YAML
53 lines
1.2 KiB
YAML
version: '2'
|
|
cloud:
|
|
project: "01HAQMMECEYQYKFJN8MP16QC41"
|
|
sql:
|
|
- name: postgresql
|
|
schema: postgresql/schema.sql
|
|
queries: postgresql/query.sql
|
|
engine: postgresql
|
|
database:
|
|
uri: "${VET_TEST_EXAMPLES_POSTGRES_AUTHORS}"
|
|
analyzer:
|
|
database: false
|
|
rules:
|
|
- sqlc/db-prepare
|
|
- postgresql-query-too-costly
|
|
gen:
|
|
go:
|
|
package: authors
|
|
sql_package: pgx/v5
|
|
out: postgresql
|
|
- name: mysql
|
|
schema: mysql/schema.sql
|
|
queries: mysql/query.sql
|
|
engine: mysql
|
|
database:
|
|
uri: "${VET_TEST_EXAMPLES_MYSQL_AUTHORS}"
|
|
rules:
|
|
- sqlc/db-prepare
|
|
# - mysql-query-too-costly
|
|
gen:
|
|
go:
|
|
package: authors
|
|
out: mysql
|
|
- name: sqlite
|
|
schema: sqlite/schema.sql
|
|
queries: sqlite/query.sql
|
|
engine: sqlite
|
|
database:
|
|
uri: file:authors?mode=memory&cache=shared
|
|
rules:
|
|
- sqlc/db-prepare
|
|
gen:
|
|
go:
|
|
package: authors
|
|
out: sqlite
|
|
rules:
|
|
- name: postgresql-query-too-costly
|
|
message: "Too costly"
|
|
rule: "postgresql.explain.plan.total_cost > 300.0"
|
|
- name: mysql-query-too-costly
|
|
message: "Too costly"
|
|
rule: "has(mysql.explain.query_block.cost_info) && double(mysql.explain.query_block.cost_info.query_cost) > 2.0"
|