This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 134113 - Code snippets for SQL
Summary: Code snippets for SQL
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: Jiri Rechtacek
URL: http://wiki.netbeans.org/DatabaseSQLS...
Keywords: PLAN
: 65165 152411 (view as bug list)
Depends on:
Blocks:
 
Reported: 2008-04-29 00:27 UTC by John Baker
Modified: 2014-12-12 22:32 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description John Baker 2008-04-29 00:27:33 UTC 
For 6.5 we want to make it easy to generate SQL statements using shortcuts within the SQL editor.
Once the SQL is generated, the SQL source can be saved in an SQL file, for later reuse (by reopening the file).

In 6.x, the SQL editor can save and open SQL files.

In 6.5, supporting SQL generation using shortcut keys, e.g. Ctrl-Alt-I, to generate an insert statement
Comment 1 David Vancouvering 2008-04-29 00:43:33 UTC 
Another aspect of this feature is to make it easy to store and load snippets from within the SQL editor, e.g. a keyboard
shortcut brings up a drop-down list and you can type to filter out possible names and see the first <n> lines of the
snippet, then pick it and it pastes into your editor.

Better than having to go to the File menu, browse for the SQL file, poking around your directory tree trying to find it.

I'm thinking the code snippets are saved in your userdir, but the user can specify a different location if they want.
Comment 2 David Vancouvering 2008-04-29 00:45:37 UTC 
Also, SQLYog and AquaStudio both have this feature that if you select a database object like a connection or table, if
you right click you have a sub-menu that lets you generate SELECT (basically View Data), INSERT, or UPDATE statements
against the current object.
Comment 3 John Baker 2008-06-15 12:06:38 UTC 
I'll be on leave of absence during the M2 timeframe.Not staffed.
Comment 4 Jiri Rechtacek 2009-10-16 14:05:24 UTC 
Reassigned to new owner.
Comment 5 Jiri Rechtacek 2009-10-23 09:29:52 UTC 
Like issue 152411 - Provide pre-defined SQL code templates in SQL editor
Comment 6 Jiri Rechtacek 2009-10-23 09:30:07 UTC 
*** Issue 152411 has been marked as a duplicate of this issue. ***
Comment 7 matthias42 2012-04-17 18:40:44 UTC 
*** Bug 65165 has been marked as a duplicate of this bug. ***
Comment 8 matthias42 2013-05-16 17:59:20 UTC 
There is a working way in netbeans:

Go to: Tools -> Options -> Editor -> Code Templates

for example: 

1. Enter "Abbreviation": "s"
2. Set "Expanded Text": "SELECT ${columns} FROM ${from}"
3. Change "Expand Template on" to "Tab"

Acknowledge the dialog.

Now enter an SQL Editor, enter "s" and press "Tab"-Key. now the first part is directly selected and you can enter the columns you want to select, with TAB you can jump to the next variable and with Shift-Tab you can jump back.

I had to look for this, but the proposed solution in the wiki would just conflict with existing shortcuts.

I'll close this as FIXED.

What could be done is define a better editor for code templates, but for that bugs already exist.
Comment 9 davelhs03 2014-12-12 22:32:22 UTC 
Geertjan Wielenga (Twitter: @GeertjanW) created this awesome plugin for Code Templates and includes some of the SQL code templates I provided him.  You can download the plugin here:
http://plugins.netbeans.org/plugin/49660/?show=true

List of SQL code templates I suggested he use:
https://gist.github.com/phpdave/4fff31d51dd34f6e8201

Vid tutorial on using his plugin:
https://www.youtube.com/watch?v=1SUHFMvM39Y