a proper properties dialog with possibility for modification should be easy to
implement. should we add a featreq for that?
..ede
On 07.04.2013 18:10, Michaël Michaud wrote:
> Hi,
>
> Just made a hackish modification for database users.
> Up to now, a project containing DataStoreDataSource
> layers or DataStoreQueryDataSource layers could no
> more be opened if connections become invalid.
>
> It now imports empty layers instead, keeping the invalid
> connection and, more important, the SQL query and the
> styles attached to the layer.
> You still cannot connect to your new database, but you
> can change connection parameters with the following
> script (only tested with DataStoreQueryDataSource)
>
> need r3482
>
> Michaël
>
> // ----------------------------------------------
> // This script will change database connections
> // for selected layers
> // Use case : you have an old project containing
> // many database connections and/or queries, but
> // your database, or password has changed.
> // You can still load the project (it will throw
> // exceptions and create empty layers), and use
> // this script to change database connections.
> // ----------------------------------------------
> import
> com.vividsolutions.jump.workbench.ui.plugin.datastore.DataStoreQueryDataSource;
> for (lyr : wc.layerNamePanel.selectedLayers) {
> ds = lyr.dataSourceQuery.dataSource;
> if (ds instanceof DataStoreQueryDataSource || ds instanceof
> DataStoreDataSource) {
> //print(ds.properties.get("Connection
> Descriptor").parameterList.schema.names);
> ds.properties.get("Connection
> Descriptor").parameterList.setParameter("Server", "new_server");
> ds.properties.get("Connection
> Descriptor").parameterList.setParameter("Server", "new_port");
> ds.properties.get("Connection
> Descriptor").parameterList.setParameter("Database","new_name");
> ds.properties.get("Connection
> Descriptor").parameterList.setParameter("User", "new_user");
> ds.properties.get("Connection
> Descriptor").parameterList.setParameter("Password","new_pwd");
> }
> }
>
> ------------------------------------------------------------------------------
> Minimize network downtime and maximize team effectiveness.
> Reduce network management and security costs.Learn how to hire
> the most talented Cisco Certified professionals. Visit the
> Employer Resources Portal
> http://www.cisco.com/web/learning/employer_resources/index.html
> _______________________________________________
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
------------------------------------------------------------------------------
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
