|
From: robert <Rob...@co...> - 2005-06-09 13:47:15
|
Hi, I have an idea for a plugin that I've been mulling over on and off for the last year. But before I started working on it I wanted to follow the guidelines set forth in the project FAQ: "If you have got an idea for a plugin just send a message to the SQuirreL Developers list giving a brief description. This helps to ensure that two people don't develop the same plugin." Here's the problem I think I can solve by writing a plugin for SQuirreL: We have a commercial J2EE app that - in theory - can run on several different app servers using several different databases (embedded as well as stand-alone). The thorny problem comes when it's time to test a release, we need to be able to run the same tests against the same data, in different app servers and different databases. Because the application has a rich client interface (via applet) much testing needs to be performed by hand. Even some of the test setup has to occur using the GUI as we don't yet have a way to automate it. I need to be able to setup a test database in Oracle, for instance, setup/run some tests, then at some point switch over to MySQL using the same data that was in Oracle, then again re-run some tests, then at some point switch over to HyperSonic (SyBase, PointBase, DB2, MS-SQL etc.) So my plugin would - I think - build on work done in SQL Scripts plugin by being able to use two connections to databases of differing types (Oracle , MySQL), asking the user for input schema on Oracle and output database in MySQL. The challenge in doing this is mapping the types - perhaps a configuration dialog would allow the user to choose to use default mappings (Oracle:NUMBER -> MySQL:MEDIUM INT) or customize them. The plugin could then create tables/views in MySQL using the definitions in Oracle. Then it would read records in each table in Oracle, and write them into the corresponding table in MySQL. So, is anyone currently working on such a plugin and if so, could I help? If not, do you all think this would be a useful plugin to include with SQuirreL, or perhaps just distribute it on my own (it would still be open source licensed)? Rob Manning CollabraSpace - Revolutionary Collaboration Visit us at http://www.collabraspace.com This message has been scanned for viruses by ClamAV v0.83 |
