Airflow调度-MysqlOperator

一个对mysql数据库表的操作的调度：

这里用到了BashOperator和MySqlOperator

# -*- coding: utf-8 -*-
import airflow
from airflow import DAG
from airflow.operators.mysql_operator import MySqlOperator
from datetime import timedelta
from airflow.operators.bash_operator import BashOperator
default_args = {
 'owner': 'cico',
 'depends_on_past': False,
 'start_date': airflow.utils.dates.days_ago(2),
 'retries': 1, # 重试次数
 'retry_delay': timedelta(minutes=1), # 运行间隔时间
}

dag = DAG(
 'MysqlOperator', # DAG名字
 default_args=default_args,
 description='my first DAG',
 schedule_interval=timedelta(days=1))

creatsql = """ 
  CREATE TABLE  if  not  exists `log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dttm` timestamp(6) NULL DEFAULT NULL,
  `dag_id` varchar(250) DE