def do_test():
# When I add context for 2 URIs with same connection details
operations_queue = OperationsQueue(self.mock_service_provider)
with mock.patch(COMPLETIONREFRESHER_PATH_PATH) as refresher_patch:
refresher_patch.return_value = self.refresher_mock
operations_queue.add_connection_context(self.connection_info)
conn_info2 = ConnectionInfo('newuri',
self.connection_info.details)
operations_queue.add_connection_context(conn_info2)
# Then I expect to only have connection
connect_mock: mock.MagicMock = self.mock_connection_service.connect
connect_mock.assert_called_once()
connect_params: ConnectRequestParams = connect_mock.call_args[
0][0]
self.assertEqual(connect_params.owner_uri,
self.expected_connection_uri)
def do_test():
# When I add context for 2 URIs with same connection details
operations_queue = OperationsQueue(self.mock_service_provider)
with mock.patch(COMPLETIONREFRESHER_PATH_PATH) as refresher_patch:
refresher_patch.return_value = self.refresher_mock
operations_queue.add_connection_context(self.connection_info)
conn_info2 = ConnectionInfo('newuri',
self.connection_info.details)
operations_queue.add_connection_context(conn_info2,
overwrite=True)
# Then I expect to only have 1 connection
# and I expect disconnect and reconnect to have been called
connect_mock: mock.MagicMock = self.mock_connection_service.connect
self.assertEqual(connect_mock.call_count, 2)
self.assertEqual(
connect_mock.call_args_list[0][0][0].owner_uri,
self.expected_connection_uri)
self.assertEqual(
connect_mock.call_args_list[1][0][0].owner_uri,
self.expected_connection_uri)
disconnect_mock: mock.MagicMock = self.mock_connection_service.disconnect
disconnect_mock.assert_called_once()
def test_add_context_creates_new_context(self):
# Given a connection will be created on a connect request
connect_result = mock.MagicMock()
connect_result.error_message = None
self.mock_connection_service.get_connection = mock.Mock(
return_value=mock.MagicMock())
self.mock_connection_service.connect = mock.MagicMock(
return_value=connect_result)
# When I add a connection context
operations_queue = OperationsQueue(self.mock_service_provider)
with mock.patch(COMPLETIONREFRESHER_PATH_PATH) as refresher_patch:
refresher_patch.return_value = self.refresher_mock
context: ConnectionContext = operations_queue.add_connection_context(
self.connection_info)
# Then I expect the context to be non-null
self.assertIsNotNone(context)
self.assertEqual(context.key, self.expected_context_key)
self.assertFalse(context.intellisense_complete.is_set())
self.assertTrue(
operations_queue.has_connection_context(self.connection_info))
class LanguageService:
"""
Class for handling requests/events that deal with Language requests such as auto-complete
"""
def __init__(self):
self._service_provider: ServiceProvider = None
self._server: JSONRPCServer = None
self._logger: [Logger, None] = None
self._valid_uri: Set = set()
self._completion_helper = DefaultCompletionHelper()
self._script_map: Dict[str, 'ScriptParseInfo'] = {}
self._script_map_lock: threading.Lock = threading.Lock()
self._binding_queue_map: Dict[str, 'ScriptParseInfo'] = {}
self.operations_queue: OperationsQueue = None
def register(self, service_provider: ServiceProvider) -> None:
"""
Called by the ServiceProvider to allow init and registration of service handler methods
"""
self._service_provider = service_provider
self._logger = service_provider.logger
self._server = service_provider.server
self.operations_queue = OperationsQueue(service_provider)
self.operations_queue.start()
# Register request handlers
self._server.set_request_handler(COMPLETION_REQUEST,
self.handle_completion_request)
self._server.set_request_handler(DEFINITION_REQUEST,
self.handle_definition_request)
self._server.set_request_handler(
COMPLETION_RESOLVE_REQUEST, self.handle_completion_resolve_request)
self._server.set_request_handler(DOCUMENT_FORMATTING_REQUEST,
self.handle_doc_format_request)
self._server.set_request_handler(DOCUMENT_RANGE_FORMATTING_REQUEST,
self.handle_doc_range_format_request)
self._server.set_notification_handler(
LANGUAGE_FLAVOR_CHANGE_NOTIFICATION, self.handle_flavor_change)
# Register internal service notification handlers
self._connection_service.register_on_connect_callback(self.on_connect)
self._service_provider.server.add_shutdown_handler(
self._handle_shutdown)
# REQUEST HANDLERS #####################################################
def handle_definition_request(
self, request_context: RequestContext,
text_document_position: TextDocumentPosition) -> None:
request_context.send_notification(
STATUS_CHANGE_NOTIFICATION,
StatusChangeParams(
owner_uri=text_document_position.text_document.uri,
status="DefinitionRequested"))
def do_send_default_empty_response():
request_context.send_response([])
if self.should_skip_intellisense(
text_document_position.text_document.uri):
do_send_default_empty_response()
return
script_file: ScriptFile = self._workspace_service.workspace.get_file(
text_document_position.text_document.uri)
if script_file is None:
do_send_default_empty_response()
return
script_parse_info: ScriptParseInfo = self.get_script_parse_info(
text_document_position.text_document.uri,
create_if_not_exists=False)
if not script_parse_info or not script_parse_info.can_queue():
do_send_default_empty_response()
return
cursor_position: int = len(
script_file.get_text_in_range(
Range.from_data(0, 0, text_document_position.position.line,
text_document_position.position.character)))
text: str = script_file.get_all_text()
script_parse_info.document = Document(text, cursor_position)
operation = QueuedOperation(
script_parse_info.connection_key,
functools.partial(self.send_definition_using_connected_completions,
request_context, script_parse_info,
text_document_position),
functools.partial(do_send_default_empty_response))
self.operations_queue.add_operation(operation)
request_context.send_notification(
STATUS_CHANGE_NOTIFICATION,
StatusChangeParams(
owner_uri=text_document_position.text_document.uri,
status="DefinitionRequestCompleted"))
def handle_completion_request(self, request_context: RequestContext,
params: TextDocumentPosition) -> None:
"""
Lookup available completions when valid completion suggestions are requested.
Sends an array of CompletionItem objects over the wire
"""
response = []
def do_send_default_empty_response():
request_context.send_response(response)
script_file: ScriptFile = self._workspace_service.workspace.get_file(
params.text_document.uri)
if script_file is None:
do_send_default_empty_response()
return
if self.should_skip_intellisense(script_file.file_uri):
do_send_default_empty_response()
return
script_parse_info: ScriptParseInfo = self.get_script_parse_info(
params.text_document.uri, create_if_not_exists=False)
if not script_parse_info or not script_parse_info.can_queue():
self._send_default_completions(request_context, script_file,
params)
else:
cursor_position: int = len(
script_file.get_text_in_range(
Range.from_data(0, 0, params.position.line,
params.position.character)))
text: str = script_file.get_all_text()
script_parse_info.document = Document(text, cursor_position)
operation = QueuedOperation(
script_parse_info.connection_key,
functools.partial(self.send_connected_completions,
request_context, script_parse_info, params),
functools.partial(self._send_default_completions,
request_context, script_file, params))
self.operations_queue.add_operation(operation)
def handle_completion_resolve_request(self,
request_context: RequestContext,
params: CompletionItem) -> None:
"""Fill in additional details for a CompletionItem. Returns the same CompletionItem over the wire"""
request_context.send_response(params)
def handle_flavor_change(self, context: NotificationContext,
params: LanguageFlavorChangeParams) -> None:
"""
Processes a language flavor change notification, adding non-PGSQL files to a tracking set
so they can be excluded from intellisense processing
"""
if params is not None and params.uri is not None:
if params.language.lower() == 'sql':
# provider.flavor can be PGSQL, MySQL
if params.flavor == self._service_provider.provider:
self._valid_uri.add(params.uri)
else:
self._valid_uri.discard(params.uri)
def handle_doc_format_request(self, request_context: RequestContext,
params: DocumentFormattingParams) -> None:
"""
Processes a formatting request by sending the entire documents text to sqlparse and returning a formatted document as a
single TextEdit
"""
response: List[TextEdit] = []
def do_send_default_empty_response():
request_context.send_response(response)
if self.should_skip_formatting(params.text_document.uri):
do_send_default_empty_response()
return
file: ScriptFile = self._workspace_service.workspace.get_file(
params.text_document.uri)
if file is None:
do_send_default_empty_response()
return
sql: str = file.get_all_text()
if sql is None or sql.strip() == '':
do_send_default_empty_response()
return
edit: TextEdit = self._prepare_edit(file)
self._format_and_add_response(response, edit, sql, params)
do_send_default_empty_response()
def handle_doc_range_format_request(
self, request_context: RequestContext,
params: DocumentRangeFormattingParams) -> None:
"""
Processes a formatting request by sending the entire documents text to sqlparse and returning a formatted document as a
single TextEdit
"""
# Validate inputs and set up response
response: List[TextEdit] = []
def do_send_default_empty_response():
request_context.send_response(response)
if self.should_skip_formatting(params.text_document.uri):
do_send_default_empty_response()
return
file: ScriptFile = self._workspace_service.workspace.get_file(
params.text_document.uri)
if file is None:
do_send_default_empty_response()
return
# Process the text range and respond with the edit
text_range = params.range
sql: str = file.get_text_in_range(text_range)
if sql is None or sql.strip() == '':
do_send_default_empty_response()
return
edit: TextEdit = TextEdit.from_data(text_range, None)
self._format_and_add_response(response, edit, sql, params)
do_send_default_empty_response()
# SERVICE NOTIFICATION HANDLERS #####################################################
def on_connect(self, conn_info: ConnectionInfo) -> threading.Thread:
"""Set up intellisense cache on connection to a new database"""
return utils.thread.run_as_thread(
self._build_intellisense_cache_thread, conn_info)
# PROPERTIES ###########################################################
@property
def _workspace_service(self) -> WorkspaceService:
return self._service_provider[utils.constants.WORKSPACE_SERVICE_NAME]
@property
def _connection_service(self) -> ConnectionService:
return self._service_provider[utils.constants.CONNECTION_SERVICE_NAME]
@property
def should_lowercase(self) -> bool:
"""Looks up enable_lowercase_suggestions from the workspace config"""
return self._workspace_service.configuration.sql.intellisense.enable_lowercase_suggestions
# METHODS ##############################################################
def _handle_shutdown(self) -> None:
"""Stop the operations queue on shutdown"""
if self.operations_queue is not None:
self.operations_queue.stop()
def should_skip_intellisense(self, uri: str) -> bool:
return not self._workspace_service.configuration.sql.intellisense.enable_intellisense or not self.is_valid_uri(
uri)
def should_skip_formatting(self, uri: str) -> bool:
return not self.is_valid_uri(uri)
def is_valid_uri(self, uri: str) -> bool:
"""
Checks if this URI can be treated as a candidate for processing or should be skipped ()
"""
return uri in self._valid_uri
def _build_intellisense_cache_thread(self,
conn_info: ConnectionInfo) -> None:
# TODO build the cache. For now, sending intellisense ready as a test
scriptparseinfo: ScriptParseInfo = self.get_script_parse_info(
conn_info.owner_uri, create_if_not_exists=True)
if scriptparseinfo is not None:
# This is a connection for an actual script in the workspace. Build the intellisense cache for it
connection_context: ConnectionContext = self.operations_queue.add_connection_context(
conn_info, False)
# Wait until the intellisense is completed before sending back the message and caching the key
connection_context.intellisense_complete.wait()
scriptparseinfo.connection_key = connection_context.key
response = IntelliSenseReadyParams.from_data(conn_info.owner_uri)
self._server.send_notification(INTELLISENSE_READY_NOTIFICATION,
response)
# TODO Ideally would support connected diagnostics for missing references
def _get_sqlparse_options(self,
options: FormattingOptions) -> Dict[str, Any]:
sqlparse_options = {}
sqlparse_options['indent_tabs'] = not options.insert_spaces
if options.tab_size and options.tab_size > 0:
sqlparse_options['indent_width'] = options.tab_size
try:
# Look up workspace config in a try block in case it's not defined / set
config = self._workspace_service.configuration
format_options = config.get_configuration(
self._service_provider._provider_name).format
if format_options:
sqlparse_options = {
**sqlparse_options,
**format_options.__dict__
}
except AttributeError:
# Indicates the config isn't defined. We are OK with this as it's not required
pass
return sqlparse_options
def _prepare_edit(self, file: ScriptFile) -> TextEdit:
file_line_count: int = len(file.file_lines)
last_char = len(file.file_lines[file_line_count - 1])
text_range = Range.from_data(0, 0, file_line_count - 1, last_char)
return TextEdit.from_data(text_range, None)
def _format_and_add_response(self, response: List[TextEdit],
edit: TextEdit, text: str,
params: DocumentFormattingParams) -> None:
options = self._get_sqlparse_options(params.options)
edit.new_text = sqlparse.format(text, **options)
response.append(edit)
def get_script_parse_info(self,
owner_uri,
create_if_not_exists=False) -> ScriptParseInfo:
with self._script_map_lock:
if owner_uri in self._script_map:
return self._script_map[owner_uri]
if create_if_not_exists:
script_parse_info = ScriptParseInfo()
self._script_map[owner_uri] = script_parse_info
return script_parse_info
return None
def _send_default_completions(self, request_context: RequestContext,
script_file: ScriptFile,
params: TextDocumentPosition) -> bool:
response = []
line: str = script_file.get_line(params.position.line)
(token_text,
text_range) = TextUtilities.get_text_and_range(params.position, line)
if token_text:
completions = self._completion_helper.get_matches(
token_text, text_range, self.should_lowercase)
response = completions
request_context.send_response(response)
return True
def send_connected_completions(self, request_context: RequestContext,
scriptparseinfo: ScriptParseInfo,
params: TextDocumentPosition,
context: ConnectionContext) -> bool:
if not context or not context.is_connected:
return False
# Else use the completer to query for completions
completer: Completer = context.completer
completions: List[Completion] = completer.get_completions(
scriptparseinfo.document, None)
if completions:
response = [
LanguageService.to_completion_item(completion, params)
for completion in completions
]
request_context.send_response(response)
return True
# Else return false so the timeout task can be sent instead
return False
def send_definition_using_connected_completions(
self, request_context: RequestContext,
scriptparseinfo: ScriptParseInfo, params: TextDocumentPosition,
context: ConnectionContext) -> bool:
if not context or not context.is_connected:
return False
definition_result: DefinitionResult = None
completer: Completer = context.completer
completions: List[Completion] = completer.get_completions(
scriptparseinfo.document, None)
if completions:
word_under_cursor = scriptparseinfo.document.get_word_under_cursor(
)
matching_completion = next(
completion for completion in completions
if completion.display == word_under_cursor)
if matching_completion:
connection = self._connection_service.get_connection(
params.text_document.uri, ConnectionType.QUERY)
scripter_instance = scripter.Scripter(connection)
object_metadata = ObjectMetadata(
None, None, matching_completion.display_meta,
matching_completion.display, matching_completion.schema)
create_script = scripter_instance.script(
ScriptOperation.CREATE, object_metadata)
if create_script:
with tempfile.NamedTemporaryFile(
mode='wt',
delete=False,
encoding='utf-8',
suffix='.sql',
newline=None) as namedfile:
namedfile.write(create_script)
if namedfile.name:
file_uri = "file:///" + namedfile.name.strip('/')
location_in_script = Location(
file_uri, Range(Position(0, 1), Position(1,
1)))
definition_result = DefinitionResult(
False, None, [
location_in_script,
])
request_context.send_response(
definition_result.locations)
return True
if definition_result is None:
request_context.send_response(DefinitionResult(True, '', []))
return False
@classmethod
def to_completion_item(cls, completion: Completion,
params: TextDocumentPosition) -> CompletionItem:
key = completion.text
start_position = LanguageService._get_start_position(
params.position, completion.start_position)
text_range = Range(start=start_position, end=params.position)
kind = DISPLAY_META_MAP.get(completion.display_meta,
CompletionItemKind.Unit)
completion_item = CompletionItem()
completion_item.label = key
completion_item.detail = completion.display
completion_item.insert_text = key
completion_item.kind = kind
completion_item.text_edit = TextEdit.from_data(text_range, key)
# Add a sort text to put keywords after all other items
completion_item.sort_text = f'~{key}' if completion_item.kind == CompletionItemKind.Keyword else key
return completion_item
@classmethod
def _get_start_position(cls, end: Position, start_index: int) -> Position:
start_col = end.character + start_index
if start_col < 0:
# Should not happen - for now, just set to 0 and assume it's a mistake
start_col = 0
return Position(end.line, start_col)