def test_check_operators(self):
conn_id = "sqlite_default"
captainHook = BaseHook.get_hook(conn_id=conn_id)
captainHook.run("CREATE TABLE operator_test_table (a, b)")
captainHook.run("insert into operator_test_table values (1,2)")
t = operators.CheckOperator(
task_id='check',
sql="select count(*) from operator_test_table" ,
conn_id=conn_id,
dag=self.dag)
t.run(start_date=DEFAULT_DATE, end_date=DEFAULT_DATE, force=True)
t = operators.ValueCheckOperator(
task_id='value_check',
pass_value=95,
tolerance=0.1,
conn_id=conn_id,
sql="SELECT 100",
dag=self.dag)
t.run(start_date=DEFAULT_DATE, end_date=DEFAULT_DATE, force=True)
captainHook.run("drop table operator_test_table")
def test_check_operators(self):
t = operators.CheckOperator(
task_id='check',
sql="SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES",
conn_id="mysql_default",
dag=self.dag)
t.run(start_date=DEFAULT_DATE, end_date=DEFAULT_DATE, force=True)
t = operators.ValueCheckOperator(task_id='value_check',
pass_value=95,
tolerance=0.1,
conn_id="mysql_default",
sql="SELECT 100",
dag=self.dag)
t.run(start_date=DEFAULT_DATE, end_date=DEFAULT_DATE, force=True)