|
From: <man...@us...> - 2010-12-26 17:28:53
|
Revision: 6058
http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6058&view=rev
Author: manningr
Date: 2010-12-26 17:28:45 +0000 (Sun, 26 Dec 2010)
Log Message:
-----------
Switched to newer style archetype which uses archetype-metadata.xml instead of archetype.xml (it allows fileSets with wildcards). Also adding resources such as documentation and integration-test data (although bug in archetype plugin causes NPE when attempting to integration test at the moment: see http://jira.codehaus.org/browse/ARCHETYPE-355 for details)
Modified Paths:
--------------
trunk/sql12/plugins/squirrelsql-plugin-archetype/pom.xml
Added Paths:
-----------
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/META-INF/maven/archetype-metadata.xml
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/pom.xml
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/changes.txt
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/licence.txt
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/readme.txt
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/net/
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/net/sourceforge/
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/net/sourceforge/squirrel_sql/
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/net/sourceforge/squirrel_sql/plugins/
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/net/sourceforge/squirrel_sql/plugins/example/
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/net/sourceforge/squirrel_sql/plugins/example/example.properties
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/test/
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/test/resources/
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/test/resources/projects/
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/test/resources/projects/basic/
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/test/resources/projects/basic/archetype.properties
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/test/resources/projects/basic/goal.txt
trunk/sql12/plugins/squirrelsql-plugin-archetype/tmp/
trunk/sql12/plugins/squirrelsql-plugin-archetype/tmp/archetype.xml
Removed Paths:
-------------
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/META-INF/maven/archetype.xml
Modified: trunk/sql12/plugins/squirrelsql-plugin-archetype/pom.xml
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/pom.xml 2010-12-26 04:36:32 UTC (rev 6057)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/pom.xml 2010-12-26 17:28:45 UTC (rev 6058)
@@ -9,10 +9,89 @@
<version>3.3.0-SNAPSHOT</version>
<relativePath>../../pom.xml</relativePath>
</parent>
-
+
<groupId>net.sf.squirrel-sql.plugins</groupId>
<artifactId>squirrelsql-plugin-archetype</artifactId>
<version>3.3.0-SNAPSHOT</version>
- <name>Archetype - squirrelsql-plugin-archetype</name>
- <url>http://maven.apache.org</url>
+ <packaging>maven-archetype</packaging>
+
+ <name>SQuirreL Plugin Archetype</name>
+ <description>
+ This project produces the maven archetype that can be used to generate a SQuirreL Plugin
+ maven project. The project that is produced contains an Example plugin that demonstrates the use
+ of key plugin APIs.
+ </description>
+ <inceptionYear>2001</inceptionYear>
+ <developers>
+ <developer>
+ <name>Gerd Wagner</name>
+ <roles>
+ <role>Administrator</role>
+ <role>Developer</role>
+ </roles>
+ </developer>
+ <developer>
+ <name>Rob Manning</name>
+ <roles>
+ <role>Developer</role>
+ <role>Release Manager</role>
+ </roles>
+ </developer>
+ </developers>
+ <licenses>
+ <license>
+ <name>GNU Lesser General Public License</name>
+ <url>http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt</url>
+ <distribution>repo</distribution>
+ </license>
+ </licenses>
+ <url>http://www.squirrelsql.org/</url>
+ <scm>
+ <connection>scm:svn:https://squirrel-sql.svn.sourceforge.net/svnroot/squirrel-sql/trunk/sql12/plugins/squirrelsql-plugin-archetype</connection>
+ <developerConnection>scm:svn:https://squirrel-sql.svn.sourceforge.net/svnroot/squirrel-sql/trunk/sql12/plugins/squirrelsql-plugin-archetype</developerConnection>
+ <url>http://squirrel-sql.svn.sourceforge.net/viewvc/squirrel-sql/trunk/sql12/plugins/squirrelsql-plugin-archetype</url>
+ </scm>
+ <issueManagement>
+ <system>SourceForge Tracker</system>
+ <url>http://sourceforge.net/tracker/?group_id=28383%26atid=393414</url>
+ </issueManagement>
+ <ciManagement>
+ <system>Hudson</system>
+ <url>https://www.squirrel-sql.org/hudson/</url>
+ </ciManagement>
+
+
+ <build>
+ <extensions>
+ <extension>
+ <groupId>org.apache.maven.archetype</groupId>
+ <artifactId>archetype-packaging</artifactId>
+ <version>2.0</version>
+ </extension>
+ </extensions>
+
+ <pluginManagement>
+ <plugins>
+ <plugin>
+ <artifactId>maven-archetype-plugin</artifactId>
+ <version>2.0</version>
+ </plugin>
+ </plugins>
+ </pluginManagement>
+ </build>
+
+ <distributionManagement>
+ <repository>
+ <id>sonatype-nexus-staging</id>
+ <name>Nexus Release Repository</name>
+ <url>https://oss.sonatype.org/service/local/staging/deploy/maven2/</url>
+ </repository>
+ <snapshotRepository>
+ <id>sonatype-nexus-snapshots</id>
+ <name>Sonatype Nexus Snapshots</name>
+ <url>https://oss.sonatype.org/content/repositories/snapshots</url>
+ </snapshotRepository>
+ </distributionManagement>
+
+
</project>
Added: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/META-INF/maven/archetype-metadata.xml
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/META-INF/maven/archetype-metadata.xml (rev 0)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/META-INF/maven/archetype-metadata.xml 2010-12-26 17:28:45 UTC (rev 6058)
@@ -0,0 +1,26 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<archetype-descriptor xsi:schemaLocation="http://maven.apache.org/plugins/maven-archetype-plugin/archetype-descriptor/1.0.0 http://maven.apache.org/xsd/archetype-descriptor-1.0.0.xsd" name="example"
+ xmlns="http://maven.apache.org/plugins/maven-archetype-plugin/archetype-descriptor/1.0.0"
+ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
+ <fileSets>
+ <fileSet filtered="true" packaged="true" encoding="UTF-8">
+ <directory>src/main/java</directory>
+ <includes>
+ <include>**/*.java</include>
+ </includes>
+ </fileSet>
+ <fileSet filtered="true" encoding="UTF-8">
+ <directory>src/main/resources</directory>
+ <includes>
+ <include>**/*.properties</include>
+ <include>**/*.txt</include>
+ </includes>
+ </fileSet>
+ <fileSet filtered="true" packaged="true" encoding="UTF-8">
+ <directory>src/test/java</directory>
+ <includes>
+ <include>**/*.java</include>
+ </includes>
+ </fileSet>
+ </fileSets>
+</archetype-descriptor>
Deleted: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/META-INF/maven/archetype.xml
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/META-INF/maven/archetype.xml 2010-12-26 04:36:32 UTC (rev 6057)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/META-INF/maven/archetype.xml 2010-12-26 17:28:45 UTC (rev 6058)
@@ -1,17 +0,0 @@
-<archetype>
- <id>squirrelsql-plugin-archetype</id>
- <sources>
- <source>src/main/java/net/sourceforge/squirrel_sql/plugins/example/ExamplePlugin.java</source>
- <source>src/main/java/net/sourceforge/squirrel_sql/plugins/example/ScriptDB2ProcedureAction.java</source>
- <source>src/main/java/net/sourceforge/squirrel_sql/plugins/example/ScriptDB2ViewAction.java</source>
- </sources>
- <resources>
- <resource>src/main/resources/doc/changes.txt</resource>
- <resource>src/main/resources/doc/licence.txt</resource>
- <resource>src/main/resources/doc/readme.txt</resource>
- <resource>src/main/resources/net/sourceforge/squirrel_sql/plugins/example/example.properties</resource>
- </resources>
- <testSources>
- <source>src/test/java/net/sourceforge/squirrel_sql/plugins/example/ExamplePluginTest.java</source>
- </testSources>
-</archetype>
Added: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/pom.xml
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/pom.xml (rev 0)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/pom.xml 2010-12-26 17:28:45 UTC (rev 6058)
@@ -0,0 +1,119 @@
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
+ <modelVersion>4.0.0</modelVersion>
+
+ <parent>
+ <groupId>net.sf.squirrel-sql.plugins</groupId>
+ <artifactId>squirrelsql-plugins-parent-pom</artifactId>
+ <version>3.3.0-SNAPSHOT</version>
+ </parent>
+
+ <groupId>${groupId}</groupId>
+ <artifactId>${artifactId}</artifactId>
+ <version>${version}</version>
+ <packaging>jar</packaging>
+ <description>Example Plugin</description>
+ <inceptionYear>2001</inceptionYear>
+ <developers>
+ <developer>
+ <name>Gerd Wagner</name>
+ <roles>
+ <role>Administrator</role>
+ <role>Developer</role>
+ </roles>
+ </developer>
+ <developer>
+ <name>Rob Manning</name>
+ <roles>
+ <role>Developer</role>
+ <role>Release Manager</role>
+ </roles>
+ </developer>
+ </developers>
+ <licenses>
+ <license>
+ <name>GNU Lesser General Public License</name>
+ <url>http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt</url>
+ <distribution>repo</distribution>
+ </license>
+ </licenses>
+ <url>http://www.squirrelsql.org/</url>
+ <scm>
+ <connection>scm:svn:https://squirrel-sql.svn.sourceforge.net/svnroot/squirrel-sql/trunk/sql12/plugins/oracle</connection>
+ <developerConnection>scm:svn:https://squirrel-sql.svn.sourceforge.net/svnroot/squirrel-sql/trunk/sql12/plugins/oracle</developerConnection>
+ <url>http://squirrel-sql.svn.sourceforge.net/viewvc/squirrel-sql/trunk/sql12/plugins/oracle</url>
+ </scm>
+ <issueManagement>
+ <system>SourceForge Tracker</system>
+ <url>http://sourceforge.net/tracker/?group_id=28383%26atid=393414</url>
+ </issueManagement>
+ <ciManagement>
+ <system>Hudson</system>
+ <url>https://www.squirrel-sql.org/hudson/</url>
+ </ciManagement>
+ <dependencies>
+ <dependency>
+ <groupId>net.sf.squirrel-sql</groupId>
+ <artifactId>fw</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>net.sf.squirrel-sql</groupId>
+ <artifactId>squirrel-sql</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>net.sf.squirrel-sql</groupId>
+ <artifactId>squirrel-sql</artifactId>
+ <type>test-jar</type>
+ <scope>test</scope>
+ </dependency>
+ <dependency>
+ <groupId>gsbase</groupId>
+ <artifactId>gsbase</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>junit</groupId>
+ <artifactId>junit</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>org.easymock</groupId>
+ <artifactId>easymock</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>org.easymock</groupId>
+ <artifactId>easymockclassextension</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>org.mockito</groupId>
+ <artifactId>mockito-all</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>net.sf.squirrel-sql.thirdparty-non-maven</groupId>
+ <artifactId>treetable</artifactId>
+ <version>20040121</version>
+ </dependency>
+ </dependencies>
+ <properties>
+ <pluginClassName>net.sourceforge.squirrel_sql.plugins.example.ExamplePlugin</pluginClassName>
+ </properties>
+ <build>
+ <plugins>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-source-plugin</artifactId>
+ </plugin>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-surefire-plugin</artifactId>
+ </plugin>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-jar-plugin</artifactId>
+ </plugin>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-assembly-plugin</artifactId>
+ </plugin>
+ </plugins>
+ </build>
+
+</project>
Added: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/changes.txt
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/changes.txt (rev 0)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/changes.txt 2010-12-26 17:28:45 UTC (rev 6058)
@@ -0,0 +1,6 @@
+Change Log
+==========
+
+0.01
+===
+- Initial release
Added: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/licence.txt
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/licence.txt (rev 0)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/licence.txt 2010-12-26 17:28:45 UTC (rev 6058)
@@ -0,0 +1,503 @@
+ GNU LESSER GENERAL PUBLIC LICENSE
+ Version 2.1, February 1999
+
+ Copyright (C) 1991, 1999 Free Software Foundation, Inc.
+ 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+ Everyone is permitted to copy and distribute verbatim copies
+ of this license document, but changing it is not allowed.
+
+[This is the first released version of the Lesser GPL. It also counts
+ as the successor of the GNU Library Public License, version 2, hence
+ the version number 2.1.]
+
+ Preamble
+
+ The licenses for most software are designed to take away your
+freedom to share and change it. By contrast, the GNU General Public
+Licenses are intended to guarantee your freedom to share and change
+free software--to make sure the software is free for all its users.
+
+ This license, the Lesser General Public License, applies to some
+specially designated software packages--typically libraries--of the
+Free Software Foundation and other authors who decide to use it. You
+can use it too, but we suggest you first think carefully about whether
+this license or the ordinary General Public License is the better
+strategy to use in any particular case, based on the explanations below.
+
+ When we speak of free software, we are referring to freedom of use,
+not price. Our General Public Licenses are designed to make sure that
+you have the freedom to distribute copies of free software (and charge
+for this service if you wish); that you receive source code or can get
+it if you want it; that you can change the software and use pieces of
+it in new free programs; and that you are informed that you can do
+these things.
+
+ To protect your rights, we need to make restrictions that forbid
+distributors to deny you these rights or to ask you to surrender these
+rights. These restrictions translate to certain responsibilities for
+you if you distribute copies of the library or if you modify it.
+
+ For example, if you distribute copies of the library, whether gratis
+or for a fee, you must give the recipients all the rights that we gave
+you. You must make sure that they, too, receive or can get the source
+code. If you link other code with the library, you must provide
+complete object files to the recipients, so that they can relink them
+with the library after making changes to the library and recompiling
+it. And you must show them these terms so they know their rights.
+
+ We protect your rights with a two-step method: (1) we copyright the
+library, and (2) we offer you this license, which gives you legal
+permission to copy, distribute and/or modify the library.
+
+ To protect each distributor, we want to make it very clear that
+there is no warranty for the free library. Also, if the library is
+modified by someone else and passed on, the recipients should know
+that what they have is not the original version, so that the original
+author's reputation will not be affected by problems that might be
+introduced by others.
+
+ Finally, software patents pose a constant threat to the existence of
+any free program. We wish to make sure that a company cannot
+effectively restrict the users of a free program by obtaining a
+restrictive license from a patent holder. Therefore, we insist that
+any patent license obtained for a version of the library must be
+consistent with the full freedom of use specified in this license.
+
+ Most GNU software, including some libraries, is covered by the
+ordinary GNU General Public License. This license, the GNU Lesser
+General Public License, applies to certain designated libraries, and
+is quite different from the ordinary General Public License. We use
+this license for certain libraries in order to permit linking those
+libraries into non-free programs.
+
+ When a program is linked with a library, whether statically or using
+a shared library, the combination of the two is legally speaking a
+combined work, a derivative of the original library. The ordinary
+General Public License therefore permits such linking only if the
+entire combination fits its criteria of freedom. The Lesser General
+Public License permits more lax criteria for linking other code with
+the library.
+
+ We call this license the "Lesser" General Public License because it
+does Less to protect the user's freedom than the ordinary General
+Public License. It also provides other free software developers Less
+of an advantage over competing non-free programs. These disadvantages
+are the reason we use the ordinary General Public License for many
+libraries. However, the Lesser license provides advantages in certain
+special circumstances.
+
+ For example, on rare occasions, there may be a special need to
+encourage the widest possible use of a certain library, so that it becomes
+a de-facto standard. To achieve this, non-free programs must be
+allowed to use the library. A more frequent case is that a free
+library does the same job as widely used non-free libraries. In this
+case, there is little to gain by limiting the free library to free
+software only, so we use the Lesser General Public License.
+
+ In other cases, permission to use a particular library in non-free
+programs enables a greater number of people to use a large body of
+free software. For example, permission to use the GNU C Library in
+non-free programs enables many more people to use the whole GNU
+operating system, as well as its variant, the GNU/Linux operating
+system.
+
+ Although the Lesser General Public License is Less protective of the
+users' freedom, it does ensure that the user of a program that is
+linked with the Library has the freedom and the wherewithal to run
+that program using a modified version of the Library.
+
+ The precise terms and conditions for copying, distribution and
+modification follow. Pay close attention to the difference between a
+"work based on the library" and a "work that uses the library". The
+former contains code derived from the library, whereas the latter must
+be combined with the library in order to run.
+
+ GNU LESSER GENERAL PUBLIC LICENSE
+ TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION
+
+ 0. This License Agreement applies to any software library or other
+program which contains a notice placed by the copyright holder or
+other authorized party saying it may be distributed under the terms of
+this Lesser General Public License (also called "this License").
+Each licensee is addressed as "you".
+
+ A "library" means a collection of software functions and/or data
+prepared so as to be conveniently linked with application programs
+(which use some of those functions and data) to form executables.
+
+ The "Library", below, refers to any such software library or work
+which has been distributed under these terms. A "work based on the
+Library" means either the Library or any derivative work under
+copyright law: that is to say, a work containing the Library or a
+portion of it, either verbatim or with modifications and/or translated
+straightforwardly into another language. (Hereinafter, translation is
+included without limitation in the term "modification".)
+
+ "Source code" for a work means the preferred form of the work for
+making modifications to it. For a library, complete source code means
+all the source code for all modules it contains, plus any associated
+interface definition files, plus the scripts used to control compilation
+and installation of the library.
+
+ Activities other than copying, distribution and modification are not
+covered by this License; they are outside its scope. The act of
+running a program using the Library is not restricted, and output from
+such a program is covered only if its contents constitute a work based
+on the Library (independent of the use of the Library in a tool for
+writing it). Whether that is true depends on what the Library does
+and what the program that uses the Library does.
+
+ 1. You may copy and distribute verbatim copies of the Library's
+complete source code as you receive it, in any medium, provided that
+you conspicuously and appropriately publish on each copy an
+appropriate copyright notice and disclaimer of warranty; keep intact
+all the notices that refer to this License and to the absence of any
+warranty; and distribute a copy of this License along with the
+Library.
+
+ You may charge a fee for the physical act of transferring a copy,
+and you may at your option offer warranty protection in exchange for a
+fee.
+
+ 2. You may modify your copy or copies of the Library or any portion
+of it, thus forming a work based on the Library, and copy and
+distribute such modifications or work under the terms of Section 1
+above, provided that you also meet all of these conditions:
+
+ a) The modified work must itself be a software library.
+
+ b) You must cause the files modified to carry prominent notices
+ stating that you changed the files and the date of any change.
+
+ c) You must cause the whole of the work to be licensed at no
+ charge to all third parties under the terms of this License.
+
+ d) If a facility in the modified Library refers to a function or a
+ table of data to be supplied by an application program that uses
+ the facility, other than as an argument passed when the facility
+ is invoked, then you must make a good faith effort to ensure that,
+ in the event an application does not supply such function or
+ table, the facility still operates, and performs whatever part of
+ its purpose remains meaningful.
+
+ (For example, a function in a library to compute square roots has
+ a purpose that is entirely well-defined independent of the
+ application. Therefore, Subsection 2d requires that any
+ application-supplied function or table used by this function must
+ be optional: if the application does not supply it, the square
+ root function must still compute square roots.)
+
+These requirements apply to the modified work as a whole. If
+identifiable sections of that work are not derived from the Library,
+and can be reasonably considered independent and separate works in
+themselves, then this License, and its terms, do not apply to those
+sections when you distribute them as separate works. But when you
+distribute the same sections as part of a whole which is a work based
+on the Library, the distribution of the whole must be on the terms of
+this License, whose permissions for other licensees extend to the
+entire whole, and thus to each and every part regardless of who wrote
+it.
+
+Thus, it is not the intent of this section to claim rights or contest
+your rights to work written entirely by you; rather, the intent is to
+exercise the right to control the distribution of derivative or
+collective works based on the Library.
+
+In addition, mere aggregation of another work not based on the Library
+with the Library (or with a work based on the Library) on a volume of
+a storage or distribution medium does not bring the other work under
+the scope of this License.
+
+ 3. You may opt to apply the terms of the ordinary GNU General Public
+License instead of this License to a given copy of the Library. To do
+this, you must alter all the notices that refer to this License, so
+that they refer to the ordinary GNU General Public License, version 2,
+instead of to this License. (If a newer version than version 2 of the
+ordinary GNU General Public License has appeared, then you can specify
+that version instead if you wish.) Do not make any other change in
+these notices.
+
+ Once this change is made in a given copy, it is irreversible for
+that copy, so the ordinary GNU General Public License applies to all
+subsequent copies and derivative works made from that copy.
+
+ This option is useful when you wish to copy part of the code of
+the Library into a program that is not a library.
+
+ 4. You may copy and distribute the Library (or a portion or
+derivative of it, under Section 2) in object code or executable form
+under the terms of Sections 1 and 2 above provided that you accompany
+it with the complete corresponding machine-readable source code, which
+must be distributed under the terms of Sections 1 and 2 above on a
+medium customarily used for software interchange.
+
+ If distribution of object code is made by offering access to copy
+from a designated place, then offering equivalent access to copy the
+source code from the same place satisfies the requirement to
+distribute the source code, even though third parties are not
+compelled to copy the source along with the object code.
+
+ 5. A program that contains no derivative of any portion of the
+Library, but is designed to work with the Library by being compiled or
+linked with it, is called a "work that uses the Library". Such a
+work, in isolation, is not a derivative work of the Library, and
+therefore falls outside the scope of this License.
+
+ However, linking a "work that uses the Library" with the Library
+creates an executable that is a derivative of the Library (because it
+contains portions of the Library), rather than a "work that uses the
+library". The executable is therefore covered by this License.
+Section 6 states terms for distribution of such executables.
+
+ When a "work that uses the Library" uses material from a header file
+that is part of the Library, the object code for the work may be a
+derivative work of the Library even though the source code is not.
+Whether this is true is especially significant if the work can be
+linked without the Library, or if the work is itself a library. The
+threshold for this to be true is not precisely defined by law.
+
+ If such an object file uses only numerical parameters, data
+structure layouts and accessors, and small macros and small inline
+functions (ten lines or less in length), then the use of the object
+file is unrestricted, regardless of whether it is legally a derivative
+work. (Executables containing this object code plus portions of the
+Library will still fall under Section 6.)
+
+ Otherwise, if the work is a derivative of the Library, you may
+distribute the object code for the work under the terms of Section 6.
+Any executables containing that work also fall under Section 6,
+whether or not they are linked directly with the Library itself.
+
+ 6. As an exception to the Sections above, you may also combine or
+link a "work that uses the Library" with the Library to produce a
+work containing portions of the Library, and distribute that work
+under terms of your choice, provided that the terms permit
+modification of the work for the customer's own use and reverse
+engineering for debugging such modifications.
+
+ You must give prominent notice with each copy of the work that the
+Library is used in it and that the Library and its use are covered by
+this License. You must supply a copy of this License. If the work
+during execution displays copyright notices, you must include the
+copyright notice for the Library among them, as well as a reference
+directing the user to the copy of this License. Also, you must do one
+of these things:
+
+ a) Accompany the work with the complete corresponding
+ machine-readable source code for the Library including whatever
+ changes were used in the work (which must be distributed under
+ Sections 1 and 2 above); and, if the work is an executable linked
+ with the Library, with the complete machine-readable "work that
+ uses the Library", as object code and/or source code, so that the
+ user can modify the Library and then relink to produce a modified
+ executable containing the modified Library. (It is understood
+ that the user who changes the contents of definitions files in the
+ Library will not necessarily be able to recompile the application
+ to use the modified definitions.)
+
+ b) Use a...
[truncated message content] |
|
From: <man...@us...> - 2010-12-28 15:26:37
|
Revision: 6064
http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6064&view=rev
Author: manningr
Date: 2010-12-28 15:26:29 +0000 (Tue, 28 Dec 2010)
Log Message:
-----------
Removed the copies of the Example plugin files under archetype-resources/. Now, the dependency plugin is used to copy these files in from the Example project's artifacts. Also, a new integration test runs by using the invoker plugin to create an archetype project from this archetype and verify that it builds successfully.
Modified Paths:
--------------
trunk/sql12/plugins/squirrelsql-plugin-archetype/pom.xml
Added Paths:
-----------
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/it/
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/it/projects/
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/it/projects/firsttest/
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/it/projects/firsttest/test.properties
Removed Paths:
-------------
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/net/sourceforge/squirrel_sql/plugins/example/ExamplePlugin.java
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/net/sourceforge/squirrel_sql/plugins/example/ExampleSqlExecutionListener.java
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/net/sourceforge/squirrel_sql/plugins/example/ScriptDB2ProcedureAction.java
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/net/sourceforge/squirrel_sql/plugins/example/ScriptDB2ViewAction.java
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/changes.txt
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/licence.txt
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/readme.txt
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/net/sourceforge/squirrel_sql/plugins/example/example.properties
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/test/java/net/sourceforge/squirrel_sql/plugins/example/ExamplePluginTest.java
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/test/java/net/sourceforge/squirrel_sql/plugins/example/ExampleSqlExecutionListenerTest.java
Modified: trunk/sql12/plugins/squirrelsql-plugin-archetype/pom.xml
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/pom.xml 2010-12-28 15:23:27 UTC (rev 6063)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/pom.xml 2010-12-28 15:26:29 UTC (rev 6064)
@@ -17,8 +17,9 @@
<name>SQuirreL Plugin Archetype</name>
<description>
- This project produces the maven archetype that can be used to generate a SQuirreL Plugin
- maven project. The project that is produced contains an Example plugin that demonstrates the use
+ This project produces the maven archetype that can be used to generate a SQuirreL
+ Plugin
+ maven project. The project that is produced contains an Example plugin that demonstrates the use
of key plugin APIs.
</description>
<inceptionYear>2001</inceptionYear>
@@ -49,7 +50,8 @@
<scm>
<connection>scm:svn:https://squirrel-sql.svn.sourceforge.net/svnroot/squirrel-sql/trunk/sql12/plugins/squirrelsql-plugin-archetype</connection>
<developerConnection>scm:svn:https://squirrel-sql.svn.sourceforge.net/svnroot/squirrel-sql/trunk/sql12/plugins/squirrelsql-plugin-archetype</developerConnection>
- <url>http://squirrel-sql.svn.sourceforge.net/viewvc/squirrel-sql/trunk/sql12/plugins/squirrelsql-plugin-archetype</url>
+ <url>http://squirrel-sql.svn.sourceforge.net/viewvc/squirrel-sql/trunk/sql12/plugins/squirrelsql-plugin-archetype
+ </url>
</scm>
<issueManagement>
<system>SourceForge Tracker</system>
@@ -60,7 +62,21 @@
<url>https://www.squirrel-sql.org/hudson/</url>
</ciManagement>
-
+ <dependencies>
+ <dependency>
+ <groupId>net.sf.squirrel-sql.plugins</groupId>
+ <artifactId>example</artifactId>
+ <version>${project.version}</version>
+ <classifier>sources</classifier>
+ </dependency>
+ <dependency>
+ <groupId>net.sf.squirrel-sql.plugins</groupId>
+ <artifactId>example</artifactId>
+ <version>${project.version}</version>
+ <classifier>test-sources</classifier>
+ </dependency>
+
+ </dependencies>
<build>
<extensions>
<extension>
@@ -78,6 +94,132 @@
</plugin>
</plugins>
</pluginManagement>
+
+ <plugins>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-dependency-plugin</artifactId>
+ <version>2.1</version>
+ <executions>
+ <execution>
+ <id>copy-example-project-java</id>
+ <phase>generate-resources</phase>
+ <goals>
+ <goal>unpack-dependencies</goal>
+ </goals>
+ <configuration>
+ <includeArtifactIds>example</includeArtifactIds>
+ <includeClassifiers>sources</includeClassifiers>
+ <includes>**\/*.java</includes>
+ <excludes>**\/*Test.java</excludes>
+ <outputDirectory>src/main/resources/archetype-resources/src/main/java</outputDirectory>
+ <markersDirectory>target/dependency-maven-plugin-markers-java</markersDirectory>
+ </configuration>
+ </execution>
+ <execution>
+ <id>copy-example-project-java-tests</id>
+ <phase>generate-resources</phase>
+ <goals>
+ <goal>unpack-dependencies</goal>
+ </goals>
+ <configuration>
+ <includeArtifactIds>example</includeArtifactIds>
+ <includeClassifiers>test-sources</includeClassifiers>
+ <includes>**\/*Test.java</includes>
+ <outputDirectory>src/main/resources/archetype-resources/src/test/java</outputDirectory>
+ <markersDirectory>target/dependency-maven-plugin-markers-test-java</markersDirectory>
+ </configuration>
+ </execution>
+ <execution>
+ <id>copy-example-project-properties</id>
+ <phase>generate-resources</phase>
+ <goals>
+ <goal>unpack-dependencies</goal>
+ </goals>
+ <configuration>
+ <includeArtifactIds>example</includeArtifactIds>
+ <includeClassifiers>sources</includeClassifiers>
+ <includes>**\/*.properties</includes>
+ <outputDirectory>src/main/resources/archetype-resources/src/main/resources</outputDirectory>
+ <markersDirectory>target/dependency-maven-plugin-markers-properties</markersDirectory>
+ </configuration>
+ </execution>
+ <execution>
+ <id>copy-example-project-docs</id>
+ <phase>generate-resources</phase>
+ <goals>
+ <goal>unpack-dependencies</goal>
+ </goals>
+ <configuration>
+ <includeArtifactIds>example</includeArtifactIds>
+ <includeClassifiers>sources</includeClassifiers>
+ <includes>**\/*.txt</includes>
+ <outputDirectory>src/main/resources/archetype-resources/src/main/resources</outputDirectory>
+ <markersDirectory>target/dependency-maven-plugin-markers-docs</markersDirectory>
+ </configuration>
+ </execution>
+
+ </executions>
+
+ </plugin>
+ <!--
+ This will test that the archetype can be used to create a new plugin project (in
+ target/it/projects) and that the plugin project will successfully build. This pattern was found
+ in a discussion about how to test archetypes here:
+ http://maven.40175.n5.nabble.com/unit-testing-archetypes-td75257.html#a75257 or
+ http://bit.ly/gABNDE if this url ever goes away.
+ -->
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-invoker-plugin</artifactId>
+ <version>1.5</version>
+ <executions>
+ <execution>
+ <id>generate-projects</id>
+ <goals>
+ <goal>install</goal>
+ <goal>run</goal>
+ </goals>
+ <configuration>
+ <cloneProjectsTo>${project.build.directory}/it/projects</cloneProjectsTo>
+ <goals>
+ <goal>org.apache.maven.plugins:maven-archetype-plugin:generate</goal>
+ </goals>
+ <pomIncludes>
+ <pomInclude>*</pomInclude>
+ </pomIncludes>
+ <projectsDirectory>${basedir}/src/it/projects</projectsDirectory>
+ <properties>
+ <archetypeArtifactId>${project.artifactId}</archetypeArtifactId>
+ <archetypeGroupId>${project.groupId}</archetypeGroupId>
+ <archetypeVersion>${project.version}</archetypeVersion>
+ <interactiveMode>false</interactiveMode>
+ </properties>
+ </configuration>
+ </execution>
+ <execution>
+ <id>verify-projects</id>
+ <goals>
+ <goal>run</goal>
+ </goals>
+ <configuration>
+ <goals>
+ <goal>verify</goal>
+ </goals>
+ <pomIncludes>
+ <pomInclude>*/*/pom.xml</pomInclude>
+ </pomIncludes>
+ <projectsDirectory>${project.build.directory}/it/projects</projectsDirectory>
+ </configuration>
+ </execution>
+ </executions>
+ <configuration>
+ <streamLogs>true</streamLogs>
+ </configuration>
+ </plugin>
+
+
+ </plugins>
</build>
<distributionManagement>
Added: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/it/projects/firsttest/test.properties
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/it/projects/firsttest/test.properties (rev 0)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/it/projects/firsttest/test.properties 2010-12-28 15:26:29 UTC (rev 6064)
@@ -0,0 +1,4 @@
+groupId=com.foo
+artifactId=firsttest
+version=1.0.0
+package=com.foo.firsttest
Deleted: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/net/sourceforge/squirrel_sql/plugins/example/ExamplePlugin.java
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/net/sourceforge/squirrel_sql/plugins/example/ExamplePlugin.java 2010-12-28 15:23:27 UTC (rev 6063)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/net/sourceforge/squirrel_sql/plugins/example/ExamplePlugin.java 2010-12-28 15:26:29 UTC (rev 6064)
@@ -1,173 +0,0 @@
-package net.sourceforge.squirrel_sql.plugins.example;
-
-import net.sourceforge.squirrel_sql.client.plugin.DefaultSessionPlugin;
-import net.sourceforge.squirrel_sql.client.plugin.PluginException;
-import net.sourceforge.squirrel_sql.client.plugin.PluginResources;
-import net.sourceforge.squirrel_sql.client.plugin.PluginSessionCallback;
-import net.sourceforge.squirrel_sql.client.plugin.PluginSessionCallbackAdaptor;
-import net.sourceforge.squirrel_sql.client.preferences.IGlobalPreferencesPanel;
-import net.sourceforge.squirrel_sql.client.session.IObjectTreeAPI;
-import net.sourceforge.squirrel_sql.client.session.ISession;
-import net.sourceforge.squirrel_sql.fw.dialects.DialectFactory;
-import net.sourceforge.squirrel_sql.fw.sql.DatabaseObjectType;
-import net.sourceforge.squirrel_sql.fw.util.IMessageHandler;
-
-/**
- * <pre>
- * The Example plugin class. If the database session's type is DB2, this plugin registers a menu action in
- * the popup menu for view and procedure nodes in the ObjectTree.
- *
- * For detailed information and usage of the Plugin API see the following:
- *
- * https://sourceforge.net/apps/trac/squirrel-sql/wiki/SQuirreLSQLClientPluginAPI
- * </pre>
- */
-public class ExamplePlugin extends DefaultSessionPlugin
-{
- private PluginResources _resources;
-
- /**
- * Return the internal name of this plugin.
- *
- * @return the internal name of this plugin.
- */
- public String getInternalName()
- {
- return "example";
- }
-
- /**
- * Return the descriptive name of this plugin.
- *
- * @return the descriptive name of this plugin.
- */
- public String getDescriptiveName()
- {
- return "Example Plugin";
- }
-
- /**
- * Returns the current version of this plugin.
- *
- * @return the current version of this plugin.
- */
- public String getVersion()
- {
- return "0.01";
- }
-
- /**
- * Returns the authors name.
- *
- * @return the authors name.
- */
- public String getAuthor()
- {
- return "Gerd Wagner";
- }
-
- /**
- * Returns the name of the change log for the plugin. This should be a text or HTML file residing in the
- * <TT>getPluginAppSettingsFolder</TT> directory.
- *
- * @return the changelog file name or <TT>null</TT> if plugin doesn't have a change log.
- */
- public String getChangeLogFileName()
- {
- return "changes.txt";
- }
-
- /**
- * Returns the name of the Help file for the plugin. This should be a text or HTML file residing in the
- * <TT>getPluginAppSettingsFolder</TT> directory.
- *
- * @return the Help file name or <TT>null</TT> if plugin doesn't have a help file.
- */
- public String getHelpFileName()
- {
- return "readme.txt";
- }
-
- /**
- * Returns the name of the Licence file for the plugin. This should be a text or HTML file residing in the
- * <TT>getPluginAppSettingsFolder</TT> directory.
- *
- * @return the Licence file name or <TT>null</TT> if plugin doesn't have a licence file.
- */
- public String getLicenceFileName()
- {
- return "licence.txt";
- }
-
- /**
- * @return Comma separated list of contributors.
- */
- public String getContributors()
- {
- return "";
- }
-
- /**
- * Create preferences panel for the Global Preferences dialog.
- *
- * @return Preferences panel.
- */
- public IGlobalPreferencesPanel[] getGlobalPreferencePanels()
- {
- return new IGlobalPreferencesPanel[0];
- }
-
- /**
- * Initialize this plugin.
- */
- public synchronized void initialize() throws PluginException
- {
- _resources = new PluginResources("net.sourceforge.squirrel_sql.plugins.example.example", this);
- }
-
- /**
- * Called when a session started. Add commands to popup menu in object tree.
- *
- * @param session
- * The session that is starting.
- * @return An implementation of PluginSessionCallback or null to indicate the plugin does not work with
- * this session
- */
- public PluginSessionCallback sessionStarted(ISession session)
- {
- // Adds the view and procedure script actions if the session is DB2.
- addTreeNodeMenuActionsForDB2(session);
-
- // Register a custom ISQLExecutionListener implementation that simply prints all SQL being executed to
- // the message panel.
- IMessageHandler messageHandler = session.getApplication().getMessageHandler();
- ExampleSqlExecutionListener sqlExecutionListener = new ExampleSqlExecutionListener(messageHandler);
- session.getSessionSheet().getSQLPaneAPI().addSQLExecutionListener(sqlExecutionListener);
-
- return new PluginSessionCallbackAdaptor(this);
- }
-
- private void addTreeNodeMenuActionsForDB2(ISession session)
- {
- try
- {
- if (DialectFactory.isDB2(session.getMetaData()))
- {
- // Plugin knows only how to script Views and Stored Procedures on DB2.
- // So if it's not a DB2 Session we tell SQuirreL the Plugin should not be used.
-
- // Add context menu items to the object tree's view and procedure nodes.
- IObjectTreeAPI otApi = session.getSessionInternalFrame().getObjectTreeAPI();
- otApi.addToPopup(DatabaseObjectType.VIEW, new ScriptDB2ViewAction(session.getApplication(),
- _resources, session));
- otApi.addToPopup(DatabaseObjectType.PROCEDURE, new ScriptDB2ProcedureAction(
- session.getApplication(), _resources, session));
- }
- }
- catch (Exception e)
- {
- throw new RuntimeException(e);
- }
- }
-
-}
Deleted: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/net/sourceforge/squirrel_sql/plugins/example/ExampleSqlExecutionListener.java
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/net/sourceforge/squirrel_sql/plugins/example/ExampleSqlExecutionListener.java 2010-12-28 15:23:27 UTC (rev 6063)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/net/sourceforge/squirrel_sql/plugins/example/ExampleSqlExecutionListener.java 2010-12-28 15:26:29 UTC (rev 6064)
@@ -1,54 +0,0 @@
-package net.sourceforge.squirrel_sql.plugins.example;
-
-import net.sourceforge.squirrel_sql.client.session.event.ISQLExecutionListener;
-import net.sourceforge.squirrel_sql.fw.util.IMessageHandler;
-
-/*
- * Copyright (C) 2010 Rob Manning
- * man...@us...
- *
- * This library is free software; you can redistribute it and/or
- * modify it under the terms of the GNU Lesser General Public
- * License as published by the Free Software Foundation; either
- * version 2.1 of the License, or (at your option) any later version.
- *
- * This library is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
- * Lesser General Public License for more details.
- *
- * You should have received a copy of the GNU Lesser General Public
- * License along with this library; if not, write to the Free Software
- * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
- */
-
-/**
- * A simple ISQLExecutionListener that displays the SQL as it is being executed in the main application
- * message panel (at the bottom of the application).
- */
-public class ExampleSqlExecutionListener implements ISQLExecutionListener
-{
- /** This is what gives the ability to print a message to the message panel */
- private final IMessageHandler _messageHandler;
-
- public ExampleSqlExecutionListener(IMessageHandler messageHandler) {
- _messageHandler = messageHandler;
- }
-
- @Override
- public void statementExecuted(String sql)
- {
- _messageHandler.showMessage("statementExecuted: "+sql);
- }
-
- @Override
- public String statementExecuting(String sql)
- {
- _messageHandler.showMessage("statementExecuting: "+sql);
-
- // We don't modify the SQL in this example. in addition to modifying it, we could veto it's execution
- // by returning null.
- return sql;
- }
-
-}
Deleted: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/net/sourceforge/squirrel_sql/plugins/example/ScriptDB2ProcedureAction.java
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/net/sourceforge/squirrel_sql/plugins/example/ScriptDB2ProcedureAction.java 2010-12-28 15:23:27 UTC (rev 6063)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/net/sourceforge/squirrel_sql/plugins/example/ScriptDB2ProcedureAction.java 2010-12-28 15:26:29 UTC (rev 6064)
@@ -1,82 +0,0 @@
-package net.sourceforge.squirrel_sql.plugins.example;
-
-import java.awt.event.ActionEvent;
-import java.sql.PreparedStatement;
-import java.sql.ResultSet;
-
-import net.sourceforge.squirrel_sql.client.IApplication;
-import net.sourceforge.squirrel_sql.client.action.SquirrelAction;
-import net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame;
-import net.sourceforge.squirrel_sql.client.session.ISession;
-import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo;
-import net.sourceforge.squirrel_sql.fw.sql.IProcedureInfo;
-import net.sourceforge.squirrel_sql.fw.sql.SQLUtilities;
-import net.sourceforge.squirrel_sql.fw.util.Resources;
-
-public class ScriptDB2ProcedureAction extends SquirrelAction {
- private static final long serialVersionUID = 1L;
-
- transient private ISession _session;
-
- // /////////////////////////////////////////////////////////
- // IBM DB 2 specific code to read procedure definitions.
- private static final String SQL =
- "SELECT TEXT " +
- "FROM SYSIBM.SYSPROCEDURES " +
- "WHERE PROCNAME = ? ";
-
- public ScriptDB2ProcedureAction(IApplication app, Resources rsrc,
- ISession session) {
- super(app, rsrc);
- _session = session;
- }
-
- public void actionPerformed(ActionEvent evt) {
- PreparedStatement stat = null;
- ResultSet res = null;
- try {
-
- IDatabaseObjectInfo[] dbObjs = _session.getSessionInternalFrame()
- .getObjectTreeAPI().getSelectedDatabaseObjects();
-
- stat = _session.getSQLConnection().prepareStatement(SQL);
-
- StringBuffer script = new StringBuffer();
- for (int i = 0; i < dbObjs.length; i++) {
- IProcedureInfo pi = (IProcedureInfo) dbObjs[i];
- stat.setString(1, pi.getSimpleName());
- res = stat.executeQuery();
- res.next();
- res.getString("TEXT");
-
- script.append(res.getString("TEXT"));
- script.append(getStatementSeparator());
- res.close();
- }
- stat.close();
-
- SessionInternalFrame sessMainFrm = _session
- .getSessionInternalFrame();
- sessMainFrm.getSQLPanelAPI().appendSQLScript(script.toString());
- sessMainFrm.getSessionPanel().selectMainTab(
- ISession.IMainPanelTabIndexes.SQL_TAB);
- } catch (Exception e) {
- throw new RuntimeException(e);
- } finally {
- SQLUtilities.closeResultSet(res);
- SQLUtilities.closeStatement(stat);
- }
- }
-
- private String getStatementSeparator() {
- String statementSeparator = _session.getQueryTokenizer()
- .getSQLStatementSeparator();
-
- if (1 < statementSeparator.length()) {
- statementSeparator = "\n" + statementSeparator + "\n";
- }
-
- return statementSeparator;
- }
-
-}
Deleted: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/net/sourceforge/squirrel_sql/plugins/example/ScriptDB2ViewAction.java
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/net/sourceforge/squirrel_sql/plugins/example/ScriptDB2ViewAction.java 2010-12-28 15:23:27 UTC (rev 6063)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/net/sourceforge/squirrel_sql/plugins/example/ScriptDB2ViewAction.java 2010-12-28 15:26:29 UTC (rev 6064)
@@ -1,85 +0,0 @@
-package net.sourceforge.squirrel_sql.plugins.example;
-
-import net.sourceforge.squirrel_sql.client.IApplication;
-import net.sourceforge.squirrel_sql.client.action.SquirrelAction;
-import net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame;
-import net.sourceforge.squirrel_sql.client.session.ISession;
-import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo;
-import net.sourceforge.squirrel_sql.fw.sql.ITableInfo;
-import net.sourceforge.squirrel_sql.fw.util.Resources;
-
-import java.awt.event.ActionEvent;
-import java.sql.ResultSet;
-import java.sql.Statement;
-
-public class ScriptDB2ViewAction extends SquirrelAction
-{
- private static final long serialVersionUID = 1L;
-
- private ISession _session;
-
-
- public ScriptDB2ViewAction(IApplication app, Resources rsrc, ISession session)
- {
- super(app, rsrc);
- _session = session;
- }
-
-
- public void actionPerformed(ActionEvent evt)
- {
- try
- {
- Statement stat = _session.getSQLConnection().createStatement();
-
- SessionInternalFrame sessMainFrm = _session.getSessionInternalFrame();
- IDatabaseObjectInfo[] dbObjs = sessMainFrm.getObjectTreeAPI().getSelectedDatabaseObjects();
-
-
- StringBuffer script = new StringBuffer();
- for (int i = 0; i < dbObjs.length; i++)
- {
- ITableInfo ti = (ITableInfo) dbObjs[i];
-
- ///////////////////////////////////////////////////////////
- // IBM DB 2 specific code to read view definitions.
- String sql =
- "SELECT TEXT " +
- "FROM SYSIBM.SYSVIEWS " +
- "WHERE NAME = '" + ti.getSimpleName() + "'";
-
- ResultSet res = stat.executeQuery(sql);
- res.next();
-
- script.append(res.getString("TEXT"));
- script.append(getStatementSeparator());
- res.close();
- //
- ///////////////////////////////////////////////////////////
- }
-
- stat.close();
-
- sessMainFrm.getSQLPanelAPI().appendSQLScript(script.toString());
- sessMainFrm.getSessionPanel().selectMainTab(ISession.IMainPanelTabIndexes.SQL_TAB);
- }
- catch (Exception e)
- {
- throw new RuntimeException(e);
- }
- }
-
- private String getStatementSeparator()
- {
- String statementSeparator = _session.getQueryTokenizer().getSQLStatementSeparator();
-
- if (1 < statementSeparator.length())
- {
- statementSeparator = "\n" + statementSeparator + "\n";
- }
-
- return statementSeparator;
- }
-
-
-}
Deleted: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/changes.txt
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/changes.txt 2010-12-28 15:23:27 UTC (rev 6063)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/changes.txt 2010-12-28 15:26:29 UTC (rev 6064)
@@ -1,6 +0,0 @@
-Change Log
-==========
-
-0.01
-===
-- Initial release
Deleted: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/licence.txt
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/licence.txt 2010-12-28 15:23:27 UTC (rev 6063)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/resources/doc/licence.txt 2010-12-28 15:26:29 UTC (rev 6064)
@@ -1,503 +0,0 @@
- GNU LESSER GENERAL PUBLIC LICENSE
- Version 2.1, February 1999
-
- Copyright (C) 1991, 1999 Free Software Foundation, Inc.
- 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
- Everyone is permitted to copy and distribute verbatim copies
- of this license document, but changing it is not allowed.
-
-[This is the first released version of the Lesser GPL. It also counts
- as the successor of the GNU Library Public License, version 2, hence
- the version number 2.1.]
-
- Preamble
-
- The licenses for most software are designed to take away your
-freedom to share and change it. By contrast, the GNU General Public
-Licenses are intended to guarantee your freedom to share and change
-free software--to make sure the software is free for all its users.
-
- This license, the Lesser General Public License, applies to some
-specially designated software packages--typically libraries--of the
-Free Software Foundation and other authors who decide to use it. You
-can use it too, but we suggest you first think carefully about whether
-this license or the ordinary General Public License is the better
-strategy to use in any particular case, based on the explanations below.
-
- When we speak of free software, we are referring to freedom of use,
-not price. Our General Public Licenses are designed to make sure that
-you have the freedom to distribute copies of free software (and charge
-for this service if you wish); that you receive source code or can get
-it if you want it; that you can change the software and use pieces of
-it in new free programs; and that you are informed that you can do
-these things.
-
- To protect your rights, we need to make restrictions that forbid
-distributors to deny you these rights or to ask you to surrender these
-rights. These restrictions translate to certain responsibilities for
-you if you distribute copies of the library or if you modify it.
-
- For example, if you distribute copies of the library, whether gratis
-or for a fee, you must give the recipients all the rights that we gave
-you. You must make sure that they, too, receive or can get the source
-code. If you link other code with the library, you must provide
-complete object files to the recipients, so that they can relink them
-with the library after making changes to the library and recompiling
-it. And you must show them these terms so they know their rights.
-
- We protect your rights with a two-step method: (1) we copyright the
-library, and (2) we offer you this license, which gives you legal
-permission to copy, distribute and/or modify the library.
-
- To protect each distributor, we want to make it very clear that
-there is no warranty for the free library. Also, if the library is
-modified by someone else and passed on, the recipients should know
-that what they have is not the original version, so that the original
-author's reputation will not be affected by problems that might be
-introduced by others.
-
- Finally, software patents pose a constant threat to the existence of
-any free program. We wish to make sure that a company cannot
-effectively restrict the users of a free program by obtaining a
-restrictive license from a patent holder. Therefore, we insist that
-any patent license obtained for a version of the library must be
-consistent with the full freedom of use specified in this license.
-
- Most GNU software, including some libraries, is covered by the
-ordinary GNU General Public License. This license, the GNU Lesser
-General Public License, applies to certain designated libraries, and
-is ...
[truncated message content] |
|
From: <man...@us...> - 2011-09-25 15:58:40
|
Revision: 6411
http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6411&view=rev
Author: manningr
Date: 2011-09-25 15:58:33 +0000 (Sun, 25 Sep 2011)
Log Message:
-----------
Fixed issue where package was not the same as the directory structure of the java source. Also, now the package as well as the plugin name are properties specified during project creation, rather than being hard-coded.
Modified Paths:
--------------
trunk/sql12/plugins/squirrelsql-plugin-archetype/pom.xml
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/it/projects/firsttest/test.properties
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/META-INF/maven/archetype-metadata.xml
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/test/resources/projects/basic/archetype.properties
Added Paths:
-----------
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/pom.xml
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/ExampleExceptionFormatter.java
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/ExampleSqlExecutionListener.java
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/ScriptDB2ProcedureAction.java
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/ScriptDB2ViewAction.java
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/__pluginName__Plugin.java
Removed Paths:
-------------
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/pom.xml
Property Changed:
----------------
trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/
Modified: trunk/sql12/plugins/squirrelsql-plugin-archetype/pom.xml
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/pom.xml 2011-09-24 18:40:50 UTC (rev 6410)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/pom.xml 2011-09-25 15:58:33 UTC (rev 6411)
@@ -11,7 +11,6 @@
<groupId>net.sf.squirrel-sql.plugins</groupId>
<artifactId>squirrelsql-plugin-archetype</artifactId>
- <version>3.3.0-SNAPSHOT</version>
<packaging>maven-archetype</packaging>
<name>SQuirreL Plugin Archetype</name>
@@ -94,72 +93,6 @@
</pluginManagement>
<plugins>
- <plugin>
- <groupId>org.apache.maven.plugins</groupId>
- <artifactId>maven-dependency-plugin</artifactId>
- <version>2.1</version>
- <executions>
- <execution>
- <id>copy-example-project-java</id>
- <phase>generate-resources</phase>
- <goals>
- <goal>unpack-dependencies</goal>
- </goals>
- <configuration>
- <includeArtifactIds>example</includeArtifactIds>
- <includeClassifiers>sources</includeClassifiers>
- <includes>**\/*.java</includes>
- <excludes>**\/*Test.java</excludes>
- <outputDirectory>src/main/resources/archetype-resources/src/main/java</outputDirectory>
- <markersDirectory>target/dependency-maven-plugin-markers-java</markersDirectory>
- </configuration>
- </execution>
- <execution>
- <id>copy-example-project-java-tests</id>
- <phase>generate-resources</phase>
- <goals>
- <goal>unpack-dependencies</goal>
- </goals>
- <configuration>
- <includeArtifactIds>example</includeArtifactIds>
- <includeClassifiers>test-sources</includeClassifiers>
- <includes>**\/*Test.java</includes>
- <outputDirectory>src/main/resources/archetype-resources/src/test/java</outputDirectory>
- <markersDirectory>target/dependency-maven-plugin-markers-test-java</markersDirectory>
- </configuration>
- </execution>
- <execution>
- <id>copy-example-project-properties</id>
- <phase>generate-resources</phase>
- <goals>
- <goal>unpack-dependencies</goal>
- </goals>
- <configuration>
- <includeArtifactIds>example</includeArtifactIds>
- <includeClassifiers>sources</includeClassifiers>
- <includes>**\/*.properties</includes>
- <outputDirectory>src/main/resources/archetype-resources/src/main/resources</outputDirectory>
- <markersDirectory>target/dependency-maven-plugin-markers-properties</markersDirectory>
- </configuration>
- </execution>
- <execution>
- <id>copy-example-project-docs</id>
- <phase>generate-resources</phase>
- <goals>
- <goal>unpack-dependencies</goal>
- </goals>
- <configuration>
- <includeArtifactIds>example</includeArtifactIds>
- <includeClassifiers>sources</includeClassifiers>
- <includes>**\/*.txt</includes>
- <outputDirectory>src/main/resources/archetype-resources/src/main/resources</outputDirectory>
- <markersDirectory>target/dependency-maven-plugin-markers-docs</markersDirectory>
- </configuration>
- </execution>
-
- </executions>
-
- </plugin>
<!-- This will test that the archetype can be used to create a new plugin
project (in target/it/projects) and that the plugin project will successfully
build. This pattern was found in a discussion about how to test archetypes
@@ -190,6 +123,7 @@
<archetypeGroupId>${project.groupId}</archetypeGroupId>
<archetypeVersion>${project.version}</archetypeVersion>
<interactiveMode>false</interactiveMode>
+ <pluginName>Example</pluginName>
</properties>
</configuration>
</execution>
Modified: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/it/projects/firsttest/test.properties
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/it/projects/firsttest/test.properties 2011-09-24 18:40:50 UTC (rev 6410)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/it/projects/firsttest/test.properties 2011-09-25 15:58:33 UTC (rev 6411)
@@ -1,5 +1,6 @@
-groupId=com.foo
-artifactId=firsttest
+groupId=net.sf.squirrel-sql.plugins
+artifactId=example
version=1.0.0
-package=com.foo.firsttest
+package=net.sourceforge.squirrel_sql.plugins.example
+pluginName=Example
Modified: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/META-INF/maven/archetype-metadata.xml
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/META-INF/maven/archetype-metadata.xml 2011-09-24 18:40:50 UTC (rev 6410)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/META-INF/maven/archetype-metadata.xml 2011-09-25 15:58:33 UTC (rev 6411)
@@ -1,26 +1,35 @@
<?xml version="1.0" encoding="UTF-8"?>
-<archetype-descriptor xsi:schemaLocation="http://maven.apache.org/plugins/maven-archetype-plugin/archetype-descriptor/1.0.0 http://maven.apache.org/xsd/archetype-descriptor-1.0.0.xsd" name="example"
- xmlns="http://maven.apache.org/plugins/maven-archetype-plugin/archetype-descriptor/1.0.0"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
- <fileSets>
- <fileSet filtered="true" packaged="true" encoding="UTF-8">
- <directory>src/main/java</directory>
- <includes>
- <include>**/*.java</include>
- </includes>
- </fileSet>
- <fileSet filtered="true" encoding="UTF-8">
- <directory>src/main/resources</directory>
- <includes>
- <include>**/*.properties</include>
- <include>**/*.txt</include>
- </includes>
- </fileSet>
- <fileSet filtered="true" packaged="true" encoding="UTF-8">
- <directory>src/test/java</directory>
- <includes>
- <include>**/*.java</include>
- </includes>
- </fileSet>
- </fileSets>
+<archetype-descriptor
+ xsi:schemaLocation="http://maven.apache.org/plugins/maven-archetype-plugin/archetype-descriptor/1.0.0 http://maven.apache.org/xsd/archetype-descriptor-1.0.0.xsd"
+ name="example"
+ xmlns="http://maven.apache.org/plugins/maven-archetype-plugin/archetype-descriptor/1.0.0"
+ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
+
+ <requiredProperties>
+ <requiredProperty key="pluginName" />
+<!-- <defaultValue>Example</defaultValue> -->
+<!-- </requiredProperty> -->
+ </requiredProperties>
+
+ <fileSets>
+ <fileSet filtered="true" packaged="true" encoding="UTF-8">
+ <directory>src/main/java</directory>
+ <includes>
+ <include>**/*.java</include>
+ </includes>
+ </fileSet>
+ <fileSet filtered="true" encoding="UTF-8">
+ <directory>src/main/resources</directory>
+ <includes>
+ <include>**/*.properties</include>
+ <include>**/*.txt</include>
+ </includes>
+ </fileSet>
+ <fileSet filtered="true" packaged="true" encoding="UTF-8">
+ <directory>src/test/java</directory>
+ <includes>
+ <include>**/*.java</include>
+ </includes>
+ </fileSet>
+ </fileSets>
</archetype-descriptor>
Property changes on: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources
___________________________________________________________________
Modified: svn:ignore
- src
+
Deleted: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/pom.xml
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/pom.xml 2011-09-24 18:40:50 UTC (rev 6410)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/pom.xml 2011-09-25 15:58:33 UTC (rev 6411)
@@ -1,129 +0,0 @@
-<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
- xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
- <modelVersion>4.0.0</modelVersion>
-
- <parent>
- <groupId>net.sf.squirrel-sql.plugins</groupId>
- <artifactId>squirrelsql-plugins-parent-pom</artifactId>
- <version>3.3.0-SNAPSHOT</version>
- </parent>
-
- <groupId>${groupId}</groupId>
- <artifactId>${artifactId}</artifactId>
- <version>${version}</version>
- <packaging>jar</packaging>
- <description>Example Plugin</description>
- <inceptionYear>2001</inceptionYear>
- <developers>
- <developer>
- <name>Gerd Wagner</name>
- <roles>
- <role>Administrator</role>
- <role>Developer</role>
- </roles>
- </developer>
- <developer>
- <name>Rob Manning</name>
- <roles>
- <role>Developer</role>
- <role>Release Manager</role>
- </roles>
- </developer>
- </developers>
- <licenses>
- <license>
- <name>GNU Lesser General Public License</name>
- <url>http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt</url>
- <distribution>repo</distribution>
- </license>
- </licenses>
- <url>http://www.squirrelsql.org/</url>
- <scm>
- <connection>scm:svn:https://squirrel-sql.svn.sourceforge.net/svnroot/squirrel-sql/trunk/sql12/plugins/oracle</connection>
- <developerConnection>scm:svn:https://squirrel-sql.svn.sourceforge.net/svnroot/squirrel-sql/trunk/sql12/plugins/oracle</developerConnection>
- <url>http://squirrel-sql.svn.sourceforge.net/viewvc/squirrel-sql/trunk/sql12/plugins/oracle</url>
- </scm>
- <issueManagement>
- <system>SourceForge Tracker</system>
- <url>http://sourceforge.net/tracker/?group_id=28383%26atid=393414</url>
- </issueManagement>
- <ciManagement>
- <system>Hudson</system>
- <url>https://www.squirrel-sql.org/hudson/</url>
- </ciManagement>
- <dependencies>
- <dependency>
- <groupId>net.sf.squirrel-sql</groupId>
- <artifactId>fw</artifactId>
- </dependency>
- <dependency>
- <groupId>net.sf.squirrel-sql</groupId>
- <artifactId>fw</artifactId>
- <type>test-jar</type>
- <scope>test</scope>
- </dependency>
- <dependency>
- <groupId>net.sf.squirrel-sql</groupId>
- <artifactId>squirrel-sql</artifactId>
- </dependency>
- <dependency>
- <groupId>net.sf.squirrel-sql</groupId>
- <artifactId>squirrel-sql</artifactId>
- <type>test-jar</type>
- <scope>test</scope>
- </dependency>
- <dependency>
- <groupId>gsbase</groupId>
- <artifactId>gsbase</artifactId>
- </dependency>
- <dependency>
- <groupId>junit</groupId>
- <artifactId>junit</artifactId>
- </dependency>
- <dependency>
- <groupId>org.easymock</groupId>
- <artifactId>easymock</artifactId>
- </dependency>
- <dependency>
- <groupId>org.easymock</groupId>
- <artifactId>easymockclassextension</artifactId>
- </dependency>
- <dependency>
- <groupId>org.mockito</groupId>
- <artifactId>mockito-all</artifactId>
- </dependency>
- <dependency>
- <groupId>net.sf.squirrel-sql.thirdparty-non-maven</groupId>
- <artifactId>treetable</artifactId>
- <version>20040121</version>
- </dependency>
- </dependencies>
- <properties>
- <pluginClassName>net.sourceforge.squirrel_sql.plugins.example.ExamplePlugin</pluginClassName>
- </properties>
- <build>
- <plugins>
- <plugin>
- <groupId>org.apache.maven.plugins</groupId>
- <artifactId>maven-dependency-plugin</artifactId>
- </plugin>
- <plugin>
- <groupId>org.apache.maven.plugins</groupId>
- <artifactId>maven-source-plugin</artifactId>
- </plugin>
- <plugin>
- <groupId>org.apache.maven.plugins</groupId>
- <artifactId>maven-surefire-plugin</artifactId>
- </plugin>
- <plugin>
- <groupId>org.apache.maven.plugins</groupId>
- <artifactId>maven-jar-plugin</artifactId>
- </plugin>
- <plugin>
- <groupId>org.apache.maven.plugins</groupId>
- <artifactId>maven-assembly-plugin</artifactId>
- </plugin>
- </plugins>
- </build>
-
-</project>
Added: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/pom.xml
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/pom.xml (rev 0)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/pom.xml 2011-09-25 15:58:33 UTC (rev 6411)
@@ -0,0 +1,129 @@
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
+ <modelVersion>4.0.0</modelVersion>
+
+ <parent>
+ <groupId>net.sf.squirrel-sql.plugins</groupId>
+ <artifactId>squirrelsql-plugins-parent-pom</artifactId>
+ <version>3.3.0-SNAPSHOT</version>
+ </parent>
+
+ <groupId>${groupId}</groupId>
+ <artifactId>${artifactId}</artifactId>
+ <version>${version}</version>
+ <packaging>jar</packaging>
+ <description>Example Plugin</description>
+ <inceptionYear>2001</inceptionYear>
+ <developers>
+ <developer>
+ <name>Gerd Wagner</name>
+ <roles>
+ <role>Administrator</role>
+ <role>Developer</role>
+ </roles>
+ </developer>
+ <developer>
+ <name>Rob Manning</name>
+ <roles>
+ <role>Developer</role>
+ <role>Release Manager</role>
+ </roles>
+ </developer>
+ </developers>
+ <licenses>
+ <license>
+ <name>GNU Lesser General Public License</name>
+ <url>http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt</url>
+ <distribution>repo</distribution>
+ </license>
+ </licenses>
+ <url>http://www.squirrelsql.org/</url>
+ <scm>
+ <connection>scm:svn:https://squirrel-sql.svn.sourceforge.net/svnroot/squirrel-sql/trunk/sql12/plugins/oracle</connection>
+ <developerConnection>scm:svn:https://squirrel-sql.svn.sourceforge.net/svnroot/squirrel-sql/trunk/sql12/plugins/oracle</developerConnection>
+ <url>http://squirrel-sql.svn.sourceforge.net/viewvc/squirrel-sql/trunk/sql12/plugins/oracle</url>
+ </scm>
+ <issueManagement>
+ <system>SourceForge Tracker</system>
+ <url>http://sourceforge.net/tracker/?group_id=28383%26atid=393414</url>
+ </issueManagement>
+ <ciManagement>
+ <system>Hudson</system>
+ <url>https://www.squirrel-sql.org/hudson/</url>
+ </ciManagement>
+ <dependencies>
+ <dependency>
+ <groupId>net.sf.squirrel-sql</groupId>
+ <artifactId>fw</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>net.sf.squirrel-sql</groupId>
+ <artifactId>fw</artifactId>
+ <type>test-jar</type>
+ <scope>test</scope>
+ </dependency>
+ <dependency>
+ <groupId>net.sf.squirrel-sql</groupId>
+ <artifactId>squirrel-sql</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>net.sf.squirrel-sql</groupId>
+ <artifactId>squirrel-sql</artifactId>
+ <type>test-jar</type>
+ <scope>test</scope>
+ </dependency>
+ <dependency>
+ <groupId>gsbase</groupId>
+ <artifactId>gsbase</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>junit</groupId>
+ <artifactId>junit</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>org.easymock</groupId>
+ <artifactId>easymock</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>org.easymock</groupId>
+ <artifactId>easymockclassextension</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>org.mockito</groupId>
+ <artifactId>mockito-all</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>net.sf.squirrel-sql.thirdparty-non-maven</groupId>
+ <artifactId>treetable</artifactId>
+ <version>20040121</version>
+ </dependency>
+ </dependencies>
+ <properties>
+ <pluginClassName>net.sourceforge.squirrel_sql.plugins.example.ExamplePlugin</pluginClassName>
+ </properties>
+ <build>
+ <plugins>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-dependency-plugin</artifactId>
+ </plugin>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-source-plugin</artifactId>
+ </plugin>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-surefire-plugin</artifactId>
+ </plugin>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-jar-plugin</artifactId>
+ </plugin>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-assembly-plugin</artifactId>
+ </plugin>
+ </plugins>
+ </build>
+
+</project>
Added: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/ExampleExceptionFormatter.java
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/ExampleExceptionFormatter.java (rev 0)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/ExampleExceptionFormatter.java 2011-09-25 15:58:33 UTC (rev 6411)
@@ -0,0 +1,61 @@
+package ${package};
+
+import static net.sourceforge.squirrel_sql.fw.util.Utilities.checkNull;
+import net.sourceforge.squirrel_sql.fw.util.ExceptionFormatter;
+
+/*
+ * Copyright (C) 2010 Rob Manning
+ * man...@us...
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License as published by the Free Software Foundation; either
+ * version 2.1 of the License, or (at your option) any later version.
+ *
+ * This library is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+ */
+
+public class ExampleExceptionFormatter implements ExceptionFormatter
+{
+
+ /**
+ * In this example, we simply prefix the original exception message with a string that lets us know that
+ * the Example plugin applied a custom format. In a real implementation, you might want to call the
+ * getCause() method on the Throwable to determine if there were chained exceptions available to drill
+ * down to the actual exception that contains the stack trace and message to the very first place in code
+ * where an exception was encountered.
+ *
+ * @see net.sourceforge.squirrel_sql.fw.util.ExceptionFormatter#format(java.lang.Throwable)
+ */
+ @Override
+ public String format(Throwable t) throws Exception
+ {
+ checkNull("format", "t", t);
+ return "ExampleExceptionFormatter: exception message was: "+t.getMessage();
+ }
+
+ /**
+ * In this example if the throwable is not null, we say that we want to format it. This lets SQuirreL
+ * know that it should not apply it's own formatting, but rather use the format applied by this formatter's
+ * format method. In a real implementation which is specific to a vendor's JDBC driver, the Throwable will
+ * be a particular vendor type and probably has a package like com.{vendor}. Also, if the vendor adds
+ * custom methods for accessing the message, they should be called using the Java reflection API so that
+ * compiling this class does not require proprietary class libraries.
+ *
+ * @see net.sourceforge.squirrel_sql.fw.util.ExceptionFormatter#formatsException(java.lang.Throwable)
+ */
+ @Override
+ public boolean formatsException(Throwable t)
+ {
+ checkNull("formatsException", "t", t);
+ return true;
+ }
+
+}
Added: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/ExampleSqlExecutionListener.java
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/ExampleSqlExecutionListener.java (rev 0)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/ExampleSqlExecutionListener.java 2011-09-25 15:58:33 UTC (rev 6411)
@@ -0,0 +1,59 @@
+package ${package};
+
+import net.sourceforge.squirrel_sql.client.session.event.ISQLExecutionListener;
+import net.sourceforge.squirrel_sql.client.session.event.SQLExecutionAdapter;
+import net.sourceforge.squirrel_sql.fw.util.IMessageHandler;
+
+/*
+ * Copyright (C) 2010 Rob Manning
+ * man...@us...
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License as published by the Free Software Foundation; either
+ * version 2.1 of the License, or (at your option) any later version.
+ *
+ * This library is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+ */
+
+/**
+ * A simple ISQLExecutionListener that displays the SQL as it is being executed in the main application
+ * message panel (at the bottom of the application).
+ */
+public class ExampleSqlExecutionListener extends SQLExecutionAdapter
+{
+ /** This is what gives the ability to print a message to the message panel */
+ private final IMessageHandler _messageHandler;
+
+ public ExampleSqlExecutionListener(IMessageHandler messageHandler) {
+ _messageHandler = messageHandler;
+ }
+
+ @Override
+ public void statementExecuted(String sql)
+ {
+ _messageHandler.showMessage("statementExecuted: "+sql);
+ }
+
+ @Override
+ public String statementExecuting(String sql)
+ {
+ _messageHandler.showMessage("statementExecuting: "+sql);
+
+ // We don't modify the SQL in this example. in addition to modifying it, we could veto it's execution
+ // by returning null.
+ return sql;
+ }
+
+ public void executionFinished()
+ {
+ }
+
+}
Added: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/ScriptDB2ProcedureAction.java
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/ScriptDB2ProcedureAction.java (rev 0)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/ScriptDB2ProcedureAction.java 2011-09-25 15:58:33 UTC (rev 6411)
@@ -0,0 +1,82 @@
+package ${package};
+
+import java.awt.event.ActionEvent;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+
+import net.sourceforge.squirrel_sql.client.IApplication;
+import net.sourceforge.squirrel_sql.client.action.SquirrelAction;
+import net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame;
+import net.sourceforge.squirrel_sql.client.session.ISession;
+import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo;
+import net.sourceforge.squirrel_sql.fw.sql.IProcedureInfo;
+import net.sourceforge.squirrel_sql.fw.sql.SQLUtilities;
+import net.sourceforge.squirrel_sql.fw.util.Resources;
+
+public class ScriptDB2ProcedureAction extends SquirrelAction {
+ private static final long serialVersionUID = 1L;
+
+ transient private ISession _session;
+
+ // /////////////////////////////////////////////////////////
+ // IBM DB 2 specific code to read procedure definitions.
+ private static final String SQL =
+ "SELECT TEXT " +
+ "FROM SYSIBM.SYSPROCEDURES " +
+ "WHERE PROCNAME = ? ";
+
+ public ScriptDB2ProcedureAction(IApplication app, Resources rsrc,
+ ISession session) {
+ super(app, rsrc);
+ _session = session;
+ }
+
+ public void actionPerformed(ActionEvent evt) {
+ PreparedStatement stat = null;
+ ResultSet res = null;
+ try {
+
+ IDatabaseObjectInfo[] dbObjs = _session.getSessionInternalFrame()
+ .getObjectTreeAPI().getSelectedDatabaseObjects();
+
+ stat = _session.getSQLConnection().prepareStatement(SQL);
+
+ StringBuffer script = new StringBuffer();
+ for (int i = 0; i < dbObjs.length; i++) {
+ IProcedureInfo pi = (IProcedureInfo) dbObjs[i];
+ stat.setString(1, pi.getSimpleName());
+ res = stat.executeQuery();
+ res.next();
+ res.getString("TEXT");
+
+ script.append(res.getString("TEXT"));
+ script.append(getStatementSeparator());
+ res.close();
+ }
+ stat.close();
+
+ SessionInternalFrame sessMainFrm = _session
+ .getSessionInternalFrame();
+ sessMainFrm.getSQLPanelAPI().appendSQLScript(script.toString());
+ sessMainFrm.getSessionPanel().selectMainTab(
+ ISession.IMainPanelTabIndexes.SQL_TAB);
+ } catch (Exception e) {
+ throw new RuntimeException(e);
+ } finally {
+ SQLUtilities.closeResultSet(res);
+ SQLUtilities.closeStatement(stat);
+ }
+ }
+
+ private String getStatementSeparator() {
+ String statementSeparator = _session.getQueryTokenizer()
+ .getSQLStatementSeparator();
+
+ if (1 < statementSeparator.length()) {
+ statementSeparator = "\n" + statementSeparator + "\n";
+ }
+
+ return statementSeparator;
+ }
+
+}
Added: trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/ScriptDB2ViewAction.java
===================================================================
--- trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/ScriptDB2ViewAction.java (rev 0)
+++ trunk/sql12/plugins/squirrelsql-plugin-archetype/src/main/resources/archetype-resources/src/main/java/ScriptDB2ViewAction.java 2011-09-25 15:58:33 UTC (rev 6411)
@@ -0,0 +1,85 @@
+package ${package};
+
+import net.sourceforge.squirrel_sql.client.IApplication;
+import net.sourceforge.squirrel_sql.client.action.SquirrelAction;
+import net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame;
+import net.sourceforge.squirrel_sql.client.session.ISession;
+import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo;
+import net.sourceforge.squirrel_sql.fw.sql.ITableInfo;
+import net.sourceforge.squirrel_sql.fw.util.Resources;
+
+import java.awt.event.ActionEvent;
+import java.sql.ResultSet;
+import java.sql.Statement;
+
+public class ScriptDB2ViewAction extends SquirrelAction
+{
+ private static final long serialVersionUID = 1L;
+
+ private ISession _session;
+
+
+ public ScriptDB2ViewAction(IApplication app, Resources rsrc, ISession session)
+ {
+ super(app, rsrc);
+ _session = session;
+ }
+
+
+ public void actionPerformed(ActionEvent evt)
+ {
+ try
+ {
+ Statement stat = _session.getSQLConnection().createStatement();
+
+ SessionInternalFrame sessMainFrm = _session.getSessionInternalFrame();
+ IDatabaseObjectInfo[] dbObjs = sessMainFrm.getObjectTreeAPI().getSelectedDatabaseObjects();
+
+
+ StringBuffer script = new StringBuffer();
+ for (int i = 0; i < dbObjs.length; i++)
+ {
+ ITableInfo ti = (ITableInfo) dbObjs[i];
+
+ ///////////////////////////////////////////////////////////
+ // IBM DB 2 specific code to read view definitions.
+ String sql =
+ "SELECT TEXT " +
+ "FROM SYSIBM.SYSVIEWS " +
+ "WHERE NAME = '" + ti.getSimpleName() + "'";
+
+ ResultSet res = stat.executeQuery(sql);
+ res.next();
+
+ script.append(res.getString("TEXT"));
+ script.append(getStatementSeparator());
+ res.close();
+ //
+ ///////////////////////////////////////////////////////////
+ ...
[truncated message content] |
