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

Summary:	Provide pre-defined SQL code templates in SQL editor
Product:	db	Reporter:	sansan <sansan>
Component:	SQL Editor	Assignee:	Jiri Rechtacek <jrechtacek>
Status:	RESOLVED DUPLICATE
Severity:	blocker	CC:	romanmostyka
Priority:	P2
Version:	6.x
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Exception Reporter:

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