tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query
¶
Example Airflow DAG that performs query in a Cloud SQL instance.
Module Contents¶
Functions¶
Generates an ip configuration for a CloudSQL instance creation body |
|
|
Generates a CloudSQL instance creation body |
|
Generates a CloudSQL database creation body |
Attributes¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.DAG_ID = 'cloudsql-query'[source]¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.REGION = 'us-central1'[source]¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.GET_COMPOSER_NETWORK_COMMAND = Multiline-String[source]¶
Show Value
""" gcloud composer environments describe $COMPOSER_ENVIRONMENT --location=$COMPOSER_LOCATION --project=$GCP_PROJECT --format="value(config.nodeConfig.network)" """
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.CLOUD_SQL_INSTANCE_NAME_TEMPLATE[source]¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.CLOUD_SQL_INSTANCE_CREATE_BODY_TEMPLATE: dict[str, Any][source]¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.DB_PROVIDERS: Iterable[dict[str, str]] = ()[source]¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.ip_configuration()[source]¶
Generates an ip configuration for a CloudSQL instance creation body
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.cloud_sql_instance_create_body(database_provider)[source]¶
Generates a CloudSQL instance creation body
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.CLOUD_SQL_DATABASE_NAME = 'test_db'[source]¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.CLOUD_SQL_USER = 'test_user'[source]¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.CLOUD_SQL_PASSWORD = 'JoxHlwrPzwch0gz9'[source]¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.CLOUD_SQL_IP_ADDRESS = '127.0.0.1'[source]¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.CLOUD_SQL_PUBLIC_PORT = 5432[source]¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.cloud_sql_database_create_body(instance)[source]¶
Generates a CloudSQL database creation body
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.CLOUD_SQL_INSTANCE_NAME = ''[source]¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.CONNECTION_PROXY_TCP_KWARGS[source]¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.CONNECTION_PROXY_SOCKET_KWARGS[source]¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.CONNECTION_PUBLIC_TCP_KWARGS[source]¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.CONNECTION_PROXY_SOCKET_ID[source]¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.CONNECTION_PROXY_TCP_ID[source]¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.CONNECTION_PUBLIC_TCP_ID[source]¶
- tests.system.providers.google.cloud.cloud_sql.example_cloud_sql_query.SQL = ['CREATE TABLE IF NOT EXISTS TABLE_TEST (I INTEGER)', 'CREATE TABLE IF NOT EXISTS TABLE_TEST (I...[source]¶