How to modify a existing plugin or develop a new one

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

How to modify a existing plugin or develop a new one

Ashish Kulkarni
Hi
I want to modify sqlscript plugin,
I want to create SQL script (DDL) for AS400 DB2
database, there are about 2000 tables in it,
The problem i am having sqlscript creates scripts for
about 50 tables and then there is a SQL error and it
stops processing, i want to modify this so i can
create SQL script for all 2000 tables, if there is an
error it should skip that table and write to a log
file and proceesed with the next table
That way i can have scripts for almost all the tables,
and from the log file i will come to know which tables
had issues.
I have downloaded all the source code, and i am using
eclipse for development,
how to build the project in eclipse and make it run
from eclipse with the plugin i want,
Ashish

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com 


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Squirrel-sql-develop mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
Reply | Threaded
Open this post in threaded view
|

Re: How to modify a existing plugin or develop a new one

Gerd Wagner
Hi Ashish,

Ashish Kulkarni wrote:

> Hi
> I want to modify sqlscript plugin,
> I want to create SQL script (DDL) for AS400 DB2
> database, there are about 2000 tables in it,
> The problem i am having sqlscript creates scripts for
> about 50 tables and then there is a SQL error and it
> stops processing, i want to modify this so i can
> create SQL script for all 2000 tables, if there is an
> error it should skip that table and write to a log
> file and proceesed with the next table
> That way i can have scripts for almost all the tables,
> and from the log file i will come to know which tables
> had issues.
> I have downloaded all the source code, and i am using
> eclipse for development,
> how to build the project in eclipse and make it run
> from eclipse with the plugin i want,

1. Create a new project and choose to import sql12 folder of the
unpacked sources.

2. Menu Windows --> Show View --> Ant will open the ant view

3. In the ant view from the right mouse menu choose 'Add build files'
and select build/build.xml

4. Double click the make_dist task. This will build SQuirreL to a folder
  squirrel-sql-dist right besides the sql12 folder.

5. Double click the compile_plugin task. This will will create the
plugins selected in sql12/build/build.properties. All standard plugins
should be built.

6. in the Eclips Run configuration set the following command line arguments:

-home <your_path>/squirrel-sql-dist/squirrel-sql/core/dist

This is the  path where you find the SQuirrel built you just created.
What you actually need this built for is to enable SQuirreL to load the
plugins when you are starting it from eclipse. Nothing more.

7. Usually Eclipse will compile the sources to sql12/bin which is
perfectly OK. When you start SQuirreL from within Eclipse the classes in
sql12/bin will be loaded first. This way any changes you do to plugin
code will take effect. The plugin jars you built above  are just helpers.


Gerd


> Ashish
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com 
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
> _______________________________________________
> Squirrel-sql-develop mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>



-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Squirrel-sql-develop mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop