[DOP-31721] Validate SQL transformation FROM clause #2007
dolfinuscodeql-analysis.yml
on: push
Linters
1m 17s
CodeQL
1m 20s
Annotations
7 errors
|
test_create_transfer.test_developer_plus_can_create_transfer_with_sql_transformation[settings0-Owner]:
tests/test_unit/test_transfers/test_create_transfer.py#L1392
AssertionError: {"error":{"code":"invalid_request","message":"Invalid request","details":[{"location":["body","transformations",0,"sql","query"],"message":"Value error, Query must contain `FROM source` clause","code":"value_error","context":{},"input":"SELECT * FROM source"}]}}
assert 422 == 200
+ where 422 = <Response [422 Unprocessable Entity]>.status_code
|
|
test_create_transfer.test_sql_transformation_with_valid_select_queries[settings0- SELECT col1 FROM source ]:
tests/test_unit/test_transfers/test_create_transfer.py#L1461
AssertionError: {"error":{"code":"invalid_request","message":"Invalid request","details":[{"location":["body","transformations",0,"sql","query"],"message":"Value error, Query must contain `FROM source` clause","code":"value_error","context":{},"input":" SELECT col1 FROM source "}]}}
assert 422 == 200
+ where 422 = <Response [422 Unprocessable Entity]>.status_code
|
|
test_create_transfer.test_developer_plus_can_create_transfer_with_sql_transformation[settings0-Maintainer]:
tests/test_unit/test_transfers/test_create_transfer.py#L1392
AssertionError: {"error":{"code":"invalid_request","message":"Invalid request","details":[{"location":["body","transformations",0,"sql","query"],"message":"Value error, Query must contain `FROM source` clause","code":"value_error","context":{},"input":"SELECT * FROM source"}]}}
assert 422 == 200
+ where 422 = <Response [422 Unprocessable Entity]>.status_code
|
|
test_create_transfer.test_sql_transformation_with_valid_select_queries[settings0-SELECT col1, col2 FROM source WHERE col1 > 100;]:
tests/test_unit/test_transfers/test_create_transfer.py#L1461
AssertionError: {"error":{"code":"invalid_request","message":"Invalid request","details":[{"location":["body","transformations",0,"sql","query"],"message":"Value error, Query must contain `FROM source` clause","code":"value_error","context":{},"input":"SELECT col1, col2 FROM source WHERE col1 > 100;"}]}}
assert 422 == 200
+ where 422 = <Response [422 Unprocessable Entity]>.status_code
|
|
test_create_transfer.test_developer_plus_can_create_transfer_with_sql_transformation[settings0-Developer]:
tests/test_unit/test_transfers/test_create_transfer.py#L1392
AssertionError: {"error":{"code":"invalid_request","message":"Invalid request","details":[{"location":["body","transformations",0,"sql","query"],"message":"Value error, Query must contain `FROM source` clause","code":"value_error","context":{},"input":"SELECT * FROM source"}]}}
assert 422 == 200
+ where 422 = <Response [422 Unprocessable Entity]>.status_code
|
|
test_create_transfer.test_sql_transformation_with_valid_select_queries[settings0- WITH some AS (SELECT col1 FROM source) SELECT * FROM some;]:
tests/test_unit/test_transfers/test_create_transfer.py#L1461
AssertionError: {"error":{"code":"invalid_request","message":"Invalid request","details":[{"location":["body","transformations",0,"sql","query"],"message":"Value error, Query must contain `FROM source` clause","code":"value_error","context":{},"input":" WITH some AS (SELECT col1 FROM source) SELECT * FROM some;"}]}}
assert 422 == 200
+ where 422 = <Response [422 Unprocessable Entity]>.status_code
|
|
test_create_transfer.test_sql_transformation_with_valid_select_queries[settings0-select col1 from table1]:
tests/test_unit/test_transfers/test_create_transfer.py#L1461
AssertionError: {"error":{"code":"invalid_request","message":"Invalid request","details":[{"location":["body","transformations",0,"sql","query"],"message":"Value error, Query must contain `FROM source` clause","code":"value_error","context":{},"input":"select col1 from table1"}]}}
assert 422 == 200
+ where 422 = <Response [422 Unprocessable Entity]>.status_code
|