Thread: [Squirrel-sql-commits] sql12/plugins/graph/src/net/sourceforge/squirrel_sql/plugins/graph ScriptInte
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Gerd W. <ger...@us...> - 2004-12-20 21:13:17
|
Update of /cvsroot/squirrel-sql/sql12/plugins/graph/src/net/sourceforge/squirrel_sql/plugins/graph In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25978 Modified Files: GraphController.java GraphDesktopController.java GraphDesktopListener.java TableFrameController.java Added Files: ScriptInterface.java SqlScriptAcessor.java Log Message: Scripting of tables (not yet functional, needs adoptions of framework) --- NEW FILE: ScriptInterface.java --- package net.sourceforge.squirrel_sql.plugins.graph; import net.sourceforge.squirrel_sql.client.session.ISession; import net.sourceforge.squirrel_sql.fw.sql.ITableInfo; public interface ScriptInterface { void scriptTablesToSQLEntryArea(ISession sess, ITableInfo[] tis); } Index: GraphController.java =================================================================== RCS file: /cvsroot/squirrel-sql/sql12/plugins/graph/src/net/sourceforge/squirrel_sql/plugins/graph/GraphController.java,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** GraphController.java 15 Dec 2004 20:50:24 -0000 1.5 --- GraphController.java 20 Dec 2004 21:13:03 -0000 1.6 *************** *** 7,10 **** --- 7,11 ---- import net.sourceforge.squirrel_sql.plugins.graph.xmlbeans.TableFrameControllerXmlBean; import net.sourceforge.squirrel_sql.plugins.graph.xmlbeans.FormatXmlBean; + import net.sourceforge.squirrel_sql.fw.sql.ITableInfo; import javax.swing.*; *************** *** 58,61 **** --- 59,67 ---- } + public void scriptAllTablesRequested() + { + scriptAllTables(); + } + }; *************** *** 115,118 **** --- 121,137 ---- } + private void scriptAllTables() + { + ITableInfo[] tableInfos = new ITableInfo[_openTableFrameCtrls.size()]; + + for (int i = 0; i < _openTableFrameCtrls.size(); i++) + { + TableFrameController tableFrameController = (TableFrameController) _openTableFrameCtrls.elementAt(i); + tableInfos[i] = tableFrameController.getTableInfo(); + } + + SqlScriptAcessor.scriptTablesToSQLEntryArea(_session, tableInfos); + } + private void refreshAllTables() { Index: GraphDesktopController.java =================================================================== RCS file: /cvsroot/squirrel-sql/sql12/plugins/graph/src/net/sourceforge/squirrel_sql/plugins/graph/GraphDesktopController.java,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** GraphDesktopController.java 15 Dec 2004 20:50:24 -0000 1.8 --- GraphDesktopController.java 20 Dec 2004 21:13:03 -0000 1.9 *************** *** 25,28 **** --- 25,29 ---- private JMenuItem _mnuRemoveGraph; private JMenuItem _mnuRefreshAllTables; + private JMenuItem _mnuScriptAllTables; private JCheckBoxMenuItem _mnuShowConstraintNames; private JCheckBoxMenuItem _mnuZoomPrint; *************** *** 149,152 **** --- 150,162 ---- }); + _mnuScriptAllTables = new JMenuItem("Script all tables"); + _mnuScriptAllTables.addActionListener(new ActionListener() + { + public void actionPerformed(ActionEvent e) + { + onScriptAllTables(); + } + }); + _mnuShowConstraintNames = new JCheckBoxMenuItem("Show constraint names"); _mnuShowConstraintNames.addActionListener(new ActionListener() *************** *** 172,175 **** --- 182,186 ---- _popUp.add(new JSeparator()); _popUp.add(_mnuRefreshAllTables); + _popUp.add(_mnuScriptAllTables); _popUp.add(new JSeparator()); _popUp.add(_mnuShowConstraintNames); *************** *** 177,180 **** --- 188,196 ---- } + private void onScriptAllTables() + { + _listener.scriptAllTablesRequested(); + } + private void onRefreshAllTables() { Index: TableFrameController.java =================================================================== RCS file: /cvsroot/squirrel-sql/sql12/plugins/graph/src/net/sourceforge/squirrel_sql/plugins/graph/TableFrameController.java,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** TableFrameController.java 15 Dec 2004 20:50:24 -0000 1.9 --- TableFrameController.java 20 Dec 2004 21:13:03 -0000 1.10 *************** *** 5,8 **** --- 5,10 ---- import net.sourceforge.squirrel_sql.plugins.graph.xmlbeans.ConstraintViewXmlBean; import net.sourceforge.squirrel_sql.plugins.graph.xmlbeans.TableFrameControllerXmlBean; + import net.sourceforge.squirrel_sql.fw.sql.TableInfo; + import net.sourceforge.squirrel_sql.fw.sql.ITableInfo; import javax.swing.*; *************** *** 50,53 **** --- 52,56 ---- private JMenuItem _mnuAddAllRelatedTables; private JMenuItem _mnuRefreshTable; + private JMenuItem _mnuScriptTable; private JCheckBoxMenuItem _mnuOrderByName; private JCheckBoxMenuItem _mnuPksAndConstraintsOnTop; *************** *** 439,445 **** }); - - - _mnuRefreshTable = new JMenuItem("Refresh table"); _mnuRefreshTable.addActionListener(new ActionListener() --- 442,445 ---- *************** *** 451,455 **** }); ! _mnuDbOrder = new JCheckBoxMenuItem("db order"); --- 451,462 ---- }); ! _mnuScriptTable = new JMenuItem("Script table"); ! _mnuScriptTable.addActionListener(new ActionListener() ! { ! public void actionPerformed(ActionEvent e) ! { ! onScriptTable(); ! } ! }); _mnuDbOrder = new JCheckBoxMenuItem("db order"); *************** *** 498,501 **** --- 505,509 ---- _popUp.add(new JSeparator()); _popUp.add(_mnuRefreshTable); + _popUp.add(_mnuScriptTable); _popUp.add(new JSeparator()); _popUp.add(_mnuDbOrder); *************** *** 521,524 **** --- 529,550 ---- } + private void onScriptTable() + { + SqlScriptAcessor.scriptTablesToSQLEntryArea(_session, new ITableInfo[]{getTableInfo()}); + } + + ITableInfo getTableInfo() + { + try + { + return _session.getSQLConnection().getSQLMetaData().getTables(_catalog, _schema, _tableName, new String[]{"TABLE"})[0]; + } + catch (SQLException e) + { + throw new RuntimeException(e); + } + } + + private void onRefresh() { Index: GraphDesktopListener.java =================================================================== RCS file: /cvsroot/squirrel-sql/sql12/plugins/graph/src/net/sourceforge/squirrel_sql/plugins/graph/GraphDesktopListener.java,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** GraphDesktopListener.java 15 Dec 2004 20:50:24 -0000 1.2 --- GraphDesktopListener.java 20 Dec 2004 21:13:03 -0000 1.3 *************** *** 7,9 **** --- 7,10 ---- void removeRequest(); void refreshAllTablesRequested(); + void scriptAllTablesRequested(); } --- NEW FILE: SqlScriptAcessor.java --- package net.sourceforge.squirrel_sql.plugins.graph; import net.sourceforge.squirrel_sql.client.session.ISession; import net.sourceforge.squirrel_sql.fw.sql.ITableInfo; import javax.swing.*; public class SqlScriptAcessor { public static void scriptTablesToSQLEntryArea(ISession session, ITableInfo[] tableInfos) { ScriptInterface si = null; //(ScriptInterface) session.getApplication().getPluginManager().bindPluginService("sqlscript", ScriptInterface.class); if (null == si) { String msg = "Scripting is only available with the SQL Scripts Plugin.\n Get the plugin from www.squirrelsql.org. It's free."; JOptionPane.showMessageDialog(session.getApplication().getMainFrame(), msg); return; } si.scriptTablesToSQLEntryArea(session, tableInfos); } } |