def Button_Add_Click(self): '''Button add click''' func_name = self.Entry_Function_Name.get() func_description = self.Entry_Function_Description.get() func_class = self.Entry_Function_Class.get() func_prototype = self.Entry_Function_Prototype.get() result = db_function.create_XFERO_Function( func_name, func_class, func_description, func_prototype) self.reload_tree()
def test_delete_XFERO_Function(self): ''' **Purpose:** DELETE rows on the XFERO_Function table with function_id = 1 and confirm that the deletion has been successful. +------------+-------------+-------------------------------------------+ | Date | Author | Change Details | +============+=============+===========================================+ | 02/06/2013 | Chris Falck | Created | +------------+-------------+-------------------------------------------+ | 10/01/2014 | Chris Falck | Tested to confirm changes to DB | +------------+-------------+-------------------------------------------+ ''' # Create the row in the database for tst in [('avcheck', 'Function to Anti-Virus check a file', 'NULL'), ]: (self.function_name, self.function_description, self.function_prototype) = tst result = db_function.create_XFERO_Function( self.function_name, self.function_description, self.function_prototype) # Perform the select self.function_id = '1' rows = db_function.delete_XFERO_Function(self.function_id) # Check update config = configparser.RawConfigParser() try: config.read('conf/XFERO_config.ini') except configparser.Error as err: raise err 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_Function') except lite.Error as err: print("Error %s:" % err.args[0]) data = cur.fetchone()[0] expected = 0 self.assertEqual(expected == data, True, "Unexpected row selected")
def test_update_XFERO_Function(self): ''' **Purpose:** UPDATE rows on the XFERO_Function table with function_id = 1 and confirm that the update has been applied to the table. +------------+-------------+-------------------------------------------+ | Date | Author | Change Details | +============+=============+===========================================+ | 02/06/2013 | Chris Falck | Created | +------------+-------------+-------------------------------------------+ | 10/01/2014 | Chris Falck | Tested to confirm changes to DB | +------------+-------------+-------------------------------------------+ ''' # Create the row in the database for tst in [('avcheck', 'Anti_Virus', 'Function to Anti-Virus check a file', 'NULL'), ]: (self.function_name, self.function_class, self.function_description, self.function_prototype) = tst result = db_function.create_XFERO_Function( self.function_name, self.function_class, self.function_description, self.function_prototype) # Perform the select self.function_id = '1' self.function_name = 'new_func' self.function_description = 'Function to Anti-Virus check a file' self.function_prototype = 'NULL' rows = db_function.update_XFERO_Function( self.function_id, self.function_name, self.function_class, self.function_description, self.function_prototype) expected_tuple = ( 1, 'new_func', 'Anti_Virus', 'Function to Anti-Virus check a file', 'NULL') for row in rows: self.assertTupleEqual( expected_tuple, row, 'Unexpected row retrieved')
def test_read_with_name_XFERO_Function(self): ''' **Purpose:** SELECT rows from the XFERO_Function table with function_name and confirm that the rows returned are as expected +------------+-------------+-------------------------------------------+ | Date | Author | Change Details | +============+=============+===========================================+ | 02/06/2013 | Chris Falck | Created | +------------+-------------+-------------------------------------------+ | 10/01/2014 | Chris Falck | Tested to confirm changes to DB | +------------+-------------+-------------------------------------------+ ''' # Create the row in the database for tst in [('avcheck', 'Anti_Virus', 'Function to Anti-Virus check a file', 'NULL'), ]: (self.function_name, self.function_class, self.function_description, self.function_prototype) = tst result = db_function.create_XFERO_Function( self.function_name, self.function_class, self.function_description, self.function_prototype) # Perform the select self.function_name = 'avcheck' rows = db_function.read_with_name_XFERO_Function(self.function_name) expected_tuple = ( 1, 'avcheck', 'Function to Anti-Virus check a file', 'NULL') for row in rows: self.assertTupleEqual( expected_tuple, row, 'Unexpected row retrieved')
def test_create_XFERO_Function(self): ''' **Purpose:** INSERT rows into the XFERO_Function table and confirm they have been successfully inserted +------------+-------------+-------------------------------------------+ | Date | Author | Change Details | +============+=============+===========================================+ | 02/06/2013 | Chris Falck | Created | +------------+-------------+-------------------------------------------+ | 08/01/2014 | Chris Falck | Added additional inputs to be tested | +------------+-------------+-------------------------------------------+ | 10/01/2014 | Chris Falck | Tested to confirm changes to DB | +------------+-------------+-------------------------------------------+ ''' for tst in [('move_file', 'Copy_File', 'Function to Move a file to a specified directory', 'target_directory={Enter_value}'), ('compress_entities', 'Manage_Archives', 'Function to tar.gz or zip files', 'entities={Enter_value} archive_name={Enter_value} \ subdir={Enter_value}'), ]: (self.function_name, self.function_class, self.function_description, self.function_prototype) = tst result = db_function.create_XFERO_Function( self.function_name, self.function_class, self.function_description, self.function_prototype) config = configparser.RawConfigParser() try: config.read('conf/XFERO_config.ini') except configparser.Error as err: raise err 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 function_id FROM XFERO_Function') except lite.Error as err: print("Error %s:" % err.args[0]) expected_tuple = ( (1,), (2,), (3,), (4,), (5,), (6,), (7,), (8,), (9,), (10,), (11,)) rows = cur.fetchall() for row in rows: self.assertIn(row, expected_tuple, 'Unexpected row retrieved')
def test_list_XFERO_Function(self): ''' **Purpose:** SELECT ALL rows on the XFERO_Function table and confirm that all rows have been returned successfully. +------------+-------------+-------------------------------------------+ | Date | Author | Change Details | +============+=============+===========================================+ | 02/06/2013 | Chris Falck | Created | +------------+-------------+-------------------------------------------+ | 08/01/2014 | Chris Falck | Added additional inputs to be tested | +------------+-------------+-------------------------------------------+ | 10/01/2014 | Chris Falck | Tested to confirm changes to DB | +------------+-------------+-------------------------------------------+ ''' expected_tuple = ((1, 'move_file', 'Function to Move a file to a specified directory', 'target_directory={Enter_value}'), (2, 'xfer_file', 'Function to transfer a file', 'NULL'), (3, 'XFERO_exit', 'Function to enable the execution of \ external programs', 'exit_script={Enter_value}'), (4, 'compress_entities', 'Function to tar.gz or \ zip files', 'entities={Enter_value} archive_name={Enter_value} \ subdir={Enter_value}'), (5, 'xform', 'Function to transform a file name', 'NULL'), (6, 'encrypt', 'Function to encrypt a file', 'NULL'), (7, 'decrypt', 'Function to decrypt a file', 'NULL'), (8, 'cksum', 'Function to produce a Checksum of a file', 'NULL'), (9, 'split_file', 'Function to split a large file into smaller files', 'NULL'), (10, 'merge_file', 'Function to merge split file', 'NULL'), (11, 'avcheck', 'Function to Anti-Virus check a file', 'NULL')) for tst in [('move_file', 'Function to Move a file to a specified directory', 'target_directory={Enter_value}'), ('xfer_file', 'Function to transfer a file', 'NULL'), ('XFERO_exit', 'Function to enable the execution of external \ programs', 'exit_script={Enter_value}'), ('compress_entities', 'Function to tar.gz or zip files', 'entities={Enter_value} archive_name={Enter_value} \ subdir={Enter_value}'), ('xform', 'Function to transform a file name', 'NULL'), ('encrypt', 'Function to encrypt a file', 'NULL'), ('decrypt', 'Function to decrypt a file', 'NULL'), ('cksum', 'Function to produce a Checksum of a file', 'NULL'), ('split_file', 'Function to split a large file into smaller files', 'NULL'), ('merge_file', 'Function to merge split file', 'NULL'), ('avcheck', 'Function to Anti-Virus check a file', 'NULL'), ]: (self.function_name, self.function_description, self.function_prototype) = tst result = db_function.create_XFERO_Function( self.function_name, self.function_description, self.function_prototype) rows = db_function.list_XFERO_Function() for row in rows: self.assertIn(row, expected_tuple, 'Unexpected row selected')