def test_read_XFERO_Route(self):
'''
**Purpose:**
SELECT rows from the XFERO_Route table with route_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 |
+------------+-------------+-------------------------------------------+
'''
for tst in [('/ftran/CIS/ISCS', '^cis_123_XYZ', '1', '1'),
]:
(self.route_monitoreddir, self.route_filenamepattern,
self.route_active, self.route_priority) = tst
result = db_route.create_XFERO_Route(
self.route_monitoreddir, self.route_filenamepattern,
self.route_active, self.route_priority)
self.route_id = '1'
rows = db_route.read_XFERO_Route(self.route_id)
expected_tuple = (1, '/ftran/CIS/ISCS', '^cis_123_XYZ', 1, 1)
for row in rows:
self.assertTupleEqual(
expected_tuple, row, 'Unexpected row retrieved')
def test_create_XFERO_Route(self):
'''
**Purpose:**
INSERT rows into the XFERO_Route 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 tst in [('/ftran/CIS/ISCS', '^cis_123_XYZ', '1', '1'),
('/ftran/UC/HMRC', '^UC_PYT_20120113', '2', '1'),
('/ftran/DRS/XEROX', '_DRS_to_XEROX$', '3', '1'),
('/ftran/CIS/FCO', '^FCO_123_XYZ', '2', '1'),
('/ftran/CPS/CITIBANK', '^CITC_PYT_20120113', '1', '1'),
('/ftran/CPS/ETSE', '_PAYT_TO_CITI$', '3', '1')
]:
(self.route_monitoreddir, self.route_filenamepattern,
self.route_active, self.route_priority) = tst
result = db_route.create_XFERO_Route(
self.route_monitoreddir, self.route_filenamepattern,
self.route_active, self.route_priority)
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 route_id FROM XFERO_Route')
except lite.Error as err:
print("Error %s:" % err.args[0])
expected_tuple = ((1,), (2,), (3,), (4,), (5,), (6,))
rows = cur.fetchall()
for row in rows:
self.assertIn(row, expected_tuple, 'Unexpected row retrieved')
def test_list_XFERO_Route_Priority(self):
'''
**Purpose:**
SELECT ALL rows on the XFERO_Route table where the Priority assigned to the
routes is set to 3 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 = ((3, '/ftran/DRS/XEROX', '_DRS_to_XEROX$', 1, 3),
(6, '/ftran/CPS/ETSE', '_PAYT_TO_CITI$', 1, 3)
)
for tst in [('/ftran/CIS/ISCS', '^cis_123_XYZ', '1', '1'),
('/ftran/UC/HMRC', '^UC_PYT_20120113', '1', '2'),
('/ftran/DRS/XEROX', '_DRS_to_XEROX$', '1', '3'),
('/ftran/CIS/FCO', '^FCO_123_XYZ', '1', '2'),
('/ftran/CPS/CITIBANK', '^CITC_PYT_20120113', '1', '1'),
('/ftran/CPS/ETSE', '_PAYT_TO_CITI$', '1', '3')
]:
(self.route_monitoreddir, self.route_filenamepattern,
self.route_active, self.route_priority) = tst
result = db_route.create_XFERO_Route(
self.route_monitoreddir, self.route_filenamepattern,
self.route_active, self.route_priority)
priority = '3'
rows = db_route.list_XFERO_Route_Priority_Route(priority)
for route in rows:
route_id = route['route_id']
route_monitoreddir = route['route_monitoreddir']
route_filenamepattern = route['route_filenamepattern']
route_active = route['route_active']
route_priority = route['route_priority']
actual_tuple = (
(route_id, route_monitoreddir, route_filenamepattern,
route_active, route_priority))
self.assertIn(
actual_tuple, expected_tuple, 'Unexpected row selected')
def test_delete_XFERO_Route(self):
'''
**Purpose:**
DELETE rows on the XFERO_Route table with route_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 |
+------------+-------------+-------------------------------------------+
'''
for tst in [('/ftran/CIS/ISCS', '^cis_123_XYZ', '1', '1'),]:
(self.route_monitoreddir, self.route_filenamepattern,
self.route_active, self.route_priority) = tst
result = db_route.create_XFERO_Route(
self.route_monitoreddir, self.route_filenamepattern,
self.route_active, self.route_priority)
self.route_id = '1'
rows = db_route.delete_XFERO_Route(self.route_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_Route')
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_list_XFERO_Route(self):
'''
**Purpose:**
SELECT ALL rows on the XFERO_Route 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, '/ftran/CIS/ISCS', '^cis_123_XYZ', 1, 1),
(2, '/ftran/UC/HMRC', '^UC_PYT_20120113', 2, 1),
(3, '/ftran/DRS/XEROX', '_DRS_to_XEROX$', 3, 1),
(4, '/ftran/CIS/FCO', '^FCO_123_XYZ', 2, 1),
(5, '/ftran/CPS/CITIBANK',
'^CITC_PYT_20120113', 1, 1),
(6, '/ftran/CPS/ETSE', '_PAYT_TO_CITI$', 3, 1)
)
for tst in [('/ftran/CIS/ISCS', '^cis_123_XYZ', '1', '1'),
('/ftran/UC/HMRC', '^UC_PYT_20120113', '2', '1'),
('/ftran/DRS/XEROX', '_DRS_to_XEROX$', '3', '1'),
('/ftran/CIS/FCO', '^FCO_123_XYZ', '2', '1'),
('/ftran/CPS/CITIBANK', '^CITC_PYT_20120113', '1', '1'),
('/ftran/CPS/ETSE', '_PAYT_TO_CITI$', '3', '1')
]:
(self.route_monitoreddir, self.route_filenamepattern,
self.route_active, self.route_priority) = tst
result = db_route.create_XFERO_Route(
self.route_monitoreddir, self.route_filenamepattern,
self.route_active, self.route_priority)
rows = db_route.list_XFERO_Route()
for row in rows:
self.assertIn(row, expected_tuple, 'Unexpected row selected')
def test_update_XFERO_Route(self):
'''
**Purpose:**
UPDATE rows on the XFERO_Route table with route_id = 3 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 |
+------------+-------------+-------------------------------------------+
'''
for tst in [('/ftran/CIS/ISCS', '^cis_123_XYZ', '1', '1'),
]:
(self.route_monitoreddir, self.route_filenamepattern,
self.route_active, self.route_priority) = tst
result = db_route.create_XFERO_Route(
self.route_monitoreddir, self.route_filenamepattern,
self.route_active, self.route_priority)
self.route_id = '1'
self.route_monitoreddir = '/ftran/test/chris'
self.route_filenamepattern = '^Chris'
self.route_active = '1'
self.route_priority = '2'
rows = db_route.update_XFERO_Route(
self.route_monitoreddir, self.route_filenamepattern,
self.route_active, self.route_priority, self.route_id)
# Check update
rows = db_route.read_XFERO_Route(self.route_id)
expected_tuple = (1, '/ftran/test/chris', '^Chris', 1, 2)
for row in rows:
self.assertTupleEqual(
expected_tuple, row, 'Unexpected row retrieved')