Hi, You could probably try the last "master" QGIS and processing, as René-Luc (rldhont) added a couple of days ago the ability to save scripts and algs result layers into a spatialite database. Combined with the tool "Refactor" ( visible in the Processing toolbox), and using your initial spatialite table, this could do the trick without the need to create a new plugin for this.
Regards Michaël 2015-11-10 15:42 GMT+01:00 Bernd Vogelgesang <[email protected]>: > Hi Micha, > > yeah, working with spatialite dbs "seriously" is still quite uncomfortable. > When I try, I mostly have to use all available means to get the work done: > DBManager, QSpatialite, SpatialiteGUI. Unfortunately I easily forget how > sql works, so doing "easy" stuff becomes very time consuming and > frustrating. > > Do you think it would be technically possible to create a plugin like > Table Manager plugin, that records the changes you want to do to the table > and then creates the necessary sql commands and performs all that stuff in > one go? > > Cause this would be sth I really would be interested donating money on! > > Cheers > Bernd > > Am 10.11.2015, 15:26 Uhr, schrieb Micha Silver <[email protected]>: > > I have found that QGIS cannot "see" any spatialite column that comes after > the "geometry" column. When I alter a table, adding a column in a > Spatialite, the new column which is after the geometry column in the > database table just does not appear in QGIS. If I recreate the table, > reordering the columns so that the geometry is last, all is good again. > > Is this a bug? or am I missing something? > > It's quite annoying considering that sqlite does not have any simple way > to shuffle the columns around, other than dropping and recreating the > table. And if I have foreign constraints defined, it becomes a whole row of > dominoes that come down... > > Thanks, > Micha > > > > > -- > Bernd Vogelgesang > Siedlerstraße 2 > 91083 Baiersdorf/Igelsdorf > Tel: 09133-825374 > > _______________________________________________ > Qgis-user mailing list > [email protected] > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user >
_______________________________________________ Qgis-user mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
