-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 01/06/13 07:26, Bart Smissaert wrote: > Is there a way to use the other features, but not this one, say if the > table is already there?
The autoimport code is one function so you get all of it, or none of it. The same is true of the import code which is a separate function, but it mimics the official SQLite shell exactly. If you are happy writing Python code then you can trivially add/change the commands in the APSW shell, as well as adding new output formats, so you make it do exactly what you want. This is the autoimport code, the vast majority of which is detecting column formats: https://code.google.com/p/apsw/source/browse/tools/shell.py#1641 You can scroll up to see the import code. I just did a timing test of autoimport on a 53MB file with 111 columns and 185k rows. It took 1m20s - two thirds of which was the detection phase. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iEYEARECAAYFAlGqUEUACgkQmOOfHg372QRVXACdG1ZDSUzrL2TGMfaE1cQuSUgN 6vMAmQHwoWKQ+/zhAuZUNwM2U2Om4SAB =P6JF -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
