1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
# Copyright (c) 2019-2024 Open Text.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
from __future__ import print_function, division, absolute_import, annotations
import mock
from .base import VerticaPythonUnitTestCase
from ...vertica.messages import NoticeResponse
from ...errors import QueryError
class NoticeTestCase(VerticaPythonUnitTestCase):
SAMPLE_DATA = {b'S': 'FATAL',
b'H': 'This is a test hint',
b'L': '9999',
b'M': 'Failure is on purpose'}
@mock.patch.object(NoticeResponse, '_unpack_data')
def test_error_message(self, mock_unpack_data):
mock_unpack_data.return_value = NoticeTestCase.SAMPLE_DATA
notice = NoticeResponse(b'ignored-due-to-mock')
self.assertEqual(
notice.error_message(),
'Severity: FATAL, Message: Failure is on purpose, Hint: This is a test hint, Line: 9999'
)
@mock.patch.object(NoticeResponse, '_unpack_data')
def test_attribute_properties(self, mock_unpack_data):
mock_unpack_data.return_value = NoticeTestCase.SAMPLE_DATA
notice = NoticeResponse(b'ignored-due-to-mock')
self.assertEqual(notice.severity, 'FATAL')
self.assertEqual(notice.hint, 'This is a test hint')
# yes, line is still a string.
self.assertEqual(notice.line, '9999')
self.assertEqual(notice.message, 'Failure is on purpose')
self.assertIsNone(notice.detail)
self.assertIsNone(notice.sqlstate)
@mock.patch.object(NoticeResponse, '_unpack_data')
def test_labeled_values(self, mock_unpack_data):
mock_unpack_data.return_value = NoticeTestCase.SAMPLE_DATA
notice = NoticeResponse(b'ignored-due-to-mock')
self.assertEqual(notice.values, {
'Severity': 'FATAL',
'Hint': 'This is a test hint',
'Line': '9999',
'Message': 'Failure is on purpose'})
@mock.patch.object(NoticeResponse, '_unpack_data')
def test_query_error(self, mock_unpack_data):
mock_unpack_data.return_value = NoticeTestCase.SAMPLE_DATA
notice = NoticeResponse(b'ignored-due-to-mock')
query_error = QueryError(notice, 'Select Fake();')
self.assertEqual(query_error.severity, 'FATAL')
self.assertEqual(query_error.hint, 'This is a test hint')
self.assertEqual(query_error.line, '9999')
self.assertEqual(query_error.message, 'Failure is on purpose')
self.assertIsNone(query_error.detail)
self.assertIsNone(query_error.sqlstate)
self.assertEqual(
str(query_error),
'Severity: FATAL, Message: Failure is on purpose, Hint: This is a test hint, Line: 9999, SQL: \'Select Fake();\'')
|
