Hi I hope that another developer picks it up add I am traveling...
Thanks Markus On Mar 9, 2016 5:53 PM, "Paulo van Breugel" <[email protected]> wrote: > Thanks, db.join table=test1 column=A other_table=test2 other_column=A now > works. When trying to link the two tables on column B and C, it doesn't, > which is because both tables have a column A. > > GRASS 7.1.svn (AEA):~ > db.join table=test1 column=B other_table=test2 > other_column=C > WARNING: SQLite driver: unable to parse decltype: REAL(20) > WARNING: SQLite driver: unable to parse decltype: REAL(20) > WARNING: SQLite driver: column 'C', SQLite type 2 is not supported > WARNING: SQLite driver: unable to parse decltype: REAL(20) > WARNING: SQLite driver: unable to parse decltype: REAL(20) > WARNING: SQLite driver: column 'C', SQLite type 2 is not supported > DBMI-SQLite driver error: > Error in sqlite3_prepare(): > duplicate column name: A > > DBMI-SQLite driver error: > Error in sqlite3_prepare(): > duplicate column name: A > > ERROR: Error while executing: 'ALTER TABLE test1 ADD COLUMN A INTEGER(20)' > ERROR: Unable to add column <A>. > > The warnings were not shown when linking via columns A, so I assume they > are not a problem? As for the problem with the duplicate column name, would > it be possible to add the option to define a prefix which is added to the > column of the second table if a column with the same name exists in the > first table (with a default prefix if none is given by the user)? > > > On 09-03-16 17:30, Markus Neteler wrote: > > > On Mar 9, 2016 5:25 PM, "Paulo van Breugel" <[email protected]> > wrote: > > > > Hoi Markus > > > > Still not there via g.extension, but I copied the script to the script > folder. > > > > I tried with two tables (both created in an external sqlite editor), > > > > Table 1: columns A (integer, key) and B (float) > > Table 2: columns A (integer, key) and C (float) > > > > First observation: using the GUI, the drop down menu for the identifier > column shows the column names of Table 1 instead of Table 2. > > Mhh, perhaps I mixed something up there. > > > I tried to link the two on the first columns and on the second columns. > In both cases I got an error message, copied below: > > > > db.join table=test1 column=A other_table=test2 > other_column=A > > > > Traceback (most recent call last): > > > > File "/home/paulo/.grass7/addons/scripts/db.join", line 170, in > <module> sys.exit(main()) > > > > File "/home/paulo/.grass7/addons/scripts/db.join", line 152, in main > columns=colspec) > > > > File > "/usr/local/grass7/grass-7.1.svn/etc/python/grass/script/core.py", line > 408, in run_command ps = start_command(*args, **kwargs) > > > > File > "/usr/local/grass7/grass-7.1.svn/etc/python/grass/script/core.py", line > 377, in start_command return Popen(args, **popts) > > > > File > "/usr/local/grass7/grass-7.1.svn/etc/python/grass/script/core.py", line 74, > in __init__ subprocess.Popen.__init__(self, args, **kwargs) > > > > File "/usr/lib/python2.7/subprocess.py", line 710, in __init__ > errread, errwrite) > > > > File "/usr/lib/python2.7/subprocess.py", line 1327, in _execute_child > raise child_exception > > > > OSError: [Errno 2] No such file or directory > > That one I fixed 30min ago or so in Svn. > > > Works now > > Please check again. > > Markus > > > Paulo > > > > > > > > On 09-03-16 14:02, Markus Neteler wrote: > >> > >> > >> On Mar 9, 2016 1:36 PM, "Paulo van Breugel" <[email protected]> > wrote: > >> > >> ... > >> > It is in svn I saw, but it doesn't show up in g.extension.. perhaps > because I am on 7.1? > >> > >> This does not matter. I didn't yet add it to the parent Make file > because it is not ready. > >> > >> Just take it from trac/svn from now... > >> > >> Markus > > > > > > >
_______________________________________________ grass-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-dev
