|
From: <wi...@us...> - 2011-08-07 15:26:16
|
Revision: 6344
http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6344&view=rev
Author: wis775
Date: 2011-08-07 15:26:10 +0000 (Sun, 07 Aug 2011)
Log Message:
-----------
Store result of SQL in file: User documentation.
Modified Paths:
--------------
trunk/sql12/plugins/sqlscript/src/main/java/net/sourceforge/squirrel_sql/plugins/sqlscript/SQLScriptPlugin.java
trunk/sql12/plugins/sqlscript/src/main/resources/doc/changes.txt
trunk/sql12/plugins/sqlscript/src/main/resources/doc/readme.html
Added Paths:
-----------
trunk/sql12/plugins/sqlscript/src/main/resources/doc/sql2file.jpg
trunk/sql12/plugins/sqlscript/src/main/resources/doc/sql2file_exportController.jpg
trunk/sql12/plugins/sqlscript/src/main/resources/doc/sql2file_progress.jpg
Modified: trunk/sql12/plugins/sqlscript/src/main/java/net/sourceforge/squirrel_sql/plugins/sqlscript/SQLScriptPlugin.java
===================================================================
--- trunk/sql12/plugins/sqlscript/src/main/java/net/sourceforge/squirrel_sql/plugins/sqlscript/SQLScriptPlugin.java 2011-08-07 09:45:18 UTC (rev 6343)
+++ trunk/sql12/plugins/sqlscript/src/main/java/net/sourceforge/squirrel_sql/plugins/sqlscript/SQLScriptPlugin.java 2011-08-07 15:26:10 UTC (rev 6344)
@@ -97,7 +97,7 @@
*/
public String getVersion()
{
- return "1.2";
+ return "1.3";
}
/**
@@ -148,7 +148,7 @@
*/
public String getContributors()
{
- return "Gerd Wagner, John Murga, Rob Manning";
+ return "Gerd Wagner, John Murga, Rob Manning, Stefan Willinger";
}
/**
Modified: trunk/sql12/plugins/sqlscript/src/main/resources/doc/changes.txt
===================================================================
--- trunk/sql12/plugins/sqlscript/src/main/resources/doc/changes.txt 2011-08-07 09:45:18 UTC (rev 6343)
+++ trunk/sql12/plugins/sqlscript/src/main/resources/doc/changes.txt 2011-08-07 15:26:10 UTC (rev 6344)
@@ -1,6 +1,14 @@
Change Log
==========
+1.3
+===
+- Added "Store result of SQL into file"
+ This is available through the menu or the tools pop-up menu (sql2file).
+ It allows you, to store the result of a SQL directly into a file, without
+ building a result table in memory. There are the same output formats
+ available as in the traditional "Export as..." action of the result table.
+
1.2
===
Modified: trunk/sql12/plugins/sqlscript/src/main/resources/doc/readme.html
===================================================================
--- trunk/sql12/plugins/sqlscript/src/main/resources/doc/readme.html 2011-08-07 09:45:18 UTC (rev 6343)
+++ trunk/sql12/plugins/sqlscript/src/main/resources/doc/readme.html 2011-08-07 15:26:10 UTC (rev 6344)
@@ -1,40 +1,76 @@
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
- <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=iso-8859-15">
- <TITLE></TITLE>
- <META NAME="GENERATOR" CONTENT="OpenOffice.org 1.1.4 (Linux)">
- <META NAME="CREATED" CONTENT="20050606;22075000">
- <META NAME="CHANGEDBY" CONTENT="Gerd Wagner">
- <META NAME="CHANGED" CONTENT="20050606;22265300">
+<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=iso-8859-15">
+<TITLE></TITLE>
+<META NAME="GENERATOR" CONTENT="OpenOffice.org 1.1.4 (Linux)">
+<META NAME="CREATED" CONTENT="20050606;22075000">
+<META NAME="CHANGEDBY" CONTENT="Gerd Wagner">
+<META NAME="CHANGED" CONTENT="20050606;22265300">
</HEAD>
<BODY LANG="en-US" DIR="LTR">
-<P><B>SQL Scripts 1.0 </B><SPAN STYLE="font-weight: medium">- Johan
-Compagner and Gerd Wagner</SPAN></P>
-<P STYLE="font-weight: medium">This plugin provides a wide range of
-scripting functions:</P>
-<UL>
- <LI><P STYLE="font-weight: medium">You may create DDL scripts for
- tables out of the Object tree or from the Graph plugin. The scripts
- contain all constraints and indexes.</P>
- <LI><P STYLE="font-weight: medium">You may create Insert scripts out
- of the Object tree for all of a table's data.</P>
- <LI><P STYLE="font-weight: medium">You may create an insert script
- from an SQL Select statement. To do so in the SQL editor hit the
- ctrl + t shortcut to open the tools popup. Then choose the sql2ins
- function from the popup.</P>
-</UL>
-<P><IMG SRC="toolspopup.jpg" NAME="Graphic1" ALIGN=LEFT BORDER=0><BR CLEAR=LEFT><BR><BR>
-</P>
-<UL>
- <LI><P STYLE="font-weight: medium">You may store the result of an
- from an SQL Select statement in a temporary table. To do so in the
- SQL editor hit the ctrl + t shortcut to open the tools popup. Then
- choose the sql2table function from the popup.</P>
-</UL>
-<P STYLE="font-weight: medium"><IMG SRC="creattable.jpg" NAME="Graphic2" ALIGN=LEFT BORDER=0><BR CLEAR=LEFT><BR><BR>
-</P>
-<P STYLE="font-weight: medium"><BR><BR>
-</P>
+ <P>
+ <B>SQL Scripts 1.3 </B><SPAN STYLE="font-weight: medium">-
+ Johan Compagner and Gerd Wagner</SPAN>
+ </P>
+ <P STYLE="font-weight: medium">This plugin provides a wide range of
+ scripting functions:</P>
+ <UL>
+ <LI><P STYLE="font-weight: medium">You may create DDL scripts
+ for tables out of the Object tree or from the Graph plugin. The
+ scripts contain all constraints and indexes.</P>
+ <LI><P STYLE="font-weight: medium">You may create Insert
+ scripts out of the Object tree for all of a table's data.</P>
+ <LI><P STYLE="font-weight: medium">You may create an insert
+ script from an SQL Select statement. To do so in the SQL editor hit
+ the ctrl + t shortcut to open the tools popup. Then choose the
+ sql2ins function from the popup.</P>
+ <LI><P STYLE="font-weight: medium">You may export the result
+ of an SQL Select statement directly into a file. To do so in the SQL
+ editor hit the ctrl + t shortcut to open the tools pop-up. Then
+ choose the sql2file function from the pop-up. Alternative, you can
+ do this via the menu entry Session => Scripts => Store result of SQL
+ in file</P>
+ </UL>
+ <P>
+ <IMG SRC="toolspopup.jpg" NAME="Graphic1" ALIGN=LEFT BORDER=0><BR
+ CLEAR=LEFT> <BR> <BR>
+ </P>
+ <UL>
+ <LI><P STYLE="font-weight: medium">You may store the result
+ of an from an SQL Select statement in a temporary table. To do so in
+ the SQL editor hit the ctrl + t shortcut to open the tools popup.
+ Then choose the sql2table function from the popup.</P>
+ </UL>
+ <P STYLE="font-weight: medium">
+ <IMG SRC="creattable.jpg" NAME="Graphic2" ALIGN=LEFT BORDER=0><BR
+ CLEAR=LEFT> <BR> <BR>
+ </P>
+ <ul>
+ <LI>
+ <P STYLE="font-weight: medium">You may export the result of the
+ currently selected SQL Select statement directly into a file. To do
+ so, select a SQL Select statement in the SQL editor and hit the ctrl
+ + t shortcut to open the tools pop-up. Then choose the sql2file
+ function from the pop-up. Alternative, you can do this via the menu
+ entry Session => Scripts => Store result of SQL in file</P> <IMG
+ SRC="sql2file.jpg" NAME="sql2file" ALIGN=LEFT BORDER=0><BR
+ CLEAR=LEFT> <BR> <BR> After this, the control dialog
+ appears. This dialog give you the control about target, type and data
+ format. Be careful, if you decide to export the data into the MS
+ Excel format. In this case, the result is build in memory and
+ SQuirreL SQL may run out of memory.<BR> <BR> <IMG
+ SRC="sql2file_exportController.jpg" NAME="sql2file" ALIGN=LEFT
+ BORDER=0><BR CLEAR=LEFT> <BR> <BR> The export is
+ done on a new database connection, so the user can continue
+ using SQuirreL SQL while exporting the data. A progress monitor show
+ the progress of the export and you can cancel it any time. If the
+ export if done, the progress dialog disappears. <BR> <BR> <IMG
+ SRC="sql2file_progress.jpg" NAME="sql2file" ALIGN=LEFT BORDER=0>
+ <BR CLEAR=LEFT> <BR> <BR></LI>
+ </ul>
+ <P STYLE="font-weight: medium">
+ <BR> <BR>
+ </P>
</BODY>
</HTML>
Added: trunk/sql12/plugins/sqlscript/src/main/resources/doc/sql2file.jpg
===================================================================
(Binary files differ)
Property changes on: trunk/sql12/plugins/sqlscript/src/main/resources/doc/sql2file.jpg
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: trunk/sql12/plugins/sqlscript/src/main/resources/doc/sql2file_exportController.jpg
===================================================================
(Binary files differ)
Property changes on: trunk/sql12/plugins/sqlscript/src/main/resources/doc/sql2file_exportController.jpg
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: trunk/sql12/plugins/sqlscript/src/main/resources/doc/sql2file_progress.jpg
===================================================================
(Binary files differ)
Property changes on: trunk/sql12/plugins/sqlscript/src/main/resources/doc/sql2file_progress.jpg
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
