DataGrip 2020.3 Help

Live templates

Use live templates to insert common constructs into your code, such as statements or definitions of database objects.

To expand a code snippet, type the corresponding template abbreviation and press Tab. Keep pressing Tab to jump from one variable in the template to the next one. Press Shift+Tab to move to the previous variable.

Live Templates

Types of live templates

The following types of live templates are distinguished:

  • Simple templates contain only fixed plain text. When you expand a simple template, the text is automatically inserted into your source code, replacing the abbreviation.

    Abbreviation Expands to
    CREATE TABLE new_table ( col INT NOT NULL );
    col int not null
  • Parameterized templates contain variables that enable user input. When you expand a parameterized template, variables are either replaced by input fields for the user to specify manually, or calculated by DataGrip automatically.

    Abbreviation Expands to
    INSERT INTO ... (...) VALUES (...);
    SELECT * FROM ...;
    SELECT count(*) FROM ... alias WHERE alias. ...;
    SELECT * FROM ... alias WHERE alias. ...;
    UPDATE ... SET ... = ... WHERE ...;
  • Surround templates wrap a block of the selected code with the text specified by the user.

Postfix code completion is similar to live templates. It transforms the current expression without selecting it. For example, you can type .cfrom after an expression to invoke the corresponding postfix completion and expand the SELECT statement to SELECT <all_column_names_from_table> FROM <table>.

Configure live templates

To configure live templates, open the Editor | Live Templates page of the Settings/Preferences Ctrl+Alt+S. On the Live Templates page, you can see all the available live templates, edit them and create new templates.

Templates are grouped according to the context where they can be used (usually, by the corresponding language). To move a template to another group, right-click the template, select Move, and then select the necessary group name.

Set an SQL dialect for a live template

You can select a specific dialect for a live template. For example, if you want the upd template to work only in MySQL and not in Db2.

  1. In Settings Ctrl+Alt+S, navigate to Editor | Live Templates.

  2. Expand the SQL tree.

  3. Right-click the template you want to modify and select Change context.

  4. In the Change Context Type for Selected Templates window, expand the SQL tree node and select the context.

    Set an SQL dialect for a live template

Each live template is defined by an abbreviation containing alphanumeric characters, dots, and hyphens. The abbreviation must be unique within a group, but the same abbreviation may be used in different groups and expand to different constructs according to the context of the corresponding group. Abbreviations of modified default templates are shown in the list with blue font.

Live template settings

To configure live templates, open Settings/Preferences (Ctrl+Alt+S), go to the Editor | Live Templates page. On this page, you can see all the available live templates grouped by language or framework. To configure a template, expand the desired group (for example, Ruby) and select a template.

Main settings

Main settings

Item Description
By default expand with

Specifies 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 list.

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

Live Templates

Displays all currently available template abbreviations 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 near the template or the group.

The Add icon Add Alt+Insert Adds a new template item to the current group of template. You can define the template abbreviation, description, text, variables, expansion key, and context in the editing area below.
The Remove icon Remove Delete Removes the selected live template from the list.
The Duplicate icon Duplicate Click 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.
The Restore deleted defaults icon Restore deleted defaults Click this button to restore the deleted live templates. This button is only enabled when the changes are applied.

Context menu of a live template

Context menu of a live template

Item Description
Move Moves the selected template to a specified group.
Change context

Changes context or contexts where the current template is enabled. When you select 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.

Copy Creates a serialized template XML in the system clipboard.
Paste Pastes an XML representation of the copied templates to the selected group of templates.

Template editing area

Template editing area

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

  • When you click the Add The Add icon or Copy  The 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.

Item Description
Abbreviation In this field, specify the template abbreviation, i.e a sequence of characters that identify the template in the editor.
Description In this field, provide optional description of a template or an example of its usage.
Template Text In this field, 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 Open the Edit Template Variables dialog, where you can define how DataGrip should process template variables upon template expansion. For more information, see Live template variables.

In this area, define the behavior of the editor when a template is expanded.

  • Expand with - from this 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.

Last modified: 29 December 2020