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 155276 - Missing SQL template in New file wizard
Summary: Missing SQL template in New file wizard
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: John Baker
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-12-11 20:46 UTC by Tomas Mysik
Modified: 2009-02-19 20:37 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
diffs (10.24 KB, text/plain)
2008-12-17 01:07 UTC, John Baker 		Details
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 Tomas Mysik 2008-12-11 20:46:25 UTC 
Missing SQL template in New file wizard.
Comment 1 Tomas Mysik 2008-12-12 10:47:59 UTC 
It's not PHP specific, looking at some other project types (J2SE, Java EE), I'm not able to find new SQL file as well. 
Petr, David, do you know whether is it a bug? Or intentional? Thanks for your comments.
Comment 2 Petr Pisl 2008-12-12 11:00:12 UTC 
I have noticed this as well, during one presentation:). There is missing a SQL template in the ide. When there will be
such template, then it can be registered for the php project and other projects as well. 

David, please provide a simple sql template. I think that using general template wizard will be ok for this reason.
Comment 3 David Vancouvering 2008-12-12 17:17:47 UTC 
This is not intentional, it's just a missing feature.  I would like to get this fixed in this release.  I just noticed
it myself when we implemented the Save As feature for SQL consoles.

For now the workaround is to choose Execute Command... on a connection in the DB explorer, and then do File->Save As.
Comment 4 John Baker 2008-12-13 07:16:34 UTC 
Is this considered a defect or a feature?
Comment 5 Tomas Mysik 2008-12-15 08:27:12 UTC 
> For now the workaround is to choose Execute Command... on a connection in the DB explorer,
> and then do File->Save As.

Or just New file -> Other -> Empty file (and name it <name>.sql).

BTW I would say it's a bug, but no need to fix it in 7.0M1, 7.0M2 is fine.
Comment 6 Petr Pisl 2008-12-15 09:33:17 UTC 
We lived with this state for many years, but is not intuitive. We have a template for almost every kind of file. So to
be consistent, there should be a template for SQL as well.
Comment 7 John Baker 2008-12-17 01:05:39 UTC 
Changes attached- since I have to wait to for the branch
Comment 8 John Baker 2008-12-17 01:07:10 UTC 
Created attachment 75055 [details]
diffs
Comment 9 John Baker 2008-12-17 22:16:50 UTC 
New SQL template is working in my local repository, but commit-validation is failing.  I need to fix some things in my
layer file
Comment 10 John Baker 2008-12-17 23:16:58 UTC 
b3f151c61e4d and 8fbabb539977
Comment 11 Quality Engineering 2008-12-22 15:19:49 UTC 
Integrated into 'main-golden', will be available in build *200812221122* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main/rev/b3f151c61e4d
User: John Baker <jbaker@netbeans.org>
Log: #155276 Missing SQL template in New file wizard