Skip to content
Merged
Show file tree
Hide file tree
Changes from all commits
Commits
File filter

Filter by extension

Filter by extension


Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
2 changes: 1 addition & 1 deletion go.mod
Original file line number Diff line number Diff line change
Expand Up @@ -18,7 +18,7 @@ require (
github.com/spf13/cobra v1.4.0
github.com/spf13/pflag v1.0.5
github.com/spf13/viper v1.10.1
github.com/stackql/any-sdk v0.5.2-beta02
github.com/stackql/any-sdk v0.5.2-beta03
github.com/stackql/go-suffix-map v0.0.1-alpha01
github.com/stackql/psql-wire v0.1.2-beta01
github.com/stackql/stackql-parser v0.0.16-alpha01
Expand Down
4 changes: 2 additions & 2 deletions go.sum
Original file line number Diff line number Diff line change
Expand Up @@ -467,8 +467,8 @@ github.com/spf13/pflag v1.0.5 h1:iy+VFUOCP1a+8yFto/drg2CJ5u0yRoB7fZw3DKv/JXA=
github.com/spf13/pflag v1.0.5/go.mod h1:McXfInJRrz4CZXVZOBLb0bTZqETkiAhM9Iw0y3An2Bg=
github.com/spf13/viper v1.10.1 h1:nuJZuYpG7gTj/XqiUwg8bA0cp1+M2mC3J4g5luUYBKk=
github.com/spf13/viper v1.10.1/go.mod h1:IGlFPqhNAPKRxohIzWpI5QEy4kuI7tcl5WvR+8qy1rU=
github.com/stackql/any-sdk v0.5.2-beta02 h1:94CtlIHDSdlch9SL5l0ybbtV2mI4yrU19Myu1dhF2xM=
github.com/stackql/any-sdk v0.5.2-beta02/go.mod h1:ZRTGrcDKFLaC+5yWo4OqXVs1HTNxgYM9nQsQDlq0Fe0=
github.com/stackql/any-sdk v0.5.2-beta03 h1:LuA5R6+973FJxH566Uk0OvliKQYq1qcDU4Y2l3OIy/M=
github.com/stackql/any-sdk v0.5.2-beta03/go.mod h1:ZRTGrcDKFLaC+5yWo4OqXVs1HTNxgYM9nQsQDlq0Fe0=
github.com/stackql/go-suffix-map v0.0.1-alpha01 h1:TDUDS8bySu41Oo9p0eniUeCm43mnRM6zFEd6j6VUaz8=
github.com/stackql/go-suffix-map v0.0.1-alpha01/go.mod h1:QAi+SKukOyf4dBtWy8UMy+hsXXV+yyEE4vmBkji2V7g=
github.com/stackql/psql-wire v0.1.2-beta01 h1:+0xeLLam3nbI1iv84pWJYGYw5VO5S/+eICRbdu6+dj8=
Expand Down
8 changes: 8 additions & 0 deletions test/python/stackql_test_tooling/flask/gcp/app.py
Original file line number Diff line number Diff line change
Expand Up @@ -409,5 +409,13 @@ def firewalls():
else:
return render_template('route_37_template.json'), 200, {'Content-Type': 'application/json'}



# Mock for: GET /v1/projects/<project_id>/effectiveIamPolicies
@app.route('/v1/projects/<project_id>/effectiveIamPolicies', methods=['GET'])
def v1_projects_effective_iam_policies(project_id: str):
# Return a realistic mock response for effectiveIamPolicies
return render_template('effective_iam_policies.json'), 200, {'Content-Type': 'application/json'}

if __name__ == '__main__':
app.run(debug=True)
Original file line number Diff line number Diff line change
@@ -0,0 +1,50 @@
{
"policyResults": [
{
"fullResourceName": "//cloudresourcemanager.googleapis.com/projects/demo-project",
"policies": [
{
"attachedResource": "//cloudresourcemanager.googleapis.com/projects/demo-project",
"policy": {
"bindings": [
{ "role": "roles/aiplatform.serviceAgent", "members": ["serviceAccount:service-ANONYMIZED@gcp-sa-aiplatform.iam.gserviceaccount.com"] },
{ "role": "roles/bigquery.admin", "members": ["user:demo-user@example.com"] },
{ "role": "roles/bigquery.user", "members": ["serviceAccount:demo-fivetran@demo-project.iam.gserviceaccount.com"] },
{ "role": "roles/bigquerydatatransfer.serviceAgent", "members": ["serviceAccount:service-ANONYMIZED@gcp-sa-bigquerydatatransfer.iam.gserviceaccount.com"] },
{ "role": "roles/cloudkms.serviceAgent", "members": ["serviceAccount:service-ANONYMIZED@gcp-sa-cloudkms.iam.gserviceaccount.com"] },
{ "role": "roles/compute.admin", "members": ["serviceAccount:demo-security-reviewer@demo.iam.gserviceaccount.com"] },
{ "role": "roles/compute.serviceAgent", "members": ["serviceAccount:service-ANONYMIZED@compute-system.iam.gserviceaccount.com"] },
{ "role": "roles/compute.storageAdmin", "members": ["serviceAccount:demo-minimal@demo-project.iam.gserviceaccount.com"] },
{ "role": "roles/container.defaultNodeServiceAgent", "members": ["serviceAccount:service-ANONYMIZED@gcp-sa-gkenode.iam.gserviceaccount.com"] },
{ "role": "roles/container.serviceAgent", "members": ["serviceAccount:service-ANONYMIZED@container-engine-robot.iam.gserviceaccount.com"] },
{ "role": "roles/containeranalysis.ServiceAgent", "members": ["serviceAccount:service-ANONYMIZED@container-analysis.iam.gserviceaccount.com"] },
{ "role": "roles/containerregistry.ServiceAgent", "members": ["serviceAccount:service-ANONYMIZED@containerregistry.iam.gserviceaccount.com"] },
{ "role": "roles/datafusion.serviceAgent", "members": ["serviceAccount:service-ANONYMIZED@gcp-sa-datafusion.iam.gserviceaccount.com"] },
{ "role": "roles/dataproc.serviceAgent", "members": ["serviceAccount:service-ANONYMIZED@dataproc-accounts.iam.gserviceaccount.com"] },
{ "role": "roles/editor", "members": [
"serviceAccount:ANONYMIZED-compute@developer.gserviceaccount.com",
"serviceAccount:ANONYMIZED@cloudservices.gserviceaccount.com",
"serviceAccount:demo-project@appspot.gserviceaccount.com"
] },
{ "role": "roles/firebaserules.system", "members": ["serviceAccount:service-ANONYMIZED@firebase-rules.iam.gserviceaccount.com"] },
{ "role": "roles/firestore.serviceAgent", "members": ["serviceAccount:service-ANONYMIZED@gcp-sa-firestore.iam.gserviceaccount.com"] },
{ "role": "roles/networkconnectivity.serviceAgent", "members": ["serviceAccount:service-ANONYMIZED@gcp-sa-networkconnectivity.iam.gserviceaccount.com"] },
{ "role": "roles/osconfig.serviceAgent", "members": ["serviceAccount:service-ANONYMIZED@gcp-sa-osconfig.iam.gserviceaccount.com"] },
{ "role": "roles/owner", "members": [
"serviceAccount:ci-testing-rw-principal@demo-project.iam.gserviceaccount.com",
"serviceAccount:demo-worker@demo-project.iam.gserviceaccount.com",
"serviceAccount:demo-project@demo-project.iam.gserviceaccount.com",
"serviceAccount:demo-project@demo.iam.gserviceaccount.com",
"user:demo-user@example.com",
"user:another-user@example.com"
] },
{ "role": "roles/pubsub.serviceAgent", "members": ["serviceAccount:service-ANONYMIZED@gcp-sa-pubsub.iam.gserviceaccount.com"] },
{ "role": "roles/resourcemanager.organizationAdmin", "members": ["serviceAccount:demo-project@demo-project.iam.gserviceaccount.com"] },
{ "role": "roles/viewer", "members": ["serviceAccount:ci-testing-viewer-principal@demo-project.iam.gserviceaccount.com"] }
]
}
}
]
}
]
}
Original file line number Diff line number Diff line change
Expand Up @@ -2674,8 +2674,10 @@ components:
response:
mediaType: application/json
openAPIDocKey: '200'
objectKey: $.policyResults
sqlVerbs:
select: []
select:
- $ref: '#/components/x-stackQL-resources/effective_iam_policies/methods/batch_get'
insert: []
update: []
delete: []
Expand Down
24 changes: 24 additions & 0 deletions test/robot/functional/stackql_mocked_from_cmd_line.robot
Original file line number Diff line number Diff line change
Expand Up @@ -231,6 +231,30 @@ AWS S3 Objects Select Simple
... ${SELECT_AWS_S3_OBJECTS_EXPECTED}
... ${CURDIR}/tmp/AWS-S3-Objects-Select-Simple.tmp


Google Cloud Asset IAM Policies Select With Slash In Path Param
${inputStr} = Catenate
... select fullResourceName from google.cloudasset.effective_iam_policies where scope = 'projects/mine';
${expectedStr} = Catenate SEPARATOR=\n
... |-------------------------------------------------------------|
... |${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}fullResourceName${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}${SPACE}|
... |-------------------------------------------------------------|
... |${SPACE}//cloudresourcemanager.googleapis.com/projects/demo-project${SPACE}|
... |-------------------------------------------------------------|
Should StackQL Exec Inline Equal Both Streams
... ${STACKQL_EXE}
... ${OKTA_SECRET_STR}
... ${GITHUB_SECRET_STR}
... ${K8S_SECRET_STR}
... ${REGISTRY_NO_VERIFY_CFG_STR}
... ${AUTH_CFG_STR}
... ${SQL_BACKEND_CFG_STR_CANONICAL}
... ${inputStr}
... ${expectedStr}
... ${EMPTY}
... stdout=${CURDIR}/tmp/Google-Cloud-Asset-IAM-Policies-Select-With-Slash-In-Path-Param-stdout.tmp
... stderr=${CURDIR}/tmp/Google-Cloud-Asset-IAM-Policies-Select-With-Slash-In-Path-Param-stderr.tmp

AWS S3 Objects Null Select Simple
Should Horrid Query StackQL Inline Equal
... ${STACKQL_EXE}
Expand Down
Loading