turbaszek commented on code in PR #23583:
URL: https://github.com/apache/airflow/pull/23583#discussion_r874436669


##########
tests/system/providers/google/cloud_sql/example_cloud_sql.py:
##########
@@ -272,64 +235,72 @@
 
     # [START howto_operator_cloudsql_db_delete]
     sql_db_delete_task = CloudSQLDeleteInstanceDatabaseOperator(
-        project_id=GCP_PROJECT_ID, instance=INSTANCE_NAME, database=DB_NAME, 
task_id='sql_db_delete_task'
-    )
-    sql_db_delete_task2 = CloudSQLDeleteInstanceDatabaseOperator(
-        instance=INSTANCE_NAME, database=DB_NAME, task_id='sql_db_delete_task2'
+        instance=INSTANCE_NAME, database=DB_NAME, task_id='sql_db_delete_task'
     )
     # [END howto_operator_cloudsql_db_delete]
+    sql_db_delete_task.trigger_rule = TriggerRule.ALL_DONE
 
     # ############################################## #
     # ### INSTANCES TEAR DOWN ###################### #
     # ############################################## #
 
     # [START howto_operator_cloudsql_replicas_delete]
     sql_instance_failover_replica_delete_task = CloudSQLDeleteInstanceOperator(
-        project_id=GCP_PROJECT_ID,
         instance=FAILOVER_REPLICA_NAME,
         task_id='sql_instance_failover_replica_delete_task',
     )
 
     sql_instance_read_replica_delete_task = CloudSQLDeleteInstanceOperator(
-        project_id=GCP_PROJECT_ID, instance=READ_REPLICA_NAME, 
task_id='sql_instance_read_replica_delete_task'
+        instance=READ_REPLICA_NAME, 
task_id='sql_instance_read_replica_delete_task'
     )
     # [END howto_operator_cloudsql_replicas_delete]
+    sql_instance_failover_replica_delete_task.trigger_rule = 
TriggerRule.ALL_DONE
+    sql_instance_read_replica_delete_task.trigger_rule = TriggerRule.ALL_DONE
 
     # [START howto_operator_cloudsql_delete]
     sql_instance_delete_task = CloudSQLDeleteInstanceOperator(
-        project_id=GCP_PROJECT_ID, instance=INSTANCE_NAME, 
task_id='sql_instance_delete_task'
-    )
-    sql_instance_delete_task2 = CloudSQLDeleteInstanceOperator(
-        project_id=GCP_PROJECT_ID, instance=INSTANCE_NAME2, 
task_id='sql_instance_delete_task2'
+        instance=INSTANCE_NAME, task_id='sql_instance_delete_task'
     )
     # [END howto_operator_cloudsql_delete]
+    sql_instance_delete_task.trigger_rule = TriggerRule.ALL_DONE
+
+    delete_bucket = GCSDeleteBucketOperator(
+        task_id="delete_bucket", bucket_name=BUCKET_NAME, 
trigger_rule=TriggerRule.ALL_DONE
+    )
 
     (
-        sql_instance_create_task
-        >> sql_instance_create_2_task
+        # TEST SETUP
+        create_bucket
+        # TEST BODY
+        >> sql_instance_create_task
         >> sql_instance_read_replica_create
         >> sql_instance_patch_task
-        >> sql_instance_patch_task2
         >> sql_db_create_task
-        >> sql_db_create_task2
         >> sql_db_patch_task
-        >> sql_db_patch_task2
         >> sql_gcp_add_bucket_permission_task
         >> sql_export_task
-        >> sql_export_task2
         >> sql_gcp_add_object_permission_task
-        >> sql_gcp_add_bucket_permission_2_task
         >> sql_import_task
-        >> sql_import_task2
         >> sql_db_delete_task
-        >> sql_db_delete_task2
         >> sql_instance_failover_replica_delete_task
         >> sql_instance_read_replica_delete_task
         >> sql_instance_delete_task
-        >> sql_instance_delete_task2
+        # TEST TEARDOWN
+        >> delete_bucket
     )
 
     # Task dependencies created via `XComArgs`:
     #   sql_instance_create_task >> sql_gcp_add_bucket_permission_task
-    #   sql_instance_create_2_task >> sql_gcp_add_object_permission_task
-    #   sql_instance_create_2_task >> sql_gcp_add_bucket_permission_2_task
+    #   sql_instance_create_task >> sql_gcp_add_object_permission_task
+
+    from tests.system.utils.watcher import watcher
+
+    # This test needs watcher in order to properly mark success/failure
+    # when "tearDown" task with trigger rule is part of the DAG
+    list(dag.tasks) >> watcher()
+
+
+from tests.system.utils import get_test_run  # noqa: E402
+
+# Needed to run the example DAG with pytest (see: 
tests/system/README.md#run_via_pytest)
+test_run = get_test_run(dag)

Review Comment:
   Shouldn't it be in `__main__`?



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to