def test_workbook_list(self):
created0 = db_api.workbook_create(WORKBOOKS[0])
created1 = db_api.workbook_create(WORKBOOKS[1])
fetched = db_api.workbooks_get_all()
self.assertEqual(2, len(fetched))
self.assertDictEqual(created0, fetched[0])
self.assertDictEqual(created1, fetched[1])
def test_workbook_list(self):
created0 = db_api.workbook_create(WORKBOOKS[0])
created1 = db_api.workbook_create(WORKBOOKS[1])
fetched = db_api.workbooks_get_all()
self.assertEqual(2, len(fetched))
self.assertDictEqual(created0, fetched[0])
self.assertDictEqual(created1, fetched[1])
def test_commit_multiple_objects(self):
db_api.start_tx()
try:
created_trigger = db_api.trigger_create(TRIGGERS[0])
self.assertIsInstance(created_trigger, dict)
fetched_trigger = db_api.trigger_get(created_trigger['id'])
self.assertIsInstance(fetched_trigger, dict)
self.assertDictEqual(created_trigger, fetched_trigger)
created_workbook = db_api.workbook_create(WORKBOOKS[0])
self.assertIsInstance(created_workbook, dict)
fetched_workbook = db_api.workbook_get(created_workbook['name'])
self.assertIsInstance(fetched_workbook, dict)
self.assertDictEqual(created_workbook, fetched_workbook)
self.assertTrue(self.is_db_session_open())
db_api.commit_tx()
finally:
db_api.end_tx()
self.assertFalse(self.is_db_session_open())
fetched_trigger = db_api.trigger_get(created_trigger['id'])
self.assertIsInstance(fetched_trigger, dict)
self.assertDictEqual(created_trigger, fetched_trigger)
fetched_workbook = db_api.workbook_get(created_workbook['name'])
self.assertIsInstance(fetched_workbook, dict)
self.assertDictEqual(created_workbook, fetched_workbook)
self.assertFalse(self.is_db_session_open())
def test_workbook_create_and_get(self):
created = db_api.workbook_create(WORKBOOKS[0])
self.assertIsInstance(created, dict)
fetched = db_api.workbook_get(created['name'])
self.assertIsInstance(fetched, dict)
self.assertDictEqual(created, fetched)
def test_workbook_create_and_get(self):
created = db_api.workbook_create(WORKBOOKS[0])
self.assertIsInstance(created, dict)
fetched = db_api.workbook_get(created['name'])
self.assertIsInstance(fetched, dict)
self.assertDictEqual(created, fetched)
def test_commit_multiple_objects(self):
db_api.start_tx()
try:
created_trigger = db_api.trigger_create(TRIGGERS[0])
self.assertIsInstance(created_trigger, dict)
fetched_trigger = db_api.trigger_get(created_trigger['id'])
self.assertIsInstance(fetched_trigger, dict)
self.assertDictEqual(created_trigger, fetched_trigger)
created_workbook = db_api.workbook_create(WORKBOOKS[0])
self.assertIsInstance(created_workbook, dict)
fetched_workbook = db_api.workbook_get(created_workbook['name'])
self.assertIsInstance(fetched_workbook, dict)
self.assertDictEqual(created_workbook, fetched_workbook)
self.assertTrue(self.is_db_session_open())
db_api.commit_tx()
finally:
db_api.end_tx()
self.assertFalse(self.is_db_session_open())
fetched_trigger = db_api.trigger_get(created_trigger['id'])
self.assertIsInstance(fetched_trigger, dict)
self.assertDictEqual(created_trigger, fetched_trigger)
fetched_workbook = db_api.workbook_get(created_workbook['name'])
self.assertIsInstance(fetched_workbook, dict)
self.assertDictEqual(created_workbook, fetched_workbook)
self.assertFalse(self.is_db_session_open())
def test_workbook_public(self):
# create a workbook(scope=public) as under one project
# then make sure it's visible for other projects.
created0 = db_api.workbook_create(WORKBOOKS[0])
fetched = db_api.workbooks_get_all()
self.assertEqual(1, len(fetched))
self.assertDictEqual(created0, fetched[0])
# assert that the project_id stored is actually the context's
# project_id not the one given.
self.assertEqual(created0['project_id'], auth_context.ctx().project_id)
self.assertNotEqual(WORKBOOKS[0]['project_id'],
auth_context.ctx().project_id)
# create a new user.
ctx = auth_context.MistralContext(user_id='9-0-44-5',
project_id='99-88-33',
user_name='test-user',
project_name='test-another',
is_admin=False)
auth_context.set_ctx(ctx)
fetched = db_api.workbooks_get_all()
self.assertEqual(1, len(fetched))
self.assertDictEqual(created0, fetched[0])
self.assertEqual('public', created0['scope'])
def test_rollback_multiple_objects(self):
db_api.start_tx()
try:
created_trigger = db_api.trigger_create(TRIGGERS[0])
self.assertIsInstance(created_trigger, dict)
fetched_trigger = db_api.trigger_get(created_trigger['id'])
self.assertIsInstance(fetched_trigger, dict)
self.assertDictEqual(created_trigger, fetched_trigger)
created_workbook = db_api.workbook_create(WORKBOOKS[0])
self.assertIsInstance(created_workbook, dict)
fetched_workbook = db_api.workbook_get(created_workbook['name'])
self.assertIsInstance(fetched_workbook, dict)
self.assertDictEqual(created_workbook, fetched_workbook)
self.assertTrue(self.is_db_session_open())
db_api.rollback_tx()
finally:
db_api.end_tx()
self.assertFalse(self.is_db_session_open())
fetched_trigger = db_api.trigger_get(created_trigger['id'])
self.assertIsNone(fetched_trigger)
self.assertRaises(exc.NotFoundException, db_api.workbook_get,
created_workbook['name'])
self.assertFalse(self.is_db_session_open())
def test_workbook_update(self):
created = db_api.workbook_create(WORKBOOKS[0])
self.assertIsInstance(created, dict)
updated = db_api.workbook_update(created['name'],
{'description': 'my new desc'})
self.assertIsInstance(updated, dict)
self.assertEqual('my new desc', updated['description'])
fetched = db_api.workbook_get(created['name'])
self.assertDictEqual(updated, fetched)
def test_workbook_update(self):
created = db_api.workbook_create(WORKBOOKS[0])
self.assertIsInstance(created, dict)
updated = db_api.workbook_update(created['name'],
{'description': 'my new desc'})
self.assertIsInstance(updated, dict)
self.assertEqual('my new desc', updated['description'])
fetched = db_api.workbook_get(created['name'])
self.assertDictEqual(updated, fetched)
def test_workbook_delete(self):
created = db_api.workbook_create(WORKBOOKS[0])
self.assertIsInstance(created, dict)
fetched = db_api.workbook_get(created['name'])
self.assertIsInstance(fetched, dict)
self.assertDictEqual(created, fetched)
db_api.workbook_delete(created['name'])
self.assertRaises(exc.NotFoundException,
db_api.workbook_get, created['name'])
def test_workbook_private(self):
# create a workbook(scope=private) as under one project
# then make sure it's NOT visible for other projects.
created1 = db_api.workbook_create(WORKBOOKS[1])
fetched = db_api.workbooks_get_all()
self.assertEqual(1, len(fetched))
self.assertDictEqual(created1, fetched[0])
# create a new user.
ctx = auth_context.MistralContext(user_id='9-0-44-5',
project_id='99-88-33',
user_name='test-user',
project_name='test-another',
is_admin=False)
auth_context.set_ctx(ctx)
fetched = db_api.workbooks_get_all()
self.assertEqual(0, len(fetched))
