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 152411 - Provide pre-defined SQL code templates in SQL editor
Summary: Provide pre-defined SQL code templates in SQL editor
Status: RESOLVED DUPLICATE of bug 134113
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-11-05 11:21 UTC by sansan
Modified: 2014-12-12 22:32 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description sansan 2008-11-05 11:21:13 UTC
The sql editor support the fantastic "abbreviations" feature, some pre-defined should exist.

For example: 
sf = "SELECT * FROM "
de = "DELETE FROM "
wh = "WHERE "
...
Comment 1 David Vancouvering 2008-11-05 21:33:30 UTC
It would be very nice to do this, we'll see if we can do it for NB.Next
Comment 2 David Vancouvering 2008-11-05 21:34:35 UTC
We should have this work in the PHP and Java editors too, just noting that...
Comment 3 Jiri Rechtacek 2009-10-16 14:06:31 UTC
Reassigned to new owner.
Comment 4 Jiri Rechtacek 2009-10-23 09:30:07 UTC

*** This issue has been marked as a duplicate of 134113 ***
Comment 5 davelhs03 2014-12-12 22:32:17 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