Hi Jon, maybe this script will be of help: https://bitbucket.org/hsarvell/ext/src/tip/sqlimport.l?at=default
It's very crude but it is trying to handle the SQL -> PicoDB conversion through the constraint that you have to first run it on table A if A is referenced in table B, and then run it again on table B, that way you can create the +Ref on import. On Thu, Jan 15, 2015 at 7:57 AM, Alexander Burger <a...@software-lab.de> wrote: > On Wed, Jan 14, 2015 at 05:54:17PM +0100, Alexander Burger wrote: >> A simple example would be >> >> (in "myAdrDB.csv" >> (while (split (line) "^I") >> (dbSync) >> (let Obj (request '(+Prs) 'nm (pack (car L))) >> (put> Obj 'adr (pack (cadr L))) >> (put> Obj ...) >> ... ) >> (commit 'upd) ) ) > > Not correct of course. Better: > > (use L > (in "myAdrDB.csv" > (while (setq L (split (line) "^I")) > (dbSync) > ... L ... > -- > UNSUBSCRIBE: mailto:picolisp@software-lab.de?subject=Unsubscribe -- UNSUBSCRIBE: mailto:picolisp@software-lab.de?subject=Unsubscribe
