Python QueryRunner.recreate_stored_procedure Examples

Example #1

File: transformation_dag_builder.py Project: teamdatatonic/dop

def exec_recreate_stored_procedure(task, runner: QueryRunner, **kwargs):
    airflow_context = kwargs["airflow_context"]
    relation = create_relation_from_task(task=task)
    sql = airflow_context["templates_dict"]["sql"]

    arguments = task.options.get("arguments", [])
    runner.recreate_stored_procedure(arguments=arguments,
                                     query=sql,
                                     relation=relation)

Example #2

def exec_recreate_stored_procedure(task, runner: QueryRunner, **kwargs):
    airflow_context = kwargs['airflow_context']
    relation = create_relation_from_task(task=task)
    sql = airflow_context['templates_dict']['sql']

    arguments = task.options.get('arguments', [])
    runner.recreate_stored_procedure(
        arguments=arguments,
        query=sql,
        relation=relation
    )