def test_read_XFERO_Scheduled_Task(self): ''' **Purpose:** SELECT rows from the XFERO_Scheduled_Task table with scheduled_task_id = 1 and confirm that the rows returned are as expected +------------+-------------+----------------------------------------------------+ | Date | Author | Change Details | +============+=============+====================================================+ | 02/06/2013 | Chris Falck | Created | +------------+-------------+----------------------------------------------------+ | 13/01/2014 | Chris Falck | Tested to confirm changes to DB | +------------+-------------+----------------------------------------------------+ ''' # Create the row in the database for t in [('FTH Housekeeping1', 'housekeeping1', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ]: self.scheduled_task_name, self.scheduled_task_function, self.scheduled_task_year, self.scheduled_task_month, self.scheduled_task_day, self.scheduled_task_week, self.scheduled_task_day_of_week, self.scheduled_task_hour, self.scheduled_task_minute, self.scheduled_task_second, self.scheduled_task_args, self.scheduled_task_active = t result = db_schedule.create_XFERO_Scheduled_Task(self.scheduled_task_name, self.scheduled_task_function, self.scheduled_task_year, self.scheduled_task_month, self.scheduled_task_day, self.scheduled_task_week, self.scheduled_task_day_of_week, self.scheduled_task_hour, self.scheduled_task_minute, self.scheduled_task_second, self.scheduled_task_args, self.scheduled_task_active) self.scheduled_task_id = '1' rows = db_schedule.read_XFERO_Scheduled_Task(self.scheduled_task_id,) expected_tuple = (1, 'FTH Housekeeping1', 'housekeeping1', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1') for row in rows: self.assertTupleEqual( expected_tuple, row, 'Unexpected row retrieved')
def Button_Add_Click(self): '''button add''' sched_task_name = self.Entry_Task_Name.get() sched_function = self.Entry_Function.get() sched_year = self.Entry_Year.get() sched_month = self.Entry_Month.get() sched_day = self.Entry_Day.get() sched_week = self.Entry_Week.get() sched_day_of_week = self.Entry_Day_of_Week.get() sched_hour = self.Entry_Hour.get() sched_minute = self.Entry_Minute.get() sched_second = self.Entry_Second.get() sched_args = self.Entry_Args.get() sched_active = self.Entry_Active.get() result = db_schedule.create_XFERO_Scheduled_Task(sched_task_name, sched_function, sched_year, sched_month, sched_day, sched_week, sched_day_of_week, sched_hour, sched_minute, sched_second, sched_args, sched_active) self.reload_tree()
def test_update_XFERO_Scheduled_Task(self): ''' **Purpose:** UPDATE rows on the XFERO_Scheduled_Task table with scheduled_task_id = 2 and confirm that the update has been applied to the table. +------------+-------------+----------------------------------------------------+ | Date | Author | Change Details | +============+=============+====================================================+ | 02/06/2013 | Chris Falck | Created | +------------+-------------+----------------------------------------------------+ | 13/01/2014 | Chris Falck | Tested to confirm changes to DB | +------------+-------------+----------------------------------------------------+ ''' # Create the row in the database for t in [('FTH Housekeeping1', 'housekeeping1', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', 1), ]: self.scheduled_task_name, self.scheduled_task_function, self.scheduled_task_year, self.scheduled_task_month, self.scheduled_task_day, self.scheduled_task_week, self.scheduled_task_day_of_week, self.scheduled_task_hour, self.scheduled_task_minute, self.scheduled_task_second, self.scheduled_task_args, self.scheduled_task_active = t result = db_schedule.create_XFERO_Scheduled_Task(self.scheduled_task_name, self.scheduled_task_function, self.scheduled_task_year, self.scheduled_task_month, self.scheduled_task_day, self.scheduled_task_week, self.scheduled_task_day_of_week, self.scheduled_task_hour, self.scheduled_task_minute, self.scheduled_task_second, self.scheduled_task_args, self.scheduled_task_active) self.scheduled_task_id = '1' self.scheduled_task_name = 'FTH HK' self.scheduled_task_function = 'housekeeping' self.scheduled_task_year = 'NULL' self.scheduled_task_month = 'NULL' self.scheduled_task_day = 'NULL' self.scheduled_task_week = 'NULL' self.scheduled_task_day_of_week = 'mon-sun' self.scheduled_task_hour = '*' self.scheduled_task_minute = '0-59' self.scheduled_task_second = '*/25' self.scheduled_task_args = '[`\/FTH/logs\', \'^FTH\', 7, False]' self.scheduled_task_active = '1' rows = db_schedule.update_XFERO_Scheduled_Task(self.scheduled_task_id, self.scheduled_task_name, self.scheduled_task_function, self.scheduled_task_year, self.scheduled_task_month, self.scheduled_task_day, self.scheduled_task_week, self.scheduled_task_day_of_week, self.scheduled_task_hour, self.scheduled_task_minute, self.scheduled_task_second, self.scheduled_task_args, self.scheduled_task_active) # Check update rows = db_schedule.read_XFERO_Scheduled_Task(self.scheduled_task_id) expected_tuple = (1, 'FTH HK', 'housekeeping', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', "[`\\/FTH/logs', '^FTH', 7, False]", '1') for row in rows: self.assertTupleEqual( expected_tuple, row, 'Unexpected row retrieved')
def test_delete_XFERO_Scheduled_Task(self): ''' **Purpose:** DELETE rows on the XFERO_Scheduled_Task table with scheduled_task_id = 1 and confirm that the deletion has been successful. +------------+-------------+----------------------------------------------------+ | Date | Author | Change Details | +============+=============+====================================================+ | 02/06/2013 | Chris Falck | Created | +------------+-------------+----------------------------------------------------+ | 13/01/2014 | Chris Falck | Tested to confirm changes to DB | +------------+-------------+----------------------------------------------------+ ''' # Create the row in the database for t in [('FTH Housekeeping1', 'housekeeping1', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ]: self.scheduled_task_name, self.scheduled_task_function, self.scheduled_task_year, self.scheduled_task_month, self.scheduled_task_day, self.scheduled_task_week, self.scheduled_task_day_of_week, self.scheduled_task_hour, self.scheduled_task_minute, self.scheduled_task_second, self.scheduled_task_args, self.scheduled_task_active = t result = db_schedule.create_XFERO_Scheduled_Task(self.scheduled_task_name, self.scheduled_task_function, self.scheduled_task_year, self.scheduled_task_month, self.scheduled_task_day, self.scheduled_task_week, self.scheduled_task_day_of_week, self.scheduled_task_hour, self.scheduled_task_minute, self.scheduled_task_second, self.scheduled_task_args, self.scheduled_task_active) self.scheduled_task_id = '1' rows = db_schedule.delete_XFERO_Scheduled_Task(self.scheduled_task_id) # Check update config = configparser.RawConfigParser() try: config.read('conf/XFERO_config.ini') except configparser.Error as e: raise e xfero_db = config.get('database', 'db_location') con = lite.connect(xfero_db) try: cur = con.cursor() cur = con.execute("pragma foreign_keys=ON") cur.execute('SELECT count(*) FROM XFERO_Scheduled_Task') except lite.Error as e: print("Error %s:" % e.args[0]) data = cur.fetchone()[0] expected = 0 self.assertEqual(expected == data, True, "Unexpected row selected")
def test_create_XFERO_Scheduled_Task(self): ''' **Purpose:** INSERT rows into the XFERO_Scheduled_Task table and confirm they have been successfully inserted +------------+-------------+----------------------------------------------------+ | Date | Author | Change Details | +============+=============+====================================================+ | 02/06/2013 | Chris Falck | Created | +------------+-------------+----------------------------------------------------+ | 13/01/2014 | Chris Falck | Tested to confirm changes to DB | +------------+-------------+----------------------------------------------------+ ''' for t in [('FTH Housekeeping1', 'housekeeping1', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping2', 'housekeeping2', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping3', 'housekeeping3', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping4', 'housekeeping4', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping5', 'housekeeping5', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping6', 'housekeeping6', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping7', 'housekeeping7', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping8', 'housekeeping8', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping9', 'housekeeping9', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping10', 'housekeeping10', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ]: self.scheduled_task_name, self.scheduled_task_function, self.scheduled_task_year, self.scheduled_task_month, self.scheduled_task_day, self.scheduled_task_week, self.scheduled_task_day_of_week, self.scheduled_task_hour, self.scheduled_task_minute, self.scheduled_task_second, self.scheduled_task_args, self.scheduled_task_active = t result = db_schedule.create_XFERO_Scheduled_Task(self.scheduled_task_name, self.scheduled_task_function, self.scheduled_task_year, self.scheduled_task_month, self.scheduled_task_day, self.scheduled_task_week, self.scheduled_task_day_of_week, self.scheduled_task_hour, self.scheduled_task_minute, self.scheduled_task_second, self.scheduled_task_args, self.scheduled_task_active) config = configparser.RawConfigParser() try: config.read('conf/XFERO_config.ini') except configparser.Error as e: raise e xfero_db = config.get('database', 'db_location') con = lite.connect(xfero_db) try: cur = con.cursor() cur = con.execute("pragma foreign_keys=ON") cur.execute('SELECT scheduled_task_id FROM XFERO_Scheduled_Task') except lite.Error as e: print("Error %s:" % e.args[0]) expected_tuple = ( (1,), (2,), (3,), (4,), (5,), (6,), (7,), (8,), (9,), (10,)) rows = cur.fetchall() for row in rows: self.assertIn(row, expected_tuple, 'Unexpected row retrieved')
def test_list_XFERO_Scheduled_Task(self): ''' **Purpose:** SELECT ALL rows on the XFERO_Scheduled_Task table and confirm that all rows have been returned successfully. +------------+-------------+----------------------------------------------------+ | Date | Author | Change Details | +============+=============+====================================================+ | 02/06/2013 | Chris Falck | Created | +------------+-------------+----------------------------------------------------+ | 13/01/2014 | Chris Falck | Tested to confirm changes to DB | +------------+-------------+----------------------------------------------------+ ''' expected_tuple = ((1, 'FTH Housekeeping1', 'housekeeping1', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', "['/FTH/logs', '^FTH', 7, False]", '1'), (2, 'FTH Housekeeping2', 'housekeeping2', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', "['/FTH/logs', '^FTH', 7, False]", '1'), (3, 'FTH Housekeeping3', 'housekeeping3', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', "['/FTH/logs', '^FTH', 7, False]", '1'), (4, 'FTH Housekeeping4', 'housekeeping4', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', "['/FTH/logs', '^FTH', 7, False]", '1'), (5, 'FTH Housekeeping5', 'housekeeping5', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', "['/FTH/logs', '^FTH', 7, False]", '1'), (6, 'FTH Housekeeping6', 'housekeeping6', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', "['/FTH/logs', '^FTH', 7, False]", '1'), (7, 'FTH Housekeeping7', 'housekeeping7', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', "['/FTH/logs', '^FTH', 7, False]", '1'), (8, 'FTH Housekeeping8', 'housekeeping8', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', "['/FTH/logs', '^FTH', 7, False]", '1'), (9, 'FTH Housekeeping9', 'housekeeping9', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', "['/FTH/logs', '^FTH', 7, False]", '1'), (10, 'FTH Housekeeping10', 'housekeeping10', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', "['/FTH/logs', '^FTH', 7, False]", '1')) for t in [('FTH Housekeeping1', 'housekeeping1', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping2', 'housekeeping2', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping3', 'housekeeping3', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping4', 'housekeeping4', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping5', 'housekeeping5', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping6', 'housekeeping6', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping7', 'housekeeping7', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping8', 'housekeeping8', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping9', 'housekeeping9', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ('FTH Housekeeping10', 'housekeeping10', 'NULL', 'NULL', 'NULL', 'NULL', 'mon-sun', '*', '0-59', '*/25', '[\'/FTH/logs\', \'^FTH\', 7, False]', '1'), ]: self.scheduled_task_name, self.scheduled_task_function, self.scheduled_task_year, self.scheduled_task_month, self.scheduled_task_day, self.scheduled_task_week, self.scheduled_task_day_of_week, self.scheduled_task_hour, self.scheduled_task_minute, self.scheduled_task_second, self.scheduled_task_args, self.scheduled_task_active = t result = db_schedule.create_XFERO_Scheduled_Task(self.scheduled_task_name, self.scheduled_task_function, self.scheduled_task_year, self.scheduled_task_month, self.scheduled_task_day, self.scheduled_task_week, self.scheduled_task_day_of_week, self.scheduled_task_hour, self.scheduled_task_minute, self.scheduled_task_second, self.scheduled_task_args, self.scheduled_task_active) rows = db_schedule.list_XFERO_Scheduled_Task() for row in rows: self.assertIn(row, expected_tuple, 'Unexpected row selected')