DataGrip 2018.1 Help

Live Templates

File | Settings | Editor | Live Templates for Windows and Linux
DataGrip | Preferences | Editor | Live Templates for macOS
Ctrl+Alt+S settings


Use this page to manage live templates and their settings. (A live template is a code fragment pattern that can be quickly inserted in the editor as a whole. For example, there are live templates for the SELECT, CREATE TABLE, UPDATE TABLE and other SQL statements.)

On this page:

List of available live templates

ItemTooltip and shortcutDescription
By default expand withUse this drop-down list to specify the default invocation key for all templates. Individual expansion keys for the particular templates are defined in the editing area.

If the standard expansion keys (Tab, Enter, or Space) are not desirable, select the Custom option from this drop-down list.

When Custom is selected, the Change link appears next to the drop-down, leading you to the Keymap page.

Live TemplatesThis list shows all currently available template abbreviations supplied with their descriptions. The abbreviations are grouped below nodes and sorted alphabetically within each group. To activate a template or an entire group, select the checkbox to its left.
add,png Add
Alt+Insert
Click this button to have a new template item added to the current group of template. You can define the template abbreviation, description, text, variables, expansion key, and context in the editing area below.
delete.png Remove
Delete
Click this button to have the selected live template removed from the list.
copy icon DuplicateClick this button to create a new template based on the selected template. A new template item is added to the current node and the fields in the Template Text area show the definition of the selected template.
restore defaultsRestoreClick this button to restore the deleted live templates. This button is only enabled when the changes are applied.

Context menu of a live template

ItemDescription
MoveChoose a group to move the selected template to.
Change contextChoose this command to modify the set of contexts where the current template is enabled. Upon choosing this command, a list of supported language contexts is displayed. To make DataGrip consider a context sensitive to the template, select a checkbox next to the context name.

The available context types depend on the enabled plugins.

CopyChoose this command to create a serialized template XML in the system clipboard.
PasteChoose this command to paste an XML representation of the copied templates to the selected group of templates.
Restore defaultsThis command only appears on the context menus of the modified templates, marked blue. Choose this command to restore the default template settings.

Template editing area

The focus is moved to this area in the following cases:

  • When you click the Add add,png or Copy  copy icon button.
  • When you select a live template in the list.
  • When you select a fragment of code in the editor and choose Tools | Save as Live Template.

Use controls of this area to create new live templates and edit the settings for the existing ones.

You can navigate through the Template Text Area using the hot keys that are marked in the field labels.

ItemDescription
Abbreviation In this text box, specify the template abbreviation, i.e a sequence of characters that identify the template in the editor.
DescriptionIn this text box, provide optional description of a template or an example of its usage.
Template TextIn this text box, type the template body that may contain plain text and variables in the format $<variable name>$. If necessary, click Edit Variables and configure the variables as required. To escape a dollar sign ($) in the template text, just duplicate it ($$).
Applicable in:This read-only field shows the languages and/or pieces of code where the editor should be sensitive to the template. Upon pressing Ctrl+J in such context, DataGrip displays a list of templates that are valid for this context.
Change Click this link to modify the set of contexts where the current template is enabled. Upon clicking the link, a list of supported language contexts is displayed. To make DataGrip consider a context sensitive to the template, select a checkbox next to the context name.
Edit Variables Click this button to open the Edit Template Variables dialog box, where you can define how DataGrip should process template variables upon template expansion. The Edit Template Variables dialog box contains a complete list of available functions. See the list of predefined functions below on this page.
OptionsIn this area, define the behavior of the editor when a template is expanded.
  • Expand with - from this drop-down list, choose the key to invoke the template.
  • Reformat according to style - select this checkbox to have DataGrip automatically reformat the expanded text according to the current style settings, defined on the Code Style page.

Predefined functions to be used in live template variables

ItemDescription
camelCase(String) Converts a string into camelCase. For example, camelCase(my-text-file), camelCase(my text file), and camelCase(my_text_file) all return myTextFile.
capitalize(String)Capitalizes the first letter of the parameter.
capitalizeAndUnderscore(sCamelCaseName) Capitalizes all the letters of a CamelCase name passed as the parameter, and inserts an underscore between the parts. For example, capitalizeAndUnderscore(FooBar) returns FOO_BAR.
complete()Invokes code completion at the position of the variable.
completeSmart()Invokes smart type completion at the position of the variable.
date(sDate)

Returns the current system date in the specified format.

Without a parameter, the current date is returned in the default system format.

date_format
decapitalize(sName)Replaces the first letter of the parameter with the corresponding lowercase letter.
enum(sCompletionString1,sCompletionString2,...)Returns a list of comma-separated strings suggested for completion when the template is expanded.
escapeString(sEscapeString)Escapes the string specified as the parameter.
expectedType()Returns the expected type of the expression into which the template expands. Makes sense if the template expands in the right part of an assignment, after return, etc.
fileName()Returns the name of the current file with its extension.
fileNameWithoutExtension()Returns the name of the current file without its extension.
firstWord(sFirstWord)Returns the first word of the string passed as the parameter.
lineNumber()Returns the current line number.
lowercaseAndDash(String) Converts a camelCase string into lower case and inserts n-dashes as separators. For example, lowercaseAndDash(MyExampleName) returns my-example-name.
snakeCase(String) Converts a string into snake_case. For example, snakeCase(fooBar) returns foo_bar.
spaceSeparated(String) Converts a string into lowercase and inserts spaces as separators. For example, spaceSeparated(fooBar) returns foo bar.
substringBefore(String,Delimiter) Removes the extension after the specified delimiter and returns only the file name. This is helpful for test file names (for example, substringBefore($FileName$,",") returns component-test in component-test.js).
time(sSystemTime)Returns the current system time in the specified format.
underscoresToCamelCase(String) Replaces underscores with camelCase letters in the string passed as the parameter. For example, underscoresToCamelCase(foo_bar) returns fooBar.
underscoresToSpaces(sParameterWithSpaces) Replaces underscores with spaces in the string passed as the parameter. For example, underscoresToSpaces(foo_bar) returns foo bar.
user()Returns the name of the current user.
Last modified: 25 July 2018