How to enable Auto completion for SQL language. #40
-
|
I saw that code highlight is supported for SQL language. But i am not understanding how to implment auto completion for SQL. I have only seen autocomplete example of CSS,HTML,javascript. Any help is appreciated. |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment · 2 replies
-
|
I haven't made autocompletion for any languages other than HTML, CSS, and JavaScript. If you want autocomplete for SQL, you'll have to make it yourself. If all you want is autocomplete for SQL keywords, then this is easily doable. import { getClosestToken } from "prism-code-editor/utils"
import { Completion, CompletionSource, registerCompletions } from "prism-code-editor/autocomplete"
const options: Completion[] = listOfSqlKeywords.map(label => ({ label, icon: "keyword" }))
const sqlSource: CompletionSource = (context, editor) => {
if (getClosestToken(editor, ".string, .comment", 0, 0, context.pos)) {
return // Disable autocomplete in comments and strings
}
const wordBefore = /\w*$/.exec(context.lineBefore)![0]
if (wordBefore || context.explicit) {
return {
from: context.pos - wordBefore.length,
options: options,
}
}
}
registerCompletions(["sql"], {
sources: [sqlSource]
}) |
Beta Was this translation helpful? Give feedback.
-
|
THank you for your response. This code helped me implement code completion for SQL. I took the SQL keywords from prism language grammer file. I have one more doubt. I want to implement auto focus on the code editor after clicking on some other button in page. But it is not working.
|
Beta Was this translation helpful? Give feedback.
-
If you have access to the const editor = createEditor(/* ... */)
editor.textarea.focus()If you don't have access to the document.querySelector(".prism-code-editor textarea").focus()If you're using the setups, the textarea will be inside a shadow root attached to your container, so you'll need to call |
Beta Was this translation helpful? Give feedback.
I haven't made autocompletion for any languages other than HTML, CSS, and JavaScript. If you want autocomplete for SQL, you'll have to make it yourself. If all you want is autocomplete for SQL keywords, then this is easily doable.