New GCP module: gcp_bigquery_table (#50678)

4 files changed, 158 insertions, 0 deletions

diff --git a/test/integration/targets/gcp_bigquery_table/aliases b/test/integration/targets/gcp_bigquery_table/aliases
new file mode 100644
index 0000000000..9812f019ca
--- /dev/null
+++ b/test/integration/targets/gcp_bigquery_table/aliases
@@ -0,0 +1,2 @@
+cloud/gcp
+unsupported
diff --git a/test/integration/targets/gcp_bigquery_table/defaults/main.yml b/test/integration/targets/gcp_bigquery_table/defaults/main.yml
new file mode 100644
index 0000000000..aa87a2a8e0
--- /dev/null
+++ b/test/integration/targets/gcp_bigquery_table/defaults/main.yml
@@ -0,0 +1,3 @@
+---
+# defaults file
+resource_name: '{{resource_prefix}}'
diff --git a/test/integration/targets/gcp_bigquery_table/meta/main.yml b/test/integration/targets/gcp_bigquery_table/meta/main.yml
new file mode 100644
index 0000000000..e69de29bb2
--- /dev/null
+++ b/test/integration/targets/gcp_bigquery_table/meta/main.yml
diff --git a/test/integration/targets/gcp_bigquery_table/tasks/main.yml b/test/integration/targets/gcp_bigquery_table/tasks/main.yml
new file mode 100644
index 0000000000..c926621b48
--- /dev/null
+++ b/test/integration/targets/gcp_bigquery_table/tasks/main.yml
@@ -0,0 +1,153 @@
+---
+# ----------------------------------------------------------------------------
+#
+#     ***     AUTO GENERATED CODE    ***    AUTO GENERATED CODE     ***
+#
+# ----------------------------------------------------------------------------
+#
+#     This file is automatically generated by Magic Modules and manual
+#     changes will be clobbered when the file is regenerated.
+#
+#     Please read more about how to change this file at
+#     https://www.github.com/GoogleCloudPlatform/magic-modules
+#
+# ----------------------------------------------------------------------------
+# Pre-test setup
+- name: create a dataset
+  gcp_bigquery_dataset:
+      name: example_dataset
+      dataset_reference:
+        dataset_id: example_dataset
+      project: "{{ gcp_project }}"
+      auth_kind: "{{ gcp_cred_kind }}"
+      service_account_file: "{{ gcp_cred_file }}"
+      state: present
+  register: dataset
+- name: delete a table
+  gcp_bigquery_table:
+      name: example_table
+      dataset: example_dataset
+      table_reference:
+        dataset_id: example_dataset
+        project_id: "{{ gcp_project }}"
+        table_id: example_table
+      project: "{{ gcp_project }}"
+      auth_kind: "{{ gcp_cred_kind }}"
+      service_account_file: "{{ gcp_cred_file }}"
+      state: absent
+#----------------------------------------------------------
+- name: create a table
+  gcp_bigquery_table:
+      name: example_table
+      dataset: example_dataset
+      table_reference:
+        dataset_id: example_dataset
+        project_id: "{{ gcp_project }}"
+        table_id: example_table
+      project: "{{ gcp_project }}"
+      auth_kind: "{{ gcp_cred_kind }}"
+      service_account_file: "{{ gcp_cred_file }}"
+      state: present
+  register: result
+- name: assert changed is true
+  assert:
+    that:
+      - result.changed == true
+      - "result.kind == 'bigquery#table'"
+- name: verify that table was created
+  gcp_bigquery_table_facts:
+      dataset: example_dataset
+      project: "{{ gcp_project }}"
+      auth_kind: "{{ gcp_cred_kind }}"
+      service_account_file: "{{ gcp_cred_file }}"
+      scopes:
+        - https://www.googleapis.com/auth/bigquery
+  register: results
+- name: verify that command succeeded
+  assert:
+    that:
+      - results['items'] | length >= 1
+# ----------------------------------------------------------------------------
+- name: create a table that already exists
+  gcp_bigquery_table:
+      name: example_table
+      dataset: example_dataset
+      table_reference:
+        dataset_id: example_dataset
+        project_id: "{{ gcp_project }}"
+        table_id: example_table
+      project: "{{ gcp_project }}"
+      auth_kind: "{{ gcp_cred_kind }}"
+      service_account_file: "{{ gcp_cred_file }}"
+      state: present
+  register: result
+- name: assert changed is false
+  assert:
+    that:
+      - result.changed == false
+      - "result.kind == 'bigquery#table'"
+#----------------------------------------------------------
+- name: delete a table
+  gcp_bigquery_table:
+      name: example_table
+      dataset: example_dataset
+      table_reference:
+        dataset_id: example_dataset
+        project_id: "{{ gcp_project }}"
+        table_id: example_table
+      project: "{{ gcp_project }}"
+      auth_kind: "{{ gcp_cred_kind }}"
+      service_account_file: "{{ gcp_cred_file }}"
+      state: absent
+  register: result
+- name: assert changed is true
+  assert:
+    that:
+      - result.changed == true
+      - result.has_key('kind') == False
+- name: verify that table was deleted
+  gcp_bigquery_table_facts:
+      dataset: example_dataset
+      project: "{{ gcp_project }}"
+      auth_kind: "{{ gcp_cred_kind }}"
+      service_account_file: "{{ gcp_cred_file }}"
+      scopes:
+        - https://www.googleapis.com/auth/bigquery
+  register: results
+- name: verify that command succeeded
+  assert:
+    that:
+      - results['items'] | length == 0
+# ----------------------------------------------------------------------------
+- name: delete a table that does not exist
+  gcp_bigquery_table:
+      name: example_table
+      dataset: example_dataset
+      table_reference:
+        dataset_id: example_dataset
+        project_id: "{{ gcp_project }}"
+        table_id: example_table
+      project: "{{ gcp_project }}"
+      auth_kind: "{{ gcp_cred_kind }}"
+      service_account_file: "{{ gcp_cred_file }}"
+      state: absent
+  register: result
+- name: assert changed is false
+  assert:
+    that:
+      - result.changed == false
+      - result.has_key('kind') == False
+#---------------------------------------------------------
+# Post-test teardown
+# If errors happen, don't crash the playbook!
+- name: delete a dataset
+  gcp_bigquery_dataset:
+      name: example_dataset
+      dataset_reference:
+        dataset_id: example_dataset
+      project: "{{ gcp_project }}"
+      auth_kind: "{{ gcp_cred_kind }}"
+      service_account_file: "{{ gcp_cred_file }}"
+      state: absent
+  register: dataset
+  ignore_errors: true